live chat
Lead Data Engineer II Job in Cleveland, Ohio US

Job Summary

The Sherwin-Williams Company
Cleveland, OH
Government and Military
Job Type
Full Time
Years of Experience
7+ to 10 Years
Job Reference Code

Lead Data Engineer II

About the Job

Founded in 1866, The Sherwin-Williams Company is a global leader in the manufacture, development, distribution, and sale of paints, coatings and related products to professional, industrial, commercial, and retail customers. The company manufactures products under well-known brands such as Sherwin-Williams, Valspar, HGTV HOME by Sherwin-Williams, Dutch Boy, Krylon, Minwax, Thompson's Water Seal, Cabot and many more. Sherwin-Williams branded products are sold exclusively through a chain of more than 4,100 company-operated stores and facilities, while the company's other brands are sold through leading mass merchandisers, home centers, independent paint dealers, hardware stores, automotive retailers, and industrial distributors. The company supplies a broad range of highly-engineered industrial and OEM coatings for wood and general industrial, coil, packaging, protective and marine, and transportation applications worldwide. Our 60,000 employees are diverse, innovative and passionate. With a variety of rewarding and challenging opportunities, Sherwin-Williams is a great place to find a career that takes you places.

The Lead Data Engineer is responsible for leading a team of developers uncover enterprise insights and drive business results using smarter data analytics via the Cloud. This is a hands-on technical role and you will play an integral role in building knowledge within the team and be part of strategic cloud data initiatives for organizational and process improvements. Influence strategies and engineering capabilities for modern Data & Analytics platform.

Essential Functions
Strategy & Planning

Full life cycle experience (requirements gathering through production deployment) in all aspects of BI, modern data warehousing, ETL, data modeling and analytics
Ensures critical Data Warehouse and BI systems remain stable while continually evolving to meet ever-changing business needs.
Effectively identify, manage and mitigate project risks and issues
Work with the extended team to support recruitment of new developers/contractors into the team
Seek out and apply new technologies and skills for ETL improvement in daily work through conferences, online training, reading, participation in organizations and user groups, etc.
Translate business needs into technical and system design specifications
Build and promote a positive working environment.

Execution & Deployment

Design and develop or modify ETL processes that load data for the data warehouse using ETL tools (Oracle ODI) and PL/SQL
Maintain existing ETL Oracle PL/SQL procedures, packages, and Unix scripts
Provide ETL performance tuning
Troubleshoot and resolve production issues under tight deadlines
Conduct ETL design reviews with the Data Architects and DBAs
Maintain clean and stable dev, qa, and test environments.
Further refine and ensure adherence to standards for development, code migration, version control, and all policies and procedures.
Drive change to implement efficient and effective development methodologies as advised by management.
Oversee the technologies, tools and techniques used within the team.
Actively contribute to the process of continual improvement for self, the team and the data warehouse environment.

Operational Management

Primary responsibility for the support of the Best of Breed data loads.
Execute project plans to successfully meet objectives.
Conduct staffing and resource management activities.
Train and integrate new team members and proactively support the continued development of existing team members.
Understand individual team member strengths and opportunities for improvement in order to provide clear tasks and objectives to improve performance.
Lead and work on installations, configurations, upgrades & administration of the current and future technology stack.
Ensure 24/7 availability of existing data loads with the assistance of remote developers within the team.
Continue to improve team's knowledge on new ETL tools.
Plan for maintenance support windows and assign validation steps to the team accordingly.
Identify and address performance, capacity, and data replication issues; bring recommendations to management.

Incidental Functions

Ability to manage time effectively and have awareness of various time zones.
Able to work well under pressure, flexible, positive & focused during times of change.
Able to solve complex problems, participates in continuous improvement, adapts the ideas of others.
Demonstrates a proactive approach, getting things done, demonstrates accountability & ownership, prioritizes own workload.
Demonstrates intellectual rigor, possesses relevant abilities and is able to pick up new skills quickly.
Attend meetings on behalf of the team.
Make presentations to management, internal and external clients, and peer groups as requested.
Train and share knowledge with the team.
Assist with Lean projects as may be required to contribute to the efficiency and effectiveness of the team.
Participate in hiring activities and fulfilling affirmative action obligations and ensuring compliance with the equal employee opportunity policy.
Minor travel may be required (domestic and international).
Work hours outside the standard office 7.5 hour work day may be required.

Position Requirements
Formal Education & Certification

Bachelor degree or foreign equivalent in a related field or equivalent experience.

Knowledge & Experience

10+ years IT experience
10+ years experience as a data engineer or related specialty (software engineer/developer, business intelligence developer, data science engineer, database administrator) with a track record of manipulating, processing, and extracting value from large datasets.
5+ years of experience in scripting and optimizing advanced Oracle SQL & PL/SQL.
5+ years of experience with an ETL or ELT tool for data extraction, transformation and loading using one or more of the following: Informatica Power Center, Oracle Data Integrator (ODI), Azure Data Factory or a similar set of tools.
Experience with manipulating, processing, and extracting value from large datasets.
Well versed with dimensional data modeling and the construction of ETL routines in a data warehouse environment.
Strong experience with UNIX/Linux scripts.
Experience with one or more of the following BI tools: Business Objects, Tableau, Oracle BI.
Proficiency in at least one of the following languages: Python, R, Scala.
Familiarity with Cloud data solutions, architecture and their interdependencies for BI use.
Experience with Microsoft Azure & Snowflake DW is a plus.
Experience with Oracle E-Business Suite is a plus.
Hands-on experience building data sources for Tableau is a plus.

Preferred Qualifications

Expertise in building, managing and migrating SaaS/PaaS enterprise applications on Cloud native applications(AWS/GCP/AZURE) at large scale; Azure is the preferred platform.
Understanding of Star schema data warehouse modeling using the Kimball Methodology.
Experience in statistical, predictive modelling and machine learning techniques
Experience developing Oracle Application Express (APEX) applications.
Hands-on experience building data sources for Tableau is a plus.

Personal Attributes

Strong written and oral communications skills.
Proven ability and initiative to learn and research new concepts, ideas, and technologies quickly.
Strong systems/process orientation with demonstrated analytical thinking, organization skills and problem solving skills.
Ability to work in a team-oriented, collaborative environment.
Ability to train and teach others.
Ability to facilitate meetings and follow up with resulting action items.
Ability to prioritize and execute tasks in a high-pressure environment.
Strong presentation and interpersonal skills.
Ability to work effectively in a multi-cultural environment, and to lead and influence cross-organizationally with and without direct authority.

Must be legally authorized to work in country of employment without sponsorship for employment visa status now or in the future.

Equal Opportunity Employer. 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, citizenship status, marital status, or any other consideration prohibited by law or contract.VEVRAA Federal Contractor requesting priority referral of protected veterans.Primary Location: United States-Ohio-CLEVELAND
Work Locations: US OH Cleveland Headquarters
101 West Prospect Ave 
 Cleveland 44115

Sherwin-Williams is proud to be an Affirmative Action, Equal Employment Opportunity, Inclusion and Diversity Supportive Employer. All qualified candidates will receive consideration for employment and will not be discriminated against based on race, color, religion, sex, sexual orientation, gender identify, national origin, protected veteran status, disability, age, pregnancy, genetic information, creed, marital status or any other consideration prohibited by law or by contract.

VEVRAA Federal Contractor requesting priority referral of protected veterans.

Job Tools

  • Save
  • Share
  • Report this job