BURGEON IT SERVICES

IT Services and IT Consulting · Canada

Website

Open jobs in Canada

Email me new jobs Save this search

Added 1 hour ago
BI
SAP GRC Architect-Internal Controls
BURGEON IT SERVICES
Toronto, ON
- Contract
Added 1 hour ago
BI
ETL Developer with Snowflake
BURGEON IT SERVICES
Calgary, AB
- Contract
Added 1 hour ago
BI
ETL with Snowflake Consultant
BURGEON IT SERVICES
Calgary, AB
- Contract
Added 2 hours ago
BI
Java Full Stack Senior Developer
BURGEON IT SERVICES
Toronto, ON
- Contract
Added 2 hours ago
BI
Senior ETL Developer – Snowflake Calgary, AB, Canada
BURGEON IT SERVICES
Calgary, AB
- Contract
Added 2 hours ago
BI
Senior ETL developer with Snowflake Exp
BURGEON IT SERVICES
Calgary, AB
- Contract
Added 3 hours ago
BI
SAP Internal Controls Architect – S/4HANA Canada (Hybrid)
BURGEON IT SERVICES
Toronto, ON
- Contract
Added 3 hours ago
BI
Angular Frontend Developer
BURGEON IT SERVICES
Montreal, QC
- Contract
Added 3 hours ago
BI
Java Developer Montreal, Canada (Onsite)
BURGEON IT SERVICES
Montreal, QC
- Contract
Added 3 hours ago
BI
SAP GRC with S/4HANA Internal Controls Experience
BURGEON IT SERVICES
Toronto, ON · Greater Toronto Area, Canada
- Contract
Added 4 hours ago
BI
Java Developer @ Montreal, Canada – WFO
BURGEON IT SERVICES
Montreal, QC
- Contract
Added 22 hours ago
BI
Angular Developer
BURGEON IT SERVICES
Montreal, QC
- Contract
Added 1 day ago
BI
Angular Developer at Montreal, Canada
BURGEON IT SERVICES
Toronto, ON
- Contract
Added 1 day ago
BI
SAP Internal Controls Architect – S/4HANA Canada (Hybrid)
BURGEON IT SERVICES
Toronto, ON
- Contract
Added 1 day ago
BI
EDI Consultant with java, Azure Experience
BURGEON IT SERVICES
Toronto, ON
- Contract
Added 1 day ago
BI
Angular Developer
BURGEON IT SERVICES
Montreal, QC
- Contract
Added 1 day ago
BI
Angular Developer
BURGEON IT SERVICES
Montreal, QC
- Contract
Added 1 day ago
BI
Program Manager
BURGEON IT SERVICES
Toronto, ON
- Contract
Added 1 day ago
BI
Senior Program Manager – Digital Transformation
BURGEON IT SERVICES
Toronto, ON · Greater Toronto Area, Canada
- Contract
Added 1 day ago
BI
Java Developer
BURGEON IT SERVICES
Montreal, QC
- Contract
Added 1 day ago
BI
Senior Program Manager (Digital Transformation) Toronto, Canada (Hybrid – client location)
BURGEON IT SERVICES
Toronto, ON
- Contract
Added 2 days ago
BI
IVR Test Lead – Conversational AI
BURGEON IT SERVICES
Toronto, ON · Greater Toronto Area, Canada
- Contract
Added 2 days ago
BI
Senior Java Microservices Developer
BURGEON IT SERVICES
Toronto, ON
- Contract
Added 4 days ago
BI
IVR Test Lead-GCEX
BURGEON IT SERVICES
Toronto, ON
- Contract
Added 4 days ago
BI
IVR Test Lead – Conversational AI
BURGEON IT SERVICES
Toronto, ON
- Contract

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