Procurement Systems & Analytics Manager
Westerville, OH - USA
Department:
Job Summary
The Procurement Systems & Analytics Manager is a key partner for the Americas Strategic Sourcing team. This role 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 KPIs and risk management.
| Responsibilities: Please list at least 5 duties/accountabilities. |
- Collect clean and validate large datasets from multiple sources(Oracle SnowFlake) to ensure accuracy consistency and completeness.
- Architect and execute advanced SQL queriesleveraging complex joins window functions and CTEsto 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: Please note minimum and preferred requirements for education. This includes degree specializations and certifications. |
- Bachelors degree in Computer Information Systems Data Analytics Supply Chain Management Business or Finance; MBA a plus.
- Minimum of seven 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.
| Requirements: Please list all experience required to perform this job. You may note some requirements as preferred. |
- 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.
YEARS OF EXPEREINCE
7 - 10 Years
TRAVEL REQUIREMENTS
10%
The successful candidate will embrace Vertivs Core Principals & Behaviors to help execute our Strategic Priorities.
OUR CORE PRINCIPALS: Safety. Integrity. Respect. Teamwork. Diversity & Inclusion.
OUR STRATEGIC PRIORITIES
Customer Focus
Operational Excellence
High-Performance Culture
Innovation
Financial Strength
OUR BEHAVIORS
Own It
Act With Urgency
Foster a Customer-First Mindset
Think Big and Execute
Lead by Example
Drive Continuous Improvement
Learn and Seek Out Development
About Vertiv
Vertiv is a $10.2billion global critical infrastructure and data center technology company. We ensure customers vital applications run continuously by bringing together hardware software analytics and ongoing services. Our portfolio includes power cooling and IT infrastructure solutions and services that extends from the cloud to the edge of the network. Headquartered in Columbus Ohio USA Vertiv employs around 20000 people and does business in more than 130 countries. Visit to learn more.
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.
Equal Opportunity Employer
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
Required Experience:
Manager
About Company
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 s ... View more