Analytics Engineer

We're 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. You’ll be partnering with teams like Marketing, Advertising, Editorial, and Finance to give them the data they need, faster.

In this role, you'll 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, you'll 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 you’d love to take on this role, and why you’re a great match for what we’re 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 anna.vipers@theguardian.com to discuss further so we can work with you to support you through your application.

Benefits at the Guardian

You'll 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 wellbeing. In 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.