Data Engineer - Social Video Analytics & Pipelines

Fremantle Group; Camden Town; On-site; GBP 65,000 - 90,000; Full time

Benefits offered by this job

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 Group is seeking a mid-level Data Engineer to design, build and optimise data pipelines across advertising, performance and content data. You will work with Google BigQuery, dbt and Microsoft Fabric to deliver analytics-ready datasets for dashboards and forecasting.

You'll own end-to-end data flows, ensure data quality and security, and collaborate with the Data & Analytics team to drive insights for finance and business decisions. This role is based in Camden Town, UK.

Qualifications

• Solid hands-on data engineering experience.
• Experience building and optimising data pipelines for analytics.
• Ability to translate business questions into robust data models.

Responsibilities

• Ingest and integrate new data sources into Fremantle's central data platform.
• Own YouTube and Meta data pipelines, ensuring timely revenue and performance data for finance.
• Build and maintain scalable data pipelines using BigQuery and dbt.
• Ensure data integrity, governance and security across the platform.
• Collaborate with Data & Analytics to structure datasets for BI dashboards.
• Optimise pipelines for performance, scalability, and reliability.
• Monitor data freshness and quality with alerts and validations.
• Document pipelines and data flows for clear handovers.

Skills

SQL

Python

Data modelling

ETL/ELT

Data governance

Data quality checks

Analytics reporting

Communication skills

Tools

BigQuery

dbt

Microsoft Fabric

Git

CI/CD tooling

APIs (REST/JSON)

Job description

Fremantle Group is seeking a mid-level Data Engineer to design, build and optimise data pipelines across advertising, performance and content data. You will work with Google BigQuery, dbt and Microsoft Fabric to deliver analytics-ready datasets for dashboards and forecasting.

You'll own end-to-end data flows, ensure data quality and security, and collaborate with the Data & Analytics team to drive insights for finance and business decisions. This role is based in Camden Town, UK.