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

RAKKGALAKANE RECRUITMENT; Boksburg; On-site; ZAR 300 000 - 600 000; Full time

Job summary

An established industry player is seeking a skilled Data Analyst with a strong background in data analytics and industrial engineering. In this pivotal role, you will be responsible for analyzing procurement spend data, managing supplier information, and optimizing procurement processes. Your expertise in Microsoft Excel and SQL will be crucial in developing dashboards and visualizing key performance indicators. This is an exciting opportunity to contribute to data-driven decision-making in a dynamic environment, where your analytical skills will directly impact business outcomes and operational efficiency. If you are passionate about data and looking to make a significant impact, this role is for you.

Qualifications

• 5+ years of experience in data analytics or industrial engineering.
• Strong proficiency in Microsoft Excel for data analysis and presentation.

Responsibilities

• Analyze procurement spend data and make sourcing recommendations.
• Develop procurement dashboards and optimize processes.

Skills

Data Analysis

Microsoft Excel

SQL

Data Presentation

Data Visualization

Education

BSC Degree in Data Analytics

Industrial Engineering

Tools

Pragma

Pay to Procure (P2P)

Netstock

Job description

• 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 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.
• Ability to apply data analysis to business needs, including procurement, finance, sales, and operations.
• Data presentation and visualisation.

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 correctness of contract purchase pricing.
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 of purchase price data.
2. Contract adherence.

Accountable for data interfacing with ancillary data systems:

1. Pragma
2. Pay to Procure (P2P)

Accountable for procurement process and system optimization:

1. Developing procurement dashboard, KPI’s and visualization tools.
2. Process optimization.

Accountable for engineering and consumable item master data management:

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

Accountable for Supplier Master Data on ERP system:

1. Supplier risk profiles and bank account verification with verification agencies.
2. Reviewing and inactivation of dormant suppliers on 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 (SED) data.
2. Preferential Procurement (PP) data.
3. Supplier and Enterprise Development (ED) data.