
Analytics Engineer
Ocado Group2 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
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.