Data Migration Engineer

Senior Manager - Talent Acquisition @ KANINI Software Solutions

We are seeking a detail‑oriented Data Migration expert/ Engineer with strong Snowflake and SQL expertise to support business engagement, data migration, Matillion and validation efforts. This role will act as a bridge between business stakeholders and technical teams to ensure accurate data replication, seamless migration, and successful adoption of a Snowflake-based data platform.

• Business Engagement & Current‑State Understanding
• Meet with business stakeholders to understand how they currently use the system, including day‑to‑day workflows, reports, and decision‑making processes.
• Document current business use cases, dependencies, and expectations from the data platform.
• Act as a liaison between business users and the technical team to ensure requirements are clearly understood and translated.
• Data Feed Assessment & Gap Analysis
• Review existing data feeds currently available in Snowflake (e.g., Quick Books, Net Suite).
• Identify missing or incomplete data feeds required to support business workflows.
• Perform gap analysis between the current environment and Snowflake to determine additional ingestion or transformation needs.
• Define requirements for building or enhancing data feeds to close identified gaps.
• Data Object & Logic Replication
• Analyze existing database objects such as stored procedures, views, and transformations used in the source environment.
• Ensure equivalent logic is replicated in Snowflake with consistent behavior.
• Validate record counts, data accuracy, and output consistency between source and Snowflake environments.
• Support testing and reconciliation efforts to ensure parity during migration.
• Work closely with the core engineering and data teams throughout the migration process.
• Help ensure a smooth transition from the legacy environment to Snowflake with minimal disruption to business users.
• Project Enablement & Knowledge Transfer
• Document findings, assumptions, and decisions to support long‑term maintainability.
• Assist in knowledge transfer to internal teams to ensure post‑migration self‑sufficiency.
• Support adoption by ensuring business users are confident in the Snowflake‑based solution.

• Strong experience with Snowflake for data storage, querying, and validation.
• Hands‑on experience with SQL Server (on‑prem, preferably SQL Server 2016).
• Advanced SQL skills, including stored procedures and views.
• Experience rebuilding and migrating data pipelines (not just lift‑and‑shift).
• Hands‑on experience with Matillion (mandatory).
• Experience building and maintaining ETL pipelines into Snowflake.
• Ability to identify missing data feeds and build new integrations.
• Experience working with multiple inbound data sources.
• Experience working with finance or accounting data.
• Familiarity with Net Suite and/or Quick Books is a strong plus.
• Understanding of data accuracy, reconciliation, and reporting needs.

Seniority level: Mid‑Senior level

Employment type: Full‑time

Job function: Health Care Provider

Industries: Hospitals and Health Care