At a Glance
- Tasks: Analyse and model data to create advanced forecasting capabilities for customer demand.
- Company: Leading UK B2C Logistics & Supply Chain organisation with a collaborative culture.
- Benefits: Join a large data team with opportunities for growth and development.
- Other info: Dynamic environment with a focus on continuous improvement and best practices.
- Why this job: Make a real impact on operational planning and resource optimisation.
- Qualifications: Advanced analytical skills in Excel, SQL, and Power BI; experience in forecasting.
The predicted salary is between 35000 - 45000 £ per year.
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.
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.
Data Analyst - Contact Centre & Resource Planning Analytics in Walsall employer: Michael Page Technology
Contact Detail:
Michael Page Technology Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst - Contact Centre & Resource Planning Analytics in Walsall
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Prepare for interviews by practising common questions and showcasing your analytical skills. Use real-life examples from your experience with SQL, Excel, or Power BI to demonstrate your expertise.
✨Tip Number 3
Don’t just apply and wait! Follow up on your applications after a week or so. A quick email can show your enthusiasm and keep you on their radar.
✨Tip Number 4
Check out our website for the latest job openings. We’re always looking for talented individuals like you to join our team, so don’t miss out on the chance to apply directly!
We think you need these skills to ace Data Analyst - Contact Centre & Resource Planning Analytics in Walsall
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Analyst role. Highlight your experience with SQL, Excel, and forecasting models. We want to see how your skills match what we're looking for!
Showcase Your Analytical Skills: In your application, don’t just list your skills—show us how you've used them! Share specific examples of how you've tackled complex data sets or improved forecasting accuracy in previous roles.
Be Clear and Concise: When writing your application, keep it clear and to the point. Use bullet points where possible to make it easy for us to read through your achievements and experiences quickly.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at Michael Page Technology
✨Know Your Data Tools
Make sure you brush up on your SQL, Excel, and Power BI skills before the interview. Be ready to discuss how you've used these tools in past roles, especially in forecasting and planning. Having specific examples of how you've tackled complex data sets will really impress them.
✨Understand the Business Context
Familiarise yourself with the logistics and supply chain industry, particularly how demand forecasting impacts operations. Being able to speak knowledgeably about seasonality factors and volume drivers will show that you understand the bigger picture and can contribute effectively.
✨Prepare for Scenario Questions
Expect questions that ask you to solve hypothetical problems or analyse data scenarios. Practice articulating your thought process clearly, as they’ll want to see how you approach problem-solving and decision-making in a data-driven environment.
✨Showcase Your Collaboration Skills
Since this role involves working closely with operational leads and resource planning teams, be prepared to discuss your experience in collaborative environments. Share examples of how you've shared best practices or worked with others to optimise performance and achieve KPIs.