ERP Procurement Data Analyst (SQL,Pragma, Qlisense, Netstock), Boksburg, Rneg + Ben
- BSC Degree in Data Analytics or Industrial Engineering or equivalent.
- More than 5 years’ experience in a data analytics or industrial engineering function.
- Netstock
- Pragma
- Supplier EDI’s
- Qliksense
- Pay to Procure (P2P)
- Computer literate and high level of Microsoft Excel proficiency.
- Highly practical Microsoft Excel skills to apply within your own context to analyse, interpret and present data.
- High level of understanding of how data is captured, stored, and accessed, with a theoretical introduction to databases and SQL.
- Interpretation of outcomes .
- Ability to apply data analysis t business needs, including procurement, finance, sales and operations .
- Data presentation and visualisation .
Duties:
Accountable for procurement spend data analysis across the group:
Making recommendations on group spend sourcing of commodity groupings.
Preparing RFQ/RFP submissions.
Regular verification of correctness of contract purchase pricing.
Tracking and reporting of global commodity and freight price indices.
Benchmarking of relevant commodity and freight prices.
Accountable for contract and purchase price management:
Updating of purchase price data.
Contract adherence.
Accountable for data interfacing with ancillary data systems:
Netstock
Pragma
Supplier EDI’s
Qliksense
Pay t Procure (P2P)
Accountable for procurement process and system optimization:
Developing procurement dashboard, KPI’s and visualization tools.
Process optimization.
Accountable for engineering and consumable item master data management:
Analysing master data and ensuring correct item grouping.
Regular review of supply lead-times and ensuring updates in Netstock system.
Item group rationalization.
Accountable for Supplier Master Data on ERP system:
Supplier risk profiles and bank account Verification with verification agencies.
Reviewing and inactivation of dormant suppliers on ERP system.
Performing supplier master data Audit report.
Coordinating credit application reviews between requesting sites, suppliers and legal review.
Accountable for maintaining and administering supplier data in B-BBEE database:
Socio-Economic (SED) data.
Preferential Procurement (PP) data.
Supplier and Enterprise Development (ED) data.
Coordinating relevant B-BBEE data during verification process.
