Location
London, White City. Expectation is 2 days in the office.

Hours
Full Time, 12 Month Fixed-Term Contract

Salary
Negotiable

About the Role
The ITV Insights Group leads the business in embedding insight into every key decision, such as what content to commission, identifying the most commercially attractive audiences, and optimising products to improve view-through rates. This role, reporting to the Lead Analytics Developer, focuses on developing data products that support the analytics priorities of the Insights Group. You will work closely with the Head of Analytics and collaborate across the Insights Group, Central Insights, and Data Science teams.

Key responsibilities include championing analytics engineering best practices by designing and structuring robust, SQL-based analytical pipelines; maintaining and iterating the M&E KPI pipeline as business needs evolve; embedding best practices through connecting Dataform to GitHub for seamless code sharing and version control; designing and implementing rigorous data quality checks and automated tests with proactive Slack notifications for pipeline issues; supporting the Central Data team with User Acceptance Testing (UAT) on new data products; collaborating with analysts and insights managers to build and optimise tables for fast, efficient dashboards; driving migration of legacy processes to BigQuery notebooks and pipelines to reduce costs and improve query efficiency; assisting in rebuilding and maintaining ITVX streaming data as a robust dimensional model using dbt, integrating complex datasets such as content metadata, broadcast schedules, VOD windows, content contracts, and user demographics; ensuring comprehensive documentation of all data products for the wider business; exploring and integrating new data sources including automated API connections (e.g. Barb) and auditing varied sources to ensure pipeline accuracy; bridging data and business value by linking source data to actionable insight; and helping standardise data models, core metrics, and processes across the Insights team.

Experience
Minimum 2+ years in data analytics, data engineering, or analytics engineering.
Advanced proficiency in SQL with the ability to write complex, performant, and clean code.
Proven experience designing, building, and automating robust ELT/ETL pipelines.
Familiarity with transformation and version control frameworks such as dbt or Dataform, alongside Git for code management and collaboration.
Hands-on experience with cloud data warehouses, preferably GCP BigQuery or similar platforms.
Strong understanding of data engineering principles and dimensional modelling (star schema, snowflake schema).
Excellent data profiling skills to explore, compare, and validate diverse data sources.

About you
A passion for TV content and ITV, with a strong understanding and interest in television.
Detail-oriented with a commitment to data quality and accuracy.
Collaborative team player able to work closely with analysts, insights managers, and data teams.
Proactive in exploring new data sources and improving existing pipelines.
Strong communication skills to bridge data and business insights effectively.

Qualifications
No specific qualifications are mandated, but relevant experience and skills in analytics engineering, SQL, cloud platforms, and data modelling are essential.