[Hiring] SQL Server to Snowflake Migration Consultant @Co-Sourcing Partners

Role Description

The SQL Server to Snowflake Migration Consultant will provide hands-on technical expertise to accelerate critical migration activities associated with the organization's transition from Microsoft SQL Server to Snowflake. The primary focus of the assignment is:

• Converting existing SQL Server queries and workloads to Snowflake-compatible SQL.
• Troubleshooting migration issues.
• Validating data and results.
• Reducing technical and delivery risk during the final phase of the migration.

This is an execution-focused position rather than an advisory-only Snowflake role. The consultant must be able to:

• Analyze existing Microsoft SQL queries.
• Understand their underlying business and data logic.
• Convert that logic appropriately for Snowflake.
• Troubleshoot differences between the environments.
• Validate that converted workloads produce the expected results.

The consultant will also support:

• ETL pipelines.
• Snowflake performance tuning.
• Reporting and dashboard validation.
• Knowledge transfer to internal team members.

As migration priorities change, the individual should be comfortable moving between:

• Query conversion.
• Troubleshooting.
• Data reconciliation.
• Pipeline support.
• Reporting validation.
• Other assignments required by the broader data team.

Qualifications

• Strong SQL query development and troubleshooting experience, particularly with Microsoft SQL Server workloads.
• Demonstrated Snowflake platform expertise.
• Previous hands-on data warehouse migration experience.

Requirements

• Comfortable moving between query conversion, troubleshooting, data reconciliation, ETL support, and Snowflake optimization.
• Ability to independently diagnose problems and drive them through resolution.

Benefits

• Gain hands-on exposure to the complex final stages of an enterprise data warehouse migration.
• Opportunity to solve difficult migration problems and see measurable progress.
• Work across SQL conversion, data validation, ETL troubleshooting, performance optimization, and reporting validation.

Objectives

• Convert Microsoft SQL Server Workloads to Snowflake.
• Troubleshoot and Resolve Migration Issues During the Final Migration Phase.
• Validate and Reconcile Migrated Data and Reporting Outputs.
• Improve Snowflake Workload Performance and Support Migration Stability.

Subtasks

• Assess the Migration Backlog and Priority SQL Workloads.
• Perform Hands-On SQL Server-to-Snowflake Query Conversion.
• Reconcile Data and Investigate Conversion Differences.
• Troubleshoot ETL Pipelines and Migration Dependencies.
• Tune Snowflake Queries and Validate Production Readiness.
• Validate Reporting and Transfer Migration Knowledge.
• Continuously Evaluate and Integrate AI to Improve Performance.

Preferred Experience - Bonus Points

• ETL troubleshooting and optimization experience.
• Power BI familiarity for validating downstream reporting outputs.
• Azure Data Factory experience for addressing pipeline-related migration dependencies.
• Healthcare data environment experience for understanding data quality and compliance awareness.

Definition of Success

By the conclusion of the engagement, the consultant has materially accelerated the final SQL Server-to-Snowflake migration by:

• Converting priority workloads.
• Resolving migration blockers.
• Validating and reconciling data.
• Improving Snowflake performance where necessary.
• Supporting reliable ETL execution.
• Confirming that affected reporting continues to operate as expected.

The most important evidence of success will be working migration outcomes rather than advisory recommendations.