WHAT YOU WILL NEED…

The ideal candidate will have strong experience in data analysis and be a natural problem-solver who loves diving deep into data to uncover trends, patterns & opportunities. Strong communication and stakeholder management is essential.

You will also need:

• Advanced analytical skills including but not limited to Excel, SQL and Microsoft Power platforms.
• Strong experience in building, developing and maintenance Excel forecasting models.
• Ability to use Excel at an advanced level, to design and manage complex forecasting models.
• 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.
• The ability to provide insight and present in a way that gives clarity, confidence and certainty to the audience.
• Forecasting and Planning experience in large scale operations (beneficial).

ABOUT THE ROLE

RAC are on the lookout for an experienced Forecasting Insights Analyst to join on the team on a permanent basis.
Our forecasts are critical to ensuring we have the right resources in place to meet member demand across our Roadside and Contact Centre Operations.
As part of the Operations Forecasting & Planning team, you’ll play a critical role in ensuring we’re ready to support our members when they need us most. You’ll be responsible for sourcing, analysing, and delivering daily forecasts that shape how we deploy our resources – from the next hour to the next six months.
Using advanced statistical forecasting techniques and SQL, you’ll analyse large and complex datasets to uncover trends, patterns, and actionable insights that ensure forecast accuracy. Your insights will guide operational and resourcing decisions, helping teams optimise performance and manage challenges effectively.
We’re looking for someone with a strong analytical background, who’s proficient in Excel, SQL, PowerBI & Tableau, and has the ability to build and develop Excel forecasting models. Experience in forecasting would be beneficial for the role.
This role will be a hybrid role, where you will spend two days in our Salford offices, and three days at home.

WHAT YOU WILL DO…

• Produce accurate and effective weekly demand forecasts (0–26 weeks) across our Roadside and Contact Centre operations.
• Forecast daily demand requirements and feed these into capacity and resourcing models to ensure we meet KPIs and service levels as efficiently as possible.
• Collaborate with colleagues across the Forecasting & Planning team and operational stakeholders to share best practices and drive continuous improvement.
• Regularly review forecast performance, ensuring accuracy remains within tolerance levels, identifying reasons for variation, and applying lessons learned to future forecasts.
• Deliver daily and hourly forecasts to the Resource Planning team within agreed SLAs.