At a Glance
- Tasks: Analyse data to improve performance and create insightful dashboards for decision-making.
- Company: Join the UK's largest employee-owned business, home to John Lewis and Waitrose.
- Benefits: Enjoy hybrid working, flexible hours, and a supportive work-life balance.
- Why this job: Be part of a culture that values innovation, collaboration, and personal growth.
- Qualifications: Proficiency in GCP, SQL, and data visualisation tools like Tableau or Looker required.
- Other info: This is a permanent role based in Bracknell with a competitive salary.
The predicted salary is between 49000 - 75000 £ per year.
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 information clearly 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
- Data Pipelining, ETL
#LI-HEADOFFICE
#LI-HYBRID
Closing Date:
August 17, 2025
Pay:
£59,000.00 – £110,000.00 Annual
Contract Type:
Permanent
Hours of Work:
35
Job Level:
Partnership Level 6
Where You\’ll Be Working:
Bracknell Campus, Doncastle Road, Bracknell, Berkshire, RG12 8YA
ABOUT 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. #J-18808-Ljbffr
Data Engineer, Space, Range and Formats employer: John Lewis Partnership Plc
Contact Detail:
John Lewis Partnership Plc Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer, Space, Range and Formats
✨Tip Number 1
Familiarise yourself with the specific tools mentioned in the job description, such as GCP Core Services and SQL. Having hands-on experience or projects showcasing your skills with these technologies can set you apart from other candidates.
✨Tip Number 2
Network with current or former employees of Waitrose or similar companies. Engaging in conversations about their experiences can provide valuable insights into the company culture and expectations, which you can leverage during interviews.
✨Tip Number 3
Prepare to discuss specific examples of how you've used data analysis to drive performance improvements in previous roles. Being able to articulate your thought process and the impact of your work will demonstrate your analytical skills effectively.
✨Tip Number 4
Stay updated on industry trends related to Space, Range, and Formats in grocery retail. Showing that you understand the market dynamics and can apply this knowledge to your role will impress hiring managers and show your commitment to the field.
We think you need these skills to ace Data Engineer, Space, Range and Formats
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience and skills that align with the job description. Focus on your analytical skills, technical proficiency in GCP services, and any experience with data visualisation tools like Tableau or Looker.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Discuss how your background in data analysis and problem-solving can contribute to improving performance at Waitrose. Be specific about your achievements and how they relate to the responsibilities outlined in the job description.
Showcase Your Analytical Skills: Provide examples of past projects where you successfully analysed data and derived actionable insights. Highlight your ability to communicate complex information clearly, as this is crucial for the role.
Proofread Your Application: Before submitting, carefully proofread your application materials. Ensure there are no spelling or grammatical errors, and that your documents are well-organised and easy to read. Attention to detail is key for this position.
How to prepare for a job interview at John Lewis Partnership Plc
✨Showcase Your Analytical Skills
As a Data Engineer, you'll need to demonstrate your strong analytical skills. Be prepared to discuss specific examples of how you've analysed complex data sets in the past and the insights you derived from them. Use metrics and outcomes to illustrate your impact.
✨Communicate Clearly
Effective communication is key in this role. Practice explaining complex data concepts in simple terms, as you'll be presenting findings to both technical and non-technical audiences. Tailor your communication style to suit different stakeholders.
✨Familiarise Yourself with Relevant Tools
Make sure you're well-versed in the tools mentioned in the job description, such as GCP, SQL, and Tableau. Be ready to discuss your experience with these technologies and how you've used them to create reports or dashboards in previous roles.
✨Demonstrate Problem-Solving Abilities
Prepare to discuss specific challenges you've faced in data analysis and how you approached solving them. Highlight your ability to identify root causes and develop data-driven solutions, as this will show your potential to contribute to continuous improvement.