Data Engineer (E2) - Strategy & Operations

This posting is for hourly paid logistics employees to apply through.

Data Engineer (E2) | Strategy & Operations | London | Hybrid (2 days office)

About us:

Ocado Technology is putting the world’s retailers online using the cloud, robotics, AI, and IoT. We develop the innovative software and systems that power Ocado.com, the world’s largest online-only grocery retailer as well as the global ‘Ocado Smart Platform’. With everything from websites to fully autonomous warehouse that we design in-house, our employees need to be specialists in a wide range of technologies to help drive our business. We champion a value-led culture to get our teams working at their very best and to help create a collaborative working environment that our people love. 

About the role: 

This role will sit in the Strategy and Operations & Data Products team, as part of the Central Data Products team that owns OSP Insights. You will work closely with the Data Engineering Product teams and more broadly with analysts across Ocado Group.  

Scope for this role 

• Work with Partners to develop products that solves real partner needs
• Design and deliver data models in BigQuery data warehouse for external and internal consumption using DBT
• Build data products in Looker

You will be instrumental in transforming data into well-structured reliable datasets that empower our organisation and partners to make informed, data driven decisions. Working closely with partners and our central data products team, you'll define requirements and build efficient data models optimized for reporting. You will be responsible for constructing essential data warehouse components (facts, dimensions, reporting tables) and developing the corresponding LookML models in Looker. You will have exposure to how those are being exposed to clients through OSP Insights. 

What we're looking for:

You will need to have…

• Strong communication skills, with the ability to gather and translate partner issues and feedback into clear requirements, and transform those requirements into accessible data products for internal and external use
• Data Modelling: Experience designing, developing and maintaining data models to support data products
• SQL: Proficient in data transformation tools (DBT), compiled query debugging, and query optimization
• Looker Development: Proficiency in LookML modeling and Looker API integration.
• Analytical experience, particularly in data storytelling
• Proficient in applying SDLC principles throughout the development lifecycle

Nice to have…

• Can build dashboards:
• Proficiency building data visualizations and dashboards
• Can administer and configure the Looker instance
• Proficiency using python to manipulate data and call APIs 
• Proficiency in git version control, including experience with branch management, code reviews and repository management
• Experience administering Looker
• Can actively engage with Bigquery DWH development
• Familiarity with DBT concepts and workflows
• Understanding of relational and dimensional data modeling principles
• Familiarity with infrastructure as code such as Teraform 
• Can deliver advanced BI products
• Experience embedding dashboards and reports into web applications 
• Experience building and deploying applications

This would make you stand out from the crowd…

• Designing and delivering BI data products
• Experience with online grocery or take-away services or other eCommerce platforms

What do I get in return:

• Hybrid working model (2 days in the office)
• 30 days ‘work from anywhere’ policy + 
• Remote working for the month of August & 50% of December 
• Wellbeing support through Apps such as Unmind and an Employee Assistance Programme
• 25 days annual leave, rising to 27 days after 5 years service (plus optional holiday purchase)
• Pension scheme (various options available including employer contribution matching up to 7%)
• Private Medical Insurance
• 22 weeks paid maternity leave and 6 weeks paid paternity leave (once relevant service requirements complete)
• Train Ticket loan (interest-free)
• Cycle to Work Scheme
• Opportunity to participate in Share save and Buy as You Earn share schemes
• 15% discount on Ocado.com and free delivery for all employees
• Income Protection(can be up to 50% of salary for 3 years) and Life Assurance(3 x annual salary)

#LI-HYBRID 

#LI-OT

#LI-JT1