Senior Data Engineer

The Senior Data Engineer in the Architecture, Experience, Digital Platforms and Strategy department within Digital Technology is responsible to design, develop, test, analyze, document, implement, and support the Enterprise Data Platform processes and related infrastructure. The Senior Data Engineer is also responsible for the timely data availability and system up-time through support functions and in-depth testing. The Senior Data Engineer works with business stakeholders to elicit, analyze, communicate, and validate requirements for changes to business processes, policies, and information systems.

 

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.

Essential Functions 

Strategy & Planning

• 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. 
  
   

Execution & Deployment

• 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.
  
   

Operational Management

• 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.

 

Incidental Functions 

• 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.

 

Formal Education & Certification

• Bachelor’s degree (or foreign equivalent) in a Computer Science, Computer Engineering, or Information Technology field of study (e.g., Information Technology, Electronics and Instrumentation Engineering, Computer Systems Management, Mathematics) or equivalent experience.

Knowledge & Experience

• 4+ years of IT experience.
• 4+ years of experience with SQL, (specifically, but not limited to, PostgreSQL, T-SQL, PL/SQL, SNOWSQL).
• 4+ years of experience with building applications, system integrations, and web services. 
• 3+ years of experience with server side scripting and programming in a Linux environment (primarily bash shell)
• 3+ years of experience using data warehouse ETL tools (specifically IICS, Fivetran/HVR, Oracle Data Integrator (ODI))
• Strong understanding of common database (Oracle, Snowflake) technologies including performance, tuning, and optimization.
• Strong data manipulation skills and experience with data warehouse ETL tools and processes.
• Deep expertise of design, planning, management, maintenance, and support of Cloud Technologies such as Azure and Snowflake is required. ASW, GCP preferred but not required.
• Good understanding of Business Intelligence Tools (MicroStrategy, Tableau, BOBJ).
• Advanced knowledge on the support of various component and configuration items.     
• Advanced knowledge in deployment of solutions.

Personal Attributes

• Strong written and oral communications skills.
• Advanced analytical, conceptual, and problem-solving skills.
• Proven ability and initiative to learn and research new concepts, ideas, and technologies quickly.
• Ability to work in a team-oriented, collaborative environment.
• Willingness and ability to assist, train and teach others.
• Ability to translate ideas into a completed solution.
• Lead and influence cross-organizationally..
• Ability to effectively move forward on tasks even with ambiguous or changing requirements.
• Strong commitment to inclusion and diversity. 

This position is not eligible for sponsorship for work authorization now or in the future, including conversion to H-1B visa.

This position is eligible to work in the office three days a week and has the option to work remotely two days a week. 

 

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 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/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.