Jobs in Canada

Email me new jobs Save this search

Added 42 mins ago
MA
Lead / Principal Data Engineer - Snowflake & dbt
Mitra AI
Canada
- Contract
…Data Engineer with deep expertise in Snowflake, DBT, advanced SQL, and modern data engineering practices to support enterprise data modernization…
Added 1 hour ago
NB
Chief Analyst, Capital Transformation
National Bank of Canada
Montreal, QC
- Temporary
analysis and programming tools such as Python, SQL, SAS, Snowflake, VBA or
Added 4 hours ago
CT
Snowflake Architect
Celebal Technologies
Calgary, AB
- Full-time
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…
Added 5 hours ago
PC
Azure Data Consultant, Senior Associate
PwC Canada
Toronto, ON
- Full-time
Proficiency in SQL and Python; strong understanding of ETL/ELT processes.
Added 6 hours ago
C
Ingénieur de données senior
CGI
Montreal, QC
- Full-time
The Data Engineer Senior acts as a specialist in the design, development, integration and optimisation of data solutions. They contribute to the implementation of pipelines, integration…
Added 8 hours ago
RB
Manager, Business Management & Optimization
Royal Bank of Canada
Toronto, ON
- Full-time
Hands-on experience with Python, SQL, APIs, workflow automation or low-code development platforms.
Added 10 hours ago
KA
Senior Databricks Engineer
KData AI
Toronto, ON
- Full-time
Core Languages: Advanced, expert-level proficiency in Python (PySpark, Spark Core) and Advanced SQL (complex analytical queries, window functions, and physical query execution plan tuning).
Added 10 hours ago
PC
Azure Data Consultant, Senior Associate
PwC Canada
Toronto, ON
- Full-time
Proficiency in SQL and Python; strong understanding of ETL/ELT processes.
Added 11 hours ago
P
Financial Analyst, FP&A
Powerex
Vancouver, BC
- Full-time
SQL or Python for data analysis and automation is an asset
Added 11 hours ago
M
Lead Full Stack Engineer
Manulife
Toronto, ON · Waterloo, ON
- Full-time
Languages and runtimes: Java, TypeScript, JavaScript, Node.js, Python, C#, .NET, and SQL.
Added 11 hours ago
M
Lead Full Stack Engineer
Manulife
Waterloo, ON
- Full-time
Languages and runtimes: Java, TypeScript, JavaScript, Node.js, Python, C#, .NET, and SQL.
Added 12 hours ago
BC
Database Administrator (Senior Systems Analyst)
British Columbia Institute of Technology
Burnaby, BC
- $84,685 to $112,200 CAD / year
- Temporary
BCIT’s Information Technology Services department is seeking a temporary, full-time (1.0 FTE) Database Administrator (Senior Systems Analyst). As a member of our Solution Delivery team, the…

Celebal Technologies

Snowflake Architect

Calgary, AB, Canada

Full-time

Apply About employer

Applications open in a new tab.

Job details

Job type: Full-time
Apply by: Dec 3, 2026
Posting language: English
Posted: Nov 3, 2026

Original job description

Title – Snowflake Data Architect

Location – Calgary, Canada

Duration – 6 Months With Possible Extension

Interview – 2 technical Round Virtually

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 using Medallion architecture, including data modeling, ingestion, transformation, governance, security, quality, and cost optimization. Advise stakeholders, develop AI agents and data marketplace solutions, 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 stakeholder communication skills; Power BI, Qlik, Control-M, and railway industry knowledge are also relevant.

Skills

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

Visa sponsorship

Not detected in the job text

Keywords

Snowflake Data Cloud
Snowpipe
Python
SQL
Stored Procedures
IDMC
Medallion Architecture
Bronze-Silver-Gold Layers
Data Warehousing
Data Modeling
Change Data Capture
Data Ingestion
Data Governance
Data Quality
Role-Based Access Control
Dynamic Data Masking
Row-Access Policies
Column-Level Security
Snowflake Marketplace
AI Agents
Git
Azure DevOps
CI/CD
Power BI
Qlik
Control-M
Data Profiling
Data Transformation
Cost Optimization
Railway Operations Data

Report this job