Business Data Analyst at Unique Personnel

Job Description    

Role Summary 

• 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. 

Key Performance Areas

• 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.
• 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.

Sales Margin Analysis and reports

• Cost of Sales analysis and reports Baan Deviation Analysis on parts and pricing

Responsibilities

• Detailed analysis on the overall parts operations,
• 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.
• Analysis on Parts selling prices in ERP system and ensuring that outdated prices are closed.
• Analysis on item supersessions and providing a parts supersession report monthly to be communicated to customers.
• Local Parts pricing comparison with pricing from the factory.  To be submitted to the factory pricing comparison platform.
• Analysis on parts supply agreement pricing history and increases.
• Analysis on Parts (Major components, GET, consumable, 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 Company GET to competitors.
• Participate to 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 weakness 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 monde.
• Support and train the end users in their daily job on MIN reporting tools (i.e. Cubes) and MIN BI dashboards.

Inherent Requirements    

• Matric; plus a related Degree or Diploma
• Minimum 5 years’ related experience within a data analysis function and/or training

Computer Skills

• MS Office – Proficiency in Outlook, Word and Excel.
• Advanced Excel specialist
• Advanced Baan knowledge