Data Engineer
Ocado Group27 days ago
Hatfield, United KingdomMid Level
Responsibilities
- Build and maintain the core data warehouse supporting analytics, reporting, machine learning, and partner data products.
- Design, develop, and maintain scalable ELT/ETL pipelines across enterprise data solutions.
- Build and optimise dimensional and analytical data models for business reporting and analytics.
- Develop reusable data transformation logic using 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, business-ready datasets.
- Monitor, troubleshoot, and optimise pipeline performance and operational resilience.
- Participate in code reviews, engineering improvements, documentation, and knowledge sharing.
Requirements
- Proven experience developing ELT/ETL pipelines and using data transformation frameworks such as dbt.
- Strong SQL skills and programming fundamentals in Python, SQL, or standard query languages.
- Hands-on experience with Git and CI/CD workflows.
- A degree in Computer Science, Data Science, Software Engineering, Mathematics, or equivalent practical experience.
- Understanding of data storage, transformation, and analysis concepts.
- Strong analytical, problem-solving, communication, and collaboration skills.
- Preferred qualifications include Python experience for data engineering workloads, modern cloud data warehouse experience ideally with Google BigQuery, dimensional modelling knowledge, and experience with Airflow, Terraform, or Grafana.
Benefits
- Hybrid working in Hatfield.
- 25 days annual leave, rising to 27 days after five years, with the option to buy more leave.
- 30 days per year to work from anywhere in the world.
- Private Medical Insurance from the first month, wellbeing support, Employee Assistance Programme, Income Protection, and Life Assurance.
- 22 weeks paid maternity or primary carer leave and six weeks paid paternity leave.
- Pension with employer matching up to 7%, share schemes, and interest-free train-ticket loans.
- Cycle to Work Scheme and free shuttle buses to and from Hatfield and Welwyn Garden City stations.
- 15% discount at Ocado.com with free delivery from the first month.
About Ocado Group
Ocado Group builds and licenses the Ocado Smart Platform, an end-to-end e-commerce, fulfillment, and robotics solution for grocery retailers, along with logistics and operations services. It also operates Ocado Retail in the UK via a 50:50 joint venture with Marks & Spencer. Founded in 2000 and headquartered in Hatfield, Hertfordshire, Ocado is a public company listed on the London Stock Exchange.