Distribution Data & Insight Analyst

John Lewis Partnership; Bracknell; Hybrid; GBP 39,000 - 65,000; Full time

Job summary

John Lewis Partnership is seeking a Distribution Data & Insight Analyst to deliver high-quality data, reporting solutions, and actionable analysis across Waitrose Transport and Distribution. You will be a trusted resource for the Supply Chain Leadership Team, 3PLs, and central functions, providing visibility and insights to drive operational excellence and business success.

The role is permanent with a hybrid work pattern at Bracknell Head Office.

Qualifications

• Relevant qualification in a numerate discipline e.g. Maths, Statistics, Data Science or similar.
• Experience in writing and optimising complex SQL queries to extract, clean, and manipulate large-scale datasets.
• Experience in building structured datasets and designing intuitive visualisation tools or dashboards.
• Ability to apply advanced analytical methods to complex and turn into actionable insight.
• Desirable: Experience of leveraging AI tools to debug code, automate repetitive tasks, and optimise analytical workflows.
• Desirable: Experience of interacting with a wide range of stakeholders, including senior leaders.
• Desirable: Experience of influencing decisions through the use of data and analytics.
• Desirable: Experience of Supply Chain reporting and data analysis in a complex, Grocery retailer

Responsibilities

• Establish a comprehensive dashboard library and data catalogue, maintaining continuous improvement of coding and tables.
• Manage and troubleshoot Transport and Warehouse KPIs, perform Warehouse Management and Transport Management System analysis to support key decision making, and facilitate the primary connection to the Partnership Data Platform team.
• Oversee the Distribution reporting roadmap and develop end-to-end Supply Chain KPI scorecards to support transforming and modernising our supply chain.
• Identify risks and opportunities through analytical support for Supply Chain reporting, while ensuring robust data governance and standardisation.

Skills

SQL queries

Data visualization

Dataset building

Advanced analytics

Education

Numerate discipline

Job description

About the role

As a Distribution Data & Insight Analyst, you will be responsible for delivering high quality data, reporting solutions, and actionable analysis across Waitrose Transport and Distribution. In this new and pivotal role, you will serve as a trusted resource for the Supply Chain Leadership Team, Distribution Centres, third-party logistics providers (3PLs), and key central functions, providing the visibility and strategic insights needed to drive operational excellence and business success.

At a glance

Expected salary - up to £65,000 depending on experience

Contract type - This position is a Permanent contract

Working pattern/flexible working - The Partnership has adopted a hybrid working approach, meaning you'll be able to work a mixture between the office and home based upon your personal needs whilst balancing the needs of the business. The team aims for 3 days a week in the office to connect and on a more ad-hoc basis to attend key meetings

Location - Bracknell Head Office

Key Responsibilities:

• Establish a comprehensive dashboard library and data catalogue, maintaining continuous improvement of coding and tables.


• Manage and troubleshoot Transport and Warehouse KPIs, perform Warehouse Management and Transport Management System analysis to support key decision making, and facilitate the primary connection to the Partnership Data Platform team.


• Oversee the Distribution reporting roadmap and develop end-to-end Supply Chain KPI scorecards to support transforming and modernising our supply chain.


• Identify risks and opportunities through analytical support for Supply Chain reporting, while ensuring robust data governance and standardisation.

Essential skills/experience you’ll need

• Relevant qualification in a numerate discipline e.g. Maths, Statistics, Data Science or similar


• Experience in writing and optimising complex SQL queries to extract, clean, and manipulate large-scale datasets


• Experience in building structured datasets and designing intuitive visualisation tools or dashboards


• Ability to apply advanced analytical methods to complex and turn into actionable insight

Desirable skills/experience you may have

• Experience of leveraging AI tools to debug code, automate repetitive tasks, and optimise analytical workflows


• Experience of interacting with a wide range of stakeholders, including senior leaders


• Experience of influencing decisions through the use of data and analytics


• Experience of Supply Chain reporting and data analysis in a complex, Grocery retailer

The partnership

We’re the largest employee owned business in the UK and home of our cherished brands, John Lewis and Waitrose. We’re not just employees, we’re Partners, driven by our purpose to build a happier world. As we look to our future, there’s never been a more exciting time to join us.

We’re ruthlessly focused on being brilliant at retail. We continue to innovate, adapt and diversify. Never Knowingly Undersold on price, quality and service in John Lewis and passionately serving food-lovers in Waitrose.

As Partners we all share the responsibility of ownership and in its rewards. We use our voices to contribute to our success, working together through the good and challenging times, holding true to our behaviours and treating everyone with kindness and respect.

We all own making the Partnership somewhere we belong. Embracing our differences and creating an environment where we’re free to be ourselves and can THRIVE. Growing ourselves individually, and as a collective.

As Partners, we make all the difference. And, we all own it.

Important points to note:

It’s important to note that some of our roles are subject to pre-employment vetting (which may include DBS checks for successful candidates). If required, you’ll be informed and provided with information about vetting during the recruitment process and we encourage you to complete any vetting documents quickly to avoid delays. Any DBS checks required will be carried out by a third-party registered body and financial probity checks may also be required for some of our roles.

We occasionally close vacancies early in the event we receive a high volume of applications, and therefore, we recommend you apply early. If you require a reasonable adjustment due to a disability which means you may need longer to complete your application please contact us as soon as possible.

We want all of our Partners to have a good work-life balance and we support flexible working. This might mean flexible or compressed hours, job sharing or shorter hour contracts, where possible. Please discuss this further with the hiring manager during your interview.