Lead Data Engineer
Apply NowCompany: Sherwin-Williams
Location: Cleveland, OH 44130
Description:
Job Description
ABOUT THE ROLE:
The Lead Data Engineer is responsible for leading in the designing, building, and maintaining of the systems and infrastructure that enable organizations to collect, store, process, and analyze large volumes of data. This role involves collaborating closely with data scientists, analysts, QA engineers, business process / functional SMEs, and other stakeholders to ensure that data is accessible, reliable, and secure. They are responsible for tasks such as data ingestion, data transformation, data integration, and data pipeline development. Lead Data Engineers also play a crucial part in data governance, ensuring that data is compliant with regulations and policies. This role also includes all aspects of software development and deployment of IT Operations to shorten delivery and time to market for data products and data pipelines and data warehousing. Overall, the incumbent helps organizations leverage their data to gain meaningful insights and make informed decisions
Responsibilities
WHAT THE ROLE WILL DO:
This position is not eligible for sponsorship for work authorization now or in the future, including conversion to H1-B visa.
This position offers a hybrid work schedule with 3 days in the office with the option of working two days remote. Relocation assistance is offered.
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
Travel: Up to 5%
Qualifications
WHAT THE INCUMBENT WILL NEED:
Required Knowledge and Experience
Required Technical Skills
Preferred Knowledge and Experience
About Us
At Sherwin-Williams, our purpose is to inspire and improve the world by coloring and protecting what matters. Our paints, coatings and innovative solutions make the places and spaces in our world brighter and stronger. Your skills, talent and passion make it possible to live this purpose, and for customers and our business to achieve great results. Sherwin-Williams is a place that takes its stability, growth and momentum and translates it to possibility for our people. Our people are behind the strength of our success, and we invest and support you in:
Life ... with rewards, benefits and the flexibility to enhance your health and well-being
Career ... with opportunities to learn, develop new skills and grow your contribution
Connection ... with an inclusive team and commitment to our own and broader communities
It's all here for you... let's Create Your Possible
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 http://www.myswbenefits.com/. 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 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, 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.
ABOUT THE ROLE:
The Lead Data Engineer is responsible for leading in the designing, building, and maintaining of the systems and infrastructure that enable organizations to collect, store, process, and analyze large volumes of data. This role involves collaborating closely with data scientists, analysts, QA engineers, business process / functional SMEs, and other stakeholders to ensure that data is accessible, reliable, and secure. They are responsible for tasks such as data ingestion, data transformation, data integration, and data pipeline development. Lead Data Engineers also play a crucial part in data governance, ensuring that data is compliant with regulations and policies. This role also includes all aspects of software development and deployment of IT Operations to shorten delivery and time to market for data products and data pipelines and data warehousing. Overall, the incumbent helps organizations leverage their data to gain meaningful insights and make informed decisions
Responsibilities
WHAT THE ROLE WILL DO:
- Lead and manage a team of data engineers, providing technical guidance, mentorship, and support
- Act as a Subject Matter expert for clients and stakeholders, providing updates and addressing any data related technical inquiries or concerns
- Oversee and drive the design, development, and maintenance of efficient and robust data pipelines, ETL processes, and data workflows
- Manage the development and maintenance of data models and schema designs to support data storage and retrieval needs
- Optimize data storage, processing, and retrieval mechanisms for performance and scalability
- Provide technical leadership and guidance in the selection and implementation of data engineering tools and technologies
- Identify and implement best practices and standards for data engineering processes and tools
- Stay up-to-date with emerging technologies and trends in data engineering, evaluating their potential impact on our data infrastructure
- Lead the Collaboration with cross-functional teams to integrate data sources and enable seamless data flow across systems and with data scientists, analysts, and stakeholders to understand data requirements and develop scalable data solutions
- Lead the implementation and maintenance of data governance and security measures to protect sensitive information and to ensure data quality and integrity by implementing effective data validation and cleansing techniques
This position is not eligible for sponsorship for work authorization now or in the future, including conversion to H1-B visa.
This position offers a hybrid work schedule with 3 days in the office with the option of working two days remote. Relocation assistance is offered.
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
Travel: Up to 5%
Qualifications
WHAT THE INCUMBENT WILL NEED:
- Education
- Required
- Bachelor's degree in Computer Science, Computer Engineering, or Information Technology or in lieu of a degree, at least 9 years of experience in data engineering.
- Required
Required Knowledge and Experience
- 6-8+ years of data engineering experience.
- 4-6+ years of experience with SQL including, but not limited to: PostgreSQL, T-SQL, PL/SQL, SNOWSQL
- 4-6+ years of experience with building applications, system integrations, and web services
- 4-6+ years of experience with server-side scripting and programming in a Linux environment (primarily bash shell)
- Experience with common database (Oracle, Snowflake) technologies including performance, tuning, and optimization.
- Experience with data manipulation and on-prem and cloud-based data warehouse ETL tools and processes
- Experience with business processes such as OTC, P2P,PIM to understand context of data usage
Required Technical Skills
- Domain architecture
- Data security
- Automated testing tools
- Version control tools
- Data modeling
Preferred Knowledge and Experience
- 4-6+ years of hands-on experience in implementation of Oracle ERP modules with focus on core HR, payroll, and benefits.
- Experience in multiple phases of implementations - right from business blueprint, gap analysis to customizations, go live and post go live support maintenance and operator training.
- 6-8+ years of data engineering experience with ETL tools like ODI, IDMC.
About Us
At Sherwin-Williams, our purpose is to inspire and improve the world by coloring and protecting what matters. Our paints, coatings and innovative solutions make the places and spaces in our world brighter and stronger. Your skills, talent and passion make it possible to live this purpose, and for customers and our business to achieve great results. Sherwin-Williams is a place that takes its stability, growth and momentum and translates it to possibility for our people. Our people are behind the strength of our success, and we invest and support you in:
Life ... with rewards, benefits and the flexibility to enhance your health and well-being
Career ... with opportunities to learn, develop new skills and grow your contribution
Connection ... with an inclusive team and commitment to our own and broader communities
It's all here for you... let's Create Your Possible
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 http://www.myswbenefits.com/. 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 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, 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.