Data Engineer

The Data & Insights department ensures that we keep accurate data at the heart of all of Ocado Retail's decision making. As a Data Engineer your skills will be essential in building and maintaining the foundations of our data solution; bringing in large quantities of data from a variety of sources, and ensuring it's clearly structured and documented. The data warehouse you would help manage would then be used by our Reporting team to deliver business intelligence to a wide range of stakeholders, and our Insights and Data Science teams to experiment and improve our proposition.

This Data Engineer role sits within a distributed Data Management team (offshore and onshore) of ~20. You will work through a backlog of developments to evolve our data warehouse. This includes integrating new data sources, developing data marts, analysing and resolving data quality issues and evolving our framework and practices to improve our delivery or development efficiency.

What you'll do

• Work as part of the Data Management team to build and maintain our data warehouse.
• Work with data users around the business to understand new requirements or issues with existing assets.
• Build ELT pipelines, sourcing data from multiple systems and propagating results into data warehouse and marts.
• Monitor, manage and resolve operational and quality issues within the data warehouse and marts.
• Manage security and information confidentiality.
• Peer QA and test deliverables.
• Support deployment and validation.
• Adhere to agreed standards and processes to ensure our work output is consistent, compliant and of high quality.
• Contribute to development of standards and processes to take advantage of rapidly evolving technologies, to improve team efficiency or work quality (e.g. with AI assistance).
• Collaborate with technical teams to integrate data scientists' models and business logic into production systems

Do you have experience in SQL?, * Experience with cloud data engineering, preferably with Google Cloud Platform

• Proficient with SQL and Python
• Experience working with cloud data orchestration tools e.g. Google Cloud Composer/Apache Airflow
• Experience working with grocery retail/e-commerce data
• Experience working with change management and CI/CD tools e.g. GitLab
• Evidence of improving efficiency in a data organisation with effective automation
• Experience working with Agile or other responsive application development methods
• Able to self-direct and take on broad projects from end-to-end
• Comfortable interacting with a wide range of stakeholders and data consumers

Our mission is to deliver joy in every shop, through unbeatable choice, unrivalled service, and reassuringly good value. We're Ocado Retail, a market-leading joint venture between Ocado Group and M&S, and the world's largest dedicated online supermarket, ocado.com. Not only is Ocado.com the only place to shop a full range of M&S food online, it's also the home to the widest online supermarket range in the UK and champion of small, independent brands. We're also the brains behind Zoom by Ocado, our same-day grocery delivery service., By joining Ocado Retail, you'll have the chance to experience life at the world's largest online retailer, work with an amazing bunch of people who challenge what's possible each day, and grow your skills and career in online retail. If that's not enough to tempt you, you'll also get access to loads of great benefits to sweeten the deal. Here's a taste of what we offer: Health & Wellbeing: Private medical insurance with option to add your family, Digital GP appointments, market-leading family policies, mental health support, discounted gym memberships, dental insurance, and more. Spend & Save: Annual bonus scheme split between personal and business objectives, recognition with reward platform, up to 7% matched pension contributions, 15% Ocado discount, 20% M&S discount, free breakfast every day in the office, electric vehicle leasing scheme, and free shuttle bus from Hatfield station to the office. Never miss the moments that matter: Hybrid working, 26 days holiday plus 8 flexible bank holidays, options to buy extra holiday, 2 weeks work from anywhere, and lifestyle break opportunities.