Data Engineer: ELT/ETL, Data Warehouse & dbt Pipelines

Ocado Group; Hatfield; On-site; GBP 70,000 - 90,000; Full time

Benefits offered by this job

25 days annual leave

Private Medical Insurance

Pension with employer matching up to 7

Cycle to Work Scheme

Ocado employee discounts

Job summary

Ocado Group is seeking a Data Engineer to build and maintain the foundational data warehouse powering analytics, ML, and partner data products. You will transform raw data into governed datasets, design scalable ELT/ETL pipelines, and implement quality checks in a cloud data warehouse environment.

You will collaborate with data scientists, analysts, product owners, and platform engineers in an agile setting to deliver reliable data feeds and transformation frameworks, while continuously

Qualifications

• Proven experience developing ELT/ETL pipelines and working with data transformation frameworks such as dbt.
• Strong SQL skills and a solid understanding of programming fundamentals in Python, SQL, or standard query languages.
• Hands-on experience using Git and CI/CD workflows.
• Strong analytical, problem-solving, and clear communication skills with a collaborative mindset.
• Degree in Computer Science, Data Science, Software Engineering, Mathematics, or equivalent practical experience.
• Solid understanding of core data concepts, including data storage, transformation, and analysis.

Responsibilities

• Responsible for building and maintaining the core data warehouse that powers analytics, reporting, machine learning, and partner data products.
• Design, develop, and maintain scalable, reliable ELT/ETL pipelines across enterprise data solutions.
• Build and optimise dimensional and analytical data models to meet complex business reporting and analytics needs.
• Develop and maintain reusable data transformation logic using modern software engineering best practices.
• Implement automated data quality checks, pipeline monitoring, and testing frameworks to ensure data reliability.
• Collaborate with analysts, data scientists, product teams, and platform engineers to deliver secure, business-ready datasets.
• Monitor, troubleshoot, and optimise pipeline performance to continuously improve efficiency and operational resilience.
• Participate in code reviews and actively contribute to continuous improvements in team engineering standards.
• Produce clear documentation and foster knowledge sharing across the data engineering craft.

Skills

ELT/ETL pipelines

dbt

SQL

Python

Git

CI/CD

data concepts

communication

Agile

Education

Degree in Computer Science, Data Science, Software Engineering, Mathematics, or equivalent practical experience

Tools

Airflow

Terraform

Grafana

Google BigQuery

Job description

Ocado Group is seeking a Data Engineer to build and maintain the foundational data warehouse powering analytics, ML, and partner data products. You will transform raw data into governed datasets, design scalable ELT/ETL pipelines, and implement quality checks in a cloud data warehouse environment.

You will collaborate with data scientists, analysts, product owners, and platform engineers in an agile setting to deliver reliable data feeds and transformation frameworks, while continuously