Data Engineer - Social

In this role you will design and operate data pipelines that blend performance, advertising, platform, audience and content data to empower Social Video dashboards, monetisation insights and viewing metrics. You will own key pipelines (YouTube/Meta) and partner with the Data & Analytics team to deliver scalable, trusted data for Finance, analysis and forecasting. You’ll work with modern tools to ensure data accuracy, security and timely delivery, enabling fast decision-making at scale. This is a hands-on, ownership role in a fast-moving, storytelling-driven company.

• generous pension
• summer Fridays
• audience tickets
• employee assistance program
• free courses and training
• EV scheme (electric vehicle)","cycle to work scheme","season ticket loan","business coaching sessions","volunteer days"),

• Ingest and integrate new data sources from social partners into Fremantle’s central data platform
• Own the YouTube and Meta data pipelines (Content ID / CMS reports) ensuring month-end revenue and performance data are complete and reconciled
• Build and maintain scalable data pipelines using BigQuery and dbt to transform raw data into analytics-ready datasets
• Ensure data integrity, governance and security across the data platform with validation and testing frameworks
• Collaborate with the central Data & Analytics team to structure datasets for BI dashboards and reporting
• Optimize pipelines for performance, scalability and efficiency with standard engineering practices (version control, code reviews, iterative development)
• Monitor pipeline health, data freshness and quality with proactive alerts and issue resolution; document pipelines and data flows for clarity and handovers
• Translate business and analytical needs into clear data models and technical solutions; adapt pipelines to changing data sources and schemas
• Automate data processes to reduce manual intervention and streamline operations
• Stay current with modern data engineering technologies and share knowledge across the team

• Cloud-based data platforms (GCP, Azure, AWS; Microsoft Fabric is a plus)
• Strong SQL and Python for complex queries, transformations, validation and automation
• Experience designing and managing ETL/ELT pipelines with dbt and BigQuery or similar
• Git-based version control, CI/CD tooling, and collaborative development practices
• Experience with YouTube Analytics / Reporting and Meta Graph APIs; finance-grade data concepts (reconciliation, controls, deadlines) a plus
• Hands-on experience retrieving and integrating data from REST/JSON APIs (authentication, pagination, rate limits, changing structures)
• Solid data modelling principles for analytics, reporting and downstream consumption
• Experience handling large, complex datasets across diverse formats (DBs, Excel, CSV, JSON, Parquet, APIs); performance-focused
• Experience integrating data from social platforms (YouTube/Meta) and advertising, audience, revenue data advantageous
• Strong problem-solving, communication and cross-functional collaboration skills
• Curiosity about how data drives programming decisions, content performance, audience behaviour and monetisation

• communication
• collaboration
• problem-solving
• Google BigQuery
• dbt
• Python