Overview
Leading UK B2C Logistics & Supply Chain organisation requires a Business Intelligence Analyst to join their expanding Operations Forecasting & Planning team. The role involves sourcing, analysing and modelling data to create advanced forecasting capabilities across operational demand workloads and national customer support operations.
Key Responsibilities
* Forecast modelling on a weekly, daily and hourly level around customer demand planning, driving the resourcing requirement to meet customer needs.
* Utilise multiple statistical forecasting methods to analyse and extract meaningful properties from large and complex data sets using SQL, enabling complex planning assumptions and improving forecast quality.
* Produce 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, performance challenges and optimisation.
* Produce and maintain 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 long‑term annual and quarterly forecasting and planning processes.
* Forecast daily demand requirements that feed into 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.
* Continuously review performance, ensuring forecast performance is within acceptable toleration, variations are understood and articulated, and lessons learned are incorporated into future forecasts.
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 building, developing and maintaining Excel forecasting models.
* Advanced Excel skills to design and manage complex forecasting models with auditability 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 from concept through to strategic solution, including demand planning models and processes.
* Ability to create reports in Power BI; knowledge and experience of Tableau and other analytical and reporting solutions is a plus.
Job Offer
Opportunity to join a leading UK organisation and a large, collaborative data team.
#J-18808-Ljbffr