Data QA

Team

QA Data Engineering Team

Role Summary

The Senior QA Data Engineer is a strong individual contributor responsible for the most complex test design and validation work on the team. This role authors detailed test plans and test cases for new transformations and ingestion processes, executes advanced data validation across base tables and tabular cubes, and leads root cause analysis on high-impact failures. The Senior QA Engineer contributes meaningfully to the team's Python/Databricks automation assets.

Key Responsibilities

• Create comprehensive test plans and test cases for new transformations and ingestion processes, working from minimal business-supplied input.
• Execute advanced data validation: verify code correctness against base tables, confirm key fields contain the correct data, and reconcile system outputs against business and vendor expectations (e.g., sales figures, account roles).
• Write complex SQL and Python validation scripts to compare data warehouse sources against tabular cube outputs, including completeness, sum totals, null percentages, and key-field checks.
• Author DAX queries against tabular cubes to extract data for comparison against the Azure Data Warehouse source.
• Lead testing for new transformations and migrations across Snowflake and Databricks, assess impact on downstream cubes and reports.
• Conduct root cause analysis on data quality incidents; document findings, impact, and remediation, and partner with development teams on resolution.
• Contribute to and extend the team's automated test scripts and frameworks under the Technical Lead's direction.
• Use Jira to receive assignments and notifications, kick off test plans, and track results.
• Mentor QA Engineers/Testers on SQL, Python, validation techniques, and test planning.

Required Skills & Experience

• 5-7 years of QA experience with at least 3 years focused on data warehouse, ETL/ELT, or pipeline testing.
• 5-7 years of hands-on testing experience on Snowflake and Databricks (notebooks, SQL, basic PySpark).
• 5-7 years of strong Python skills for writing validation scripts, iterating across columns/tables, and producing automated comparison reports.
• 5-7 years of advanced SQL skills, including complex joins, aggregations, window functions, and reconciliation patterns.
• 5-7 years of demonstrated ability to write detailed test plans and test cases independently.
• 5-7 years of experience performing root cause analysis on data issues and producing structured RCA documentation.
• 5-7 years of experience working in Jira-driven QA workflows.
• Strong communication skills; comfortable working directly with business stakeholders to clarify requirements.

Secondary / Nice to Have

• Experience with Azure Synapse / Azure Data Warehouse.
• DAX query authoring against tabular cubes (SSAS Tabular / Azure Analysis Services / Power BI).
• Exposure to AI workflows or AI-assisted automation for test case generation or data validation.
• Experience with synthetic and controlled test data generation.

Pay

The starting pay range for this role is $60/Hr to $70/Hr. Actual compensation will depend on a number of factors, including the candidate's relevant experience, technical skills, and other qualifications.

Benefits

• Medical, dental, and vision insurance
• Flexible spending or health savings account
• AD&D insurance
• Employee assistance
• Participation in a 401k program
• Additional voluntary or legally-required benefits