Senior QA Lead - ETL, Data Warehouse & Validation

Agility Partners; Columbus (OH); On-site; USD 95,000 - 125,000; Full time

Job summary

Agility Partners in Columbus, OH is seeking a Lead QA Analyst – ETL & Data Validation to guide testing across enterprise data initiatives. You will lead manual testing of ETL processes in Data Warehouse and Data Lake environments and oversee a small QA team.

The role emphasizes SQL-driven validation, data integrity, and collaboration with developers, analysts, and stakeholders to ensure high-quality data delivery. SQL expertise and hands-on leadership are essential for success.

Qualifications

• Bachelor’s Degree or equivalent combination of education and professional experience.
• 5+ years of QA experience supporting ETL, Data Warehouse, or enterprise data-focused projects.
• Strong manual testing background with experience validating complex data movement processes.
• Experience leading SIT and UAT testing efforts.
• Proven experience leading QA teams, QA standups, or coordinating offshore QA resources.
• Python experience required.
• Strong understanding of ETL processes, data validation, and enterprise data ecosystems.
• Excellent communication, analytical, and troubleshooting skills.

Responsibilities

• Lead QA testing efforts for Data Warehouse, Data Lake, and enterprise data movement initiatives.
• Perform hands-on manual testing of ETL processes, backend systems, and data integrations.
• Develop and execute test strategies, test plans, test cases, and testing documentation.
• Lead System Integration Testing (SIT) and User Acceptance Testing (UAT) activities.
• Validate source-to-target data mappings, data transformations, and data reconciliation processes.
• Analyze and validate large-scale datasets containing millions of records.
• Identify, troubleshoot, and document defects related to data quality, data integrity, and data movement.
• Partner closely with developers, business analysts, and project stakeholders to ensure high-quality data delivery.
• Lead QA standups and coordinate testing efforts for a team of 2-3 QA analysts, including offshore resources when applicable.
• Utilize Azure DevOps (ADO) or similar testing platforms for test management and execution.

Skills

ETL testing

Data validation

SQL

Python

QA leadership

SIT/UAT

Data Warehouse

Data Lake

Data quality

Communication

Education

Bachelor's Degree

Tools

Azure DevOps

Job description

Agility Partners in Columbus, OH is seeking a Lead QA Analyst – ETL & Data Validation to guide testing across enterprise data initiatives. You will lead manual testing of ETL processes in Data Warehouse and Data Lake environments and oversee a small QA team.

The role emphasizes SQL-driven validation, data integrity, and collaboration with developers, analysts, and stakeholders to ensure high-quality data delivery. SQL expertise and hands-on leadership are essential for success.