Senior Data Quality & Snowflake Migration Engineer

About the role

Everforth Apex Systems seeks a Senior Data Quality & Snowflake Migration Engineer for a remote (U.S.) position supporting a financial services partner. The contract runs through 12/31 with likely extension. The role focuses on profiling, validating, transforming, reconciling, and migrating data from legacy/source systems into Snowflake, ensuring data quality throughout the migration lifecycle.

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
• Data Migration & Reconciliation
• Data Profiling & Root-Cause Analysis
• 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.

Benefits

• Medical, dental, vision, life, disability, and other insurance plans (optional supplemental coverage)
• Employee Stock Purchase Program (ESPP)
• 401K program with company match after 12 months of tenure
• Health Savings Account (HSA) available on the HDHP plan
• SupportLinc Employee Assistance Program (EAP) – up to 8 free counseling sessions
• Corporate discount savings program and other discounts
• On‑demand training program
• Access to certification prep and a library of technical and leadership courses/books/seminars after 6+ months of tenure
• Certification discounts and perks for associations such as CompTIA and IIBA
• Dedicated customer service team for consultants
• Certified Career Coach
• Welcome Packet containing full list of benefits, programs, support teams and resources