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. Welcome to Huntington! At Huntington, we look out for people. From reinventing banking with game-changing innovations to building an internal culture that creates lifelong bonds, together, we can make people’s lives better. And amazing things happen when we look out for each other. We prove it every day. Whether it’s helping a colleague or collaborating on a new tool that will revolutionize the way people save money, our actions can have a huge impact. Our colleagues look out for people with a Can-Do Attitude, Service Heart and Forward Thinking. Those are our values—simple but powerful. Each of them pushes us do the right thing, to do right by people. Because people are what matter. If that sounds like you, we hope you’ll apply to join our team. If you’d like to learn more about how Huntington looks out for people, visit We endeavor to make this site accessible to any and all users. If you would like to contact us regarding the accessibility of this site or if you require a reasonable accommodation to apply for a job or to perform the essential functions of the job, please send an email to View email address on click.appcast.io Reasonable Accommodations Reasonable Accommodations Various methods will be used throughout the recruitment process to verify candidate authenticity. Any interviews conducted virtually must be joined from a distraction-free environment, with the candidate on camera and without the use of virtual backgrounds. EEOC Disclaimer Know Your Rights CA Data Privacy CA Data Privacy Rights Tobacco Disclaimer Tobacco-Free Hiring Practice 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.