Analytics Engineer

Analytics Engineer - DBT & SQL

Location:

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

Salary: £40,000 depending on experience

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

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

• Experience with GCP/Big Query 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 Git Lab CI.
• Background working with media, marketing, or advertising data.

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