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: Earn up to £70,000, enjoy 33 days holiday, and hybrid working options.
- Why this job: Be part of a growing team and modernise demand and supply planning.
- Qualifications: 4-5 years in analytics, strong SQL skills, and Excel expertise required.
- Other info: Work in Central London with opportunities for global impact and career growth.
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.
Responsibilities
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.
Qualifications
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, this includes 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.
Benefits
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 employer: RHR
Contact Detail:
RHR Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Planning Analyst
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend events, and connect on LinkedIn. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Prepare for interviews by practising common questions and showcasing your analytical skills. Use examples from your past experience to demonstrate how you've tackled challenges and improved processes.
✨Tip Number 3
Don’t just apply and wait! Follow up on your applications with a friendly email. It shows your enthusiasm and keeps you on their radar. Plus, it’s a great way to ask if they need any more info from you.
✨Tip Number 4
Check out our website for the latest job openings. We’re always looking for talented individuals like you to join our team. Applying directly through us can give you an edge!
We think you need these skills to ace Planning Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Planning Analyst role. Highlight your experience with data analysis, Excel, and any relevant tools you've used. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about this role and how your background makes you a perfect fit. We love seeing enthusiasm and a bit of personality!
Showcase Your Technical Skills: Since this role requires strong proficiency in SQL, Excel, and Google Sheets, make sure to mention specific projects or tasks where you've used these skills. We’re keen to see your analytical prowess in action!
Apply Through Our Website: Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy to do!
How to prepare for a job interview at RHR
✨Know Your Tools Inside Out
Make sure you’re well-versed in Excel and Google Sheets, especially with advanced formulas like XLOOKUP and Dynamic Arrays. Brush up on Power Query and be ready to discuss how you've used these tools in past roles to drive insights and improve processes.
✨Showcase Your Analytical Skills
Prepare examples of how you've interpreted data to make recommendations in previous positions. Be ready to discuss specific projects where your analysis led to tangible improvements in planning or inventory management.
✨Familiarise Yourself with SQL and BI Tools
Since the role requires proficiency in SQL and self-serve BI tools, ensure you can talk about your experience with these technologies. If you’ve worked with Python or Generative AI, mention how you’ve leveraged these for automating tasks or enhancing data analysis.
✨Understand the Company’s Market
Research the retailer's position in the market and its key competitors. Being able to discuss industry trends and how they might impact supply chain planning will show that you’re not just a number cruncher but also a strategic thinker.
