About the Role:
This role sits within our Data and Technology team.
In this role, you will own and extend our config-driven data platform (DMC), which standardises ingestion, transformation, and delivery of paid media data across 26+ ad platforms for multiple global clients. You will work closely with our team to build and maintain ELT pipelines — from Cloud Function ingestion into BigQuery through to dbt-powered transformation — ensuring the highest standard in data integrity and scalability.
This is an exciting role with excellent career opportunities within a high-profile team and scope to strategically shape the agency. We are looking for someone who can hit the ground running, contribute to a mature mono-repo data platform, and help drive best practices across the engineering team. Experience with digital media data is highly beneficial.
Responsibilities:
- Own and extend the end-to-end data pipeline — from Cloud Function ingestion through dbt transformation (staging → intermediate → marts) to analysis-ready tables in BigQuery.
- Develop and maintain dbt macros, Jinja templates, and platform YAML definitions that auto-generate models across 26+ ad platforms.
- Manage and improve GCP infrastructure (BigQuery, Cloud Run, Cloud Functions, Cloud Scheduler, Pub/Sub) provisioned via Terraform.
- Build and maintain the Python CLI tooling that orchestrates client onboarding, config compilation, and pipeline execution.
- Mentor the team of data engineers, driving best practices in DataOps, code review, testing, and documentation.
- Proactively review existing processes to identify opportunities to automate manual work, optimise data delivery, and re-design infrastructure for greater scalability.
- Collaborate with analysts, data scientists, and BI teams (PowerBI, Looker Studio, Tableau, etc.) to maximise the value delivered from data models.
- Contribute to CI/CD pipelines (Cloud Build), testing (pytest, dbt tests), and documentation (MkDocs, etc.).
About You
Required:
- Strong experience with dbt — macros, Jinja templating, incremental models, seeds, testing, and packages.
- 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, Cloud Storage, Pub/Sub, and Cloud Scheduler
- Experience with Infrastructure as Code (Terraform) for provisioning and managing cloud resources.
- Solid understanding of data modelling techniques (star schema, dim/fact architecture, slowly changing dimensions).
- Comfortable with Git (GitHub, branching strategies, pull requests) and CI/CD (Cloud Build or similar).
- Ability to translate business needs into technical specifications.
Highly Desirable:
- Experience with Docker and containerised workloads (Cloud Run Jobs).
- Familiarity with CLI frameworks (Click) and config-driven architectures (Pydantic, YAML-based configuration).
- Knowledge of the digital media / paid media industry — we process data from 26+ ad platforms (Google Ads, Meta, DV360, TikTok, etc.).
- Exposure to multi-cloud integrations (Azure Blob, AWS S3, SFTP).
- Mono-repo experience — managing multi-client configurations in a single codebase.
Nice to Have:
- Experience with Databricks (and dbt-databricks).
- Familiarity with modern Python dev tooling — Poetry, ruff, mypy, pre-commit.
- Experience with docs-as-code (MkDocs or similar).
Qualities:
- Ownership – an ability to manage multiple workstreams across clients with accuracy, and see things through from design to deployment.
- Curiosity – a natural inclination to explore new tools, dig into unfamiliar systems, and understand how things work end-to-end.
- Resourcefulness – an ability to unblock yourself, whether that means reading source code, querying logs, or finding creative workarounds when data or documentation is limited.
- Problem-solving – an ability to think through complex data issues methodically and design clean, maintainable solutions.
- Collaboration – a desire to work openly, share knowledge, and build a team culture where code reviews and pair programming are valued.
About the Agency:
At OMD EMEA, we strive to deliver on our promise of ‘better decisions, faster‘ for our clients, partners and all 6,000+ OMDers across our region every day. As part of the world’s largest media network, our business is staging experiences for consumers who have more choice and less attention than ever before. The key to the process is empathy. Empathy to see the world through the eyes of the consumer, to recognise the needs of our clients and to identify aspirations of our talent.
Learn Fast, Act Fast. To help navigate the road to a ‘new normal’, learning from, and acting upon data signals at scale and speed is crucial. Visit Why OMD? to learn more about our unique Act Fast Framework.
Our working pattern for colleagues is to be present in the office three days a week at our offices in London with the other days available to work remotely. Let us know if you have any questions about our working pattern as part of your application and interview process.
Flexible Working
At Omnicom Media Group, we are committed to supporting flexibility for our people while fostering collaboration, innovation, and teamwork. We have a hybrid working model (three days in the office, two working remotely), to ensure that we meet the needs of both our people and our business, balancing the benefits of in-person connections with the flexibility of remote working. Our standard working hours are 9:30 – 17:30, but we offer the ability to flex around core hours of 10:30 – 16:30 to give our people flexibility on how they manage their working day, whether that’s in the office or working remotely. For example, you could start work at 8:30 and finish at 16:30 or start at 10:30 and finish at 18:30.
We encourage open conversations between our people and managers to help navigate high-need periods and individual circumstances. Our goal is to create an environment where people feel genuinely supported to do their best - both in their careers and in their lives outside of work.
Be Your Best
We want everyone to make the most of the opportunity to shine and showcase your talents and we are happy to make adjustments in the recruitment process so you can be your best. Please discuss any specific requirements with your dedicated Talent Team member or if you would feel more comfortable, you can email us confidentially at [email protected] to let us know how we can support you.
Diversity, Equity & Inclusion at OMG
At OMG, our vision is to be an agency where difference is valued and everyone is able to thrive in a culture of equality, inclusion and belonging. We are committed to providing a truly inclusive environment that reflects today’s society, where everyone is able to bring their true selves to work, and where diverse voices and backgrounds are valued, heard, and well-represented.
We will process your personal data in accordance with our Recruitment Privacy Notice which is available on https://omnicommediagroup.com/recruitment-privacy-notices/.
Skills Required
- Strong experience with dbt -- macros, Jinja templating, incremental models, seeds, testing, and packages.
- 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, Cloud Storage, Pub/Sub, and Cloud Scheduler
- Experience with Infrastructure as Code (Terraform) for provisioning and managing cloud resources.
- Solid understanding of data modelling techniques (star schema, dim/fact architecture, slowly changing dimensions).
- Comfortable with Git (GitHub, branching strategies, pull requests) and CI/CD (Cloud Build or similar).
- Ability to translate business needs into technical specifications.
Omnicom Media Group UK Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Omnicom Media Group UK and has not been reviewed or approved by Omnicom Media Group UK.
-
Leave & Time Off Breadth — Leave allowances include 27 days’ annual leave plus a birthday day and options to trade holiday. Additional “summer Fridays/recharge days” help widen time‑off options.
-
Flexible Benefits — Hybrid working with a typical three‑days‑in/two‑days‑remote pattern and defined core hours supports flexibility. Work‑from‑anywhere allowances and 2–3 WFH days are also referenced in the UK context.
-
Healthcare Strength — Private medical insurance, life assurance, and an Employee Assistance Programme are part of the core package. Mental wellbeing support, trained Mental Health First Aiders, and a subsidised gym further reinforce health coverage.
Omnicom Media Group UK Insights
What We Do
OMG UK delivers transformational experiences for consumers, clients and talent. Powered by the Omni marketing orchestration system, OMG connects best-in-class capabilities that enable our full-service media agencies OMD, MG OMD, PHD and Hearts & Science to deliver more relevant and actionable consumer experiences, more productive and proactive client experiences, and more collaborative and rewarding talent experiences. We are enormously proud of our Agency and Network of the Year accolades, including most recently, PHD named Adweek’s Global Media Agency of the Year, MG OMD named Thinkbox TV Planning Agency of the Year, and OMG Unite named Media Agency of the Year at the Leadership and Diversity Awards. We are committed to providing a truly inclusive environment where everyone is able to bring their true selves to work, diverse voices and minority communities are valued, heard and well represented, and where everyone is able to thrive in a culture of equality, inclusion and fairness.
.png){kind=logo}
