Analytics Engineer

Ocado Technology Group; Hatfield; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

A leading logistics technology provider in Hatfield is looking for an Analytics Engineer to enhance their data model capabilities. You will be responsible for designing, testing, and documenting production-grade data models and automating data pipelines to improve decision-making. Candidates must possess a strong background in SQL and experience with Google BigQuery. The company offers a collaborative culture, flexible working conditions, and comprehensive benefits to support employee well-being.

Benefits

30 days 'work from anywhere' policy

Dedicated wellbeing support apps

Generous leave increasing with years of service

Pension plan with up to 7% employer contribution

Comprehensive private medical cover

Family-friendly leave policies

Interest-free train tickets

Free shuttle services

Share schemes

15% discount on Ocado and other retailers

Income protection and life insurance

Qualifications

• Highly proficient in SQL, with experience in window functions and performance tuning.
• Hands-on experience with Google Cloud Platform.
• Strong understanding of dimensional modelling and Star Schema.
• Experienced in using dbt for data transformation.
• Ability to communicate technical specifications from business requirements.

Responsibilities

• Design and document production-grade data models using SQL and dbt.
• Develop transformation layers for analytical needs.
• Automate data pipelines for analysis and user-centric applications.
• Optimize SQL queries for performance efficiency.
• Champion software engineering best practices in analytics.

Skills

Proficiency in SQL

Experience with cloud data warehouses

Understanding of data modelling concepts

Experience with dbt or similar tools

Proactive communication skills

Education

Relevant degree or equivalent experience

Tools

Google BigQuery

Git

Job description

Analytics Engineer - Hybrid (Hatfield 2 days a week)

Here at Ocado Logistics it’s our mission to provide an outstanding customer experience for our partners, developing groundbreaking technology, opening multiple sites at an accelerating rate and engaging in exciting new business partnerships around the world - changing the way the world shops, for good.

We are the beating heart of our UK business and comprise a network of cutting edge warehouses and offices across the country that ensure that we optimise the experience and use our proprietary technology across the supply chain to deliver an exceptional shopping experience. At the same time delivering bags of possibilities for our employees and a career that will ensure no two days are ever the same.

We wouldn’t be able to positively impact the way the world shops without our passionate team members - who keep our business running, our vans delivering, our customers' products picked and packed and our proprietary technology operating at optimum levels. Both behind the scenes within the warehouses and across the front end of the customer experience which means we now have an opportunity for an Analytics Engineer to join the team.

The Analytics Engineer sits at the intersection of data analysis, automation, and application development, bridging the gap between raw data sources and business insights. You will be responsible for designing and documenting clean data models that power our decision‑making, while playing a pivotal role in modernising our technology stack by increasing our adoption of transformation orchestration and implementing robust automation practices.

You will be

• Designing, testing, and documenting production‑grade data models using SQL and dbt within Google BigQuery.
• Developing transformation layers to build staging, intermediate, and mart tables that serve global analytical and reporting needs.
• Automating data pipelines to feed analysis and building user‑centric applications to replace legacy tools (Excel/Oracle).
• Optimising SQL queries and BigQuery usage to ensure performance efficiency and cost control across the network.
• Championing software engineering best practices within the analytics workflow, including Git workflows, CI/CD, and code reviews.

About you

• You are highly proficient in SQL, with specific experience in window functions, nested data, and performance tuning for the Analytics Engineer remit.
• You have hands‑on experience working with cloud data warehouses, specifically Google Cloud Platform (BigQuery).
• You possess a strong understanding of data modelling concepts, including dimensional modelling and Star Schema.
• You are experienced in using dbt (or similar) for data transformation and are familiar with version control systems such as Git.
• You are a proactive communicator, able to translate business requirements from non‑technical stakeholders into technical specifications.

What you can expect to receive in return

At Ocado we believe in a workplace where everyone feels valued and supported, so you’ll find a safe and collaborative atmosphere that is as fresh as our produce as well as an award winning recognition programme and benefits package that includes a healthy work‑life balance, extensive healthcare coverage, competitive salaries, and exclusive employee discounts.

• Flexible Work: Enjoy 30 days of 'work from anywhere' policy for a balanced life.
• Wellbeing Support: Access dedicated apps and an Employee Assistance Programme for holistic well‑being.
• Generous Leave: Begin with 25 days, growing to 27 after 5 years, with an option to buy more.
• Pension Plan: Secure your future with our pension scheme, featuring up to 7% employer contribution matching.
• Private Medical Cover: Rest easy with comprehensive private medical insurance.
• Family‑Friendly: We support your family with maternity, adoption, shared parental leave, and paternity leave.
• Financial Aid: Get interest‑free train tickets and join our Cycle to Work Scheme.
• Shuttle Services: Convenient free shuttle buses connect you to work.
• Share Schemes: Join exciting share plans to participate in our success.
• Shopping Perks: Enjoy a 15% discount on https://www.google.com/url?sa=E&source=gmail&q=Ocado.com and savings at popular retailers and restaurants.
• Financial Protection: We offer Income Protection and Life Insurance for financial security.

Join Ocado Logistics today and become a part of a culture that wholeheartedly values and supports your well‑being throughout every stage of your career.

Due to the high volume of applications we receive, if you have not heard from us within 3 weeks of the closing date, please assume that your application has been unsuccessful on this occasion.

Ocado Group is an equal opportunities employer and as such makes every effort to ensure that all potential employees are treated fairly and equally, regardless of their sex, sexual orientation, marital status, race, colour, nationality, ethnic or national origin, religion or belief, age, or disability or union membership status.