Lead Data Analyst - Sherwin-Williams

The Lead Data Analyst seeks to gain insights into data related to Sherwin-Williams’ global ERP solution and develops reports and analytical solutions to meet business needs. The analyst collects and analyzes data, interprets business requirements, and develops reports, visualizations, and analytics to deliver valuable insights to stakeholders. Reporting within the Enterprise Data & Insights organization, the analyst will help to improve efficiency, enhance customer experiences, and manage risks by interpreting complex data sets.

Here, we believe there’s not one path to success, we believe in careers that grow with you. Whoever you are or wherever you come from in the world, there’s a place for you at Sherwin-Williams. We provide you with the opportunity to explore your curiosity and drive us forward. Sherwin-Williams values the unique talents and abilities from all backgrounds and characteristics. All qualified individuals are encouraged to apply, including individuals with disabilities and Protected Veterans. We’ll give you the space to share your strengths and we want you show us what you can do. You can innovate, grow and discover in a place where you can thrive and Let Your Colors Show!
At Sherwin-Williams, part of our mission is to help our employees and their families live healthier, save smarter and feel better. This starts with a wide range of world-class benefits designed for you. From retirement to health care, from total well-being to your daily commute—it matters to us. A general description of benefits offered can be found at Click on “Candidates” to view benefit offerings that you may be eligible for if you are hired as a Sherwin-Williams employee.
Compensation decisions are dependent on the facts and circumstances of each case and will impact where actual compensation may fall within the stated wage range. The wage range listed for this role takes into account the wide range of factors considered in making compensation decisions including skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled.
The wage range, other compensation, and benefits information listed is accurate as of the date of this posting. The Company reserves the right to modify this information at any time, with or without notice, subject to applicable law.
Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable federal, state, and local laws including with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act where applicable.
Sherwin-Williams is proud to be an Equal Employment Opportunity/Affirmative Action employer committed to an inclusive and diverse workplace. All qualified candidates will receive consideration for employment and will not be discriminated against based on race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age, pregnancy, genetic information, creed, marital status or any other consideration prohibited by law or by contract.
As a VEVRAA Federal Contractor, Sherwin-Williams requests state and local employment services delivery systems to provide priority referral of Protected Veterans.
Please be aware, Sherwin-Williams recruiting team members will never request a candidate to provide a payment, ask for financial information, or sensitive personal information like national identification numbers, date of birth, or bank account numbers during the application process.

CORE RESPONSIBILITIES AND TASKS:

• Collaborate with business users to understand requirements, changes, and enhancements, and translate them into lean specifications.
• Support sizing of features and user stories for reporting & analytics solution components.
• Participate in refinement sessions to identify and log subtasks required to complete development.
• Collaborate with Data Solution Architects to draft technical designs for analytics solutions.
• Analyze large datasets to identify trends, patterns, and insights that drive business decisions.
• Collaborate with data engineering on Extraction, Transformation, and Loading (ETL) of data from various sources to support report requirements.
• Develop reports, visualizations, and analytical solutions based on technical designs.
• Conduct functional unit testing for analytics and reports.
• Manage report versioning, ensuring that reports are maintained and up to date with system changes and user requirements.
• Document report development process and enforce best practices for report development, ensuring consistency and performance across all reports.
• Deploy reports and analytics solutions according to the instance strategy and deployment methodology.
• Identify opportunities to improve existing reports and dashboards.

“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.”

FORMAL EDUCATION:

Required:

• Bachelor's degree in Computer Science, Information Systems, or related field, or in lieu of related degree, at least 8 years of experience in data analysis.

KNOWLEDGE & EXPERIENCE:

Required:

• 8+ years of experience in data analysis, business intelligence, or a similar role working with Oracle Fusion Cloud ERP applications.
• Proven experience in a techno-functional role, with the ability to bridge technical and business requirements.
• Familiarity with business operations, processes, and key functions.
• Experience communicating complex technical subjects to technical and non-technical audiences through developing documentation and training materials.
• Experience in coordinating with IT teams and stakeholders.
• Independent, curious, eager to tackle a wide variety of problems, and able to quickly develop knowledge and understanding of new domains and underlying data sources.
• Experience developing, testing, documenting, and maintaining standardized outcome metrics meeting diverse business needs.
• Experience developing, implementing, testing, and maintaining methodologies for standardized and repeatable reporting for internal and external audiences.

Preferred:

• Experience working in a team-oriented, collaborative environment.
• Experience with Agile (Scrum) methodologies and related tools (Jira).
• Experience supporting and managing cross-functional teams in a dynamic environment.
• Experience with business processes and related data requirements in one or more of these process areas:
  
  • Financials: Accounts Payable, Accounts Receivable, Fixed Assets, General Ledger, Tax
  • OTI: Order Management, Pricing & Promotions, Warehousing & Distribution, Invoicing
  • PMI: Planning & Procurement, Manufacturing Execution, Inventory Management

TECHNICAL/SKILL REQUIREMENTS:

Required:

• Proficiency in SQL, PL/SQL, and data modeling.
• Experience with Data Analytics and Visualization Tools (e.g., Tableau and MicroStrategy)​
• Strong knowledge of data warehousing concepts and ETL processes.
• Advanced analytical, conceptual, and problem-solving skills.
• Strong ability and initiative to learn and research new concepts, ideas, and technologies quickly.

Preferred:

• Familiarity with Oracle Cloud PVOs, OTBI, APIs, and integration tools.

Travel Requirements: (TIME SPENT AWAY FROM HOME OR OTHER TYPICAL OFFICE LOCATION)

• 10%