Talent.com
freelance.ca
Data Engineer / Snowflake Migration Specialistfreelance.ca • Toronto, Canada
Data Engineer / Snowflake Migration Specialist

Data Engineer / Snowflake Migration Specialist

freelance.ca • Toronto, Canada
30+ days ago
Job type
  • Full-time
Job description
Role: Data Engineer / Snowflake Migration Specialist
Location: Toronto - Hybrid (4 Days WFO)

Key Responsibilities

• Design, develop, and maintain scalable and reliable data engineering pipelines to support analytics and business intelligence needs
• Architect, design, and implement solutions that meet stakeholder's needs
• Architect, implement, and optimize Snowflake data warehouse solutions, including data modeling, performance tuning, and cost optimization
• Lead and support data migration initiatives, including migration from on-premises or legacy data platforms to Snowflake or other cloud-based solutions
• Develop and manage ELT/ETL processes using modern data integration tools and frameworks
• Participate actively in requirements gathering, data modeling, and design sessions
• Prepare high-level and detailed technical specifications for the projects in accordance with security and architecture documentation objectives
• Develop detailed plans and accurate estimates for the completion of the build, system testing, and implementation phases of a project
• Collaborate with data architects, analytics teams, and business stakeholders to translate requirements into technical solutions
• Running and optimizing SQL queries on RDBMS like MS SQL server, MySQL/MariaDB
• Ensure data quality, security, governance, and compliance throughout the data lifecycle
• Develop, code, document, and execute unit tests, systems, integration and acceptance tests, and testing tools for functions of high complexity
• Troubleshoot and resolve performance, data integrity, and pipeline reliability issues
• Document architecture, data flows, and operational procedures

What do you need to succeed?

Must-have

• Strong hands-on experience in Data Engineering, including data pipeline development and large-scale data processing
• Deep expertise in Snowflake architecture, including Virtual warehouses, Micro-partitioning, Clustering and performance optimization, Security and access control
• Proven experience with data migration projects, including assessment, planning, execution, and validation
• Minimum 5+ years of experience in software engineering or analytics in creating enterprise data architectures, distributed and microservice software architectures and design patterns
• Strong SQL skills and experience with data modeling (dimensional and/or data vault)
• Core SQL database concepts, including creating DDL, DML scripts, normalization, running, and optimizing SQL queries on RDBMS
• Experience working with cloud platforms (AWS, Azure, or GCP)
• 2+ years of application development experience in Hadoop, NoSQL databases like MongoDB, Cassandra, or HBase
• Familiarity with orchestration and data integration tools (e.g., Airflow, dbt, Informatica, Fivetran, or similar)
• Prior experience with Liquibase, Git code repos like GitHub
• Bachelor's degree in information technology, Computer Science
• Strong problem-solving skills and ability to work independently in a fast-paced environment
Create a job alert for this search

Data Engineer / Snowflake Migration Specialist • Toronto, Canada

Similar jobs

Senior Data Engineer - Azure

Manulife Financial Corporationtoronto, on, Canada
Full-time

We are seeking a Senior Data Engineer - Azure to our team who will be able to bring their unique ideas, viewpoints, and technical experience.The role will collaborate with Architects, Engineers, an... Show more

 • Promoted

Senior Snowflake Data Engineer | AWS, Spark & AI Growth

Tiger Analytics, LLCtoronto, on, Canada
Full-time

A fast-growing analytics consulting firm is seeking a Data Engineer to architect and implement advanced analytics capabilities.The role requires expertise in data engineering with extensive experie... Show more

 • Promoted

Data Engineer: Analytics & Visualization Specialist

TekStaff IT SolutionsToronto, ON, CA
Full-time

Unlock the power of data as a Data Engineer with TekStaff, specializing in analytics and visualization.Drive projects focusing on PySpark, SQL, and cutting-edge cloud technologies.TekStaff's client... Show more

 • Promoted

Data Engineer - Snowflake, dbtCore/Cloud, AWS

Aviva CanadaMarkham, Ontario, Canada
Full-time

Individually we are people, but together we are Aviva.Individually these are just words, but together they are our Values – Care, Commitment, Community, and Confidence.At Aviva Canada, we put peopl... Show more

 • Promoted

Senior Cloud Data Engineer Position

Source CodeToronto, ON, CA
Temporary

Unlock your potential as a Senior DataOps/Cloud Data Engineer in Toronto for a rewarding 10-month contract.This onsite role requires mastery in Microsoft Azure technologies and a deep understanding... Show more

 • Promoted

Senior Snowflake & Python Data Engineer (Hybrid)

Themesoft Inc.Toronto, ON, CA
Temporary

A technology solutions provider is seeking a Senior Snowflake Developer to join their Toronto team in a hybrid capacity.The successful candidate will design, develop, and optimize data solutions us... Show more

 • Promoted

Lead Data Engineer

RBCToronto, ON, CA
Full-time +1

Join RBC as a Data Engineer to design, build, and maintain stable, scalable data assets in Snowflake that power enterprise reporting and analytics across the organization.You will work closely with... Show more

 • Promoted

Senior Data Engineer

Morningstartoronto, on, Canada
Full-time

The ideal candidate should have strong hands‑on expertise in.Design, build, and maintain end‑to‑end data pipelines with Snowflake as the primary data warehouse.Implement and support Medallion Archi... Show more

 • Promoted

LLM Serving Engineer (Cloud AI Engineering), Senior / Staff Engineer

Qualcommmarkham, york region, Canada
Full-time

Engineering Group, Engineering Group >.LLM Serving Engineer (Cloud AI Engineering).Qualcomm is utilizing its traditional strengths in digital wireless technologies to play a central role in the evo... Show more

 • Promoted

Senior Data Engineer - Azure ETL & DB Migration

Rubicon PathToronto, ON, CA
Full-time

A technology solutions provider based in Toronto is seeking a Senior Software Developer to manage data migration projects, focusing on transferring high-sensitive data to Azure SQL Database.The ide... Show more

 • Promoted

Data Engineer - AWS, Snowflake, DBT, Airflow | Remote

act digitalToronto, ON, CA
Remote
Full-time

An international IT consulting firm is seeking a mid-level or senior Data Engineer to support a global pharmaceutical project.Responsibilities include reviewing data engineering designs, performing... Show more

 • Promoted

Data Engineer - Analytics Pipelines & Power BI (Hybrid)

Accenturetoronto, on, Canada
Full-time

A global technology consulting firm in Toronto is seeking a Data Engineer to support large-scale infrastructure programs.This role involves designing data transformation frameworks for analytics-re... Show more

 • Promoted

Senior Engineer-Cloud AI Infrastructure

Huawei Canadamarkham, york region, Canada
Permanent

Huawei Canada has an immediate permanent opening for a Senior Engineer.Established in 2014, the Distributed Scheduling and Data Engine Lab is Huawei Cloud's technical innovation center in Canada.Th... Show more

 • Promoted

Data Engineer - Snowflake

Tiger AnalyticsToronto, ON, CA
Full-time

Tiger Analytics is a fast-growing advanced analytics consulting firm.Our consultants bring deep expertise in Data Science, Machine Learning and AI.We are the trusted analytics partner for several F... Show more

 • Promoted

Azure Data Engineer

Pacer GroupToronto, ON, CA
Full-time

Strong knowledge of Azure services: Data Factory, Databricks, Azure SQL, Spark SQL.Understanding of ETL/ELT concepts, data ingestion patterns, and data warehousing.Experience troubleshooting pipeli... Show more

 • Promoted

Azure Data Engineer: Fabric Pipelines & Data Models

Symbiotic GroupToronto, ON, CA
Full-time

A leading IT consulting firm is looking for an experienced Azure Data Engineer to build and manage a scalable data integration platform.The successful candidate will work on Microsoft Fabric to des... Show more

 • Promoted

Cloud Data Migration Engineer: Snowflake on Azure (Hybrid)

Direct IT Recruiting Inc.Toronto
Full-time +1

A technology recruiting firm in Toronto is seeking a Business Operations Manager for a 12-month contract.The role involves supporting the migration of Capital Market Analytics assets to cloud platf... Show more

 • Promoted

Sr. Data Platform Engineer

tripstacktoronto, on, Canada
Full-time

Founded in Toronto, Canada in 2016, Tripstack has been part of Etraveli Group since 2019.It is a B2B Flights as a Service provider and a world leader in virtual interlining.Operating from offices i... Show more

 • Promoted

Domain Architect for Advanced Snowflake Data Solutions and Migration

TechDigital GroupToronto, ON, CA
Full-time

Shape the future of data architecture as a Domain Architect specializing in Snowflake.Oversee data projects and migration strategies to optimize performance and client solutions remotely.Bringing o... Show more

 • Promoted

Senior Data Engineer Focused on Data Solutions

TechDoQuestMarkham, ON, CA
Full-time

Seize the opportunity as a Senior Data Engineer specializing in data solutions and coding excellence.Apply your extensive experience in Snowflake and cloud technologies to transform data into insig... Show more