Data Engineer: ELT/ETL & Data Warehouse Expert

Ocado Group; Hatfield; Hybrid; GBP 65,000 - 90,000; Full time

Benefits offered by this job

25 days annual leave

Private Medical Insurance

Wellbeing support and EAP

Pension with employer matching

Cycle to Work Scheme

Free shuttle buses to Hatfield

Ocado discount

Job summary

Ocado Group is seeking a Data Engineer to build and maintain the foundational data warehouse powering analytics, reporting, ML, and partner data products. You will transform raw operational data into governed, business-ready datasets and collaborate with data scientists, analysts, and platform engineers in an agile environment.

You will design reliable ELT/ETL pipelines, implement data quality controls, and optimise performance across our cloud data warehouse to ensure seamless downstream data

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

SQL proficiency

Python basics

Analytical thinking

Clear communication

Education

Degree in Computer Science, Data Science, Software Engineering, Mathematics

Tools

dbt

Airflow

Terraform

Grafana

Git & CI/CD

Job description

Ocado Group is seeking a Data Engineer to build and maintain the foundational data warehouse powering analytics, reporting, ML, and partner data products. You will transform raw operational data into governed, business-ready datasets and collaborate with data scientists, analysts, and platform engineers in an agile environment.

You will design reliable ELT/ETL pipelines, implement data quality controls, and optimise performance across our cloud data warehouse to ensure seamless downstream data