Analytics Engineer in London

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.

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.