Space, Range and Formats Performance Analyst

John Lewis Partnership; Bracknell; Hybrid; GBP 59,000 - 75,000; Full time

Job summary

Join a leading employee-owned business as a Space, Range & Formats Performance Analyst at the Bracknell Head Office. You will play a crucial role in driving performance improvements through data analysis and insights, while enjoying a hybrid working pattern. If you're skilled in analytics and enjoy collaboration, this is an opportunity to thrive in a supportive environment.

Qualifications

• Proficiency in GCP Core Services, SQL, and data visualization tools like Tableau or Power BI.
• Strong data analysis and interpretation skills with attention to detail.
• Excellent written and verbal communication skills.

Responsibilities

• Analyse key performance indicators to provide actionable insights.
• Create and maintain performance reporting and dashboards for stakeholders.
• Collaborate with cross-functional teams to address business problems.

Skills

Analytical skills

Communication skills

Attention to detail

Problem-solving skills

Collaboration skills

Tools

GCP Core Services

Tableau

Power BI

SQL

BigQuery

Job description

Apply on JLP Jobs - the official careers website for John Lewis Partnership, John Lewis & Partners, and Waitrose & Partners.

About the role

As a Space, Range & Formats Performance Analyst, you will be responsible for analysing Space, Range and Formats key performance indicators and identifying areas for improvement by gathering, analysing and interpreting data to provide insights and recommendations that drive informed decision making and improve process and performance as well as influence our future strategy. This role requires strong analytical skills, attention to detail and the ability to communicate complex information effectively, to facilitate this a primary focus of the roles to create a robust foundation data layer and to build and support internal-facing Management Information (MI) and Business Intelligence (BI) dashboards, for both technical and non-technical audiences.With a relentless connection to our customers, the commercial teams and branches alike, you’ll both; set up and continuously improve regular performance reporting, and lead projects to shape, optimise, and improve Waitrose performance. Rooted in adaptability, driven by a continuous improvement mindset, and fueled by a commitment to getting it right first time.

• Expected salary - £59,000- £75,000 (dependent 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 Analytics and Data Science team aim for around 2 days a week in the office to connect and on a more ad-hoc basis to attend key meetings.

• Location - This role is based at our Bracknell Head Office.

Key responsibilities

Data Collection, Management & Maintenance:Collect data from various sources (e.g., databases, Snowflake, CCM), ensuring data quality and accuracy. Clean, validate, and prepare data for analysis. Maintain organized data repositories.

Data Analysis & Interpretation: Conduct quantitative and qualitative analysis using appropriate tools and techniques (e.g., statistical analysis, trend analysis, forecasting). Identify patterns, trends, and anomalies in data. Interpret findings and translate them into actionable insights or opportunities to drive performance

Reporting & Visualization:Create and maintain clear, concise, and visually appealing reports, dashboards, and presentations to communicate findings and clear “so what” recommendations to stakeholders. Tailoring communication approach to different audiences.

Problem Solving & Solution Development:Identify business problems and opportunities. Analyse root causes and develop data-driven solutions. Evaluate the effectiveness of implemented solutions.

Collaboration & Communication: Collaborate with cross-functional teams to understand business requirements, gather feedback, and present findings. Actively participate in team meetings and discussions.

Ad-Hoc Analysis: Complete ad-hoc analysis at pace in response to key business issues or opportunities.

Essential skills/experience you’ll need

• Technical Skills: Proficiency in GCP Core Services: Compute Engine, GKE, Storage, SQL, BigQuery, Pub/Sub, Functions.

  • Visualisation: Experience in Tableau, Looker, Power B

  • SQL: Querying and manipulating data in Cloud SQL, Snowflake or BigQuery.I

• Analytical Skills: Strong analytical and problem-solving skills with the ability to analyze complex data and draw meaningful conclusions.

• Communication Skills: Excellent written and verbal communication skills, including the ability to present complex informationclearly and concisely

• Attention to Detail: Meticulous attention to detail and a commitment to data accuracy.

• Problem-Solving Skills: Ability to identify and define problems, develop creative solutions, and implement them effectively.

• Collaboration Skills: Ability to work effectively in a team environment and collaborate with cross-functional teams

Desirable skills/experience you may have

• Space, Range & Formats Experience: Previous experience in Space, Range & Formats reporting and analysis in a Grocery Retailer

#LI-HEADOFFICE

#LI-HYBRID

35

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 also recommend that you apply as soon as possible as vacancies can close early if we see a high number of applicants.

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.