Lead ETL Developer

DESCRIPTION

Huntington Bank’s Enterprise Data Warehouse team is looking for a Lead ETL (Extract, Transform, Load) Developer. This role will be required to learn and model using a variety of different ETL tools and databases. Will be required to develop, maintain and enhance code for new projects and current bank deliverables, ensure all IT SDLC processes are documented and practiced, work closely with the Enterprise Information team, and cross-impact other bank applications as code and processes change. The role may also assist other Enterprise Information Management programmers across different technology stacks. If you consider data as a strategic asset and have a passion for learning and continuous improvement, this role is for you. Key Responsibilities

• Translate requirements and data mapping documents to technical design.
• Develop, enhance, and maintain code following best practices and standards.
• Create and execute unit test plans. Support regression and system testing

efforts.

• Debug and problem solve issues found during testing and/or production.
• Communicate status, issues, and blockers with the project team.
• Support continuous improvement by identifying and solving opportunities.

Basic Qualifications

• Bachelor’s degree
• A minimum of 5 years of experience in ETL development (Datastage and

PySpark,). * A minimum of 5 years of experience writing SQL queries and troubleshooting. Preferred Qualifications

• Star Schema design and coding (Dimension and Fact Table design)
• Understanding of enterprise data warehousing best practices and standards.
• Good communication and interpersonal skills.
• Good organization skills and the ability to work independently as well as

with a team.

• Experience in financial services (banking) industry.
• Experience in Datastage.
• Experience with AWS Cloud technologies and/or Snowflake.
• Experience in Agile processes.
• Experience leading development teams.

Exempt Status: (Yes = not eligible for overtime pay) (No = eligible for overtime pay) Yes Workplace Type: Office Our Approach to Office Workplace Type Certain positions outside our branch network may be eligible for a flexible work arrangement. We’re combining the best of both worlds: in-office and work from home. Our approach enables our teams to deepen connections, maintain a strong community, and do their best work. Remote roles will also have the opportunity to come together in our offices for moments that matter. Specific work arrangements will be provided by the hiring team. Compensation Range: 70,000.00 - 140,000.00 Annual Salary The compensation range represents the anticipated low and high end of the base compensation range for this position. Actual compensation will vary based on various factors including but not limited to location, experience, and education.  Colleagues in this position are also eligible to participate in an applicable incentive compensation plan.  In addition, Huntington provides a variety of benefits to colleagues, including health insurance coverage, wellness program, life and disability insurance, retirement savings plan, paid leave programs, paid holidays and paid time off (PTO). Huntington is an Equal Opportunity Employer. Tobacco-Free Hiring Practice: Visit Huntington's Career Web Site for more details. Note to Agency Recruiters: Huntington will not pay a fee for any placement resulting from the receipt of an unsolicited resume. All unsolicited resumes sent to any Huntington colleagues, directly or indirectly, will be considered Huntington property. Recruiting agencies must have a valid, written and fully executed Master Service Agreement and Statement of Work for consideration.