Sr. Procurement Analyst

Republic Services•Phoenix, AZ

About The Position

POSITION SUMMARY: With limited supervision, the Senior Procurement Data Analyst aligns with category stakeholders to capture their requirements and offer effective solutions. The Senior Procurement Data Analyst provides key analytical support to Category leaders through high-level statistical data analysis and modeling, database development and management, and financial analysis. With a focus on collaboration, this role is responsible for responding to internal requests and using creative and critical thinking skills to identify and implement solutions that will support the data analysis needs of various category teams within the Procurement organization. PRINCIPAL RESPONSIBILITIES: Works with internal stakeholders to identify and analyze data sources from disparate systems to derive insights and turn data into actionable information. Accesses and compiles large amounts of data and applies statistical techniques to analyze the data, forecast, interpret, and quantify trends on various aspects of information. Develops, manages, and maintains key statistical and/or financial databases, using SQL, Excel, Access and/or other tools. Obtains data for cost analysis studies respective to assigned categories and conducts spend analysis as necessary to support sourcing activities. Optimizes category solutions and drives continuous improvement. Analyzes and recommends the use of alternative sources or materials to reduce costs. Analyzes and evaluates suppliers. Prepares related reports and provides analysis to senior procurement leadership and internal stakeholders as appropriate. Compiles and analyzes data to determine the feasibility of buying products and establishes price objectives for contract transactions. Provides team and Procurement leadership with insight into competitive pricing as appropriate. Implements processes to enable optimal category solutions including cost modeling, price/volume analysis, TCO analysis. Aligns with sourcing initiatives and leverages internal and external resources to assist with and perform research to develop the supply base. Develops a comprehensive understanding of the supply base. Identifies, analyzes and creates opportunities to improve/reduce the supply base. This may include, but is not limited to, the identification of processes and controls to ensure data accuracy and consistency. Performs market and industry trend analysis, evaluates supply sources, and assists stakeholders in identifying solutions to their needs. Develops effective management presentation materials based on findings, including professional display of information. Communicates regularly with internal stakeholders to maintain knowledge of the stakeholder’s business and opportunities and anticipate their needs/requests. Uncovers issues, evaluates various courses of action, and promotes the best option for resolution. Conducts complex spend analyses to support sourcing related activities, using intermediate to advanced analytical modeling techniques to understand supplier price and cost. Leads multiple projects simultaneously, including process planning and supplier quality improvement efforts. May coordinate activities of others, including assigning and delegating work. Performs other duties as assigned or apparent.

Requirements

Advanced proficiency with spreadsheet and database management tools; advanced MS Excel skills including VBA programming, macros, and advanced formulas.
Ability to effectively communicate, both written and verbally, with customers and stakeholders to build strong internal and external relationships while maintaining a high sense of urgency and customer focus.
Ability to effectively manage multiple projects or tasks with varying and sometimes competing timelines.
3-5 years of supply chain and/or equivalent experience (i.e. Finance, Engineering, Accounting, Transportation, Operations, etc.).

Nice To Haves

Supply Chain, Continuous Improvement, Six Sigma, or Lean Sigma experience.
Experience with intermediate SQL querying.
Experience with MS PowerPoint and Access and eProcurement systems.
Experience analyzing and documenting complex business processes or problems using intermediate to advanced statistical and analytical modeling techniques and with a focus on detail, cost drivers, and total cost of ownership.
Demonstrated experience leading or providing direction to others.

Responsibilities

Works with internal stakeholders to identify and analyze data sources from disparate systems to derive insights and turn data into actionable information.
Accesses and compiles large amounts of data and applies statistical techniques to analyze the data, forecast, interpret, and quantify trends on various aspects of information.
Develops, manages, and maintains key statistical and/or financial databases, using SQL, Excel, Access and/or other tools.
Obtains data for cost analysis studies respective to assigned categories and conducts spend analysis as necessary to support sourcing activities.
Optimizes category solutions and drives continuous improvement.
Analyzes and recommends the use of alternative sources or materials to reduce costs.
Analyzes and evaluates suppliers.
Prepares related reports and provides analysis to senior procurement leadership and internal stakeholders as appropriate.
Compiles and analyzes data to determine the feasibility of buying products and establishes price objectives for contract transactions.
Provides team and Procurement leadership with insight into competitive pricing as appropriate.
Implements processes to enable optimal category solutions including cost modeling, price/volume analysis, TCO analysis.
Aligns with sourcing initiatives and leverages internal and external resources to assist with and perform research to develop the supply base.
Develops a comprehensive understanding of the supply base.
Identifies, analyzes and creates opportunities to improve/reduce the supply base.
Performs market and industry trend analysis, evaluates supply sources, and assists stakeholders in identifying solutions to their needs.
Develops effective management presentation materials based on findings, including professional display of information.
Communicates regularly with internal stakeholders to maintain knowledge of the stakeholder’s business and opportunities and anticipate their needs/requests.
Uncovers issues, evaluates various courses of action, and promotes the best option for resolution.
Conducts complex spend analyses to support sourcing related activities, using intermediate to advanced analytical modeling techniques to understand supplier price and cost.
Leads multiple projects simultaneously, including process planning and supplier quality improvement efforts.
May coordinate activities of others, including assigning and delegating work.
Performs other duties as assigned or apparent.