ERP Procurement Data Analyst (SQL,Pragma, Qlisense, Netstock),

Minimum Requirements:

• BSC Degree in Data Analytics or Industrial Engineering or equivalent.
• More than 5 years’ experience in a data analytics or industrial engineering function.
• Computer literate with a high level of Microsoft Excel proficiency.
• Highly practical Microsoft Excel skills to analyze, interpret, and present data.
• High level of understanding of how data is captured, stored, and accessed, including a theoretical introduction to databases and SQL.
• Ability to apply data analysis to business needs, including procurement, finance, sales, and operations.
• Data presentation and visualization skills.

Duties:

Accountable for procurement spend data analysis across the group:

1. Making recommendations on group spend sourcing of commodity groupings.
2. Preparing RFQ/RFP submissions.
3. Regular verification of contract purchase pricing accuracy.
4. Tracking and reporting of global commodity and freight price indices.
5. Benchmarking of relevant commodity and freight prices.

Accountable for contract and purchase price management:

1. Updating purchase price data.
2. Ensuring contract adherence.

Accountable for data interfacing with ancillary data systems:

1. Using Pragma and Pay to Procure (P2P).

Accountable for procurement process and system optimization:

1. Developing procurement dashboards, KPIs, and visualization tools.
2. Process optimization.

Accountable for engineering and consumable item master data management:

1. Analyzing master data and ensuring correct item grouping.
2. Regular review of supply lead-times and ensuring updates in the Netstock system.

Accountable for Supplier Master Data on ERP system:

1. Managing supplier risk profiles and bank account verification with verification agencies.
2. Reviewing and inactivating dormant suppliers in the ERP system.
3. Coordinating credit application reviews between requesting sites, suppliers, and legal review.

Accountable for maintaining and administering supplier data in B-BBEE database:

1. Socio-Economic Development (SED) data.
2. Preferential Procurement (PP) data.
3. Supplier and Enterprise Development (ED) data.