Description
Procurement Analyst
Job Summary:
Reporting to the Procurement Regional Director, this role will be responsible for performing analytics to support the Procurement services function.
Responsibilities:
(40%) Data Analysis & Reporting:
Must be able to perform advanced Excel skills, such as but not limited to, V lookups, H lookups, IF functions, pivot tables, charts, graphs, etc.
Conduct spends analysis from software systems to provide reports for suppliers and across spend categories.
Collate data and analysis from multiple internal systems as well as external sources to develop professional PowerPoints to provide to the internal Procurement Front Office for presentation to internal stakeholders as well as external suppliers.
Establish and publish (weekly & monthly) dashboards to track category spend, inflation/deflation, key projects and provide the completed reports.
Develop scorecards to measure supplier performance and continuous improvement per agreement with the Front Office.
Obtain data from numerous different source systems and cleanse for data integrity for incorporation into spreadsheets and reports.
(40%) Core Procurement Support:
Produce Business and Market Intelligence reports to the Procurement Front Office. Role includes, but is not limited to; conducting independent research for procurement categories, identifying potential suppliers based upon predetermined criteria, conducting financial/bankruptcy analysis on potential suppliers, identifying historical internal spend for procurement categories, and consolidating & drafting a report-out to the Procurement Front Office.
Event Execution:
Analyse data, derived from multiple sources, to summarize cost and service trends. Utilize findings to make recommendations to the Front Office. Communicate with suppliers regarding upcoming events, field queries and system use. Load, launch and monitor sourcing events utilizing a software database. Relay and respond to supplier queries. Track and communicate supplier completion of responses. Analyse results and provide feedback in Excel and/or PowerPoint reports for presentation to internal stakeholders
Negotiate with suppliers on pricing and payment terms as agreed with Procurement Front Office.
Stakeholder Communication: Provide data analysis for events and build presentations to support Procurement Front Office stakeholder decision meetings.
(15%) Procurement Administration support:
Support and navigate existing tools and pending software tools.
Process Documentation
Maintain Work Package standard work.:
Responsible for auditing to make sure standard work is being followed.
(5%) Tools & Training:
Managing incoming call centre tickets
Train stakeholders in existing and new systems.
Training Administration:
Learning module administration for Procurement - including uploading modules to E-learning system (ie Conflict Minerals).
Reporting for managers; administrators
Essential:
An honours degree or equivalent experience in related technical field such as Finance, Accounting, Business or similar fields
Minimum of 2 years substantial experience in a similar procurement or buying role.
Knowledge and understanding of Procurement concepts, policies, and procedures.
Ability to work with all levels of internal and external customers. Demonstrated ability to provide the highest level of customer service to internal and external customers.
Excellent interpersonal and communication skills and attention to detail.
Strong skill in MS Outlook, Excel, Word, and the ability to learn additional programs as needed.
Demonstrated experience in managing multiple projects across different areas of the business.
Ability to analyse data using standard statistical methods including Datamodelling; creates spreadsheets, graphs, and charts to illustrate findings; and drafts clear and concise management reports.