Parts Business Data Analyst

Talent Guru International (Pty) Ltd; Germiston; On-site; ZAR 30 000 - 60 000; Full time

Job summary

An established industry player is seeking a skilled data analyst to enhance their parts business operations. In this role, you will perform in-depth analysis on inventory levels, sales margins, and procurement processes to ensure KPIs are met. Collaborating closely with the Head of Parts Business, you will provide data-driven insights and support the team in optimizing inventory management and forecasting. This position offers an exciting opportunity to make a significant impact on operational efficiency and contribute to continuous improvement initiatives within the organization. If you are passionate about data and looking for a challenging yet rewarding role, this could be the perfect fit for you.

Qualifications

• Proven experience in data analysis with a focus on inventory and sales.
• Strong skills in using Baan and Power BI for reporting and analysis.

Responsibilities

• Conduct detailed analysis on parts sales and inventory to meet KPI objectives.
• Support Parts teams in forecasting and inventory management processes.

Skills

Data Analysis

Advanced Baan

MS Office

EXCEL

Power BI

Parts Management

Inventory Management

MIN BI

Education

Diploma

Tools

MIN BI dashboards

Cubes

Job description

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

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

• Advanced Baan
• MS Office
• EXCEL
• Data Analysis
• Power BI
• Parts
• Inventory
• MIN BI
  
  

Desired Qualification Level

• Diploma