Analytics Engineer

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.

Responsibilities

• Transform complex data into clean, trusted, and highly usable products that inform real‑time marketing strategies for some of the UK\’s most recognizable brands.
• 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 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.