Sr. Analyst

Position Summary
The CoE Analytics & CCO Analyst position will deliver internal analyses and external business intelligence insights to the category management team by implementing a robust analytical process (eg. Collaborative Category Optimization) for designated categories. Responsible for the management of data (gathering, summarizing, and analyzing of data) necessary to complete the analysis for designated categories. Demonstrate the company's core values of respect, honesty, integrity, diversity, inclusion, and safety.
Essential Job Functions

• Business Intelligence and Data Analytics
• Map key business questions to data need and assess feasibility of obtaining requested internal/external data
• Collect and validate data from internal systems and supplier sources as needed
• Facilitate and execute development of spend analytics reports and insights to drive data backed decisions and improve performance (eg. financial, market, supplier, pricing)
• Perform system agnostic calculations and combine data from multiple sources into a presentable format
• Draw insights, document findings, and communicate results from internal and market analysis
• Prepare category improvement projections and conduct post-implementation variance analysis
• Interact with other CoE activities to provide assistance in pulling the data at different stages of the sourcing events and determine common data needs
• Support CoE Sr. Analyst and Manager in coordinating with category management to develop and perform spend analytics and negotiation materials per category and aggregate
• Advanced Analytics
• Able to identify total internal costs associated with supplier price, delivery, operations and quality
• Able to quantify the overall total ownership cost of each product or service to identify cost savings
• Perform and report should cost analysis & TCO analysis
• Benefit Tracking
• Partner with the KPI & Benefits team to develop a tracking mechanism to report and communicate the savings achieved
• Additional Support
• Support business user adoption of business intelligence and self-service reporting objectives
• Support talent development framework and proven experience in creating/maintaining training curriculum
• Must be able to perform the essential job functions of this position with or without reasonable accommodation

Minimum Position Qualifications

• Bachelor's Degree in Business, Information Management, Finance, Retail, CPG, or Data Analytics
• 1 year of data analysis experience including building SQL, queries, and common/standard use of data analysis tools
• Familiarity with data modeling, data dictionary, data analytics and data profiling
• Ability to become a key point of contact for the team, speak to internal clients, develop/maintain long term relationship with internal stakeholders
• Self-starter, ability to work independently in a fast-paced environment while delivering solid results
• Analytical skills with ability to identify, quantify and effectively leverage data to support business decisions, communicate opportunities and/or raise business risks
• Advanced Microsoft Office skills
• Ability to synthesize analysis into compelling oral/written communications and presentations

Desired Previous Experience/Education

• 1 year of experience in a data organization, clearly exposed and performing tasks within different data governance aspects (quality, standards, reference data, data management)
• 1 year of experience building should cost and TCO analyses

Fresh Job Description:
Position Summary:
Support the day to day execution of strategies for assigned categories and focus on reducing organizational spend to improve savings and enhancing relationships with business stakeholders and suppliers. Demonstrate the company's core values of respect, honesty, integrity, diversity, inclusion, and safety.
Essential Job Functions:

• Tactical Sourcing
• Design and execute sourcing events for pertinent category
• Utilize available e-sourcing and optimization tools efficiently
• Develop different award optimization scenarios to minimize total cost of ownership
• Respond to supplier and stakeholder questions (e.g. category, supply, event, price, or specification)
• Support the execution of supplier financing programs maintaining a holistic view of early payment and accounts payables programs
• Prepare planning guide to facilitate the completion of the negotiation and support where needed

• Sourcing Analysis
• Conduct opportunity assessments, benchmarking, and should cost modeling to develop sourcing opportunities
• Prepare category improvement projections and conduct post-implementation variance analysis
• Identify total internal costs associated with supplier price, delivery, operations and quality
• Quantify the overall total ownership cost of each product or service to identify cost savings

• Contract Management
• Work with the contract management team in the administration of contract data, addendums, item master sheets, and additional supplier documentation

• Supplier Relationship Management
• Support category managers in the development of supplier performance/continuous improvement targets and related scorecards
• Work with the SRM team in the administration of supplier assessments, score cards, and other analytics to manage supplier performance

• Benefit Tracking
• Partner with the KPI & Benefits team to develop a tracking mechanism to report and communicate the savings achieved

• Additional Support
• Support other initiatives / projects in the company that may affect organization's performance and collaborate with necessary stakeholders
• Support talent development framework and proven experience in creating/maintaining training curriculum
• Must be able to perform the essential functions of this position with or without reasonable accommodation

Minimum Position Qualifications/Education:

• Bachelor's degree in Business Management, Supply Chain, Operations, Finance, CPG, or similar
• 1-year professional experience in procurement activities
• Ability to identify, quantify and effectively communicate business risks
• Self-starter, ability to work independently in a fast-paced environment while delivering solid action-oriented results quickly
• Analytical skills with the ability to identify, quantify and effectively leverage data to support business decisions, communicate opportunities and/or raise business risks
• Ability to monitor compliance with established guidelines, policies, procedures, and regulations
• Advanced Microsoft Office skills (Word, Excel, PowerPoint, Outlook, Vizio)
• Ability to synthesize analysis into compelling oral and written communications and presentations

Desired Previous Job Experience/Education:

• CPM/CPSM, CSCP or equivalent certification
• Expertise in Microsoft Office, data visualization tools
• 1-year professional experience in Procurement, Supply Chain, Manufacturing, or Retail