Snowflake Data Migration Engineer w/ Python

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

Location: REMOTE

Duration 12-18mth+

Must have:

• Snowflake & Advanced SQL
• Data Quality Controls & Validation
• Migration testing and production validation
• Experience with Informatica Data Quality/PowerCenter, Oracle, Redshift, Salesforce,
  • • • JSON is a plus.
• Python
• AWS / S3
• Must have strong excellent communication
• LinkedIn Page

Senior Data Quality & Snowflake Migration Engineer:

• We are seeking an experienced Senior Data Quality & Snowflake Migration Engineer with strong expertise in Snowflake, SQL, Python, data migration, data integration, and data quality controls.
• The role will focus on ensuring data is accurately profiled, validated, transformed, reconciled, and migrated from legacy and source systems into Snowflake.
• The ideal candidate will have hands‑on experience working with complex enterprise datasets and implementing data quality controls throughout the migration lifecycle, from source assessment through production validation.
• The candidate's experience includes data migrations, integrations, Snowflake development, data analysis, mapping, and data‑quality implementation.

Key Responsibilities:

• Design and implement data quality controls for large‑scale data migrations into Snowflake.
• Perform source data profiling and analysis to identify completeness, accuracy, consistency, duplication, and formatting issues.
• Define and implement pre‑migration and post‑migration validation controls.
• Develop SQL‑based data quality rules, validation queries, and exception reporting.
• Perform source‑to‑target mapping, field mapping, transformation analysis, and fit‑gap assessments.
• Develop Snowflake SQL and ETL/ELT processes for data cleansing, transformation, migration, and integration.
• Implement data reconciliation controls to validate record counts, key attributes, transformations, and source‑to‑target data accuracy.
• Identify migration exceptions, investigate data‑quality defects, perform root‑cause analysis, and coordinate remediation.
• Implement data cleansing, standardization, validation, duplicate identification, and data integrity controls.
• Build automated data validation and processing solutions using SQL and Python.
• Create Snowflake views, data extracts, dashboards, and exception reports to support migration monitoring and validation.
• Support migration testing, UAT, production cutover, and post‑migration data validation.
• Work closely with data engineers, architects, analysts, and business stakeholders to define data quality acceptance criteria and migration controls.

Required Skills:

• Snowflake & Advanced SQL
• Data Quality Controls & Validation
• Source-to-Target / Field Mapping
• ETL/ELT & Data Integration
• Python
• AWS / S3
• Data cleansing and standardization
• Data lineage and dependency analysis
• Exception reporting and remediation
• Migration testing and production validation
• Experience with Informatica Data Quality/PowerCenter, Oracle, Redshift, Salesforce, JSON is a plus.

$000,000 – $000,000 Salary range is not shown on the candidate portal