Data Warehouse Automated Testing Lead

Description

Summary:

Huntington Bank is seeking an experienced QA Testing Analyst Lead with deep expertise in ETL testing, data validation, and enterprise data warehouse environments. This role is primarily manual ETL/data testing while we are in the early-stages of automation. You will work across our Data Lake and Data Warehouse platforms using Snowflake, AWS, DataStage, Zena/Zeke, Python, and Azure DevOps, ensuring accurate data movement, transformation, and quality across the entire ingestion lifecycle.

If you’re passionate about data quality, understand how data should move through a warehouse, and have led QA efforts in complex data environments, this role is for you.

Responsibilities:

• Lead QA efforts for data ingestion, ETL pipelines, and data warehouse transformations across staging, integration, and Snowflake environments.
• Perform manual ETL testing, validating source-to-target mappings, transformation logic, lineage, reconciliation, and system balancing controls to ensure data completeness and integrity.
• Execute SQL-based data validation for large datasets and high‑volume batch processes; analyze and troubleshoot data issues and source-to-target mismatches.
• Coordinate UAT activities with business teams, including planning, execution support, and translating technical data issues into clear, business-friendly language.
• Contribute to early automation by building initial automated test cases and identifying repetitive validation scenarios suitable for automation.
• Document test plans, test cases, results, and evidence in Azure DevOps, maintaining accurate source-to-target mapping spreadsheets.
• Provide clear daily/weekly QA status updates and lead defect triage sessions to ensure timely resolution.
• Lead and mentor QA Analysts (onshore/offshore), set QA strategy, manage priorities across projects, and ensure consistent application of QA best practices.

Basic Qualifications:

• Bachelor’s degree
• 5+ years of ETL testing experience in data warehouse environment
• 3+ years of experience with Snowflake and AWS
• 3+ years of experience leading QA Analysts on a project team
•  2+ years of test automation experience

Preferred Qualifications:

• Experience in financial services or banking
• Strong understanding of data warehouse concepts (star/snowflake schema, data lineage, transformations)
• Familiarity with automation tools/frameworks (PyTest, Cucumber, Selenium, DBT tests)
• Experience with Azure DevOps and CI/CD pipelines
• Excellent communication, analytical, and problem‑solving skills

Exempt Status: (Yes = not eligible for overtime pay) (No = eligible for overtime pay)

Workplace Type:

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.

Huntington is an Equal Opportunity Employer.

Tobacco-Free Hiring Practice: Visit Huntington's Career Web Site for more details.

Note to Agency Recruiters:  Huntington Bank will not pay a fee for any placement resulting from the receipt of an unsolicited resume.  All unsolicited resumes sent to any Huntington Bank colleagues, directly or indirectly, will be considered Huntington Bank property. Recruiting agencies must have a valid, written and fully executed Master Service Agreement and Statement of Work for consideration.