Analytics Engineer

ITV Consumer Limited 2024; Greater London; Hybrid; GBP 60,000 - 90,000; Full time

Benefits offered by this job

Generous holiday allowance

Annual bonus

Pension contribution

Save as you earn – ITV shares

Wellbeing days

Volunteering days

Job summary

ITV is seeking a data analytics engineer for a 12 Month Fixed-Term Contract within the ITV Insights Group in London. The role focuses on building robust SQL-based data pipelines, advancing the KPI ecosystem, and migrating workloads to BigQuery notebooks.

You will collaborate across analytics, data science and central data teams to deliver scalable data products. The ideal candidate has 2+ years in data analytics/engineering, strong SQL, and hands-on experience with dbt or Dataform, Git, and

Qualifications

• 2+ years of experience in data analytics, data engineering, or analytics engineering.
• Advanced SQL proficiency with complex, performant code.
• Design, build, and automate robust ELT/ETL pipelines.
• Experience with dbt or Dataform and Git for version control.
• Hands-on experience with GCP BigQuery or similar cloud platforms.
• Understanding of dimensional modeling (star/snowflake).

Responsibilities

• Champion analytics engineering best practices by designing robust SQL-based pipelines.
• Maintain and evolve KPI pipelines and connect Dataform to GitHub for version control.
• Design data quality checks and automated tests with Slack alerts.
• Support UAT on new data products with Central & Insights teams.
• Collaborate with analysts to build foundational tables for dashboards.
• Migrate legacy processes to BigQuery notebooks and pipelines to reduce costs.
• Help rebuild ITVX streaming data as a dimensional model and document data products.
• Integrate new data sources and build automated API connections.
• Bridge data and business value by standardising data models and core metrics.

Skills

Advanced SQL proficiency

Data Pipeline Development

dbt or Dataform

Git version control

Cloud Data Warehouse (GCP BigQuery)

Data Modeling

Data Profiling

Tools

dbt

Dataform

Git

BigQuery

Job description

12 Month Fixed-Term Contract Main purpose of the role: The ITV Insights Group will lead the business in putting insight in every key decision. For example; What content should we commission? Which audience is most commercially attractive for us? How do we optimise our product to improve view through rates? The answers to these questions and more will enable ITV to succeed in the future. This role will be line managed by the Lead Analytics Developer, with the primary aim to develop data products to enable the analytics priorities of the Insights Group. The role will also work closely with the Head of Analytics and collaboratively with the analytics function within the Insights Group, as well as Central Insights and Data Science. Specific responsibilities:

• Champion analytics engineering best practices within the Insights team by designing and structuring robust, SQL-based analytical pipelines.
• Maintain the M&E KPI pipeline, iterating on metrics as business needs evolve. Embed best practices by connecting Dataform to GitHub for seamless code sharing and version control.
• Design and implement rigorous data quality checks and automated tests, configuring proactive Slack notifications to alert the team to pipeline issues.
• Support the Central Data team to conduct thorough User Acceptance Testing (UAT) on newly developed data products.
• Collaborate closely with analysts and insights managers to design, build, and optimise tables that serve as the foundation for fast, efficient dashboards.
• Drive the migration of legacy processes over to BigQuery notebooks and pipelines, simultaneously reducing operational costs and improving query efficiency.
• Assist in rebuilding and maintaining ITVX streaming data as a robust dimensional model using dbt. This involves integrating complex datasets, such as content metadata, broadcast schedules, VOD windows, content contracts, and user demographics. Ensure all data products are comprehensively documented for the wider business.
• Explore and integrate new data sources to empower the Insights team. This includes building automated API connections (e.g. Barb) and proactively auditing varied sources (such as FAST schedule feeds) to guarantee our pipelines run on the most accurate data available.
• Bridge data and business value by acting as the link between source data and actionable insight. Help standardise data models, core metrics, and processes across the Insights team.
• 2+ years of experience in data analytics, data engineering, or analytics engineering
• Advanced SQL proficiency: Ability to write complex, performant, and clean code
• Data Pipeline Development: Ability to design, build, and automate robust ELT/ETL pipelines to turn raw data into clean, reliable data products
• Transformation & Version Control: Experience using frameworks like dbt or Dataform, alongside Git for code management, collaboration, and version control
• Cloud Data Warehouse experience: Hands-on experience with GCP (BigQuery) or similar cloud platforms
• Data Modeling expertise: Understanding of data engineering principles and dimensional modelling (star schema, snowflake schema)
• Data Profiling: Strong ability to explore, compare, and validate different data sources to fully understand their structure and quirks
• A passion for TV Content, and ITV, with an excellent understanding and interest in television
• Flexible working with a range of options
• Generous holiday allowance, plus you can buy more
• Annual bonus opportunity
• Competitive pension contribution
• Save as you earn - with an opportunity to buy ITV shares
• Wellbeing and volunteering days plus a wide range of opportunities to help you live a balanced and healthy life

More about our benefitsCorporate Teams Working smart and working fast, we're behind the most talked-about brands. Discover more about the teams making sure everyone at itv has a life outside of work. Find out moreWhat is the magic of ITV? It starts with a simple love of television. Watching it, creating it, talking about it. Whether it's daytime or primetime, for downtime or anytime. We're inspired by our audiences. Who helps shape what we make. Standing shoulder to shoulder with them. Because what matters to them, matters to us. Starting conversations. Winning hearts. Changing minds and sometimes even society itself. Big or small, what we make makes an impact.