QA Data Validation Engineer – CRDM Migration

Role                       : QA Data Validation Engineer – CRDM Migration

Location               : Seattle WA

Role Overview

We are looking for a QA Data Validation Engineer to support the CRDM migration from on-premises SQL Server to Snowflake. This role will focus on data quality, migration validation, reconciliation, BI/report testing, and validation automation. This person will be working with our main QA resource that is already a part of the team.

The resource will work closely with our other QA person, Data Engineers, BIAs, and business SMEs to ensure data and analytics remain complete and accurate throughout the migration and EDW-to-EDP repointing effort.

Key Responsibilities

• Co-develop and execute validation strategies for the SQL Server-to-Snowflake migration.
• Validate tables, views, transformations, stored procedures, historical data, and incremental loads.
• Perform source-to-target reconciliation using row counts, aggregates, checksums, null/duplicate analysis, and detailed data comparisons.
• Build and maintain Python-based automated data validation frameworks for repeatable, scalable testing.
• Validate Power BI semantic models and reports, including measures, calculations, filters, and business results.
• Validate CRDM dependencies being repointed from on-premises EDW sources to EDP/Snowflake.
• Develop test cases, document results, manage defects, perform regression testing, and support UAT and signoff.
• Partner with Data Engineering and BIAs to investigate discrepancies and ensure migration readiness.

Desired Skills & Experience

• Strong experience with data warehouse/analytics migrations, data quality, ETL testing, and source-to-target validation.
• Strong SQL skills with hands-on SQL Server and Snowflake experience.
• Strong Python experience building automated data validation and reconciliation frameworks.
• Experience testing large datasets, complex transformations, ETL/ELT pipelines, and dimensional data models.
• Experience validating Power BI reports and semantic models; SSAS experience is desirable.
• Experience with test planning, regression testing, UAT, defect management, and Azure DevOps.
• Experience with Snowflake Cortex; Snowflake AI Migration (AIM) experience preferred.

Ideal Candidate

A technically strong Data QA Engineer who combines QA discipline with hands-on Snowflake, SQL, Python, and BI testing experience. The ideal candidate can independently validate complex data migrations at scale, automate reconciliation, identify root causes of discrepancies, and provide clear evidence that migrated data and reporting are production-ready.