O pozici
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.
Co budeš dělat
- 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.)
Koho hledáme
- 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.
Benefity
- 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.
- 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.
- 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.