Vendor Management Analyst - Power Automate, Ariba, Excel

Top 5 Technical Skills:

1. Vendor Management Office experience in large company
2. Strong Excel and Analytical Reporting
3. Strong PowerBI
4. Strong MS Power Automate Experience
5. Vendor Management software/packages, preferable Ariba
6. Data management / data migration project from spreadsheets into an application

Top 3 Soft Skills:

1. Detail oriented ("Amazing attention to detail")
2. Strong communications - Proactive Communications
3. "Right Hand Resource" for VM
4. Own their work (hard worker) -
5. Solution Provider - Take the Ball and Run with It Attitude...

Full Job Description Below:

1. Tools I have used for extracting data:
2. DBeaver
3. SAP
4. SAP Ariba

• Tool I used to build reports:
• Excel
• PowerBI
• DBeaver
• Day to day activities:
• Build spend and forecasting reports/dashboards
• Build savings dashboards
• Meet with suppliers
• KPI Reporting
• Contractor headcounts
• Spend
• Overall utilization / performance
• Investigate data for suppliers for any potential fraud
• Compare spend from multiple systems to find discrepancies
• Create standardizations in documentation
• Check for discrepancies/variances in team data
• Develop workflows using PowerAutomate to make manual tasks automated
• Network between multiple departments to understand the data
• Come up with ideas to make the daily manual work for the team more efficient and automated needs an outsider s perspective in a way.

There are 2 junior apprentices on the team (1 data analyst, 1 automation specialist), will work alongside them.
Job description via the above information:
Description VMO Analyst is responsible for developing and maintaining data-driven insights that support procurement, supplier management, and business decision-making. This role analyzes spend, savings, supplier performance, and workforce utilization while identifying data discrepancies, process improvements, and automation opportunities. Working closely with procurement, finance, operations, and supplier partners, the analyst transforms complex data into actionable dashboards and reports that improve visibility, reduce manual effort, and support strategic initiatives.
Key Responsibilities

• Develop and maintain procurement dashboards and reports using Excel, Power BI, and DBeaver.
• Create spend analysis, forecasting, and savings dashboards to support procurement strategy and executive reporting.
• Produce and maintain KPI reporting, including:
• Contractor headcount metrics
• Procurement spend
• Resource utilization and supplier performance
• Extract and analyze data from enterprise systems including SAP, SAP Ariba, and databases using DBeaver.
• Investigate supplier data to identify potential fraud, anomalies, and compliance risks.
• Compare financial and procurement data across multiple systems to identify discrepancies, variances, and data quality issues.
• Validate team reporting and investigate inconsistencies to ensure data accuracy.
• Develop standardized documentation, reporting processes, and best practices to improve consistency across the organization.
• Design and implement workflow automations using Microsoft Power Automate to eliminate manual tasks and improve operational efficiency.
• Collaborate with cross-functional teams to understand business requirements, define reporting needs, and ensure data integrity.
• Build relationships with suppliers and internal stakeholders to support procurement initiatives and performance management.

Technical Skills

• Data Extraction: DBeaver, SAP, SAP Ariba
• Reporting & Analytics: Microsoft Excel, Power BI, DBeaver
• Process Automation: Microsoft Power Automate
• Data Validation and Reconciliation
• KPI Development and Performance Reporting
• Spend Analysis and Forecasting
• Supplier Performance Analysis
• Documentation and Process Standardization

Core Competencies

• Data analysis and business intelligence
• Procurement analytics
• Dashboard development and visualization
• Financial and spend analysis
• Problem-solving and investigative analysis
• Process improvement and automation
• Cross-functional collaboration
• Stakeholder and supplier relationship management
• Attention to detail and data quality assurance

Benefits: