Description
My client requires a Super X NPI Daya Analyst - 6 months - Swindon - £308 per day
Scope of work for Super X NPI Data analyst
Develop and maintain project data files for a product portfolio program (Super X) to enable supply chain implementation of it. The program consists of ca. 8 product portfolio projects, such as marketing initiatives to change/update product portfolios, license to operate projects to ensure industry or OEM claims, procurement component changing initiatives and supply chain sourcing projects. This role is part of a supply chain team managing the product phase in phase out in the blending plants.
Project scopes and timing are as per below are spread over 9 E&A blending plants, with some plants seeing an impact of% changes to their portfolio. Total Super X scope is around 5000 skus from the 8700 skus in these plants.
Data file requirements
QUARTERLY
-
8 Product mapping files: receive marketing mapping and overlay plant perspective and volumes (MS Excel and Business Objects)
-
8 Formulation files: receive new product BOMs and link these to product mapping files to calculate raw material volumes per plant (MS Excel)
-
1 Integrated raw material forecast file: compile a consolidated view of all projects' formulation files to understand holistic Super X impact to all plants and all raw materials, ideally by linking this central file to each project file (MS Excel)
MONTHLY
-
8 Stock tracking files - FG: develop projected inventory view for finished goods (FG) through data extractions (Business Objects, SAP, BW reporting, MS Excel)
-
8 Stock tracking files - RM: develop specifically a project inventory view on packs and labels (SAP, Fusion, Business Objects). Understand further data availability from suppliers with Procurement and plants.
WEEKLY
-
8 Product tracking files: develop a product tracking file to closely monitor adherence to an agreed phase in phase out plan by developing an alert principle in a spreadsheet that provides insight on deviations of stock build, production or forecast shifts, etc. (SAP-BW reports, existing MS Access reports and creating of a new MS Excel tool)
-
1 KPI Dashboard file: develop a professional looking dashboard to monitor KPIs and their progress over time to share in governance slide packs.(stock write off risks, adherence to phase in phase out plan, new product stock build metrics, etc) (MS Excel)
Please quote Ref JS2141