Parts Business Data Analyst

Performs the role of specialist in data analysis (statistic / process) to assist the Head of Parts Business in monitoring inventory levels and ensuring that KPI's can be achieved through the monitoring of Sales, Procurement and Forecast processes.

Accountabilities / Key Performance Areas

1. Detailed analysis on parts sales, inventory on order compared to projected inventory, safety stock, parts consumption peaks or drops, parts usage for production, surplus, and parts forecast, in order to achieve the defined KPI / objectives.
2. Work as a support to the Parts teams in reviewing the system's settings and in the processes related to Parts forecast validation, inventory ordering, and yearly parts sales and inventory budget definition or review.
3. Sales Margin Analysis and reports.
4. Cost of Sales analysis and reports.
5. Baan Deviation Analysis on parts and pricing.
6. Detailed analysis on the overall parts operations.
7. Ensuring KPI's (stock turn, fill rate, surplus, cashflow) are being met; if not, identify reasons and initiate actions with Parts, Controlling, Service and Reman.
8. Analysis on Parts selling prices in ERP system and ensuring that outdated prices are closed.
9. Analysis on item supersessions and providing a parts supersession report monthly to be communicated to customers.
10. Local Parts pricing comparison with pricing from the factory to be submitted to the factory pricing comparison platform.
11. Analysis on parts supply agreement pricing history and increases.
12. Analysis on Parts (Major components, Ground Engaging Tools, consumables, kits, etc.) sales and market share.

Communicate and support the Parts planning team to adjust and monitor the parts sales forecast on rolling 24 months. Liaise with MIN in the usage of MIN BI reports or when a new BI report is required to cover local specifics; potentially create the local report if agreed. Pricing comparison on Ground Engaging Tools to competitors. Participate in the continuous improvement of the internal processes and organization; provide fact-based input to the Head of Parts Business for data-driven decisions.

Proactively enforce internal processes, address and resolve weaknesses in the overall parts operations. Collaborate regularly with the Head of Parts Business. Interact with subject matter experts and management to keep reporting aligned with strategy and business model. Support and train the end users in their daily job on MIN reporting tools (i.e., Cubes) and MIN BI dashboards.

Desired Skills

1. Advanced Baan
2. MS Office
3. EXCEL
4. Data Analysis
5. Power BI
6. Parts
7. Inventory
8. MIN BI

Desired Qualification Level

Diploma