Sourcing Analyst I

The Sherwin-Williams Company; Cleveland (OH); On-site; USD 55,000 - 70,000; Full time

Job summary

The Sherwin-Williams Company is seeking a Sourcing Analyst I in Cleveland to support pricing, spend analysis, and supplier performance management. You will develop pricing analyses, maintain pricing data in ERP, and generate vendor reports.

Travel up to 5% may be required. This role is not remote/hybrid and reports to Sherwin-Williams Global Headquarters in Cleveland, OH 44113. Bachelor’s degree and strong MS Office skills are required.

Qualifications

• Bachelor's degree or commensurate experience.
• Strong PC skills including Microsoft Office.
• Experience with ERP systems and BI reporting is desirable.

Responsibilities

• Analyze pricing and spend data to support category strategy.
• Generate reports using MS Office, BI and ERP tooling.
• Maintain vendor lists, performance history, quotes and savings records.
• Assist with supplier performance management and invoice pricing discrepancies.
• Support cost-saving initiatives and eBusiness/consignment projects.
• Coordinate document and sample requests and track project progress.

Skills

Analytical skills

Microsoft Office

ERP systems

BI reporting

Vendor management

Cross-functional collab

Education

Bachelor's Degree or equivalent

Tools

ERP systems

BI tools

Job description

The Sourcing Analyst I position plays a critical role in supporting the company's sourcing and procurement strategy. This role is responsible for analyzing pricing and spend data, supporting supplier performance management, identifying costsaving opportunities, and assisting with category strategy execution. The ideal candidate demonstrates strong analytical skills, attention to detail, and the ability to collaborate effectively across crossfunctional teams.

CORE RESPONSIBILITIES AND TASKS:

• Provide support for the categories of Industrial Resin Raw Materials (including Toller).
  • 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.
  • Enter and maintain savings and technical projects within the systems.
  • Coordinate document and sample requests from the business teams.
  • 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.

Additional Responsibilities may include:

• 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.
• Support category initiatives

Travel Requirement: Up to 5%

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.

This role is not remote/ hybrid and will report to Sherwin-Williams Global Headquarters located at 1 Sherwin Way, Cleveland, OH 44113.

POSITION REQUIREMENTS:

Required:

• Must be eighteen (18) years of age or older.
• Must be legally authorized to work in the country of employment without needing sponsorship for employment work visa status now or in the future.
• Bachelor's Degree from an accredited institution, or commensurate experience
• Position requires strong PC skills including ability in Microsoft Office Suite.
• Effectively controlling, reconciling, and analyzing purchasing information maintained on multiple systems.
• Learning how to use the ERP purchasing/manufacturing and AOM systems.
• Increasing the efficiency of the Procurement Group by improving the availability of timely, accurate, and relevant purchasing and supplier information.
• Learning corrective action required to eliminate repeat invoice or purchase order pricing errors.
• Fostering an atmosphere of teamwork among all departments.
• Developing positive working relationships with key stakeholders.

Preferred:

• A minimum of two (2) years' experience working in a Sourcing, Payables, Receivables, Customer Service or Manufacturing environment is desirable.
• Prior experience with existing ERP systems.
• Strong competency in developing and analyzing reports using Business Intelligence Tools.
• Prior experience in chemicals industry.
• Multi-Lingual is a plus.