DescriptionHuntington 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).
