Inventory Data Analyst

Execustaff; South Africa; In loco; ZAR 180.000 - 320.000; Tempo pieno

Descrizione del lavoro

Execustaff is seeking an Inventory Data Analyst for our East Rand operations. The role focuses on generating weekly and monthly inventory reports, aligning material availability with production plans, and maintaining ERP-driven data accuracy to support procurement and manufacturing activities.

Candidates should have 1–3 years in inventory analytics, strong Excel skills, and familiarity with ERP systems such as Dynamics 365 Business Central.

Competenze

• Matric/Grade 12 and a diploma/degree in supply chain or logistics.
• Proficient in Microsoft Excel.
• 1–3 years’ experience in inventory control, reporting or analytics.
• Knowledge of inventory or ERP systems (Dynamics 365 BC preferred).
• Inventory report writing and data management skills.
• Mining/production knowledge is advantageous.

Mansioni

• Generate weekly buying reports for production demand and long lead time items (4–6 months).
• Coordinate fabrication and assembly planning to align material, workforce, and production timelines.
• Update major components buying reports and maintain ABCD product group codes every 4–6 months.
• Maintain monthly machine kits stock levels.
• Prepare daily, weekly and monthly inventory reports and present to management.
• Monitor stock accuracy and identify slow-moving or obsolete items.
• Generate Excel inventory reports and maintain current reports.

Conoscenze

Excel

Data analytics

Inventory management

ERP systems

Inventory replenishment

Database management

Deadline driven

Communication

Independent worker

Customer focus

Problem solving

Mining knowledge

Production knowledge

Dynamics 365 BC

Written communication

Formazione

Matric/Grade 12

Diploma or degree in Supply Chain, Logistics, Inventory Management, or related field

Strumenti

Dynamics 365 Business Central ERP

Descrizione del lavoro

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

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