Procurement Systems & Analytics Specialist
Vertiv, Westerville, OH, United States
Job Description
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
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, KPIs and risk management.
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.
Education & Certifications
Bachelor’s degree in Computer Information Systems, Data Analytics, Supply Chain Management, Business, or Finance; MBA a plus.
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.
Previous experience with SAP or Oracle a plus.
Qualifications
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.
Time Travcel Required
10%
Work Authorization
No calls or agencies please. Vertiv will only employ those who are legally authorized to work in the United States. This is not a position for which sponsorship will be provided. Individuals with temporary visas such as E, F‑1, H‑1, H‑2, L, B, J, or TN or who need sponsorship for work authorization now or in the future, are not eligible for hire.
Vertiv is an Equal Opportunity/Affirmative Action employer. We promote equal opportunities for all with respect to hiring, terms of employment, mobility, training, compensation, and occupational health, without discrimination as to age, race, color, religion, creed, sex, pregnancy status (including childbirth, breastfeeding, or related medical conditions), marital status, sexual orientation, gender identity / expression (including transgender status or sexual stereotypes), genetic information, citizenship status, national origin, protected veteran status, political affiliation, or disability. If you have a disability and are having difficulty accessing or using this website to apply for a position, you can request help by sending an email to help.join@vertivco.com.
#J-18808-Ljbffr
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
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, KPIs and risk management.
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.
Education & Certifications
Bachelor’s degree in Computer Information Systems, Data Analytics, Supply Chain Management, Business, or Finance; MBA a plus.
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.
Previous experience with SAP or Oracle a plus.
Qualifications
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.
Time Travcel Required
10%
Work Authorization
No calls or agencies please. Vertiv will only employ those who are legally authorized to work in the United States. This is not a position for which sponsorship will be provided. Individuals with temporary visas such as E, F‑1, H‑1, H‑2, L, B, J, or TN or who need sponsorship for work authorization now or in the future, are not eligible for hire.
Vertiv is an Equal Opportunity/Affirmative Action employer. We promote equal opportunities for all with respect to hiring, terms of employment, mobility, training, compensation, and occupational health, without discrimination as to age, race, color, religion, creed, sex, pregnancy status (including childbirth, breastfeeding, or related medical conditions), marital status, sexual orientation, gender identity / expression (including transgender status or sexual stereotypes), genetic information, citizenship status, national origin, protected veteran status, political affiliation, or disability. If you have a disability and are having difficulty accessing or using this website to apply for a position, you can request help by sending an email to help.join@vertivco.com.
#J-18808-Ljbffr