At a Glance
- Tasks: Drive planning capabilities by designing and maintaining Excel and Google Sheets tools.
- Company: 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: Join a growing team and make a real impact in modernising planning processes.
- Qualifications: 4-5 years of analyst experience, strong SQL skills, and advanced Excel proficiency.
- Other info: Hybrid working in Central London with excellent career growth opportunities.
The predicted salary is between 43200 - 58800 £ 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 London employer: RHR
Contact Detail:
RHR Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Planning Analyst in 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 the interview by brushing up on your Excel and Google Sheets skills. Be ready to showcase your analytical prowess with real-life examples of how you've used data to drive decisions.
✨Tip Number 3
Don’t just wait for job postings! Keep an eye on our website and apply directly. Sometimes, being proactive can put you ahead of the competition.
✨Tip Number 4
Show your passion for modern tools! If you’ve dabbled in Python or AI, mention it during interviews. Companies love candidates who are eager to innovate and improve processes.
We think you need these skills to ace Planning Analyst in 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, SQL, and any relevant tools you've used. We want to see how your skills align with 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 Analytical Skills: In your application, be sure to showcase your analytical skills. Provide examples of how you've used data to drive decisions or improve processes in previous roles. We’re all about data-driven insights here at StudySmarter!
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 and straightforward!
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 Lambda. Brush up on Power Query and data modelling techniques, as these will likely come up during your interview.
✨Showcase Your Analytical Skills
Prepare to discuss specific examples where you've interpreted data to make recommendations. Think of instances where your insights led to improvements in planning or inventory management, as this will demonstrate your value to the team.
✨Familiarise Yourself with the Company
Research the retailer’s operations in the UK and European markets. Understanding their supply chain structure and recent changes will help you tailor your responses and show that you’re genuinely interested in the role.
✨Be Ready for Technical Questions
Expect questions about SQL and relational database logic. Brush up on your knowledge of self-serve BI tools and be prepared to discuss how you might use modern tools like Python or Generative AI to enhance your work.