Daya Analyst - 6 months - Swindon - £308 per day

Wiltshire  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

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

Start date
ASAP
Duration
6 months
From
ABW Recruitment
Published at
14.12.2017
Project ID:
1470606
Contract type
Freelance
To apply to this project you must log in.
Register