Senior SQL Data Analyst

About Ocado Technology

“We are on a mission: to transform the future of online grocery through cutting-edge technology innovation.”

Ocado Technology is changing the way the world shops using advanced Artificial Intelligence, Machine Learning, Robotics, Big Data, Cloud and IoT. We develop the innovative software and hardware systems that power Ocado.com, as well as the unique ‘Ocado Smart Platform’ which is being implemented by ambitious retailers across the world from Europe to America, Asia and beyond. 

We build everything in-house: from intelligent, frictionless e-commerce platforms to highly automated warehouses, our employees are skilled specialists with expertise across a wide range of technologies. We’re working on cutting-edge innovations that are shaping the future of our society.

We are a fast-growing, global company. Today we have colleagues in development centre across the world - London, Hatfield, Welwyn Garden City (UK), Krakow, Wroclaw (Poland), Sofia (Bulgaria), Barcelona (Spain), Stockholm (Sweden), Las Vegas, San Francisco (USA) and Toronto (Canada).

The team... 

This Product Analyst role is in our Ocado Robotics team which will act as a ‘centre of excellence’ driving forward Ocado Technologies Robotic Arm capabilities, spanning multiple use cases across different industries.

As a Product Analyst you will create, maintain and analyse product dashboards using the data created by tests and usability studies within Ocado Robotics, supporting Product Managers to make data driven decisions to continue to innovate and improve our Robotic Picking technology. We’re looking for ambitious, creative problem-solvers who can challenge convention and make an impact.

Your responsibilities will include...

• Value - Identify the fundamental metrics / KPIs behind Ocado Robotics, the levers that drive them and use these to help product managers unlock and track the value delivered by our products
• Architecture - Understand where data resides, who owns it and how it is used and identify opportunities for improvement
• Tooling - Identify and build reusable solutions to enable analysis to build on previous work
• Problem solving - Use your skills and experience to find platform problems and opportunities, help to size them and understand the route cause and drivers to guide the product roadmap
• Data democratisation - Empower teams with the right tools, reports and guidance to leverage insight to make better informed decisions 
• Craft - Share best practice analytics techniques across Ocado Technology

We'd be interested to hear from you if you have the below... 

Essential Toolkit 

• Technical 
• Intermediate-expert SQL experience
• Able to work with large and complex datasets and apply various data wrangling techniques

• Analytics 101
• Designing KPIs and Metrics that Matter
• Applying data analysis techniques and mathematical methods to complex problems 
• Able to provide actionable insights for stakeholders using a data driven approach.
• Building self-service BI solutions e.g. Tableau, Looker, DataStudio
• Statistical analysis 
  
  
• Communication 
• Active listener
• Ability to simplify the complex and tailor output for any audience

• Collaboration 
• Able to bring different skills and personalities together to deliver great outcomes

Mindset

• Can-do attitude in a fast-paced, complex and often ambiguous environment 
• Strong bias for action and impatience for improvement
• Commercially-aware and user-focused - ability to understand needs and identify priorities to unlock value through analytics
• Interest in and curiosity about Robotics

Experience

• Significant demonstrable experience in a Data / Business Analyst role
• First class / 2:1 degree in a highly numerate subject
  (e.g. Computer Science, Maths, Physics, Engineering or similar) or relevant experience

Bonus points if you have experience in... 

• Advanced Analytics: Machine learning and simulation 
• Domain knowledge: Ecommerce, Supply Chain, Fulfilment or Logistics
• Experience of A/B testing implementation
• Experience with BigQuery

What we can offer you

Our employee benefits are designed for you, we care about people and we’ve ensured we have a wealth of benefits that focus on your well-being. We can offer technically stretching work, a competitive salary and;

• Flexible working patterns and options for remote working (depending on your role/team)
• 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
• Free shuttle bus to and from Hatfield Train Station to the Hatfield offices [Only include for relevant roles]
• Free shuttle bus to and from Welwyn Garden City Train Station to the Welwyn Garden City offices [Only include for relevant roles]
• Opportunity to participate in Sharesave 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)

We also have regular divisional socials, sports clubs not to mention the Ocado Technology Academy for a packed schedule of courses, conferences and events. If you think you have what it takes to make a difference, please submit your application below.

We are thrilled to welcome applicants from across the world. Whilst we are able to offer visa sponsorship, please note that we are only able to cover the company-specific costs. For all employment offers made for UK roles, it is expected that you will be based in the UK in commutable distance, ready for your first day of work, so please keep this in mind. If you have any questions, please don't hesitate to ask.

Due to the energising nature of Ocado's business, vacancy close dates, when stated, are indicative and may be subject to change so please apply as soon as possible to avoid disappointment. If you have applied and been rejected for this role in the last 6 months, or applied and been rejected for a role with a similar skill set, we will not re-evaluate you for this position. After 6 months, we will treat your application as a new one. All benefits information is subject to change and the terms of the individual arrangements.

Be bold, be unique, be brilliant, be you. We are looking for individuality and we value diversity above gender, sexual orientation, race, nationality, ethnicity, religion, age, disability or union participation. We are an equal opportunities employer and we are committed to treating all applicants and employees fairly and equally.