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. About the role: 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 includes a healthy work-life balance, extensive healthcare coverage, competitive salaries, and exclusive employee discounts. 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. 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. 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.