Analytics Engineer

Datatech; City Of London; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading media agency in London is seeking an Analytics Engineer to build and maintain data models, transform raw data, and ensure data quality. In this hybrid role, you will collaborate with the Marketing Intelligence team, contributing to innovative marketing strategies. Ideal candidates are proficient in SQL and dbt, and are passionate about data-driven decision-making. Join a team that values training and contributes to a meaningful Data for Good ethos.

Benefits

Training and development

Collaborative work environment

Opportunities for career advancement

Qualifications

• Confident in writing clean, performant SQL queries.
• Experienced with building, testing, and documenting dbt models.
• Comfortable using and editing existing Python scripts.
• Solid understanding of version control with Git.
• Able to translate technical topics for non-technical audiences.
• Collaborative and adaptable in a fast-paced environment.

Responsibilities

• Build and maintain robust data models in DBT.
• Manage onboarding of new data feeds collaboratively.
• Champion data quality with tests and alerts.
• Align data models with business objectives.
• Evolve Python tooling and adapt scripts.
• Ownership of projects from design to deployment.

Skills

SQL

dbt

Python

Git

Strong communicator

Team player

Tools

GCP/BigQuery

Airflow

CI/CD pipelines

Job description

Analytics Engineer - DBT & SQL

Location: London - Hybrid (3 days/week central London office)

Salary: 40,000 depending on experience

Ref: J13038

Please note sponsorship is not available now or in the future.

An exciting opportunity has opened up at one of the UK's fastest-growing independent media agencies. An Analytics Engineer is needed to help shape the future of data in a business where performance, innovation, and impact come together.

You'll sit at the heart of the Marketing Intelligence team, transforming complex data into clean, trusted, and highly usable products that inform real‑time marketing strategies for some of the UK's most recognisable brands. This is a role for someone who doesn’t just write SQL, but builds scalable, structured models that empower analysts, marketers, and data scientists to move faster and smarter, all while contributing to a Data for Good ethos that drives meaningful, measurable outcomes.

Responsibilities

• Build and maintain robust data models in DBT, transforming raw data into high‑quality, trusted sources for analytics and activation.
• Manage onboarding of new data feeds from discovery to documentation, collaborating with both technical and business stakeholders.
• Champion data quality, creating tests and alerts to ensure confidence and consistency in our outputs.
• Work closely with senior leaders across data and marketing to align models with business objectives.
• Contribute to and evolve our Python tooling, adapting scripts and automations to support the wider data platform.
• Collaborate with teams across analytics, data science, and visualisation to make sure data is accessible, meaningful, and impactful.
• Take ownership of projects from design through to deployment, following agile best practices.

Desired Profile

You're a curious, proactive problem‑solver who's passionate about clean, well‑documented data. You care about data quality, team collaboration, and making a measurable difference in how data is used across a business.

Must‑Have Skills

• SQL – Confident in writing clean, performant queries; understands ANSI SQL principles.
• dbt – Experienced with building, testing, and documenting models in production environments.
• Python – Comfortable using and editing existing scripts; familiar with core concepts.
• Git – Solid understanding of version control and team‑based workflows.
• Strong communicator – Able to translate technical topics for non‑technical audiences.
• Team player – Collaborative, curious, and happy to work in a self‑organising, fast‑paced environment.

Nice‑to‑Have Skills

• Experience with GCP/BigQuery or other cloud data warehouses (e.g., Snowflake, Redshift).
• Familiarity with data orchestration tools (e.g., Airflow).
• Experience with data visualisation platforms such as Preset.io/Apache Superset or other.
• Exposure to CI/CD pipelines, ideally using GitLab CI.
• Background working with media, marketing, or advertising data.

The Opportunity

• Work alongside smart, supportive teammates who genuinely care about data, performance, and growth.
• Play a key role in a business that's investing in its data capabilities for the long term.
• Huge emphasis on training and development.
• Contribute to an evolving data platform and a top 1% dbt codebase that sets standards others aspire to.
• Be part of a company with a strong Data for Good ethos, where your work helps drive real‑world results with purpose.

If you’re ready to develop up your analytics career, working with top‑tier tools and a brilliant team, we want to hear from you.