We are seeking a dynamic and proactive individual with at least one year of experience in demand forecasting to join our team. The ideal candidate will thrive in a fast-paced environment and can hit the ground running, confidently producing accurate forecasts.
Strong communication skills are essential, as this role involves regular interaction with the commercial team and other stakeholders across various levels of the business. A keen analytical mindset and advanced Excel skills are critical, with the ability to interpret and manipulate complex data sets and extract actionable insights.
Job Overview
Known internally as a Demand Forecasting Analyst, using standardised methodology and excel to format, manage and generate SKU Forecast and create Purchase order requirements within the S&OP Process
Generate demand forecasts at agreed frequency by customer and/or business channel to:
- Meet customer service level agreements.
- Minimizing overall stock commitment
- Minimising slow and obsolete stock
- Provide purchasing with recommended purchasing data.
- Provide consolidated customer stock forecasts.
- Determine appropriate levels of inventory to achieve availability levels while minimising working capital requirements.
Review and maintain SKU and supplier attributes - specifically SKU Status – ABC, Live, Stocked / None Stocked, Forecaster and Planner names, Supplier Supplier Status – Supplier and Vessel Lead time
Key Duties and Responsibilities
Review Frequency
- Establish and maintain at agreed frequency, customer demand forecasts
Stock / Service Level
- Maintain agreed levels of buffer stockholding to cope with variability in customer demand patterns and any supply chain slippage.
- Model initial stock holding requirements for a new range, wearer trial or roll-outs
- Periodically identify both slow moving and obsolete stock by customer.
Reporting
- Maintain a rolling 18 month customer demand & stock forecast
- Maintain and report a 26 week constrained demand
- Maintain adequate management information to report upon levels of availability and changes in levels of stock
- Supply KPI data and or reporting as required to help support the management and commercial agreeents of the customers
Communication
- Liaise with the commercial teams to understand all the factors that will influence and determine the demand for garments.
Supply Chain Planning and Delivery
- Validate the output from MPS/MRP before it is action by Purchasing and within the OTB and MOQ business constraints
- Make instructions to increase, decrease, cancel or create new p/o's
- Determine shipment modes, balancing the need to maximise product availability, within the constraints of the commercial agreement and the objective of maximising container utilisation.
- Work with Purchasing to re-prioritise and/or expedite production to reduce the impact of stock outs or cope with abnormal demand patterns
Knowledge, Skills and Experience Required
Essential
- GCSE Maths A or B as a minimum standard
- A good understanding of using Excel V lookups, creating basic formula and graphs and formatting.
- Broad experience and understanding of demand forecasting and the dependencies around it
- Demonstrate ability to decipher and explain numerical data / graphs and trends, pulling out the relevant information for the audience
- Task focused and ability to priorotise work load
Desirable
- A Level Maths
- Excel Skills using Forecasting / Lookups /VBA
- Fundamental understanding of dependies around forecasting as well as good knowledge and experience of demand forecasting, MRP, MPS processes and systems
- Proven analytical experience and presentation of data to customers and senior leadership teams
- To own and drive task to final conclusion within agreed timeframe, at the same time hold others accountable for their tasks.
- Maintain control and ability to priorotise work
Life Working at Mi Hub
Our people are at the heart of our business. At Mi Hub, we know how hard our people work to achieve our business goals and keep our customers at the heart of our work.
- Mi Time Policy (after training is complete)– minimum 3 days in the office, finish early on a Friday rota basis (3pm!) and flexi your time and building up an extra half days annual leave per month. Also, grab a free tea and coffees whenever you are in the office!
- Annual leave - 25 days holiday plus Bank Holidays increasing to 27 days plus bank holidays when you get to 5 years’ service. If this isn’t enough, we provide the ability once a year for employee to buy extra annual leave.
- 3x death in service life insurance scheme should the worst happen in your employment with us.
- Celebrating Service, we offer long service awards to celebrate continued employment.
- EAP covering support for mental health and well-being.
- Employee Engagement (survey or Mi Forum) – We care for your opinions.
- Social calendar driven by our desire to raise funds for local and national charities, supporting a number each year.
- We take huge pride in our ESG policy which includes our impact on the environment and ensuring our company is ‘a great place to work’.
Mi Hub is an inclusive employer that values diversity in its workforce. We encourage applications from all individuals without regard to race, religion, gender, sexual orientation, national origin, disability or age.
If you wish to contact our in-house recruitment team you can contact them, via:
Email: recruitment @mi-hub.co.uk
Applications will also be accepted by email.
Mi Hub will keep your details for 13 months in accordance with our privacy policy, in case any other roles crop up that we think you'd be suitable for. If you'd like us to remove your details at any point, please contact the recruitment team on recruitment @mi-hub.co.uk
Mi Hub operates a Preferred Supplier List for recruitment agencies and only accept candidate introductions from agencies we have specifically engaged in writing for a particular role. Any unsolicited CVs or contact from agencies not formally instructed on the role, will not be recognised and no fees will be payable. Should we engage with a candidate whose details were submitted speculatively in this manner, it will not constitute acceptance of terms, and no agency fees will be owed.
Job Types: Full-time, Permanent
Pay: From £33,000.00 per year
Benefits:
- Bereavement leave
- Cycle to work scheme
- Enhanced maternity leave
- Enhanced paternity leave
- Flexitime
- Free parking
- Health & wellbeing programme
- On-site parking
- Paid volunteer time
Application question(s):
- Have you been responsible for creating and maintaining demand forecasts in a previous role?
- Are you confident explaining data, trends, or forecasts to non-technical stakeholders (e.g. commercial teams or managers)?
- Can you reliably commute to the office location (Castle Donington) at least 3 times per week?
- Do you have experience handling and manipulating large amounts of data in excel using vlookups and pivot tables?
Experience:
- hands on Demand Forecasting: 1 year (required)
Work authorisation:
- United Kingdom (required)
Work Location: Hybrid remote in Derby DE74 2UG
