Find work in Canada.

505,188 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 25 mins ago
SQ
Conseiller/Conseillère stagiaire, Programme de perfectionnement du conseiller -Perspectives d'avenir/Advisor Trainee- Advisor Development Program -Future Opportunities
Sunlife Québec
Trois-Rivières, QC · Greater Trois-Rivieres Metropolitan Area
- Full-time
…help them plan financially for the various stages of life. Our Advisor Development Program is designed to prepare you for a successful launch to an advisory career at Sun…
Added 25 mins ago
T
HR Business Partner
TransLink
Vancouver, BC · Greater Vancouver, BC
- $84,480 to $126,720 CAD / year
- Full-time
The Human Resources (HR) Business Partner acts as a strategic partner and trusted advisor to assigned client groups, providing consultation, advice, and coaching to business leaders and…
Added 25 mins ago
SQ
Conseiller/Conseillère stagiaire, Programme de perfectionnement du conseiller -Perspectives d'avenir/Advisor Trainee- Advisor Development Program -Future Opportunities
Sunlife Québec
Quebec, QC
- Full-time
…help them plan financially for the various stages of life. Our Advisor Development Program is designed to prepare you for a successful launch to an advisory career at Sun…
Added 25 mins ago
SQ
Conseiller/Conseillère stagiaire, Programme de perfectionnement du conseiller -Perspectives d'avenir/Advisor Trainee- Advisor Development Program -Future Opportunities
Sunlife Québec
Levis, QC
- Full-time
…help them plan financially for the various stages of life. Our Advisor Development Program is designed to prepare you for a successful launch to an advisory career at Sun…
Added 25 mins ago
MI
Microsoft Dynamics CRM Developer
Maarut Inc
Montreal, QC
- Contract
The client is looking for a senior developer whose main field is Microsoft Dynamics CRM, with command of the CI/CD chain. The role covers the full cycle: requirements analysis, design,…
Added 25 mins ago
Retail Sales Representative - Vaughan
Encore
Vaughan, ON
Our client is Unilever - one of the world’s most trusted names in nutrition, hygiene, and personal care. With 400+ household brands (think Axe, Dove, OLLY, Hellmann’s), they’re committed to…
Added 25 mins ago
Retail Sales Representative - Toronto
Encore
Toronto, ON
Our client is Unilever - one of the world’s most trusted names in nutrition, hygiene, and personal care. With 400+ household brands (think Axe, Dove, OLLY, Hellmann’s), they’re committed to…
Added 25 mins ago
JC
Asset Management - Institutional Sales Associate, Canada
JPMorgan Chase & Co.
Toronto, ON
- Full-time
As an Institutional Sales Associate (ISA), you will be working with your client advisor(s) helping Institutional clients/prospects navigate the complexities of the broader capital markets…
Added 40 mins ago
WT
Senior Manager, Advice Innovation & Experience (16-month Fixed Term Contract)
Wealthsimple Technologies
Remote, Canada
- $156,000 to $195,000 CAD / year
- Full-time
- Remote
Your scope is the whole of Wealthsimple's advice business, not a single client segment. This role lives at the intersection of sales, service, product innovation, and commercial execution,…
Added 54 mins ago
CF
Consultant, Advisor Development
CI Financial
Toronto, ON
- Full-time
Reporting to the VP of Practice Management of CIGAM, the Consultant, Advisor Development is responsible for delivering consultations, workshops, and educational programs that help financial…
Added 54 mins ago
S&
Manager, Complex Accounting
Stevenson & White
Ottawa, ON
- $120,000 to $140,000 CAD / year
- Full-time
Our client is a prominent real estate company with a long-standing presence in North America, specializing in residential development, real estate investment, and property management. We’re…
Added 54 mins ago
CC
Financial Aid Advisor
Conestoga College
Kitchener, ON
- Full-time
The Financial Aid Advisor supports students by providing expert guidance on the Ontario Student Assistance Program (OSAP) and other funding sources. This role involves processing financial…
Added 54 mins ago
IB
Customer Service Representatives - Personal Lines - RIBO Licensed
InsureLine Brokers (Enterprise) Inc
Pickering, ON
- Full-time
…work in a collaborative environment that values integrity, client advocacy, and clear communication. The organization is committed to helping clients understand their coverage options and…
Added 54 mins ago
PC
Project Technologist
Pinchin Canada
Richmond, BC
- Full-time
Current employees are encouraged to speak with their HR Advisor for information on the application process.
Added 54 mins ago
A
Senior Project Manager (Environment)
AtkinsRéalis
Toronto, ON
- Full-time
Serve as a trusted advisor and primary client contact, providing clear, practical advice on environmental and regulatory matters, anticipating challenges and resolving issues to maintain…
Added 54 mins ago
R
Client Advisor
RBC
Winnipeg, MB
- Part-time
…champion the RBC brand and drive business by supporting new client acquisition and deepening existing relationships. If you have the self-motivation to deliver exceptional customer service…
Added 54 mins ago
R
Associate
RBC
BC
- Full-time
You will provide quality client service and help deepen relationships with existing clients through ongoing, efficient support to both clients and the Advisor Team.
Added 54 mins ago
R
Director, Real Estate
RBC
Vancouver, BC
- Full-time
…syndicated facilities. You will act as a trusted strategic advisor, connecting clients with other RBC partners to meet their diverse commercial and personal financial needs. While credit…
Added 54 mins ago
R
Assistant Branch Operations Manager
RBC
Toronto, ON
- Full-time
…and administrative support to the Branch Management Team and Advisor teams. In addition to managing client account activities and ensuring compliance standards are met, the Assistant Branch…
Added 1 hour ago
T
Senior Manager, Executive Communications
TD
Toronto, ON
- Full-time
Act as a trusted communications advisor and strategic sounding board, helping shape narratives, refine messaging and guide conversations on content, tone and stakeholder impact.
Added 1 hour ago
SL
Digital Graphic Designer
Sun Life
Toronto, ON · Waterloo, ON · Montreal, QC · Sun Life Waterloo King
- Full-time
Advise partners on how to bring the creative vision for key advisor-facing and Client-facing digital initiatives to life.
Added 1 hour ago
D
Personal Finance Advisor
Desjardins
Levis, QC · Caisse Desjardins de la Chaudière
- Full-time
As a personal finance advisor, you’re responsible for developing and maintaining lasting and trusting business relationships with members and clients, to ensure they’re satisfied. Your role…
Added 1 hour ago
D
Wealth Management Advisor
Desjardins
Sainte-Marie, QC · Caisse Desjardins de La Nouvelle-Beauce
- Full-time
As a wealth management advisor, you’re responsible for developing and maintaining lasting and trusting business relationships with members and clients, to ensure they’re satisfied. Your…
Added 1 hour ago
Business Advisor - Vancouver Branches, Vancouver, BC
Scotiabank
Vancouver, BC
Successful candidates will participate in a structured onboarding and integration period within the district before being assigned to Business Advisor opportunities based on business needs.
Added 1 hour ago
Manager, Business Banking, Virtual Advice - Halifax, NS (Bilingual English/French)
Scotiabank
Halifax, NS
Assisting with the development and refinement of the virtual advice model to generate incremental business, client and Advisor value

BURGEON IT SERVICES

ETL Developer with Snowflake

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

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, including Medallion architecture, data ingestion, modeling, transformation, validation, and security controls. Advise stakeholders on governance, performance, and cost optimization; develop AI agents and mentor junior consultants.

Requirements

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

Skills

Snowflake
ETL Development
Data Engineering
Data Warehousing
Data Architecture
Medallion Architecture
Python
SQL
Data Modeling
Data Governance
Data Quality
Change Data Capture
IDMC
CI/CD
Role-Based Access Control
Stakeholder Communication

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
Python
SQL
Stored Procedures
Snowpipe
IDMC
Change Data Capture
Data Modeling
Data Governance
Data Quality
Role-Based Access Control
Dynamic Data Masking
Row-Access Policies
Column-Level Security
Git
Azure DevOps
Power BI
Qlik
Control-M
Snowflake Marketplace
Cortex Analyst
Snowflake Intelligence
AI Agents
Railway Operations Data

Report this job