QA Test Automation Lead, Data Warehouse

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.
• Create 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 Project Managers/Scrum Masters to drive project teams towards defect resolution.
• Leverage existing tools/techniques to streamline and automate wherever possible.
• Participate in walk-through, inspection, review, and user group meetings for quality assurance.
• 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 be accountable for validating system quality.

Qualifications

• 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+ years of experience leading QA Analysts on a project team