Data Warehouse QA Lead: Automation & Data Integrity

Heitmeyer Consulting

Columbus (OH)

On-site

USD 90,000 - 120,000

Full time

42 hours ago

Be an early applicant

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

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.