Analytics Engineer

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

Job summary

A leading media agency in the UK seeks an Analytics Engineer to enhance data-driven performance. The role focuses on building robust models in dbt, ensuring data quality, and collaborating with marketing teams. Candidates should be proficient in SQL, dbt, and Python, with a proactive, team-oriented mindset. This is a hybrid role offering exposure to cutting-edge tools and an emphasis on training and development.

Benefits

Training and development

Referral schemes

Supportive team environment

Qualifications

• Confident in writing clean, performant SQL queries.
• Experienced with dbt for building and documenting models.
• Comfortable editing Python scripts.
• Solid understanding of Git for version control.
• Able to explain technical topics to non-technical audiences.
• Enjoys collaborative and fast-paced environments.

Responsibilities

• Build and maintain robust data models in dbt.
• Manage onboarding of new data feeds.
• Champion data quality with tests and alerts.
• Work closely with senior leaders on business objectives.
• Contribute to Python tooling and automations.
• Collaborate across analytics, data science, and visualisation.
• Take ownership of projects through design and deployment.

Skills

SQL

dbt

Python

Git

Strong communicator

Team player

Tools

GCP/BigQuery

Airflow

Snowflake

Redshift

Preset.io

Apache Superset

GitLab CI

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 role is for someone who not only writes 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.

• 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.

You're a curious, proactive problem-solver who is 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 (e.g., Preset.io, Apache Superset).
• 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 is 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.

Alternatively, you can refer a friend or colleague by taking part in our fantastic referral schemes!

If you have a friend or colleague who would be interested in this role, please refer them to us. For each relevant candidate that you introduce to us (there is no limit) and we place, you will be entitled to our general gift/voucher scheme.