Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Manage SKU forecasts and create purchase order requirements using Excel.
- Company: Join a leading apparel business known for its innovative approach.
- Benefits: Enjoy competitive salary, 25 leave days, hybrid working, and flexi-hours.
- Why this job: Be part of a dynamic team shaping demand forecasting in fashion.
- Qualifications: Tertiary qualification preferred; experience in demand planning and advanced Excel skills required.
- Other info: Opportunity to work with key stakeholders and influence supply chain decisions.
The predicted salary is between 36000 - 60000 £ per year.
Alexander Steele has partnered with a leading apparel business that has an exciting opportunity for a Demand Forecasting Analyst to manage and generate SKU forecasts and create purchase order requirements using standardised methodology and Excel format.
On Offer:
- Competitive salary + Benefits
- 25 leave days + 8 bank holidays
- Hybrid remote working options (3 days in the office)
- Flexi-work options
Key responsibilities include:
- Establish and maintain customer demand forecasts at agreed frequency
- Maintain a rolling 18-month customer unconstrained demand & stock forecast
- Maintain agreed level of buffer stockholding to cope with variability in customer demand patterns and any supply chain slippage
- Model initial stock holding requirements for new ranges, wearer trials, or rollouts
- Provide KPI data and reports to support management and commercial agreements with customers
- Determine shipment modes, balancing product availability, commercial constraints, and container utilisation
Experience and skills required:
- A relevant tertiary qualification is advantageous
- Demand Planning and Forecasting experience
- Intermediate to advanced Excel skills, including V lookups, formulas, graphs, and formatting
- Ability to interpret and explain numerical data, graphs, and trends effectively
- Understanding of forecasting dependencies, demand forecasting, MRP, MPS processes, and systems
- Good interpersonal and communication skills across all levels
#J-18808-Ljbffr
Demand Forecast Analyst employer: Alexander Steele
Contact Detail:
Alexander Steele Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Demand Forecast Analyst
✨Tip Number 1
Familiarise yourself with the specific forecasting methodologies used in the apparel industry. Understanding how to establish and maintain customer demand forecasts will give you a significant edge during interviews.
✨Tip Number 2
Brush up on your Excel skills, especially V lookups and data visualisation techniques. Being able to demonstrate your proficiency in Excel during practical assessments or discussions can set you apart from other candidates.
✨Tip Number 3
Prepare to discuss your experience with demand planning and forecasting in detail. Be ready to share specific examples of how you've managed stock levels and responded to variability in customer demand.
✨Tip Number 4
Network with professionals in the apparel industry and join relevant online forums or groups. Engaging with others in the field can provide insights into the role and may even lead to referrals for the position.
We think you need these skills to ace Demand Forecast Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience in demand planning and forecasting. Use specific examples that demonstrate your intermediate to advanced Excel skills, such as V lookups and data analysis.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention how your skills align with the key responsibilities, particularly in managing SKU forecasts and understanding supply chain dynamics.
Showcase Your Analytical Skills: Provide examples of how you've successfully interpreted numerical data and trends in previous roles. This could include any KPI reports you've generated or how you've modelled stock holding requirements.
Proofread Your Application: Before submitting, carefully proofread your application for any errors or inconsistencies. A polished application reflects your attention to detail, which is crucial for a Demand Forecast Analyst.
How to prepare for a job interview at Alexander Steele
✨Showcase Your Excel Skills
Since the role requires intermediate to advanced Excel skills, be prepared to discuss your experience with V lookups, formulas, and data visualisation. You might even want to bring examples of past work where you've used these skills effectively.
✨Understand Demand Forecasting
Make sure you have a solid grasp of demand forecasting principles and methodologies. Be ready to explain how you would establish and maintain customer demand forecasts, as well as how you handle variability in demand patterns.
✨Prepare for Scenario Questions
Expect questions that assess your problem-solving abilities, especially regarding stock holding requirements and shipment modes. Think of scenarios where you've had to balance product availability with commercial constraints and be ready to discuss your thought process.
✨Communicate Effectively
Good interpersonal and communication skills are crucial for this role. Practice explaining complex numerical data and trends in a clear and concise manner, as you may need to present your findings to various stakeholders.
