Data Analyst

Execustaff; South Africa; On-site; ZAR 360,000 - 480,000; Full time

Job summary

Execustaff seeks a Data Analyst for a Heavy Engineering Manufacturing Concern in the East Rand. The role focuses on inventory, data analysis, and reporting within the Supply Chain context.

You will generate reports, monitor stock accuracy, and support procurement and production planning with data-driven insights to ensure on-time delivery.

Qualifications

• Matric/Grade 12 is required or equivalent.
• Diploma/degree in Supply Chain, Logistics, Inventory Management or related field preferred.
• Proficiency in Microsoft Excel is essential; data analytics certification is a plus.
• Knowledge of inventory or ERP systems is advantageous.

Responsibilities

• Generate weekly buying reports for production demand and long lead-time items (4–6 months ahead).
• Coordinate fabrication planning to align material availability, workforce scheduling and production timelines.
• Update and maintain monthly machine kits stock levels and ABCD product group codes.
• Prepare daily, weekly and monthly inventory reports and present clear, actionable findings to management.

Skills

Analytical mindset

Inventory control

Excel proficiency

Data analysis

Education

Matric/Grade 12

Diploma or degree in Supply Chain, Logistics, Inventory Management

Tools

Microsoft Excel

Dynamics 365 Business Central ERP

Job description

A Heavy Engineering Manufacturing Concern based in the East Rand is seeking a Data Analyst, duties include Inventory.

This is an analytical role within Supply Chain!

Qualifications & Experience:

• Matric/Grade 12
• Diploma or degree in Supply Chain, Logistics, Inventory Management, or related field
• Proficiency in Microsoft Excel
• Data and/or analytics related certification is an advantage
• Knowledge and experience with inventory or ERP systems
• 1-3 years’ experience in inventory control, reporting, or supply chain analytics
• Inventory replenishment experience & understanding of inventory data management concept
• Database management skills
• Ability to work under pressure
• Ability to prioritize tasks
• Excellent interpersonal skills
• Ability to work independently
• Customer focused
• Responsible for meeting deadline and targets
• An analytical mind and inclination for problem solving
• Inventory report writing
• Mining industry knowledge
• Production knowledge would be advantageous
• Dynamics 365 Business Central ERP
• Excellent written and communication skills

Basic Function:

• Generating of buying reports on a weekly basis for production demand - Generating of forward orders buying reports for all items with long lead times for a period of 4 – 6 months
• Directed fabrication and assembly planning to align material availability, workforce scheduling, and production timelines, ensuring efficient workflow and on time delivery
• Generating of Major Components buying reports for all major components- Updating and maintaining of ABCD product group codes, to be updated every 4 – 6 months for repair units
• Updating and maintaining monthly machines kits stock levels
• Prepare daily, weekly and monthly inventory reports (stock levels, movement, and valuations) and present to management in a clear and actionable format
• Monitor stock accuracy, slow moving obsolete and dead inventory
• Generating of excel inventory reports
• Maintaining of current excel reports

Key Responsibilities:

• All inventory purchased from foreign suppliers need to be planned 6 months in advanced, for all long lead time spare parts for the production schedule, this allows for sufficient time for supplier lead times and shipping lead times
• Weekly buying reports need to be generated to cater for production shortages as well as to cater for SKU replenishment and sales shortages
• Performed daily inventory checks to maintain accurate stock levels, ensuring uninterrupted production flow and timely fulfilment of operational requirements
• The updating of the product group code (ABDC Analysis) will be updated every 4 months to ensure that the correct inventory for the correct movement trends is catered for. This will lower the risk of planning and purchasing inventory that might result in dead or slow-moving stock
• SKU levels will be updated every 6 months for production, after the product group code has been updated. SKU levels will need to be verified and updated only after signature as been received from Branch managers/HOD from the relevant locations. Updating of the SKU levels will ensure that the correct inventory is purchased as well as lower the risk of dead or slow-moving stock
• Forward order buying reports are generated and processed to assist suppliers with planning of inventory on the supplier side.
• Ensure that when generating any form of buying report that is processed accurately and that all relevant checks are put into place before buying reports are released to the procurement department
• Travelling to assembly and fabrication locations
• Support stock takes by preparing reports and reconciling results