Data Warehouse QA Lead

Heitmeyer Consulting; Columbus (OH); On-site; USD 90,000 - 120,000; Full time

Job summary

Heitmeyer Consulting is seeking a hands-on Data Warehouse QA Lead in Columbus, OH to own QA testing of data pipelines, ETL validation, and test automation for Enterprise Data Warehouse and Data Lake initiatives.

The ideal candidate has deep experience in ETL testing, SQL, Snowflake, AWS, Python, data validation, and QA leadership, coordinating testing across Agile teams and driving automation to improve quality and speed.

Qualifications

• Bachelor's degree or equivalent experience.
• ETL testing experience in Data Warehouse or Data Lake.
• Experience with SQL, Snowflake, AWS and Python.
• QA Lead experience coordinating testing activities and hands-on test automation.
• Experience with source-to-target validation, data reconciliation, and data quality testing.
• Strong Excel skills, including formulas, pivot tables, and macros.
• Experience working in Agile teams.

Responsibilities

• Lead QA activities across Data Warehouse and Data Lake projects.
• Create test strategies, test plans, and testing status reporting.
• Coordinate testing efforts across QA resources and project teams.
• Execute and oversee ETL, data integration, system integration, regression, and UAT testing.
• Perform source-to-target validation, data reconciliation, and data quality testing.
• Analyze and troubleshoot data issues using SQL.
• Validate data mappings, transformation logic, and business requirements.
• Support and expand test automation solutions.
• Utilize Excel, including formulas, pivot tables, and macros, for data comparison and validation.
• Identify opportunities to streamline testing processes, documentation, and reporting.

Skills

QA Lead

ETL Testing

SQL

Snowflake

AWS

Python

Data Validation

Test Automation

Agile

Education

Bachelor's degree

Tools

DataStage

Informatica

AWS Glue

PyTest

Selenium

DBT

Azure DevOps

CI/CD

Job description

Heitmeyer Consulting is currently looking for a Data Warehouse QA Lead in Columbus, OH. The person needs to live in the Columbus, OH area. No C2C or agencies.

Hands-on QA Test Automation Lead to support Enterprise Data Warehouse and Data Lake initiatives. This role combines QA leadership, ETL testing, SQL-based data validation, and test automation. The ideal candidate has deep experience testing data pipelines and integrations, leading QA efforts, and driving process improvements through automation and innovation. This is primarily a Data Warehouse QA role, not a traditional UAT, Salesforce, or application testing position. Candidates should demonstrate strong ETL testing, SQL, Snowflake, AWS, Python, and data validation experience, along with prior QA leadership and test automation experience.

Key Responsibilities

• Lead QA activities across Data Warehouse and Data Lake projects.
• Create test strategies, test plans, and testing status reporting.
• Coordinate testing efforts across QA resources and project teams.
• Execute and oversee ETL, data integration, system integration, regression, and UAT testing.
• Perform source-to-target validation, data reconciliation, and data quality testing.
• Analyze and troubleshoot data issues using SQL.
• Validate data mappings, transformation logic, and business requirements.
• Support and expand test automation solutions.
• Utilize Excel, including formulas, pivot tables, and macros, for data comparison and validation.
• Identify opportunities to streamline testing processes, documentation, and reporting.

Basic Qualifications

• Bachelor's degree or equivalent experience.
• ETL testing experience in a Data Warehouse or Data Lake environment.
• Experience with SQL, Snowflake, AWS and Python.
• QA Lead experience coordinating testing activities, and hands-on test automation experience.
• Experience with source-to-target validation, data reconciliation, and data quality testing.
• Strong Excel skills, including formulas, pivot tables, and macros.
• Experience working in Agile teams.

Preferred Qualifications

• Banking or financial services experience.
• Experience with DataStage, Informatica, AWS Glue, or similar ETL tools.
• Designing, implementing, or expanding automated testing frameworks.
• Establishing a test automation suite for a team or application.
• Experience with PyTest, Selenium, DBT tests, or similar automation tools.
• Experience with Azure DevOps and CI/CD processes.
• Knowledge of data warehouse concepts, including star schemas, fact tables, dimension tables, and data lineage.
• Demonstrated ability to improve processes, documentation, and team efficiency.

Heitmeyer Consulting is an equal opportunity employer, and we encourage all qualified candidates to apply. Qualified applicants will be considered without regard to minority status, gender, disability, veteran status, or any other characteristic protected by law.