Data Migration Engineer

KANINI; Nashville (TN); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading tech company in Nashville, TN seeks a Mid-Senior level Senior Manager - Talent Acquisition. The role involves supporting data migration to Snowflake, ensuring data accuracy, and working with stakeholders on system integrations. Ideal candidates have strong experience in Snowflake and SQL, with a hands-on approach to building ETL pipelines. Full-time employment in a health care provider function is offered, with goal of seamless data migration and user adoption of the Snowflake platform.

Qualifications

• Strong experience with Snowflake for data storage, querying, and validation.
• Hands-on experience with SQL Server (preferably SQL Server 2016).
• Advanced SQL skills including stored procedures and views.
• Hands-on experience with Matillion is mandatory.

Responsibilities

• Meet with business stakeholders to understand workflows and decision-making processes.
• Perform gap analysis between current environment and Snowflake.
• Ensure equivalent logic is replicated in Snowflake with consistent behavior.
• Assist in knowledge transfer to internal teams for post-migration self-sufficiency.

Skills

Strong experience with Snowflake for data storage, querying, and validation

Hands‑on experience with SQL Server (preferably SQL Server 2016)

Advanced SQL skills

Experience rebuilding and migrating data pipelines

Hands‑on experience with Matillion

Experience working with finance or accounting data

Understanding of data accuracy, reconciliation, and reporting needs

Job description

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.

Responsibilities

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

Qualifications

• 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 NetSuite and/or QuickBooks 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