Forecasting & Planning Insights Analyst

RAC; Manchester; Hybrid; GBP 35,000 - 55,000; Full time

Job summary

RAC is seeking an experienced Forecasting Insights Analyst to enhance resource deployment across operations. The role entails sourcing and analyzing data to provide accurate forecasts, using advanced tools like SQL, Excel, PowerBI, and Tableau. In return, RAC offers a competitive salary along with valuable benefits including a share scheme, generous leave, and support services for families.

Benefits

FREE RAC Complete Breakdown Service from Day One

25 days annual leave plus bank holidays

Option to join pension scheme with company match

Life Assurance cover

Family leave support

Enhanced Parental Leave

24/7 confidential personal support service

Car salary sacrifice scheme

Access to online discounts portal

FREE onsite parking

Qualifications

• Experience in data analysis and problem-solving.
• Advanced proficiency in Excel for building forecasting models.
• Strong communication skills for stakeholder management.

Responsibilities

• Produce accurate weekly demand forecasts (0-26 weeks).
• Collaborate to drive continuous improvement in forecasting.
• Regularly review forecast performance for accuracy.

Skills

Analytical skills

SQL

Excel

Forecasting

Tools

PowerBI

Tableau

Job description

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.

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).

In return we offer…

At RAC, our colleagues do whatever it takes to help our customers. And we believe in rewarding you in return. As well as a competitive salary, you’ll have all these extra benefits:

• FREE RAC Complete Breakdown Service from Day One.
• 25 days annual leave entitlement plus bank holidays.
• Option to join RAC’s Group Personal Pension scheme where we will match / contribute up to 6.5% on qualifying earnings.
• 2 x Basic Salary Core Employer funded Life Assurance cover (4 x for pension scheme members) with the option to flex up to 10 x cover through our flexible benefits offering.
• Family leave support including paid time off, flexibility and resources to help balance work and family commitments.
• Enhanced Parental Leave
• Confidential personal support service, available 24 hours a day every day of the year for you and any family members ages 16+ in your household.
• Car salary sacrifice scheme – after 12 months of employment, where you’ll enjoy significant tax savings, including electric vehicle options.
• Access to Orange Savings, our online discounts portal offering 1000’s of savings on high street retailers, supermarkets, holidays, tech and much, much more.
• FREE onsite parking.
  When you join us you will automatically be opted into our Colleague Share Scheme, called ‘Owning it together’. This is a unique opportunity for our colleagues to get rewarded for the outstanding work they deliver, to share in the future success of the RAC and is no ordinary work benefit, incentive, or bonus!
  

When you join us you will automatically be opted into our Colleague Share Scheme, called ‘Owning it together’. This is a unique opportunity for our colleagues to get rewarded for the outstanding work they deliver, to share in the future success of the RAC and is no ordinary work benefit, incentive, or bonus!

We’re committed to developing a culture that is representative of the diverse communities we serve and one which is open, accessible, collaborative, and inclusive. We welcome applicants of all backgrounds and experiences.