Data Engineer

p iframe src= https://www.youtube.com/embed/bY0nNPT75xY width= 560 height= 314 /iframe /p p strong Data Engineer (Modelling amp; Transformation)| Hybrid Working | Hatfield /strong /p p strong /strong /p p data-path-to-node= 2 strong data-path-to-node= 2 data-index-in-node= 0 Introduction: /strong /p p data-path-to-node= 2 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. /p p id= p-rc_ed609c6a5ee7893e-248 data-path-to-node= 3 span data-path-to-node= 3,0 strong data-path-to-node= 3,0 data-index-in-node= 0 About the Role: /strong /span /p p data-path-to-node= 3 span data-path-to-node= 3,0 As a Data Engineer within our Data Engineering Modelling and Transformation team, you will be directly responsible for building and maintaining the foundational data warehouse that powers analytics, reporting, machine learning, and partner data products across Ocado Technology /span span data-path-to-node= 3,1 sup class= superscript /sup /span span data-path-to-node= 3,2 . In this role, you will transform raw operational data into trusted, governed, and business-ready datasets that drive strategic and operational decision-making across the entire organisation /span span data-path-to-node= 3,3 sup class= superscript /sup /span span data-path-to-node= 3,4 . /span /p p id= p-rc_ed609c6a5ee7893e-249 data-path-to-node= 4 span data-path-to-node= 4,0 Working in an agile environment, you will collaborate closely with data scientists, analysts, product owners, and platform engineers to deliver high-quality data feeds and scalable transformation frameworks /span span data-path-to-node= 4,1 sup class= superscript /sup /span span data-path-to-node= 4,2 . You will focus on designing reliable ELT/ETL pipelines, establishing rigorous data quality controls, and optimizing performance across our cloud data warehouse infrastructure to ensure seamless downstream data delivery for all enterprise consumers /span span data-path-to-node= 4,3 sup class= superscript /sup /span span data-path-to-node= 4,4 . /span /p p data-path-to-node= 5 strong data-path-to-node= 5 data-index-in-node= 0 Key Responsibilities: /strong /p ul data-path-to-node= 6 li p id= p-rc_ed609c6a5ee7893e-250 data-path-to-node= 6,0,0 span data-path-to-node= 6,0,0,0 Responsible for building and maintaining the core data warehouse that powers analytics, reporting, machine learning, and partner data products /span span data-path-to-node= 6,0,0,1 sup class= superscript /sup /span span data-path-to-node= 6,0,0,2 . /span /p /li li p id= p-rc_ed609c6a5ee7893e-251 data-path-to-node= 6,1,0 span data-path-to-node= 6,1,0,0 Design, develop, and maintain scalable, reliable ELT/ETL pipelines across enterprise data solutions /span span data-path-to-node= 6,1,0,1 sup class= superscript /sup /span span data-path-to-node= 6,1,0,2 . /span /p /li li p id= p-rc_ed609c6a5ee7893e-252 data-path-to-node= 6,2,0 span data-path-to-node= 6,2,0,0 Build and optimise dimensional and analytical data models to meet complex business reporting and analytics needs /span span data-path-to-node= 6,2,0,1 sup class= superscript /sup /span span data-path-to-node= 6,2,0,2 . /span /p /li li p id= p-rc_ed609c6a5ee7893e-253 data-path-to-node= 6,3,0 span data-path-to-node= 6,3,0,0 Develop and maintain reusable data transformation logic using modern software engineering best practices /span span data-path-to-node= 6,3,0,1 sup class= superscript /sup /span span data-path-to-node= 6,3,0,2 . /span /p /li li p id= p-rc_ed609c6a5ee7893e-254 data-path-to-node= 6,4,0 span data-path-to-node= 6,4,0,0 Implement automated data quality checks, pipeline monitoring, and testing frameworks to ensure data reliability /span span data-path-to-node= 6,4,0,1 sup class= superscript /sup /span span data-path-to-node= 6,4,0,2 . /span /p /li li p id= p-rc_ed609c6a5ee7893e-255 data-path-to-node= 6,5,0 span data-path-to-node= 6,5,0,0 Collaborate with analysts, data scientists, product teams, and platform engineers to deliver secure, business-ready datasets /span span data-path-to-node= 6,5,0,1 sup class= superscript /sup /span span data-path-to-node= 6,5,0,2 . /span /p /li li p id= p-rc_ed609c6a5ee7893e-256 data-path-to-node= 6,6,0 span data-path-to-node= 6,6,0,0 Monitor, troubleshoot, and optimise pipeline performance to continuously improve efficiency and operational resilience /span span data-path-to-node= 6,6,0,1 sup class= superscript /sup /span span data-path-to-node= 6,6,0,2 . /span /p /li li p id= p-rc_ed609c6a5ee7893e-257 data-path-to-node= 6,7,0 span data-path-to-node= 6,7,0,0 Participate in code reviews and actively contribute to continuous improvements in team engineering standards /span span data-path-to-node= 6,7,0,1 sup class= superscript /sup /span span data-path-to-node= 6,7,0,2 . /span /p /li li p id= p-rc_ed609c6a5ee7893e-258 data-path-to-node= 6,8,0 span data-path-to-node= 6,8,0,0 Produce clear documentation and foster knowledge sharing across the data engineering craft /span span data-path-to-node= 6,8,0,1 sup class= superscript /sup /span span data-path-to-node= 6,8,0,2 . /span /p /li /ul p data-path-to-node= 7 strong data-path-to-node= 7 data-index-in-node= 0 What We’re Looking For: /strong /p p data-path-to-node= 8 em data-path-to-node= 8 data-index-in-node= 0 Essential /em /p ul data-path-to-node= 9 li p id= p-rc_ed609c6a5ee7893e-259 data-path-to-node= 9,0,0 span data-path-to-node= 9,0,0,0 Proven experience developing ELT/ETL pipelines and working with data transformation frameworks such as dbt /span span data-path-to-node= 9,0,0,1 sup class= superscript /sup /span span data-path-to-node= 9,0,0,2 . /span /p /li li p id= p-rc_ed609c6a5ee7893e-260 data-path-to-node= 9,1,0 span data-path-to-node= 9,1,0,0 Strong SQL skills and a solid understanding of programming fundamentals in Python, SQL, or standard query languages /span span data-path-to-node= 9,1,0,1 sup class= superscript /sup /span span data-path-to-node= 9,1,0,2 . /span /p /li li p id= p-rc_ed609c6a5ee7893e-261 data-path-to-node= 9,2,0 span data-path-to-node= 9,2,0,0 Hands-on experience using Git and CI/CD workflows /span span data-path-to-node= 9,2,0,1 sup class= superscript /sup /span span data-path-to-node= 9,2,0,2 . /span /p /li li p id= p-rc_ed609c6a5ee7893e-262 data-path-to-node= 9,3,0 span data-path-to-node= 9,3,0,0 Strong analytical, problem-solving, and clear communication skills with a collaborative mindset /span span data-path-to-node= 9,3,0,1 sup class= superscript /sup /span span data-path-to-node= 9,3,0,2 . /span /p /li li p id= p-rc_ed609c6a5ee7893e-263 data-path-to-node= 9,4,0 span data-path-to-node= 9,4,0,0 Degree in Computer Science, Data Science, Software Engineering, Mathematics, or equivalent practical experience /span span data-path-to-node= 9,4,0,1 sup class= superscript /sup /span span data-path-to-node= 9,4,0,2 . /span /p /li li p id= p-rc_ed609c6a5ee7893e-264 data-path-to-node= 9,5,0 span data-path-to-node= 9,5,0,0 Solid understanding of core data concepts, including data storage, transformation, and analysis /span span data-path-to-node= 9,5,0,1 sup class= superscript /sup /span span data-path-to-node= 9,5,0,2 . /span /p /li /ul p data-path-to-node= 10 em data-path-to-node= 10 data-index-in-node= 0 Nice to Haves /em /p ul data-path-to-node= 11 li p id= p-rc_ed609c6a5ee7893e-265 data-path-to-node= 11,0,0 span data-path-to-node= 11,0,0,0 Practical experience writing Python for data engineering workloads /span span data-path-to-node= 11,0,0,1 sup class= superscript /sup /span span data-path-to-node= 11,0,0,2 . /span /p /li li p id= p-rc_ed609c6a5ee7893e-266 data-path-to-node= 11,1,0 span data-path-to-node= 11,1,0,0 Experience working with modern cloud data warehouses, ideally Google BigQuery /span span data-path-to-node= 11,1,0,1 sup class= superscript /sup /span span data-path-to-node= 11,1,0,2 . /span /p /li li p id= p-rc_ed609c6a5ee7893e-267 data-path-to-node= 11,2,0 span data-path-to-node= 11,2,0,0 Practical understanding of dimensional data modelling principles /span span data-path-to-node= 11,2,0,1 sup class= superscript /sup /span span data-path-to-node= 11,2,0,2 . /span /p /li li p id= p-rc_ed609c6a5ee7893e-268 data-path-to-node= 11,3,0 span data-path-to-node= 11,3,0,0 Experience using tools in our tech stack such as Airflow, Terraform, or Grafana /span span data-path-to-node= 11,3,0,1 sup class= superscript /sup /span span data-path-to-node= 11,3,0,2 . /span /p /li li p id= p-rc_ed609c6a5ee7893e-269 data-path-to-node= 11,4,0 span data-path-to-node= 11,4,0,0 Previous experience working within Agile delivery teams /span span data-path-to-node= 11,4,0,1 sup class= superscript /sup /span span data-path-to-node= 11,4,0,2 . /span /p /li /ul p data-path-to-node= 12 strong data-path-to-node= 12 data-index-in-node= 0 Benefits: /strong /p p data-path-to-node= 12 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: /p p data-path-to-node= 13 em Time to recharge: /em /p p data-path-to-node= 13 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. /p p data-path-to-node= 14 em Health amp; wellbeing: /em /p p data-path-to-node= 14 Private Medical Insurance from your first month, wellbeing support through specialist apps and EAP, plus Income Protection and Life Assurance. /p p data-path-to-node= 15 em Family-first policies: /em /p p data-path-to-node= 15 22 weeks paid maternity/primary carer leave and 6 weeks paid paternity leave /p p data-path-to-node= 16 em Financial support: /em /p p data-path-to-node= 16 Pension with employer matching up to 7%, share schemes (Sharesave amp; BAYE), and interest-free loans for train tickets. /p p data-path-to-node= 17 em Commuter perks: /em /p p data-path-to-node= 17 Cycle to Work Scheme and free shuttle buses to/from Hatfield and Welwyn Garden City stations. /p p id= p-rc_ed609c6a5ee7893e-270 data-path-to-node= 18 em Exclusive discounts: /em /p p id= p-rc_ed609c6a5ee7893e-270 data-path-to-node= 18 15% off at Ocado.com with free delivery (starting in your span class= citation-37 citation-end-37 first month). sup class= superscript data-turn-source-index= 1 /sup /span /p p id= p-rc_ed609c6a5ee7893e-271 data-path-to-node= 19 span class= citation-36 citation-end-36 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. sup class= superscript data-turn-source-index= 2 /sup /span 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. nbsp; /p p #LI-HYBRID /p p #LI-JT1 /p Find more English Speaking Jobs in United Kingdom on Arbeitnow