Remote Senior Snowflake Data Migration & Quality Engineer

ZealHire Inc.; Northern (KY); Hybrid; USD 120,000 - 180,000; Full time

Job summary

ZealHire Inc. is seeking a Senior Data Quality & Snowflake Migration Engineer for remote work. The role centers on data migration into Snowflake with strong SQL, Python, and data quality discipline.

You will profile, validate, transform, reconcile, and migrate data from legacy systems into Snowflake while ensuring data integrity across the lifecycle. You will design quality controls, develop ETL/ELT processes, and collaborate with data engineers, architects, and stakeholders to meet acceptance

Qualifications

• Experience with Snowflake and Advanced SQL in data migration projects.
• Proven ability to implement data quality controls across migration lifecycles.
• Hands-on experience with data profiling, validation, mapping, and reconciliation.

Responsibilities

• Design and implement data quality controls for large-scale data migrations into Snowflake.
• Perform source data profiling and analysis to identify data quality issues.
• Define pre- and post-migration validation controls.
• Develop SQL-based data quality rules, validation queries, and reports.
• Perform source-to-target mapping, field mapping, and transformation analysis.
• Develop Snowflake SQL and ETL/ELT processes for cleansing, transformation, migration.
• Implement data reconciliation controls to validate counts and accuracy.
• Identify migration defects and coordinate remediation.
• Create data validation solutions using SQL and Python.
• Build Snowflake views, extracts, dashboards, and reports for migration monitoring.
• Support migration testing, UAT, cutover, and post-migration validation.

Skills

Snowflake SQL

Data Quality

Source-to-Target

ETL/ELT

Python

AWS S3

Data Cleansing

Data Lineage

Exception Reporting

Migration Validation

Tools

Informatica Data Quality/PowerCenter

Oracle

Redshift

Salesforce

JSON

Job description

ZealHire Inc. is seeking a Senior Data Quality & Snowflake Migration Engineer for remote work. The role centers on data migration into Snowflake with strong SQL, Python, and data quality discipline.

You will profile, validate, transform, reconcile, and migrate data from legacy systems into Snowflake while ensuring data integrity across the lifecycle. You will design quality controls, develop ETL/ELT processes, and collaborate with data engineers, architects, and stakeholders to meet acceptance