Analytics Engineer

Were looking for a motivated Analytics Engineer with experience working on a modern data stack (think dbt Google Cloud Platform Fivetran Airflow and Tableau) to create the reliable governed datasets that power data-informed decisions across The Guardian. Youll be partnering with teams like Marketing Advertising Editorial and Finance to give them the data they need faster.

In this role youll ensure our data models are high quality resilient and well-governed. Working closely with Data Product Managers Data Platform Engineers and your fellow Analytics Engineers youll turn raw data into curated easy-to-use datasets for analysts and our internal data applications.

About the Role

• Data Modelling and Transformation: Design and implement conceptual logical and physical data models using SQL and dbt to build cost-efficient and maintainable ELT pipelines scheduled with Apache Airflow.
• Data Quality Assurance: Implement and monitor testing metrics (completeness accuracy validity timeliness) and collaborate with data owners/stewards to quickly identify and resolve quality incidents.
• Requirements Gathering and Delivery: Work closely with data users to determine functional and non-functional requirements and deliver new and existing data products within an agile framework.
• Documentation and Governance: Collaborate with Data Governance Analysts and Software Engineers to ensure comprehensive documentation of source data business logic transformation lineage and metadata is available.
• Compliance: Model data strictly according to policies for data privacy protection security and broader governance and regulatory frameworks.

About You

• You have experience designing and building optimised data models using established methodologies (e.g. Kimball) in a consumer-orientated organisation.
• You are skilled in business analysis and requirement gathering translating business objectives into effective model designs.
• You can write complex analytical SQL for ELT pipelines with a strong understanding of performance implications modularisation and idempotence.
• You have experience with the modern data stack (e.g. BigQuery Airflow DBT Fivetran Tableau Git).
• You communicate effectively both verbally and in writing to explain complex or technical concepts to a variety of stakeholders including non-technical colleagues.

We actively encourage applications from groups traditionally underrepresented in the UK media

We operate in a hybrid environment working 3 days a week from our offices in Kings Cross and 2 days a week remotely.

We value and respect all differences (seen and unseen) in all people. We aspire to have inclusive working experiences and an environment that reflects the audience we serve where our people have equal access to career development opportunities their voices are heard and can contribute to our future. We actively encourage applications from people of all backgrounds. Many of our staff work flexibly and we will consider all requests for flexible working arrangements.

How to apply

To apply please upload your latest CV and a cover letter which outlines why youd love to take on this role and why youre a great match for what were looking for.

We appreciate the time taken to prepare each application we receive. We do not use AI-assisted technology to review applications; every application is reviewed by a member of our recruitment team.

The closing date for applications is Friday 29th May 2026.

All roles at the Guardian are open for everybody to apply. It is important to us that you feel supported and comfortable throughout your recruitment process in order to perform your best. Please let us know if there are any changes we could make to help your application this includes providing documents in accessible formats or personalising the process to better support your needs. Please contact Anna Vipers on to discuss further so we can work with you to support you through your application.

Benefits at the Guardian

Youll have 30 days of annual leave per year (plus bank holidays) with the option to purchase an additional 5 days. Our pension scheme is generous; if you contribute 5% then we will contribute 8-12% (depending on your age). We believe in giving back which is why employees are given 2 volunteering days annually and the option of payroll giving. Season ticket loans are also available.

You are entitled to private healthcare life cover income protection and eye tests. You can also opt in to dental insurance.

We have enhanced maternity paternity adoption and shared parental leave policies in place. We also support our employees by offering an IVF menopause baby loss and trans equality policy.

Culture and wellbeing

We want everyone to feel like they belong at the Guardian and we champion diversity of thought. Our various employee forums provide a platform to use their voice to foster an inclusive workplace. We became the first major media organisation to achieve B Corp status.

We offer tools to help you prioritise your wellbeing including access to our employee benefits platform which provides tailored support for health and addition we also offer free yoga and pilates classes. These run alongside our corporate gym membership and cycle to work scheme.

Our canteen has views overlooking the Regents Canal and caters for breakfast lunch and dinner.

Learning and development

We encourage personal and professional growth. Employees have access to a broad range of tools and solutions and we are happy to support the pursuit of professional qualifications through vocational courses and apprenticeships.