Ocado Group

Analytics Engineer

Ocado Group  •  Hatfield, GB (Hybrid)  •  5 hours ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

Analytics Engineer | Tech Ops | Hybrid Working | Hatfield

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 an Analytics Engineer for Tech Ops and OMRS, you will bridge the gap between data producers and data consumers, transforming complex data from our robotics and automated systems into trusted, certified data foundations. Focusing on bot, grid, and maintenance telemetry, you will design reporting layers in dbt and implement standardized definitions in the semantic layer to ensure metrics remain consistent across all dashboards, analysts, and AI tools.

In this role, you will act as the key liaison between Data Engineering and business analysts, establishing robust data models and governing metric changes. You will play a pivotal role in enabling self-service analytics, triaging domain requests, and using modern AI-assisted engineering tools to build reliable, high-performing data pipelines that support our global operations.

Key Responsibilities:

  • Build and maintain layered dbt models in BigQuery, balancing query performance with long-term maintainability.
  • Implement and govern standardized business metrics within the dbt semantic layer (MetricFlow).
  • Migrate existing metric logic into the semantic layer while resolving data duplication.
  • Elevate analyst workflows into certified, production-ready reporting marts with full documentation and lineage.
  • Implement automated data quality testing and monitoring, escalating issues to upstream data producers.
  • Serve as the primary point of contact to triage and scope data requests across Tech Ops and OMRS.
  • Translate operational processes into clear data requirements in collaboration with subject matter experts.
  • Enable and coach analysts on dbt best practices, conducting merge request reviews.
  • Maintain metadata to ensure compatibility with AI tools and automated analytics plugins.
  • Utilize AI-assisted development tools (such as Claude Code) to accelerate data modelling and migration.

What We’re Looking For:

Essential

  • Strong hands-on experience with SQL (BigQuery preferred) and dbt, including models, macros, testing, and documentation.
  • Proven background in dimensional data modelling (Kimball or Inmon methodologies) and Git version control workflows.
  • Solid understanding of BI platforms (such as Looker) to align reports with semantic layers.
  • Ability to translate ambiguous business requirements into precise technical data structures.
  • Clear communication skills with the ability to explain technical trade-offs to non-technical stakeholders.
  • Degree in a numerate discipline or equivalent practical experience.

Nice to Haves

  • Experience working with metric/semantic layers (MetricFlow, LookML) or data quality tools (e.g., Validio).
  • Proficiency with Python, Google Cloud Platform (GCP), or data modelling tools such as SQLdbm.
  • Familiarity with using AI development tools to write, optimize, or review analytics code.
  • Prior exposure to telemetry, robotics, warehouse automation, or maintenance data.

Benefits

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.
  • Health & wellbeing:
  • Private Medical Insurance from your first month, wellbeing support through specialist apps and EAP, plus Income Protection and Life Assurance.
  • Family-first policies:
  • 22 weeks paid maternity/primary carer leave and 6 weeks paid paternity leave
  • Financial support:
  • Pension with employer matching up to 7%, share schemes (Sharesave & BAYE), and interest-free loans for train tickets.
  • Commuter perks:
  • Cycle to Work Scheme and free shuttle buses to/from Hatfield and Welwyn Garden City stations.
  • Exclusive discounts:
  • 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

Ocado Group

About Ocado Group

We’re Ocado Group - a global, technology business redefining ecommerce, fulfilment and logistics in online grocery and distribution industries. Our cutting-edge, proprietary technology enables our partners and customers to win in their markets, develop a competitive advantage and offer an unparalleled customer proposition.

Our mission is simple — to change the way the world shops for good.

Our heritage as the UK’s largest pure-play online grocer through Ocado Retail LTD (a 50:50 joint venture with M&S), and expertise in high-performing logistics and fulfilment through Ocado Logistics, has equipped us with technology innovation, expertise and operational know-how to build and innovate the Ocado Smart Platform (OSP). OSP is the world’s leading ecommerce, fulfilment and logistics platform designed for the unique demands of online grocery and trusted by leading online grocery retailers worldwide.

Now, with Ocado Intelligent Automation (OIA), our unparalleled experience and proven automated retrieval and storage technology is helping businesses outside of online grocery future-proof their fulfilment operations.

Industry
IT & Software
Company Size
5,001-10,000 employees
Headquarters
Hatfield, GB
Year Founded
Unknown
Social Media