Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Drive planning capabilities by designing and maintaining Excel and Google Sheets tools.
- Company: Join a global retailer with iconic brands and a dynamic supply chain team.
- Benefits: Competitive salary up to £70,000, generous bonus, and 33 days holiday.
- Why this job: Be part of a growing team and modernise demand and supply planning.
- Qualifications: 4-5 years as an analyst, strong SQL skills, and advanced Excel expertise.
- Other info: Hybrid working in Central London with excellent career growth opportunities.
The predicted salary is between 42000 - 84000 £ per year.
A global retailer is looking for a planning data analyst to join its supply chain team at its London office. This organisation has some of the biggest names and most well-loved brands in its market. It is a multi-billion-dollar organisation distributing product to over 80 countries, with offices in Hong Kong, China, London, France, Spain and Germany. Due to exponential year-on-year growth, all offices are growing the teams across all functions.
This is a new role into the supply chain structure, following a restructure. The role will cover the UK and European markets that this retailer operates in. The planning data analyst is the analytical engine and tool-builder for the planning department. Reporting to the change manager, you will drive the evolution of existing planning capabilities by designing and maintaining robust Excel and Google Sheets tools. You will work in close daily partnership with the S&OP manager and the senior demand & supply managers, providing the insights and the reliable toolsets required to optimize inventory and improve forecast accuracy across Europe.
The ideal candidate will have four to five years’ experience in an analyst capacity and will be able to demonstrate sound interpretation of data, to make recommendations and improvements that will drive the planning department forward. You’ll have a strong proficiency in SQL or relational database logic, and experience with self-serve BI Tools. You’ll need to be an expert in Excel and Google Sheets, including advanced formulas (XLOOKUP, Lambda, Dynamic Arrays), Power Query (M), and a deep understanding of data modelling. An interest in utilizing modern tools (such as Python or Generative AI) to assist in script writing and automating repetitive data tasks would be advantageous.
In return they are offering a competitive salary of up to £70,000, a generous bonus and 33 days holiday, including bank holiday entitlement. The office is located in Central London and offers hybrid working. The opportunity will give you the chance to work with one of the biggest and most established names in the sector, that is experiencing growth on a global scale. You’ll also play a significant part in evolving the planning department to achieve its goals of growth and a modernised approach to demand and supply planning.
Planning Analyst in City of London employer: RHR
Contact Detail:
RHR Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Planning Analyst in City of London
✨Tip Number 1
Network like a pro! Reach out to people in the industry, especially those already working at the company you're eyeing. A friendly chat can give you insider info and maybe even a referral!
✨Tip Number 2
Prepare for interviews by practising common questions related to data analysis and supply chain management. We recommend using the STAR method to structure your answers – it helps you showcase your skills effectively.
✨Tip Number 3
Show off your skills with a portfolio! Create a few sample projects or case studies that highlight your expertise in Excel, SQL, and any modern tools you've used. This will make you stand out from the crowd.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Planning Analyst in City of London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Planning Analyst role. Highlight your experience with Excel, Google Sheets, and any relevant tools you've used. We want to see how your skills match what we're looking for!
Show Off Your Data Skills: In your application, don’t just list your skills—show us how you’ve used them! Share specific examples of how you've interpreted data and made recommendations in your previous roles. This will help us see your analytical prowess.
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're excited about this role and how you can contribute to our planning department. Keep it engaging and personal; we love a bit of personality!
Apply Through Our Website: We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you get all the updates. Plus, it’s super easy to do!
How to prepare for a job interview at RHR
✨Know Your Data Tools
Make sure you brush up on your Excel and Google Sheets skills before the interview. Be ready to discuss advanced formulas like XLOOKUP and how you've used Power Query in past roles. This will show that you're not just familiar with the tools, but that you can leverage them effectively.
✨Showcase Your Analytical Skills
Prepare examples of how you've interpreted data in previous positions. Think about specific instances where your insights led to improvements in planning or inventory management. This will demonstrate your ability to drive the planning department forward.
✨Understand the Business Context
Research the company and its market presence. Knowing about their brands and supply chain operations will help you tailor your responses and show that you're genuinely interested in the role. It’s all about connecting your skills to their needs.
✨Be Ready for Technical Questions
Expect questions around SQL and relational database logic. Brush up on your knowledge and be prepared to explain how you've used these skills in practical scenarios. If you have experience with modern tools like Python or Generative AI, don’t hesitate to mention it!
