Vendor Management Analyst - Power Automate, Ariba, Excel

Vendor Management Analyst

Type: W2 With Benefits - No C2C

Remote - supporting CST or MST

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:
    1. DBeaver
    2. SAP
    3. SAP Ariba
  2. Tool I used to build reports:
    1. Excel
    2. PowerBI
    3. DBeaver
    4. Day to day activities:
      1. Build spend and forecasting reports/dashboards
      2. Build savings dashboards
      3. Meet with suppliers
      4. KPI Reporting
        1. Contractor headcounts
        2. Spend
        3. Overall utilization / performance
        4. Investigate data for suppliers for any potential fraud
        5. Compare spend from multiple systems to find discrepancies
        6. Create standardizations in documentation
        7. Check for discrepancies/variances in team data
        8. Develop workflows using PowerAutomate to make manual tasks automated
        9. Network between multiple departments to understand the data
        10. 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.
        11. 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:

            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.

            Please contact me to discuss the details of this position further.

            *Please forward resume directly to for immediate consideration - rstarinieri at sesc .com

            I look forward to speaking with you soon!

            Robin Starinieri

            Director of Recruiting

            Systems Engineering Services

            Back to blog

            Common Interview Questions And Answers

            1. HOW DO YOU PLAN YOUR DAY?

            This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

            2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

            When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

            3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

            Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

            4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

            With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

            5. HOW DO YOU PROCESS INFORMATION?

            Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

            6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

            Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

            7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

            Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

            8. HOW TO PRIORITIZE WORK?

            The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

            9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

            Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

            10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

            This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...