Data Administrator - Demand Planning Team - 6 Month Contract

Location: Hybrid (Four days in the office, one day from home)

About the Business: Join a leading company in the development and production of systems and products for waterproofing, bonding, sealing, damping, reinforcing, and protecting in the building sector and motor vehicle industry.

About the Demand Planning Team: The Demand Planning team is responsible for managing the sales forecasting process to deliver accurate sales forecasts.

This involves generating a baseline forecast using statistical tools within IBP (Sales Forecasting Tool) and collaborating with key stakeholders to achieve a consensus forecast.

The forecast is crucial for planning and managing inventory to ensure an exceptional customer experience.

The team works closely with the Sales and Operations teams across multiple sites, including Leeds, Welwyn Garden City, Preston, Redditch, and Wishaw.

Purpose of the Role: This role, based in Preston, is a fixed-term position to support the transition to a new warehouse that will temporarily be unavailable within IBP.

The Data Administrator will manage data within Excel to ensure the forecasting solution runs effectively.

Key tasks include:

• Uploading sales data by product and customer planning level to IBP.


• Downloading the forecast by product to SAP.


• Consolidating data for daily/monthly reporting.


• Supporting the monthly Sales & Operations process (S&OP).

Key Responsibilities for the Data Administrator:

• Familiarize with the S&OP process and core systems (SAP, IBP, BI).


• Extract and format sales data monthly to align with IBP configuration for upload.


• Extract and format sales data daily/monthly to support analysis of sales vs.
  
  forecast at customer and SKU levels.


• Extract forecast data from IBP monthly, reformat, and upload to SAP.


• Document processes with appropriate checks to mitigate the risk of errors and revenue loss.

What We Would Like to See in Candidates:

• Strong Excel skills and familiarity with handling data.


• Attention to detail and accuracy, as the business is data-driven and the forecast is critical to success.


• Confidence in managing and manipulating data.


• Effective communication skills and the ability to manage tasks to a timetable.


• Experience with SAP/IBP is desirable but not essential.

Benefits for the Sucessful Candidate:

• Annual Salary £29,000 - £35,000 DOE (Pro Rata 6 Months)


• Hybrid working - One day working from home


• Stable 6 Months contract

To apply for the Data Administrator role, please click “Apply Now” and attach an updated copy of your CV.

Alternatively, please contact Lewis Lynch at E3 Recruitment for more information.