5-7 years of experience in data engineering with a focus on Snowflake and SQL Server.
Advanced SQL proficiency, particularly in creating stored procedures and views.
Hands-on experience with Matillion for ETL processes.
Experience in migrating data pipelines, not just basic transfers.
Proven ability to identify and address data feed gaps for business workflows.
Familiarity with finance-related systems like QuickBooks and NetSuite is a plus.
Understanding of data accuracy and reconciliation principles.
Responsibilities
Engage with stakeholders to grasp current system usage and workflows.
Document existing business cases and expectations for the data platform.
Assess current data feeds and conduct gap analyses for effective migration.
Replicate existing database objects and validate their functionality in Snowflake.
Collaborate with engineering teams to ensure smooth migration processes.
Support knowledge transfer and documentation for post-migration support.
Enhance user confidence in the new Snowflake-based system.
Benefits
Long-term engagement and potential for career stability.
Opportunity to work with cutting-edge data technologies.
Collaborative work environment with cross-functional teams.
Exposure to finance data platform which enhances domain expertise.
Possibility for professional development through knowledge transfer initiatives.
Full Job Description
Job Description Title : Data Migration Engineer - SQL Server to Snowflake & Matillion for a Finance Data Platform
Location : Nashville TN
Duration : Long Term
1. 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.
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.
4. Migration Support & Collaboration
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