Senior Analytics Engineer: Data Pipelines & BigQuery

ITV plc; Greater London; Hybrid; GBP 65,000 - 85,000; Full time

Job summary

ITV plc in London, White City, seeks a data analytics engineer on a 12-month fixed-term contract. The role will develop data products, maintain KPI pipelines, and collaborate across the Insights Group, Data Science, and Central Insights.

The team focuses on how content decisions and audiences are optimised through robust data models and scalable pipelines. You will work with dbt/Dataform, Git, and BigQuery to deliver reliable data foundations for dashboards and decision-making in a hybrid office

Qualifications

• 2+ years of experience in data analytics, data engineering, or analytics engineering.
• Advanced SQL proficiency: write complex, performant, and clean code.
• Design, build, and automate robust ELT/ETL pipelines.
• Experience using dbt or Dataform with Git for version control.
• Cloud data warehouse experience with GCP BigQuery or similar.

Responsibilities

• Champion analytics engineering best practices within the Insights team by designing robust SQL-based pipelines.
• Maintain KPI pipelines and integrate Dataform with GitHub for version control.
• Design and implement data quality checks and automated tests, with Slack alerts for pipeline issues.
• Support UAT on new data products with the Central Data team.
• Collaborate with analysts to build and optimize tables for fast dashboards.
• Lead migration of legacy processes to BigQuery notebooks and pipelines to reduce costs and improve queries.
• Help rebuild ITVX streaming data as a dimensional model with dbt and document data products.
• Explore and integrate new data sources, including API connections, to ensure data accuracy across pipelines.
• Bridge data and business value by standardising data models and core metrics.

Skills

Advanced SQL proficiency

Data analytics

ELT/ETL pipelines

Data modeling

DBT/Dataform

Git version control

TV content passion

Tools

dbt

Dataform

Git

Job description

ITV plc in London, White City, seeks a data analytics engineer on a 12-month fixed-term contract. The role will develop data products, maintain KPI pipelines, and collaborate across the Insights Group, Data Science, and Central Insights.

The team focuses on how content decisions and audiences are optimised through robust data models and scalable pipelines. You will work with dbt/Dataform, Git, and BigQuery to deliver reliable data foundations for dashboards and decision-making in a hybrid office