Data Engineer

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

Benefits offered by this job

25 days annual leave + 30 days WFH

Private medical insurance

Pension with employer contribution

Cycle to work

Shuttle buses to Hatfield

Ocado discount

Job summary

Ocado Group requires a Data Engineer to join the Data Engineering Modelling and Transformation team. You will build and maintain the foundational data warehouse powering analytics, reporting, ML, and partner data products across Ocado Technology.

As part of an agile team, you will design reliable ELT/ETL pipelines, implement data quality checks, and optimise cloud-based data warehouse infrastructure to deliver trusted datasets for enterprise consumers.

Qualifications

• Proven experience building ELT/ETL pipelines and data transformation frameworks (dbt).
• Strong SQL skills and programming fundamentals in Python/SQL.
• Hands-on experience with Git and CI/CD workflows.
• Analytical, problem-solving, and clear communication skills; collaborative mindset.

Responsibilities

• Build and maintain the core data warehouse powering analytics, reporting and ML.
• Design, develop and maintain scalable ELT/ETL pipelines across enterprise data solutions.
• Create dimensional/analytical data models for complex reporting needs.
• Develop reusable data transformation logic following software engineering best practices.
• Implement automated data quality checks, pipeline monitoring and testing frameworks.
• Collaborate with analysts, data scientists, product teams and platform engineers to deliver secure datasets.
• Monitor and optimise pipeline performance for efficiency and resilience.
• Participate in code reviews and contribute to engineering standards.

Skills

ELT/ETL pipelines

SQL

Python

Git

CI/CD

Data quality

Analytical thinking

Education

Bachelor's degree in Computer Science, Data Science, Software Engineering, Mathematics, or equivalent

Tools

dbt

Airflow

Terraform

Grafana

Job description

Introduction:

We are Ocado Group, and we're bringing world-class automation to online grocery. Our Ocado Smart Platform (OSP) combines cutting‑edge robotics, AI, and IoT within our advanced CFCs (Customer Fulfilment Centres). We've mastered the single pick, transforming online delivery for our global partners. Join us and be part of a team pushing the boundaries of retail technology.

About the Role:

As a Data Engineer within our Data Engineering Modelling and Transformation team, you will be directly responsible for building and maintaining the foundational data warehouse that powers analytics, reporting, machine learning, and partner data products across Ocado Technology. In this role, you will transform raw operational data into trusted, governed, and business-ready datasets that drive strategic and operational decision‑making across the entire organisation.

Working in an agile environment, you will collaborate closely with data scientists, analysts, product owners, and platform engineers to deliver high-quality data feeds and scalable transformation frameworks. You will focus on designing reliable ELT/ETL pipelines, establishing rigorous data quality controls, and optimizing performance across our cloud data warehouse infrastructure to ensure seamless downstream data delivery for all enterprise consumers.

Key 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.

What We’re Looking For:

• 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.

Nice to Haves

• Practical experience writing Python for data engineering workloads.


• Experience working with modern cloud data warehouses, ideally Google BigQuery.


• Practical understanding of dimensional data modelling principles.


• Experience using tools in our tech stack such as Airflow, Terraform, or Grafana.


• Previous experience working within Agile delivery teams.

We believe in supporting our people with meaningful, flexible benefits that prioritise well-being and work-life balance. Here's a snapshot of what you can expect:

Time to recharge

• 25 days annual leave (rising to 27 after 5 years), plus the option to buy more - and 30 days a year to work from anywhere in the world.


• Private Medical Insurance from your first month, wellbeing support through specialist apps and EAP, plus Income Protection and Life Assurance.


• 22 weeks paid maternity/primary carer leave and 6 weeks paid paternity leave


• Pension with employer matching up to 7%, share schemes (Sharesave & BAYE), and interest‑free loans for train tickets.


• Cycle to Work Scheme and free shuttle buses to/from Hatfield and Welwyn Garden City stations.


• 15% off at Ocado.com with free delivery (starting in your first month).

Be bold, be unique, be brilliant, be you. We are looking for individuality and we value diversity. We are an equal opportunities employer and we are committed to treating all applicants and employees fairly and equally. We are committed to making reasonable adjustments to provide a positive, barrier‑free recruitment process and supportive work environment. If you have any support or access requirements, we encourage you to advise us at the time of application.

#LI-HYBRID

#LI-JT1

Stay in the loop

Can't find what you're looking for or not ready for a move? Join our Talent Community to stay up to date with Ocado Group news and events, you'll also be the first to know about new opportunities - before they are posted.