Vendor Management Analyst - Power Automate, Power BI, Ariba, Excel

Type: W2 With Benefits
- No C2C

Remote - supporting CST or MST

• 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 Power Automate 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.

• 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.

• 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

• 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

SES hires W2 benefitted and non-benefitted consultants. Our contract employee benefits include group medical dental vision life LT and ST disability insurance, 21 days of accrued paid time off, 401k, tuition reimbursement, performance bonuses, paid overtime, and more.