Senior Data QA Engineer: ETL/ELT, SQL & Python

Madison-Davis; Charlotte (NC); On-site; USD 110,000 - 160,000; Full time

Job summary

Madison-Davis, LLC is seeking a senior QA Analyst to support a Cyber Data Operations team responsible for enterprise data platforms and analytics dashboards. This highly technical QA position will ensure the accuracy, reliability, and completeness of data moving through complex warehouse and cloud-based environments.

The successful candidate will use SQL and Python-based tools to validate data, automate testing, investigate defects, and verify ETL/ELT transformations from source through target.

Qualifications

• Eight+ years of QA, data testing, ETL/ELT testing, or related
• Hands-on QA experience at senior level
• Advanced SQL for complex validation and troubleshooting
• Hands-on Python for automation, analysis, or data validation
• Strong enterprise data-testing experience
• Experience testing ETL/ELT pipelines and data transformations
• Understanding source-to-target mappings
• Experience testing data warehouses, data lakes, or lakehouse environments
• Experience building and maintaining regression-test coverage
• Functional, integration, system, regression, and UAT testing
• Agile/Scrum teamwork experience
• Ability to work onsite in Charlotte at least three days per week

Responsibilities

• Develop and execute detailed test plans, test cases, and test scripts
• Test enterprise data pipelines, transformations, dashboards, and related data products
• Validate ETL and ELT processing from source through target
• Perform complex data validation and reconciliation using SQL
• Use Python-based tools to automate testing, profiling, and quality checks
• Test data-warehouse, data-lake, lakehouse, and cloud-platform functionality
• Validate record counts, business rules, transformations, nulls, duplicates, and outputs
• Investigate discrepancies and perform root-cause analysis
• Identify, document, report, and track defects through resolution
• Build and maintain reusable automation and regression-test coverage
• Validate REST API behavior and resulting data
• Maintain traceability between requirements, test cases, defects, and final validation
• Perform functional, integration, regression, system, and UAT testing
• Partner with engineers, developers, and stakeholders in an Agile/Scrum environment

Skills

QA testing

Data validation

ETL/ELT testing

SQL

Python

Root-cause analysis

Agile/Scrum

Communication

Tools

SQL

Python

Databricks

Spark SQL

PySpark

Pandas

Postman

Job description

Madison-Davis, LLC is seeking a senior QA Analyst to support a Cyber Data Operations team responsible for enterprise data platforms and analytics dashboards. This highly technical QA position will ensure the accuracy, reliability, and completeness of data moving through complex warehouse and cloud-based environments.

The successful candidate will use SQL and Python-based tools to validate data, automate testing, investigate defects, and verify ETL/ELT transformations from source through target.