Find work in Canada.

507,100 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 15 mins ago
C
Analyst, Enterprise Data and Records co-op
CIBC
Toronto, ON
- Full-time
Added 15 mins ago
C
Electronic Reliability Engineer Co-op (Winter 2027)
Ciena
Ottawa, ON
- Full-time
Added 15 mins ago
M
Platform Engineer
Manulife
Toronto, ON · Waterloo, ON
- Full-time
We’re looking for a Platform Engineer who enjoys solving complex infrastructure challenges, improving developer experiences, and building secure, automated cloud environments. You’ll work…
Added 15 mins ago
M
Strategic Partnership Manager
Manulife
Halifax, NS · Toronto, ON · Waterloo, ON · Montreal, QC
- Full-time
Added 15 mins ago
L
Senior Product Manager
Litera
Toronto, ON · Canada-Toronto, ON-Office
- Full-time
Added 15 mins ago
S
Data Scientist
SymphonyAI
Toronto, ON
- Full-time
Added 15 mins ago
MN
Vice President, Professional Services
March Networks
Remote, Canada
- Full-time
- Remote
…processes, improving resource utilization, and embedding automation, analytics, and AI into the service lifecycle. This leader must also have demonstrated success leading globally…
Added 15 mins ago
HD
Amazon Brand Manager
Hadley Designs
Remote, Canada
- Full-time
- Remote
Added 15 mins ago
Director, AI Wealth Enablement
The Canada Life Assurance Company
London, ON · Toronto, ON · ON · Mississauga Ontario, ON
Deep understanding of AI capabilities and limitations (including generative AI, automation, analytics, and machine learning) and how they apply in regulated environments such as financial…
Added 15 mins ago
VC
Account Executive/Directeur(trice) de comptes - Dental Technology
Valsoft Corporation
Remote, Canada
- Full-time
- Remote
…clinics: AI Scribe, AI receptionist, SMS outreach, digital forms, analytics and more. We're part of the Manos portfolio (a Valsoft division), which includes Dentitek, MacPractice and…
Added 15 mins ago
Software Engineer 3, Identity and Access Management
MongoDB
Toronto, ON
…workloads, embrace innovation, and unleash AI. Our industry-leading developer data platform, MongoDB Atlas, is the only globally distributed, multi-cloud database and is available in more…
Added 15 mins ago
Research Consultant
Reach3 Insights
Toronto, ON
Added 15 mins ago
PC
Junior Compliance Manager ( Calgary, AB)
Phantom Compliance
Crowsnest Pass, AB
- Full-time
Eagerness to learn blockchain analytics, transaction monitoring workflows, and risk assessment models.
Added 15 mins ago
PC
Service Delivery Manager ( Blairmore, AB)
Phantom Compliance
Crowsnest Pass, AB
- Part-time
Familiarity with blockchain analytics tools for forensic investigation
Added 15 mins ago
UT
Java Programmer # 26-27285
US Tech Solutions
Fredericton, NB
- $60 to $65 CAD / hour
- Contract
Added 15 mins ago
UT
.NET Developer # 26-27284
US Tech Solutions
Fredericton, NB
- $60 to $65 CAD / hour
- Contract
Added 15 mins ago
D
Software Engineer in Test
Dexian
Mississauga, ON
- Other
Continuous Quality Analytics: Define and instrument automated metrics and dashboards reflecting code quality, test coverage, defect leakage, MTTR, and test execution efficiency.
Added 15 mins ago
OM
Director, Inventory Management
Ontario Medical Supply
Mississauga, ON
- $120,000 to $125,000 CAD / year
- Full-time
Analytics, Performance and Executive Reporting
Added 15 mins ago
S
Senior Software Engineering Manager
symplistic.ai
Woodbridge, ON
- $150,000 CAD / year
- Full-time
Added 15 mins ago
RI
Growth Marketing Manager
Realtax Inc.
Newmarket, ON
- Full-time
Added 29 mins ago
Principal Strategic Deal Maker- Sales Executive
Capgemini
Mississauga, ON
Knowledge of enterprise technology trends including Cloud, AI, Data & Analytics, Digital Engineering, Cybersecurity, Intelligent Automation, and Platform Modernization
Added 29 mins ago
RB
Senior Director, AI Architecture
Royal Bank of Canada
Toronto, ON
- Full-time
Big Data Management, Data Modeling, Data Science, Decision Making, Deep Learning, Machine Learning (ML), Predictive Analytics, Programming Languages, Relationship Building
Added 29 mins ago
MI
Director of Product
Method Integration Inc.
Remote, Canada
- Full-time
- Remote
Added 29 mins ago
Partnership Trust & Safety Manager
impact.com
Victoria, BC
Added 29 mins ago
AC
Tech Analyst
Air Canada
Toronto, ON
- Full-time

BURGEON IT SERVICES

ETL with Snowflake Consultant

Calgary, AB, Canada

Contract

Apply About employer

Applications open in a new tab.

Job details

Job type: Contract
Apply by: Nov 26, 2026
Posting language: English
Posted: Oct 27, 2026

Original job description

Senior ETL with Snowflake Consultant

Location: Calgary, AB, Canada

12 Months

JD:

PURPOSE OF THE POSITION:

We are looking for a Senior ETL developer with Snowflake experience to serve as a technical leader and trusted advisor for business/stakeholders. This role is not just about building data pipelines. But also architecting the future of our CPKC data ecosystems. Profile must possess expertise on best practices in data governance, data quality, CORTEX Analyst/Search, SNOWFLAKE Intelligence and modern data architecture, specifically the Medallion framework.

Job necessitates direct exposure to stakeholders focused at understanding their business challenges and design performance-oriented solutions on Snowflake Data Cloud that are secure, reliable and cost efficient.

POSITION ACCOUNTABILITIES:

Design and implement scalable, end-to-end data platform solutions on Snowflake.

Architect data solutions using Medallion (Bronze, Silver, Gold) architecture.

Facilitate befitting Data Modelling Methodologies for Data Warehousing enabling a sound realization of Business Intelligence and Analytics needs.

Design and implement CDC (Change Data capture) and data ingestion using tools like Snowpipe, Python and IDMC.

Recommend and help enforcing Snowflake best practices and governance for data warehousing, data lakes, data engineering, and cost optimization.

Work on realizing robust Role-Based Access Control(RBAC) models to ensure optimal privileges.

Implement asset and user tagging for tracking credits/over-usage with resulting notifications/alerting

Implement concepts like Dynamic Data Masking, Row-Access Policies and Column-Level Security for protecting sensitive data.

Design and implement data validation, profiling, transformation and cleansing processes directly within data pipelines or layer of Medallion architecture.

Mentor junior consultants, fostering a culture of technical excellence and continuous learning.

Leverage Snowflake-Marketplace as an app store for readily exposure and use of data.

Design and develop AI agents on structured or non-structured data.

POSITION REQUIREMENTS:

8+ years of experience in data engineering, data warehousing, and data architecture.

4+ years of hands-on, in-depth experience with Snowflake Data Cloud.

Proven, demonstrable experience designing and implementing Medallion architecture in a production environment.

Proficient in use of Python, SQL, Stored-proc for transformation.

Excellent communication and client-facing skills, with the ability to explain complex technical concepts to non-technical stakeholders.

Experience with CI/CD practices for data pipelines using Git, Azure DevOps.

Expertise in using and building IDMC pipelines.

Familiarity with reporting tools such as POWER BI and QLIK.

Working knowledge of integration with Control-M to enable process orchestration.

Familiarity with the railway industry and an understanding of operation data will be preferred.

Apply About employer

More about this job

Responsibilities

Design and implement scalable Snowflake data platforms and pipelines using Medallion architecture, including ingestion, transformation, data quality, governance, security, and cost optimization. Advise stakeholders, develop AI agents and data-sharing solutions, and mentor junior consultants.

Requirements

Requires 8+ years of data engineering, warehousing, and architecture experience, including 4+ years of hands-on Snowflake experience and production experience with Medallion architecture. Candidates should be proficient in Python, SQL, stored procedures, IDMC, and CI/CD, with strong client-facing communication skills; Power BI, Qlik, Control-M, and railway-industry knowledge are also relevant.

Skills

Snowflake
ETL
Data Engineering
Data Warehousing
Data Architecture
Medallion Architecture
Python
SQL
Stored Procedures
Data Governance
Data Quality
Data Modeling
Change Data Capture
IDMC
Azure DevOps
CI/CD

Visa sponsorship

Not detected in the job text

Keywords

Snowflake Data Cloud
ETL
Data Engineering
Data Warehousing
Data Architecture
Medallion Architecture
Bronze-Silver-Gold Layers
Data Governance
Data Quality
Cortex Analyst
Cortex Search
Snowflake Intelligence
Data Modeling
Change Data Capture
Snowpipe
Python
SQL
Stored Procedures
IDMC
Role-Based Access Control
Dynamic Data Masking
Row-Access Policies
Column-Level Security
Git
Azure DevOps
Power BI
Qlik
Control-M
Snowflake Marketplace
AI Agents

Report this job