Inventory Data Analyst

Execustaff Recruiting Services; Johannesburg; On-site; ZAR 200 000 - 300 000; Full time

Job summary

A recruitment agency in Gauteng seeks an Inventory Analyst to manage the inventory from foreign suppliers, generate buying reports, and ensure timely planning for spare parts. The ideal candidate will have exceptional Excel skills, ERP experience, and a strong background in supply chain management. Join a dynamic team to optimize inventory levels and support the company's operations effectively.

Qualifications

• Proficient in Excel for reporting and analysis.
• Experience with ERP systems for data management.
• Strong verbal and written communication skills in English.

Responsibilities

• Generate and maintain weekly buying reports.
• Plan inventory for long lead time items.
• Update SKU levels based on product group analysis.

Skills

Fluent in English

Excellent written skills in English

Excellent verbal skills in English

Excellent communication skills

Advanced Excel skills

Knowledge and experience with ERP systems

Supply chain knowledge and experience

Customer focus

Analytical thinking and problem-solving skills

Database management skills

Report writing skills

Ability to work well under pressure

Ability to prioritize tasks

Accountability for meeting deadlines and targets

Matric / Grade 12

Mining industry knowledge

MS Navision experience

Inventory replenishment experience

Ability to work independently

Interpersonal skills

Education

Data and/or analytics-related certification

Matric / Grade 12

Tools

MS Navision

Excel

Job description

Requirements:

• Fluent in English.
• Excellent written skills in English.
• Excellent verbal skills in English.
• Excellent communication skills.
• Matric / Grade 12
• Data and / or analytics-related certification
• Advanced Excel skills
• Knowledge and experience with ERP systems
• Supply chain knowledge and experience
• Inventory replenishment experience and understanding of inventory data management concepts
• Database management skills
• Ability to work well under pressure
• Ability to prioritize tasks
• Excellent interpersonal skills
• Ability to work independently
• Customer focus
• Accountability for meeting deadlines and targets
• Analytical thinking and problem-solving skills
• Report writing skills
• Mining industry knowledge
• MS Navision experience

Basic Function:

• Generating weekly buying reports for sales orders and production demands
• Generating forward order buying reports for all items with long lead times
• Updating and maintaining of SKU levels
• Updating and maintaining of ABC group analysis
• Creating of SKU levels for all new locations
• Generating and maintaining Excel inventory reports
• Maintaining current Excel reports daily

Key responsibilities:

• All Inventory purchased from foreign suppliers need to be planned six to eight months in advance, for all long lead time spare parts for after-market sales and production, this allows for sufficient time for supplier lead times and shipping lead times.
• Weekly buying reports need to be generated to cater for SKU replenishment, current sales shortages as well as current production shortages.
• The updating of the product group code (ABCD Analysis) will be updated every four to six months, to ensure that the correct inventory for the correct item 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 four to six months for each location, after the product group code has been updated, SKU levels will need to be verified and updated only after signatures have been received from Branch managers 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, for the Company's Mining Machines and Manufacturing divisions. Forward orders are placed for a period of 4-6 months, Forwards order buying reports are processed in advanced.
• 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.
• Ensuring that all buying reports are checked for verification by the Inventory Officer.
• Travelling to both branches, every second month, to plan sales inventory demands.
• Assist Management with any ad hoc projects / requests at all times.