Client Details
Leading UK B2C Logistics & Supply Chain organisation
Description
Key Responsibilities:
Forecast modelling on a weekly, daily and hourly level around customer demand planning, which drives the resourcing requirement to meet customer needs.
Utilise multiple statistical forecasting methods and apply this to analyse and extract meaningful properties from large and complex data sets using SQL, to enable complex planning assumptions and improve forecast quality.
Production of accurate and effective weekly demand forecasts (rolling 0 - 26 weeks) across lines of business ensuring awareness and management of Seasonality factors, Volume driver analysis and Special event forecasting
Provide insight and intelligence to enable Operational leads and Resource Planning teams to make informed decisions on resourcing, and performance challenges and optimisation.
Producing and maintaining forecast analysis and tracking, and operational performance reporting to identify performance risks, and opportunities.
Support the Senior Planning and Forecasting Manager and Head of Planning & Trading with the production of the long term annual and quarterly forecasting and planning processes.
Forecasting daily demand requirements, and feeds into the capacity / resourcing models, to achieve KPIs and SLAs as efficiently as possible
Share best practice across colleagues in the Forecasting & Planning team, and ops stakeholders.
Continuous review of performance, ensuring forecast performance is within acceptable toleration, variations are understood and articulated, and lessons learnt are incorporated into future forecasts.Profile
Key Skills & Attributes:
Advanced analytical skills using Excel, SQL and Power BI (DAX / Power Query)
Forecasting and Planning experience in large scale operations - Field and/ or Contact Centres
Experience in building, developing and maintenance Excel forecasting models
Ability to use Excel at an advanced level, to design and manage complex forecasting models in a manner that ensure easy audit and transparency
Awareness and ability to create, develop models and solutions to support problem solving activities and scenario modelling
Strong modelling skills and ability to develop and build from concept through to strategic solution, Demand Planning models and processes
Ability to create reports in Power BI, or have knowledge and experience of Tableau and other analytical and reporting solutionsJob Offer
Opportunity to join a leading UK organisation
Opportunity to join a large and collaborative data team
Salary description
£35000.00 - £40000.00 per year