Hybrid QA Test Automation Lead, Data Warehouse

at Huntington National Bank

• Job title: QA Test Automation Lead, Data Warehouse
• Job type: Full Time
• Experience level: Senior
• Salary: $70,000 - $140,000 per year
• Degree requirement: Bachelor's Degree
• Tech skills: AWS, Azure, Cloud, ETL, Selenium, SQL
• Location requirements: Hybrid, Dallas, United States

About the role

• QA Test Automation Lead in Data Warehouse team developing automated testing strategies and frameworks. Collaborating to ensure regulatory alignment across data ingestion and integration projects.

Responsibilities

• Lead quality assurance efforts for multiple concurrent projects focused on data ingestion and integration, ensuring alignment with banking regulatory standards
• Design, implement, and maintain automated testing frameworks and CI/CD pipelines to support scalable and secure data operations
• Develop and execute comprehensive test strategies covering System Integration Testing (SIT) and closely partner with the team for User Acceptance Testing (UAT)
• Collaborate with data engineers, developers, project managers, and compliance teams to ensure data quality, integrity, and traceability throughout the ingestion lifecycle
• Drive continuous improvement in QA processes
• Design and implement a scalable test automation framework and strategy
• Create daily/weekly test execution metrics and status reporting
• Assist the Project Managers/Scrum Masters to drive project team to defect resolution
• Leverage existing tools/techniques to streamline and automate wherever possible
• Actively participate in walk-through, inspection, review and user group meetings for quality assurance
• Actively participate in the review of project requirements, data mappings and technical design specifications
• Analyze data, troubleshoot data issues, and create action plans to address data quality issues
• Collaborate with project team on defect analysis and triage
• Participate in production implementation verification and being accountable for validating system quality

Requirements

• Bachelor’s degree
• 5+ years of ETL testing experience in data warehouse environment
• 3+ years of test automation experience
• 2+ years of experience with Snowflake and AWS
• 2+ Experience leading QA Analysts on a project team
• Experience in financial services (banking) industry
• Strong experience with SQL, ETL testing, and data warehouse concepts (e.g., star/snowflake schema, OLAP)
• Proficiency in test automation tools such as Cucumber, Selenium, PyTest, or DBT tests
• Experience with cloud data platforms (Snowflake, AWS)
• Familiarity with CI/CD tools (Azure DevOps)
• Excellent verbal and written communications skills
• Ability to effectively prioritize and execute tasks
• Detail oriented and highly motivated with strong organizational, analytical and problem-solving skills

Benefits

• health insurance coverage
• wellness program
• life and disability insurance
• retirement savings plan
• paid leave programs
• paid holidays
• paid time off (PTO)