Overview

Analytics Engineer - dbt & SQL
Location: City of London - Hybrid (3 days/week during probation, then 2 days/week)
Salary: £35,000 - £40,000 (dependent on experience)
Ref: J13009

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.

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.

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.

Datatech is one of the UK's leading recruitment agencies in the field of analytics and host of the critically acclaimed event, Women in Data. For more information, visit our website: www.datatech.org.uk