Data Migration Test Analyst

Job Title: Data Migration Test Analyst - Snowflake SQL Azure

Location: Seattle, WA (Hybrid - Local Candidates Only)

Important: This is not a traditional QA Automation, Manual QA, Selenium, Cypress, Playwright, SDET, or Web Application Testing position.

We are looking for professionals with hands-on experience in Data Migration Testing, Data Warehouse Testing, ETL/ELT Validation, SQL Data Validation, Snowflake, and Source-to-Target Data Reconciliation. Candidates whose experience is primarily focused on UI testing, test automation frameworks, functional QA, mobile testing, or general application testing are unlikely to be a good fit for this role.

Local candidates in the Greater Seattle area who can work in a hybrid onsite environment are strongly encouraged to apply.

Position Overview

Join a large-scale enterprise data modernization program supporting the migration of critical business data into Snowflake within a Microsoft Azure environment. This role focuses on validating enterprise data migrations by ensuring data accuracy, completeness, integrity, transformation, and reconciliation between legacy systems and the target Snowflake platform.

This opportunity is best suited for professionals with experience in:

• Enterprise Data Migration Testing

• Data Warehouse Testing

• ETL/ELT Validation

• Data Quality Testing

• SQL Data Validation

• Source-to-Target Mapping and Reconciliation

• Snowflake Migration Projects

Required Qualifications

• 5+ years of experience in Data Migration, Data Warehouse, ETL, or Data Quality Testing.

• Strong experience validating enterprise data migration initiatives.

• Hands-on experience with Source-to-Target Data Validation and Reconciliation.

• Advanced SQL skills for data validation and analysis.

• Experience testing ETL/ELT pipelines and data transformations.

• Hands-on experience with Snowflake.

• Experience working within Microsoft Azure data environments.

• Experience validating APIs and data integrations.

• Experience creating test strategies, test plans, and test documentation.

• Experience validating large datasets and enterprise reporting.

• Familiarity with Azure DevOps, Jira, or similar test management tools.

Key Responsibilities

• Validate enterprise data migrations from legacy platforms into Snowflake.

• Perform source-to-target reconciliation across large datasets.

• Validate ETL/ELT pipelines, transformation logic, and business rules.

• Develop SQL queries for data validation and reconciliation.

• Investigate data quality issues, anomalies, and transformation defects.

• Execute functional, integration, regression, and user acceptance testing for migration initiatives.

• Validate reports, dashboards, and analytics following data migration.

• Collaborate with Data Engineers, Data Architects, Business Analysts, and Product Owners to resolve data quality issues.

• Document testing results, defects, root cause analysis, and validation evidence.

Preferred Qualifications

Experience with the following technologies is highly desirable:

• Alteryx Designer or Alteryx Server

• Automated Data Validation and Reconciliation

• QuerySurge or similar data comparison tools

• Snowflake migration projects

• Azure Data Factory

• Data Profiling and Data Quality Monitoring tools

• Power BI dataset validation

• Python scripting for data validation and testing automation

Preferred Industry Experience

Candidates with experience in the following industries will be given preference:

• Banking

• Financial Services

• Credit Union

• Lending

• Wealth Management