Location:London
Contract:Permanent
Type of work:Hybrid (Minimum of 2/3 days in the London office)
The Role and the team
Fremantle’s Global Insight Department is integral to analysing television performance metrics, audience viewing behaviours, and emerging content trends. Positioned centrally within the organisation, the department is unifying internal performance data and other company datasets into a consolidated Microsoft Fabric environment, enhancing data accessibility and analytical efficiency across the business.
As a Data Analyst/Engineer, you will play a pivotal role in both managing and optimising the company's data infrastructure and performing in-depth data analyses. Your responsibilities will encompass working with Microsoft Fabric, Azure Data Factory, SQL, and other tools to construct data pipelines. Additionally, you will analyse datasets to come up with insights for the business, supporting various business units in making informed decisions across the whole of Fremantle. This hybrid role is ideal for professionals who are both technically adept and analytically minded, capable of navigating the intricacies of data engineering while delivering insightful analyses.
As a company built on storytelling, we love talking about TV and film—so if you enjoy seeing how data drives the industry, and want to make a difference here, you’ll fit right in.
Key Responsibilities
- Ingest and integrate new data sources into Fremantle’s centralised Microsoft Fabric data platform.
- Build and maintain data pipelines to transform raw data into structured, analytics-ready datasets.
- Perform data analyses to identify trends, patterns, and insights that inform business decisions.
- Ensure data integrity, governance, and security within the Fabric/Azure ecosystem.
- Collaborate closely with the Data & Analytics team to structure datasets for dashboards, reporting, and advanced analytics.
- Work with stakeholders to understand business needs and translate them into data models and analytical solutions.
- Automate data processes to reduce manual intervention and improve efficiency.
- Stay current with best practices in data engineering and analysis, particularly within the Microsoft ecosystem.
Essential Skills and Experience
- Hands-on experience with cloud-based data platforms (e.g., Azure, AWS, or Snowflake); familiarity with Microsoft Fabric or GCP is desirable.
- Proficiency in Spark SQL and PySpark, with the ability to write complex queries and transformations for data management, optimisation, and scalable processing.
- Experience with ETL/ELT pipelines, using tools like Azure Data Factory or similar; experience with Google BigQuery is a bonus.
- Experience writing Python scripts for data transformation, validation, and automation.
- Experience in retrieving and integrating data from APIs, including RESTful and JSON-based services and other data collection methods such as web scraping.
- Understanding of data modelling principles and best practices for structuring data for analytics.
- Ability to work with large, complex datasets across various formats, including databases, Excel files, CSV, JSON, Parquet, and APIs, while optimising performance.
- Experience with data visualisation tools, particularly Power BI, for creating interactive dashboards and reports.
- Nice to have – experience with Power Automate for workflow automation and Power Apps for building data-driven applications.
- Familiarity with data governance tools like Microsoft Purview is a plus.
- Strong problem-solving skills, with the ability to diagnose and resolve data issues.
- Bonus if experienced with Generative AI tools, including Custom GPTs, for data processing, automation, or intelligent data augmentation.
- Excellent communication skills, with the ability to collaborate with analysts, stakeholders, and technical teams.
Our benefits include a generous company pension, summer Fridays, audience tickets, personalised working, employee assistance programme, access to free courses and training, local discounts, free breakfast, lunch, coffee and snacks in the office, cycle to work scheme, season ticket loan, business coaching sessions and volunteer days.
If you need any of this information in a different format or would like to suggest a different form of application, please contact
Fremantle is part ofRTL Group, a global leader across broadcast, content and digital, itself a division of the international media giantBertelsmann.
For more information, please visitFremantle.com, follow us @FremantleHQor visit ourLinkedInandFacebookpages.
#J-18808-Ljbffr
