About the role
<p><strong>About the Role:</strong></p> <p>This role sits within our Data and Technology team.</p> <p>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.</p> <p>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.</p> <p><strong>Responsibilities:</strong></p> <ul> <li>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.</li> <li>Develop and maintain dbt macros, Jinja templates, and platform YAML definitions that auto-generate models across 26+ ad platforms.</li> <li>Manage and improve GCP infrastructure (BigQuery, Cloud Run, Cloud Functions, Cloud Scheduler, Pub/Sub) provisioned via Terraform.</li> <li>Build and maintain the Python CLI tooling that orchestrates client onboarding, config compilation, and pipeline execution.</li> <li>Mentor the team of data engineers, driving best practices in DataOps, code review, testing, and documentation.</li> <li>Proactively review existing processes to identify opportunities to automate manual work, optimise data delivery, and re-design infrastructure for greater scalability.</li> <li>Collaborate with analysts, data scientists, and BI teams (PowerBI, Looker Studio, Tableau, etc.) to maximise the value delivered from data models.</li> <li>Contribute to CI/CD pipelines (Cloud Build), testing (pytest, dbt tests), and documentation (MkDocs, etc.).</li> </ul> <p><strong>About You</strong></p> <p><strong>Required:</strong></p> <ul> <li>Strong experience with dbt — macros, Jinja templating, incremental models, seeds, testing, and packages.</li> <li>Proficient in Python 3.11+ — building CLI tools, data processing, and automation.</li> <li>Proficient in SQL, ideally BigQuery dialect.</li> <li>Experience with Google Cloud Platform — especially BigQuery, Cloud Run, Cloud Functions, Cloud Storage, Pub/Sub, and Cloud Scheduler</li> <li>Experience with Infrastructure as Code (Terraform) for provisioning and managing cloud resources.</li&g