Data Engineer — Build Scalable Social Video Data Pipelines

Fremantle; Greater London; On-site; GBP 70,000 - 100,000; Full time

Benefits offered by this job

Generous company pension

Summer Fridays

Audience tickets

Employee assistance program

Free courses and training

EV scheme

Cycle to work scheme

Season ticket loan

Business coaching sessions

Volunteer days

Job summary

Fremantle is seeking a strong mid-level Data Engineer to design, build and optimise data pipelines that merge performance, advertising, platform and content data from global sources into Fremantle’s data environment.

You will work with Google BigQuery, dbt, Microsoft Fabric and modern data tools to deliver accurate, secure datasets for dashboards, monetisation insights and viewing metrics.

Qualifications

• Proven experience with cloud data platforms (GCP, AWS, Azure; Microsoft Fabric a plus).
• Strong SQL and Python skills; write complex queries and reusable scripts for transformation and automation.
• Experience designing/monitoring robust ETL/ELT pipelines with tools like dbt and BigQuery.
• Familiarity with version control, CI/CD, code reviews and testing practices.
• Experience with YouTube Analytics/Reporting and Meta Graph APIs is a plus.

Responsibilities

• Ingest and integrate new data sources from social partners into Fremantle’s data platform.
• Own YouTube and Meta data pipelines to ensure timely month-end revenue and performance data.
• Build and maintain scalable pipelines transforming raw data into analytics-ready datasets.
• Ensure data governance, quality, and security across the data platform.
• Collaborate with the central Data & Analytics team to structure datasets for BI dashboards and reporting.
• Optimize pipelines for performance, scalability, and reliability; document data flows.
• Translate business needs into data models and adapt pipelines to evolving data sources.
• Automate repetitive data processes to reduce manual intervention.
• Stay current with modern data engineering practices and share knowledge.

Skills

SQL

Python

ETL/ELT

dbt

BigQuery

Cloud platforms

Git

APIs

Data modelling

Data governance

Tools

dbt

BigQuery

Microsoft Fabric

Git

CI/CD

Job description

Fremantle is seeking a strong mid-level Data Engineer to design, build and optimise data pipelines that merge performance, advertising, platform and content data from global sources into Fremantle’s data environment.

You will work with Google BigQuery, dbt, Microsoft Fabric and modern data tools to deliver accurate, secure datasets for dashboards, monetisation insights and viewing metrics.