Inventory Data Analyst

SUMMARY:
A Heavy Engineering Manufacturing Concern based in East Rand is seeking an Inventory Data Analyst.

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

POSITION INFO:
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 it 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