Data Engineer
Builds and runs Ocado's central data warehouse powering analytics, reporting, ML, and partner data products — designing scalable ELT/ETL pipelines with dbt, SQL, and Python, plus automated data-quality checks, monitoring, and testing within Git/CI-CD engineering workflows, on-site in Hatfield, UK.
- Compensation
- Not disclosed
- Location
- Hatfield, United Kingdom
- Work setup
- Remote
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- Not specified
- Category
- Data engineering
- Posted
Skills
Must have
- Proven experience developing ELT/ETL pipelines and working with dbt
- Strong SQL skills and foundation in Python/SQL or comparable query languages
- Practical experience with Git and CI/CD workflows
- Strong analytical and problem-solving skills with good communication and a collaborative way of working
- Degree in Computer Science, Data Science, Software Engineering, Mathematics or equivalent practical experience
- Solid understanding of data concepts, storage, transformation, and analysis
- Team orientation and clear communication
Nice to have
- Structured, analytical thinking
Full description
Overview
In this Data Engineer role, you will build and maintain a foundational data warehouse that powers analytics, ML, and partner data products. You’ll transform raw data into trusted, business-ready datasets through scalable ELT/ETL pipelines and robust data quality controls. You’ll work in an agile, cross-functional environment to deliver secure, scalable data feeds that support decision-making across the organisation. This is a hands-on role with impact on data architecture, performance, and governance, enabling data-driven outcomes.
Pay / Benefits
- 25 days annual leave
- 30 days remote work from anywhere
- Private Medical Insurance
- pension with employer matching up to 7%
- Sharesave and BAYE share schemes
- Cycle to Work Scheme
Responsibilities
- Build and maintain the core data warehouse powering analytics, ML, and partner data products
- Design, develop, and maintain scalable ELT/ETL pipelines
- Develop and optimise dimensional and analytical data models
- Create reusable data transformation logic using modern software engineering practices
- Implement automated data quality checks, monitoring, and testing frameworks
- Collaborate with analysts, data scientists, product teams, and platform engineers to deliver datasets
- Monitor and optimise pipeline performance for efficiency and resilience
- Participate in code reviews and contribute to engineering standards
- Produce clear documentation and share knowledge across the team
Key requirements
- Proven experience developing ELT/ETL pipelines and dbt
- Strong SQL skills and programming familiarity with Python/SQL
- Hands-on experience with Git and CI/CD workflows
- Strong analytical and problem-solving abilities with clear communication and collaboration
- Degree in Computer Science, Data Science, Software Engineering, Mathematics, or equivalent practical experience
- Solid understanding of core data concepts including storage, transformation, and analysis
- Collaborative mindset
- Analytical thinking
- Clear communication
- ELT/ETL pipelines
- dbt
- SQL