Jobs in Canada

Email me new jobs Save this search

Added 1 hour ago
ES
Data Science Generative AI and Data Engineering
Enterprise Solutions Inc.
Toronto, ON
- Contract
Experience with Python, SQL, vector databases, embeddings, and AIML frameworks
Added 1 hour ago
M
RQ11623 - Systems Testing/QA Specialist - Senior
Maarut
Toronto, ON
- Contract
Understanding of scripting languages (e.g., Python,
Added 3 hours ago
P
Core Java, Apache Spark, Python
PeoplePilot
Montreal, QC
- $120,000 to $130,000 CAD / year
- Full-time
We are seeking a highly motivated and experienced Software Engineer with strong expertise in Core Java, Apache Spark, Python, SQL, and Linux to design, develop, and support scalable…
Added 3 hours 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 4 hours 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 7 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 9 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 10 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 11 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 13 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 13 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 14 hours ago
P
Financial Analyst, FP&A
Powerex
Vancouver, BC
- Full-time
SQL or Python for data analysis and automation is an asset
Added 14 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.

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