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 the team to build and maintain ELT pipelines—from Cloud Function ingestion into BigQuery through to dbt‑powered transformation—ensuring the highest standards in data integrity and scalability. This is an exciting position with excellent career opportunities and scope to strategically shape the agency.

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 impr...