KANINI ยท 4 days ago
Data Migration Specialist
KANINI is seeking a detail-oriented Data Migration Specialist to support business engagement and data migration efforts using Snowflake and SQL. The role involves acting as a bridge between business stakeholders and technical teams to ensure accurate data replication and successful adoption of a Snowflake-based data platform.
Responsibilities
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
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
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
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
Qualification
Required
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
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
Company
KANINI
Redefining Excellence. Your Partner in Sustainable Software Development.
H1B Sponsorship
KANINI has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (6)
2024 (6)
2023 (2)
2022 (8)
2021 (4)
Funding
Current Stage
Late StageLeadership Team
Company data provided by crunchbase