Senior Data Engineer

Design, develop, test, analyze, document, implement, and support the Enterprise Data Platform processes and related infrastructure. Acquire and interpret business requirements and create functional specifications and estimates for large efforts. Submit and review process improvements - set direction across the team and share with technical leadership. Assist the team in understanding program direction. Contribute to development across the full software development lifecycle - from requirements gathering through deployment in all aspects of Data Warehousing. Includes ETL, data modeling, analytics, and reporting. Program and resolve features that are large and challenging in scope to create high-value business solutions. Design components for Data Warehouse technologies both on-prem and cloud environments included but not limited to Snowflake, Oracle, ETL, and SQL. Design and meet project requirements. Set direction for the technical aspects of a project. Mitigate risk to deployment of warehouse solutions to the environment. Understand the impact of code that is introduced into the environment and the impact that it can have on the ecosystem. Troubleshoot and support code deployment and resolve code concerns for best practices, security, and code styles. Preempt code deficiencies. Assist and lead other team members to learn to recognize, troubleshoot, and eliminate "at risk" code. Support Agile methodologies by participating in the development of team norms, support agile methodologies, and participate within the Agile community. Share Agile best practices with the program. Lead the creation and implementation of high impact internal team process improvement initiatives. Coordinate and run meetings to understand requirements for defects, enhancements, and large size project efforts. Assist team members in understanding efforts needed to complete tasks. Provide direction on solving complex activities. Develop new technology solutions, create POC's, and be able to document and share solutions designed. Provide guidance and leadership to the team in understanding solutions. Work with others to set and provide direction for capabilities, build consensus. Participate in training and mentoring other team members. Create and deliver presentations for the team. Participate in hiring activities by assisting with interviewing while keeping affirmative action and equal opportunity policy at forefront. Assess the efficiency of intricate code and evaluate the analysis and weaknesses in the design. Provide guidance to team members on implementing corrective measures to address the issues. Role is hybrid allowing periodic work from home within reasonable commuting distance of the Cleveland, OH office. Multiple openings available.

SALARY : $130,832 per year

LOCATION : The Sherwin-Williams Company, 101 West Prospect Avenue, Cleveland, OH 44115

REQUIREMENTS : Bachelor's degree (or foreign equivalent) in a Computer Science, Computer Engineering, Applied Computer Science or Information Technology field of study and five (5) years of experience as a Data Engineer, Senior Developer, Consultant or related role where required experience gained.

SPECIAL SKILLS : Also requires experience in the following :

Five (5) years of Information Technology;

Five (5) years with SQL, (specifically, but not limited to, PostgreSQL, T-SQL, PL / SQL, SNOWSQL);

Five (5) years with building applications, system integrations, and web services;

Three (3) years with server-side scripting and programming in a Linux environment (primarily bash shell);

Three (3) years using data warehouse ETL tools (specifically Informatica / IDMC, Fivetran / HVR, Oracle Data Integrator (ODI));

Three (3) years using enterprise scheduling tools (specifically BMC Control-M, Autosys, Crontab);

Common database (Oracle, Snowflake) technologies including performance, tuning, and optimization;

Data manipulation with data warehouse ETL tools and processes;

Design, planning, management, maintenance, and support of Cloud Technologies such as Azure and Snowflake;

Business Intelligence Tools (MicroStrategy, Tableau, BOBJ);

Support of various component and configuration items such as Informatica IDMC ETL Job Configuration, COA Analytics reporting, Data Quality Rules in Informatica / Snowflake;

Deployment of solutions such as Informatica IDMC / Snowflake code deployment using GITHUB CI / CD.

CONTACT : To apply visit : https : / / careers.sherwin-williams.com

#LI-DNP, #NP, #DNP-LI