Data Platform Lead - ELT, dbt & BigQuery

Omnicom Media; Greater London; On-site; GBP 90,000 - 130,000; Full time

Job summary

Omnicom Media is seeking an experienced Data Engineer to own and extend our config-driven data platform (DMI) within the EMEA, Data and Technology team in the UK. You will build and maintain ELT pipelines from Cloud Function ingestion into BigQuery through to dbt-powered transformations, ensuring data integrity and scalability for multiple global clients.

You will collaborate with analysts, data scientists, and BI teams to maximise value from data, mentor engineers, and drive best practices

Qualifications

• Strong dbt experience including macros, Jinja templating, incremental models, seeds and testing.
• Proficient in Python 3.11+ building CLI tools, data processing and automation.
• Proficient in SQL, ideally BigQuery dialect.
• Experience with Google Cloud Platform especially BigQuery, Cloud Run, Cloud Functions, Pub/Sub and Cloud Scheduler.
• Experience with Infrastructure as Code (Terraform).
• Solid understanding of data modelling techniques (star schema, dim/fact, slowly changing dimensions).
• Comfortable with Git, branching strategies, PRs, and CI/CD pipelines.

Responsibilities

• Own and extend the end-to-end data pipeline from ingestion to analysis-ready tables in BigQuery.
• Develop and maintain dbt macros, Jinja templates, and platform definitions across 26+ ad platforms.
• Manage and improve GCP infrastructure provisioned via Terraform.
• Build and maintain Python CLI tooling for onboarding, config compilation, and pipeline execution.
• Mentor data engineers and promote DataOps, code reviews, testing, and documentation.
• Identify opportunities to automate processes and redesign infrastructure for scalability.
• Collaborate with analysts, data scientists, and BI teams to maximise data value.

Skills

dbt

Python CLI

BigQuery SQL

Google Cloud

Terraform

Data modelling

Git & CI/CD

Business requirements

Tools

Docker

CLI frameworks

MkDocs

Databricks

Pydantic

Job description

Omnicom Media is seeking an experienced Data Engineer to own and extend our config-driven data platform (DMI) within the EMEA, Data and Technology team in the UK. You will build and maintain ELT pipelines from Cloud Function ingestion into BigQuery through to dbt-powered transformations, ensuring data integrity and scalability for multiple global clients.

You will collaborate with analysts, data scientists, and BI teams to maximise value from data, mentor engineers, and drive best practices