Data Engineer Mid
Summary
Mid-level Data Engineer at Ocado Group building and maintaining the foundational data warehouse that powers analytics, reporting, ML, and partner data products for the Ocado Smart Platform. Day to day: dimensional data modelling, SQL/Python, dbt ELT pipelines, and automated data quality checks — hybrid working in Hatfield, UK.
Data Engineer (Modelling & Transformation)| Hybrid Working | Hatfield 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).
Skills, with evidence
Build and optimise dimensional and analytical data models to meet complex business reporting and analytics needs. must have
Implement automated data quality checks, pipeline monitoring, and testing frameworks to ensure data reliability. must have
- Python Strong SQL skills and a solid understanding of programming fundamentals in Python, SQL, or standard query languages. must have
- SQL Strong SQL skills and a solid understanding of programming fundamentals in Python, SQL, or standard query languages. must have
- dbt Proven experience developing ELT/ETL pipelines and working with data transformation frameworks such as dbt. must have
- Warehousing 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 .
- Cost & performance Build and optimise dimensional and analytical data models to meet complex business reporting and analytics needs .
- Machine learning 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 . not practised here
- Airflow / orchestration Experience using tools in our tech stack such as Airflow, Terraform, or Grafana .
Implement automated data quality checks, pipeline monitoring, and testing frameworks to ensure data reliability .
- GCP Experience working with modern cloud data warehouses, ideally Google BigQuery . not practised here
- Terraform Experience using tools in our tech stack such as Airflow, Terraform, or Grafana . not practised here