Snowflake Data Engineer / Data Migration Engineer
Location: Tukwila, WA (Hybrid)
Duration: 6+ Months
Note: w2 only No C2CJob Summary
We are seeking an experienced Snowflake Data Engineer / Data Migration Engineer to support the Finance Data Mart team in a large-scale migration initiative. The ideal candidate will have strong expertise in Snowflake, Azure Data Factory, SQL Server migrations, ETL development, and Power BI semantic models. This role requires hands-on experience with modern data engineering practices, CI/CD automation, and cloud-based analytics solutions.
Required Skills Snowflake Development
- Strong hands-on experience with Snowflake development and administration.
- Experience converting SQL Server T-SQL stored procedures and processes into Snowflake.
- Expertise in translating SQL Server DDL objects to Snowflake.
- Experience designing and developing migration frameworks for moving data from SQL Server to Snowflake.
- Strong knowledge of data validation, reconciliation, and migration testing.
- Experience optimizing Snowflake performance and query tuning.
ETL & Data Integration
- Experience converting SSIS packages into Azure Data Factory (ADF) pipelines.
- Strong knowledge of Azure Data Factory setup and configuration for Development, Pre-Production, and Production environments.
- Experience designing scalable and reusable ETL frameworks.
- Knowledge of Apache Iceberg storage technology.
Azure DevOps & CI/CD
- Experience creating and maintaining Azure DevOps CI/CD release pipelines.
- Experience automating deployments for data engineering solutions.
Source Control
- Strong experience with GitHub.
- Knowledge of branching strategies, repository management, and deployment workflows.
- Experience improving source control and DevOps processes.
Analytics & Reporting
- Experience developing and maintaining SSAS Cubes using Visual Studio.
- Experience migrating SSAS Cubes or Semantic Models to Power BI Semantic Models.
- Ability to validate migrated models and optimize performance.
AI-Assisted Development
- Experience using AI-powered development tools to improve productivity while maintaining coding standards.
- Experience with Snowflake AI Migration (AIM) tools is a plus.
Required Qualifications
- Strong SQL Server and Snowflake development experience.
- Experience with Azure Data Factory and cloud-based ETL development.
- Strong understanding of data warehouse design and migration methodologies.
- Experience with Azure DevOps, GitHub, and CI/CD best practices.
- Excellent analytical, troubleshooting, and problem-solving skills.
- Strong communication and collaboration skills.
Preferred Qualifications
- Experience with Apache Iceberg.
- Experience with Power BI Semantic Models.
- Familiarity with AI-assisted software development tools.
- Experience working on enterprise-scale cloud migration projects.