Sourcing Analyst I

The Sourcing Analyst I position plays a critical role in supporting Sherwin-Williams' sourcing and procurement strategy. This role is responsible for analyzing spend, evaluating supplier performance, identifying cost saving opportunities, and supporting category strategy execution. The ideal candidate brings strong analytical capability, diligence, and an ability to collaborate across cross-functional teams in a fast-paced environment.

Additional Information

The travel for this position is 5%.

This role is not remote/hybrid. This role will report to our Global Technical Center in Brecksville, OH or 1101 S 3rd St Minneapolis, MN 55415.

Job duties include contact with other employees and access confidential and proprietary information and/or other items of value, and such access may be supervised or unsupervised. The Company therefore has determined that a review of criminal history is necessary to protect the business and its operations and reputation and is necessary to protect the safety of the Company's staff, employees, and business relationships.

• Provide support for the categories of Raw Materials (including but not limited to Color Pigments, Colorants and Dyes)
• Generate reports using various Microsoft software applications and other Business Intelligence and ERP system tools
• Assist with maintaining specific departmental components of the supply chain, such as inventory tracking, vendor management, process issues, information technology, and related areas
• Develop and maintain a variety of reports such as vendor lists, performance history, price quotes, and other information
• Keep manager informed of work problems and issues, report on project progress
• Maintain detailed and accurate records
• Assume responsibility for the completion of assigned duties
• Develop and maintain a standardized pricing analysis process and determine impact of supplier price changes
  Maintain current vendor pricing in the appropriate ERP system as directed by the Sourcing Managers
• Review and resolve invoices with pricing errors with Sourcing Manager final approval
• Maintain current pricing in the numerous Pricing databases
• Review and resolve invoice pricing discrepancies while interacting with Accounts Payable personnel and/or suppliers to proactively take actions that will prevent recurrence
• Maintain and support eBusiness initiatives including paperless purchasing and consignment inventory rollouts
• Update and maintain records for cost savings initiatives utilizing project software; Interface with Technical, Operations, and Business Unit counterparts to track project progress and timelines; Assist Finance team with validation of reported savings as necessary
• Develop and maintain the Supplier Relationship Management System to improve communications between HQ and suppliers
• Meet with suppliers to present overviews of various eBusiness platform programs, answer questions and provide support to anticipate and/or resolve issues or concerns
• Communicate with suppliers about eBusiness initiatives, including pricing and problem resolution
• Assist with analyzing and comparing vendors/supplier performance; recommend changes to management
• Manage (or assist with) special projects, which may include compiling and analyzing targeted data, reviews and assessments of processes or operations or developing special reports. Creates detailed reports on findings and recommendations
• Assist with resolution of supply issues which may include tracking of orders and delivery dates as necessary
• Perform market research and cost model/impact analysis in support of category strategy and supplier negotiation
• Assist with preparing requests for proposals/quotation, such as drafting documents, gathering data from sites, setting up electronic events, analyzing potential bidders, and responding to questions and/or concerns
• Assist with analyzing and comparing suppliers and their performance; recommend changes to management to save money and reduce working capital
• Assist with maintaining specific departmental components of the supply chain, such as inventory tracking, vendor management, process issues, information technology, and related areas
• Develops and maintain a variety of reports such as vendor lists, performance history, price quotes, and other information

Minimum Requirements:

• Must be at least eighteen (18) years of age
• Must be legally authorized to work in the country of employment without needing sponsorship for employment work visa status now or in the future (e.g., OPT, CPT, H1B, EB-1,etc.)
• Must have Bachelor's Degree or higher
• Must have at least four (4) year of experience using Microsoft Office products (e.g. Word, Excel, PowerPoint, Teams, and/or Outlook
• Must have working experience with controlling, reconciling, and analyzing purchasing information maintained on multiple systems
• Must have experience with Enterprise Resource Planning (ERP) system with purchasing/manufacturing and AOM systems

Preferred Qualification:

• Have at least two (2) years' experience working in a Sourcing, Payables, Receivables, Customer Service, Engineering or Manufacturing environment
• Have prior work experience with Business Intelligence Tools (e.g. Tableau)