Data Migration Engineer

Kanini Software Solutions; Nashville (TN); On-site; USD 80,000 - 100,000; Full time

Job summary

A software solutions company is seeking a Data Migration Engineer to facilitate the migration from SQL Server to Snowflake for a finance data platform. This role involves understanding business processes, conducting gap analyses, and ensuring data accuracy during the migration. Ideal candidates will have strong expertise in Snowflake, SQL Server, and ETL practices, as well as familiarity with financial data management. The position is based in Nashville, TN.

Qualifications

• Strong experience with Snowflake for data storage and validation.
• Hands-on experience with SQL Server, ideally SQL Server 2016.
• Experience in rebuilding and migrating data pipelines.
• Expertise in ETL, Data Integration, and maintaining ETL pipelines in Snowflake.

Responsibilities

• Meet with stakeholders to understand system usage and workflows.
• Document current business use cases and data dependencies.
• Liaise between users and technical teams to clarify requirements.
• Analyze existing database objects and ensure logic consistency.

Skills

Snowflake

SQL Server

Advanced SQL

ETL & Data Integration

Matillion

Finance and Accounting Data

Data Reconciliation

QuickBooks

NetSuite

Job description

Data Migration Engineer – SQL Server to Snowflake & Matillion for a Finance Data Platform

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.

2. Data Feed Assessment & Gap Analysis

Review existing data feeds currently available in Snowflake (e.g., QuickBooks, NetSuite).

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.

3. 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.

5. 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.

Required Skills & Experience

• 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)
• ETL & Data Integration
• 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
• Finance & Source Systems (Preferred)
• 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

Kanini Software Solutions, Inc. does not discriminate in employment matters on the basis of race, gender, religion, age, national origin, citizenship, veteran status, family status, disability status, or any other protected class. We support workplace diversity. If you have a disability, please let us know if there is anything we can do to improve the interview process for you; we’re happy to accommodate. Kanini Software Solutions, Inc., 25 Century Blvd., Ste. 602, Nashville, TN 37214.

Automation, Cloud, AI‑driven Insights – more than “Dreams of the Future” these have become the “Demands of the Present”, to set the stage for a business to be truly digital.