Location: Head office, Trafford Park, Manchester (Hybrid)

Salary: £35,000.00-£40,000.00 + Excellent Benefits

Role Responsibilities

Reporting to the Supply Chain Manager, the SIOP Data Analyst will:

• Maintain forecasts for the UK and European Sales Team, uploading into SAP, as and when required, to facilitate accurate data within the system for production with respect to short, mid and long-term planning.
• Act as primary link between Sales, Supply Chain, Procurement and Production teams; highlighting major forecast changes.
• Organise regular supply/forecast reviews with key customers and the sales teams to assess and discuss any issues which may impact supply and production.
• Develop initiatives to improve forecast accuracy levels.
• Work closely with the Marketing department with reference to the product lifecycle. Supporting the Supply Chain Manager, ensure that all new product introductions and promotions are updated in a timely manner. Ensure products on phase out have a clean exit plan. Communicate timelines to wider stakeholders.
• Attend and contribute to key customer business events, to build strong relationships and to ensure collaborative working

• Demonstrate experience working in complex business environment and deliver results.
• Demonstrate knowledge and experience in business analysis, attention to detail, ability to work with large volume of data, ability to present information.
• Ability to interface and collaborate effectively with all levels of the organisation.
• Analytical skills & business acumen.
• Ability to multi-task and assess priorities in a complex and demanding environment.
• Highly self-motivated and results oriented.
• Building relationships with internal and external stakeholders
• Take ownership of safety stock & safety time parameters to ensure strong availability whilst minimising working capital.
• Support the Supply Chain Manager within the Rationalisation Team on the costs individual materials add to the business to ensure every material can stand up for itself.
• Ensure data downloads are completed on-time in line with the SIOP calendar.
• Measure forecast accuracy at key account, ABCD categories & SKU levels. Provide reports to the business on forecast accuracy performance and rationale for key misses.
• Facilitate and chair monthly SIOP reviews with sales and supply chain teams.
• Work with sales team and Supply Chain Manager to launch feature displays with 3rd party contractors.
• Work with sales team and Supply Chain Manager to continuously improve how the business executes promotional activity, winter plans from a forecasting, supply chain and production plant perspective.
• Use supplier data to interrogate forecasts and challenge customer stock holding to ensure maximum availability on shelf.
• Complete standard company monthly reports including pallet, stock holding & PA3 inventory.
• Provide support to colleagues to cover absence.

• Previous experience in a FMCG environment.
• Relevant Business degree, or equivalent.
• Strong SAP knowledge required
• Intermediate/advanced Excel experience required – ability to manipulate and analyse data using tools such as vlook-ups, pivot tables, etc.
• Demonstrate knowledge of the Supply Chain and factors that influence supply and demand.

• Business analysis: 5 years (required)
• fmcg: 3 years (required)
• Supply chain management: 3 years (required)
• SAP: 5 years (required)
• Microsoft Excel: 5 years (required)

• Bereavement leave
• Company pension
• Enhanced maternity leave
• Enhanced paternity leave
• Free parking
• Health & wellbeing programme
• Life insurance
• On-site parking
• Sick pay
• Work from home

Holts have been around for over 100 years, and you don’t get to be as old as we are without having great people working with us. For over a century Holts has been making vehicles shine and perform to the best of their ability. And the approach is no different when it comes to our people.

We pride ourselves on developing and training our colleagues; promoting from within and giving you the tools to shine in your career. When working for Holts, you can be assured of a progressive, inclusive, and friendly working environment that welcomes all new members to the team.

This is alongside the opportunity to work within one of the most respected names in the automotive industry today, getting to grips with our four household names in Redex, Prestone, Simoniz, and Holts. As a member of the Holts team, you’ll be helping vehicle owners worldwide keep their vehicles functioning and looking their best.

We can’t wait to welcome you on board!

If you’re looking for your next opportunity and a chance to progress your career, and/or would like further information on this role, please contact Sarah McKie-Jones, Head of HR at sarah.mckie-jones@holtsauto.com.