Lead ETL Developer, Data Warehouse

Huntington - Easton, OH

Full-time - Mid Level

Hybrid - Easton, OH

Repair and Maintenance

About the position

Huntington Bank is seeking a Lead ETL Developer for its Enterprise Data Warehouse (EDW) team. This role focuses on ensuring data quality across the enterprise and involves building data integrity controls to support critical business processes. The Lead ETL Developer will lead teams in developing, maintaining, and enhancing code while ensuring adherence to IT SDLC processes. The ideal candidate will have extensive knowledge of data warehousing cloud technologies and a passion for leveraging data as a strategic asset.

Responsibilities

• Translate requirements and data mapping documents to a 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 project team.
• Support continuous improvement by identifying and solving opportunities.

Requirements

• Bachelor's Degree
• 5+ years of experience in ETL development within a Data Warehouse.
• 3+ years leading developers on an Agile development line.

Nice-to-haves

• Deep understanding of enterprise data warehousing best practices and standards.
• Proven experience in cloud projects with hands-on migration expertise on public clouds such as AWS and Azure, preferably Snowflake.
• Strong experience with Python/PySpark, DataStage ETL and SQL development.
• Strong experience in software engineering comprising of designing, developing and operating robust and highly-scalable cloud infrastructure services.
• Experience with data governance and data management approaches, including data quality.
• Experience with building data integrity controls using custom build or vendor packages (Infogix, Data360, etc).
• Knowledge of Cybersecurity organization practices, operations, risk management processes, principles, architectural requirements, engineering and threats and vulnerabilities, including incident response methodologies.
• Understand Authentication & Authorization Services, Identity & Access Management.
• Experience in financial services (banking) industry.