QA Data Validation Engineer: SQL to Snowflake & Power BI

Fractal; Seattle (WA); On-site; USD 115,000 - 145,000; Full time

Job summary

Fractal is seeking a QA Data Validation Engineer to lead validation of the CRDM migration from SQL Server to Snowflake, ensuring production-ready data and BI reporting. You will design and execute validation strategies, conduct source-to-target comparisons, and validate dashboards and semantic models.

You will also build Python-based automated validation frameworks, coordinate with Data Engineers, BIAs, and SMEs, and help drive UAT and sign-off for complex migrations.

Qualifications

• Strong experience with data warehouse 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 desirable.
• Experience with test planning, regression testing, UAT, defect management, and Azure DevOps.
• Snowflake Cortex and Snowflake AI Migration experience preferred.

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, and filters.
• 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.

Skills

Data migrations

SQL Server

Snowflake

Python

Power BI validation

Azure DevOps

ETL testing

UAT coordination

Tools

SQL Server

Snowflake

Power BI

SSAS

Azure DevOps

Job description

Fractal is seeking a QA Data Validation Engineer to lead validation of the CRDM migration from SQL Server to Snowflake, ensuring production-ready data and BI reporting. You will design and execute validation strategies, conduct source-to-target comparisons, and validate dashboards and semantic models.

You will also build Python-based automated validation frameworks, coordinate with Data Engineers, BIAs, and SMEs, and help drive UAT and sign-off for complex migrations.