Business Intelligence Analyst (Forecasting/Planning Analytics)

Leading UK B2C Logistics & Supply Chain organisation require a Business Intelligence Analyst to join their expanding Operations Forecasting & Planning team. You will have responsibility for sourcing, analysing and modelling the Data to create advanced forecasting capabilities across operational demand workloads and national customer support operations.

Leading UK B2C Logistics & Supply Chain organisation

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.
  

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 solutions
  

Opportunity to join a leading UK organisation

Opportunity to join a large and collaborative data team