Procurement Systems & Analytics Specialist

Vertiv Group•Westerville, OH

About The Position

Generic Job Summary: A brief synopsis of the role; this summary is intended to describe all employees at Vertiv who perform this work. Your HRBP can provide the Job Architecture description if needed. The Senior Procurement Data Analyst is a key partner for the Americas Strategic Sourcing team. The Analyst will evaluate data to generate reports and strategic insights to drive the Americas Strategic Sourcing KPIs. Full engagement and relationship with Sourcing Manager (SM) teams to complete all ad hoc requests. Support successful Large Program execution, sourcing analysis, and supplier performance improvement initiatives. Work with the Strategic Sourcing team on various procurement projects and be viewed as a strong project facilitator by Strategic Sourcing Leadership. Additionally, the ability to work independently with at times with minimal direction in a fast-paced, often high-stress environment. Business Unit Job Summary: A brief synopsis of the role for this set of work. This summary can include details about products, regions, scope and other details unique to a GBU, department or position. Collect, clean, and validate large datasets from multiple sources (Oracle, SnowFlake) to ensure accuracy, consistency, and completeness. Develop and maintain interactive dashboards, reports, and visualizations (e.g., Power BI) to track KPIs and Strategic Sourcing performance. Conduct deep-dive trend and root cause analyses to identify improvement opportunities and support strategic decision-making. Partner with functional teams (Procurement, Operations, Finance, Sales) to define metrics, design reports, and automate recurring analyses. Use statistical and predictive analysis to support Large Program successful execution, Supplier performance improvement, and Sourcing goals. Continuously improve data pipelines and data integrity, working closely with IT and system owners. Prepare and present findings and recommendations to senior leadership in clear, business-focused terms. Identify automation opportunities and implement self-service analytics tools to empower users and reduce manual reporting. Perform business process analysis and own the design and improvement of new and existing tools and processes to support business decisions. Regularly review reporting, make recommendations for necessary changes and implement improvements. Effectively resolve roadblocks to collection of complete and accurate data and adoption of tools. Identify data integrity issues and lead cross functional efforts to develop processes to resolve discrepancies. Using data analysis methods, develop recommendations to leadership for improvements in reporting, KPI’s and risk management.

Requirements

Minimum of five years of analytical experience performing detailed analyses.
Experience in defining, scoping and implementing projects.
Advanced knowledge of SharePoint, Excel, PowerPoint, and Power BI along with experience in writing queries to access information from relational database management systems.
5-7 years of experience
Proven success in the identification of issues using advanced analytics.
Expert-level SQL proficiency with the ability to write, debug, and optimize complex queries (including window functions, subqueries, and CTEs) for data extraction and performance tuning
Detail-oriented, analytical and results-driven.
Motivated problem solver.
Excellent communication skills and ability to build cross-functional relationships.
Ability to manage and manipulate large amounts of data quickly.
Ability to manage multiple simultaneous requests and projects.
Ability to work in a fluid environment without closer supervision.

Nice To Haves

MBA a plus.
Previous experience with SAP or Oracle a plus.

Responsibilities

Collect, clean, and validate large datasets from multiple sources (Oracle, SnowFlake) to ensure accuracy, consistency, and completeness.
Architect and execute advanced SQL queries—leveraging complex joins, window functions, and CTEs—to extract actionable insights from multi-source relational databases and optimize query performance for large-scale datasets.
Develop and maintain interactive dashboards, reports, and visualizations (e.g., Power BI) to track KPIs and Strategic Sourcing performance.
Conduct deep-dive trend and root cause analyses to identify improvement opportunities and support strategic decision-making.
Partner with functional teams (Procurement, Operations, Finance, Sales) to define metrics, design reports, and automate recurring analyses.
Use statistical and predictive analysis to support Large Program successful execution, Supplier performance improvement, and Sourcing goals.
Continuously improve data pipelines (ETL and ELT) and data integrity, working closely with IT and system owners.
Prepare and present findings and recommendations to senior leadership in clear, business-focused terms.
Identify automation opportunities and implement self-service analytics tools to empower users and reduce manual reporting.
Perform business process analysis and own the design and improvement of new and existing tools and processes to support business decisions.