Snowflake Data Engineer / Data Migration Engineer
Conch Technologies
Tukwila, United States of America
8 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Tukwila, United States of America
Tech stack
Artificial Intelligence
Data analysis
Apache HTTP Server
Azure
Cloud Computing
Continuous Integration
Data Validation
Information Engineering
Data Integration
ETL
Data Mart
Data Migration
Data Warehousing
DevOps
Programming Tools
Github
Microsoft Visual Studio
Microsoft SQL Server
Query Optimization
Power BI
Software Tools
Azure DevOps Pipelines
Software Configuration Management
SQL Stored Procedures
SQL Server Integration Services
SQL Server Analysis Services
T-SQL
Azure
Delivery Pipeline
Snowflake
Git Flow
Storage Technologies
Maintaining Code
Cloud Migration
Software Coding
Software Version Control
Data Pipelines
Job description
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
Requirements
- 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., * 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., POSITION Data Engineer LOCATION Tukwila, WA (hybrid) Local to WA only! REQUIRED SKILLS * Experience leveraging AI tools to accelerate development while maintaining code qua…
- 1 day ago