Lead, Regional Data Operations, NOAM (US)

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

Job summary

The Sherwin-Williams Company in Cleveland, OH is seeking a Lead Data Management Analyst to plan, design, develop and assess data quality and governance programs. You will ensure data integrity, completeness and proper formatting, using SQL, ETL and profiling techniques to test outputs against specifications.

Responsibilities include leading audits, documenting tests, and guiding automated and manual data quality work within governance frameworks.

Qualifications

• Bachelor's degree in CS/IT or related field, or 9+ years data management experience.
• 6+ years in data quality management.
• In-depth knowledge of data quality frameworks, policies, procedures and controls.
• Extensive knowledge of data governance, MDM, and data modeling.
• Expertise in SQL, ETL, and data profiling and cleansing.
• Analytical skills to analyze complex data quality issues and root cause.
• Legally authorized to work without sponsorship in the United States.

Responsibilities

• Facilitate quality assessments on data elements and structures for integrity and quality.
• Provide strategic guidance for manual or automated data testing against specs and governance rules.
• Lead regular and ad hoc reviews, audits and investigations of data activity and integrity; prepare reports.
• Implement guidelines and documentation of test development processes and standards.

Skills

SQL

ETL

Data profiling

Data cleansing

Data governance

Master data management

Data modeling

Analytical skills

Education

Bachelor's degree in Computer Science or IT

Tools

IBM InfoSphere Information Analyzer

Talend

Data Warehousing & ETL

SAS

R

Python

SSAS

Oracle

Microsoft SQL Server

MySQL

DataFlux

Trillium

Informatica Data Quality

Job description

The Lead Data Management Analyst focus specializes in planning, designing, developing and performing assessments on data and structures to ensure integrity, completeness, quality, and appropriateness of formats, records and structures. Uses manual and/or automated methods and procedures to test output as established by product management, client specifications, and business/governance rules.

• Facilitate quality assessments on data elements and structures to document and evaluate integrity, completeness, quality, and appropriateness of formats, records and structures.
• Provide strategic guidance for manual and/or automated methods, processes and procedures to test output or input based on data compliance, quality and use requirements as established by product management, client specifications, and governance programs.
• Lead efforts for regular and ad hoc reviews, audits, and investigations of data activity and integrity; prepares reports and summaries of findings.
• Implement guidelines and documentation of test development processes, procedures and standards.

This position is not hybrid/remote and will be located at our Cleveland Headquarters office.

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.

Must be eighteen years or older

EDUCATION AND EXPERIENCE

Required

• Bachelor's degree in Computer Science, Information Technology, or a related technical field, or in lieu of related degree, at least 9 years of experience in data management
• 6+ years of experience in data quality management field
• In-depth knowledge of development and implementation data quality frameworks, policies, procedures, and controls
• Extensive knowledge of data governance, master data management, and data modeling
• Expertise in SQL, ETL, and data profiling and cleansing techniques
• Exceptional analytical skill with the ability to analyze complex data quality issues, conduct root cause analysis, and develop remedial action plans
• Knowledge of data governance, master data management, and data modeling
  • Technical Skills
    • Data Quality Assessment and Monitoring Tools (e.g., IBM InfoSphere Information Analyzer, Talend)
    • Data Warehousing & ETL Processes
    • Data Analysis Tools (e.g., SAS, R, Python, SSAS)
    • Database Management (e.g., Oracle, Microsoft SQL Server, MySQL)
    • Data Profiling and Cleansing Tools (e.g., DataFlux, Trillium, Informatica Data Quality)
• Must be at least 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.

Preferred

• Experience supporting Oracle PDH, Oracle PIM, Oracle ERP, or similar enterprise data platforms.
• Experience operating within a regional or global support model.
• Experience supporting workflow automation, operational reporting, self-service capabilities, or support transformation initiatives.
• Experience supporting Product, Customer, Location, Supplier, or Employee master data domains.