Ocado Group

Analytics Engineer

Ocado Group
Apply
2 days ago
Hatfield, United KingdomMid Level

Responsibilities

  • Build and maintain performant, maintainable layered dbt models in BigQuery.
  • Implement and govern standardized business metrics in the dbt semantic layer using MetricFlow.
  • Migrate existing metric logic into the semantic layer and resolve data duplication.
  • Transform analyst workflows into certified, production-ready reporting marts with documentation and lineage.
  • Implement automated data-quality testing and monitoring and escalate issues to upstream data producers.
  • Triage and scope data requests across Tech Ops and OMRS and translate operational processes into precise data requirements.
  • Enable and coach analysts on dbt best practices and conduct merge-request reviews.
  • Maintain metadata for compatibility with AI tools and automated analytics plugins.
  • Use AI-assisted development tools such as Claude Code to accelerate data modelling and migration.

Requirements

  • Strong hands-on experience with SQL and dbt, including models, macros, testing, and documentation, with BigQuery preferred.
  • Experience with dimensional data modelling using Kimball or Inmon methodologies.
  • Experience with Git version-control workflows and BI platforms such as Looker.
  • Ability to translate ambiguous business requirements into precise technical data structures and explain technical trade-offs to non-technical stakeholders.
  • A degree in a numerate discipline or equivalent practical experience.
  • Preferred experience with MetricFlow, LookML, Validio, Python, Google Cloud Platform, SQLdbm, and AI development tools.
  • Prior exposure to telemetry, robotics, warehouse automation, or maintenance data is advantageous.

Benefits

  • Hybrid working in Hatfield.
  • 25 days of annual leave, increasing to 27 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 apps and EAP support, Income Protection, and Life Assurance.
  • 22 weeks of paid maternity or primary-carer leave and six weeks of paid paternity leave.
  • Pension with employer matching up to 7%, Sharesave and BAYE 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.
  • Equal-opportunity employer offering reasonable adjustments and a supportive, barrier-free recruitment process.

Tech Stack

Categories

Data Engineering
Ocado Group

About Ocado Group

5,001-10,000 employees

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.

Contact me