Inventory Data Analyst

SUMMARY:
One of our clients, based in Boksburg, is seeking an Inventory Data Analyst.

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

• 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

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