Data Validation Quality Analyst

TechDigital Group; Minneapolis (MN); On-site; USD 80,000 - 110,000; Full time

Job summary

A leading technology firm in the United States is seeking a Senior Data Validation Quality Analyst to lead quality assurance during a large-scale data migration from SQL Server to Snowflake. The role focuses on ensuring data accuracy and integrity, requiring deep expertise in SQL, data validation, and cloud data platforms. Candidates should also have a strong foundation in data governance. This position offers an opportunity to work collaboratively in defining validation strategies and conducting thorough testing.

Qualifications

• Deep expertise in SQL and data validation.
• Strong foundation in cloud data platforms and testing methodologies.
• Experience with data governance and testing methodologies.

Responsibilities

• Develop and implement end-to-end data validation strategies for SQL migration to Snowflake.
• Design test cases and validation scripts to ensure data accuracy.
• Collaborate with teams to define validation criteria and acceptance thresholds.
• Conduct source-to-target data comparisons using SQL.
• Identify and document data anomalies and transformation issues.
• Ensure adherence to data governance and compliance standards.
• Maintain comprehensive documentation of validation processes.
• Support post-migration audits and contribute to quality improvement.

Skills

SQL

Python

ETL

Data validation

Data governance

Job description

Overview

Skills Used - QA - SQL, Python, ETL Senior Data Validation Quality Analyst to lead quality assurance efforts during a large-scale data migration from on-premises SQL Server to Snowflake. This pivotal role ensures the accuracy, completeness, and integrity of migrated datasets by designing and executing robust validation strategies. The ideal candidate will bring deep expertise in SQL, data validation, and cloud data platforms, along with a strong foundation in data governance and testing methodologies.

Key Responsibilities

• Develop and implement end-to-end data validation strategies for SQL Server to Snowflake migration
• Design test cases, validation scripts, and automation frameworks to ensure data accuracy and consistency.
• Collaborate with data engineers, migration teams, and business stakeholders to define validation criteria and acceptance thresholds.
• Conduct source-to-target data comparisons using SQL and Snowflake queries
• Identify, document, and escalate data anomalies, gaps, and transformation issues.
• Ensure adherence to data governance, privacy, and regulatory compliance standards.
• Maintain comprehensive documentation of validation processes, test results, and issue resolutions.
• Support post-migration audits and contribute to ongoing quality improvement initiatives