Analytics Engineer - DBT & SQL (Hybrid London)

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

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.