Find work in Canada.

320,818 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 18 mins ago
Quantitative Equity Alpha Research
CCLIM - Quantitative Equity
Vancouver, BC
Investing presents a rich set of research problems that you will explore in this role. Quantitative Researchers lead the development of our investment models and strategies. This requires…
Added 33 mins ago
CC
Project Manager (Municipal Infrastructure)
Chandos Construction
Calgary, AB
- Full-time
Ready to make a lasting impact through critical infrastructure? Join us as a Senior Project Manager and take the lead on projects that deliver safe, reliable services to the communities we…
Added 33 mins ago
ZR
Property Manager - Saskatoon
Zen Residential Ltd.
Edmonton, AB
- Full-time
Take ownership of leasing efforts to ensure high occupancy levels through active marketing, lead follow-up, conducting tours, and closing lease agreements
Added 33 mins ago
Q
Senior ASIC Verification Engineer
Qualcomm
Markham, ON
- Full-time
Lead complex debug activities through the development cycle (pre and post-silicon)
Added 48 mins ago
Project Manager
Konrad
Toronto, ON
…broader areas of digital consulting including strategy, product development, and user…
Added 48 mins ago
Program Manager
Konrad
Toronto, ON
In this high-impact role, you will lead the evolution of client engagements, guiding programs from initial strategy and discovery through to successful delivery, while contributing to…
Added 48 mins ago
SC
IT Site Manager
STERIS Canada ULC (Canada Manufacturing)
Quebec, QC
- Full-time
…success of our manufacturing and business operations. You will lead a local IT team, oversee infrastructure and systems that support day-to-day operations, drive technology projects, and…
Added 48 mins ago
TC
Manager, Budget Services
The City of Guelph
Guelph, ON
- Other
Lead the corporate operating and capital budget development and variance reporting processes, ensuring alignment with Council priorities, corporate objectives and approved financial…
Added 1 hour ago
TS
TDS Operations Analyst II
TD Securities
Toronto, ON
- Full-time
…opportunities to all colleagues. Growth opportunities and skill development are defining features of the colleague experience at TD. Our compensation policies and practices have been…
Added 1 hour ago
SM
Business Analyst – Senior - RQ11545
S M Software Solutions Inc
Toronto, ON
- Internship
Lead the team in defining and testing of usability requirements and metrics.
Added 1 hour ago
SM
Business Analyst – Senior - RQ11545
S M Software Solutions Inc
Toronto, ON
- Internship
Lead the team in defining and testing of usability requirements and metrics.
Added 1 hour ago
WI
IT Automation Architect
WSP in Canada
Moncton, NB
- Full-time
Lead architecture reviews, design workshops, and governance activities to ensure solutions align with approved standards, security requirements, and operational objectives.
Added 1 hour ago
WI
IT Automation Architect
WSP in Canada
Winnipeg, MB
- Full-time
Lead architecture reviews, design workshops, and governance activities to ensure solutions align with approved standards, security requirements, and operational objectives.
Added 1 hour ago
SM
RQ11635 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Senior Software Developer – ETL with strong experience in data warehousing, business intelligence, reporting, ETL development, Oracle SQL/PL/SQL, Informatica, Crystal…
Added 1 hour ago
SM
Business Analyst – Senior - RQ11545
S M Software Solutions Inc
Toronto, ON
- Internship
Lead the team in defining and testing of usability requirements and metrics.
Added 1 hour ago
SM
RQ11635 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Senior Software Developer – ETL with strong experience in data warehousing, business intelligence, reporting, ETL development, Oracle SQL/PL/SQL, Informatica, Crystal…
Added 1 hour ago
SM
RQ11635 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Senior Software Developer – ETL with strong experience in data warehousing, business intelligence, reporting, ETL development, Oracle SQL/PL/SQL, Informatica, Crystal…
Added 1 hour ago
WI
IT Automation Architect
WSP in Canada
Toronto, ON
- Full-time
Lead architecture reviews, design workshops, and governance activities to ensure solutions align with approved standards, security requirements, and operational objectives.
Added 1 hour ago
C
ServiceNow Business System Architect
CGI
Toronto, ON
- Full-time
Lead and advise on the design of innovative solutions
Added 1 hour ago
SM
Associate Director - Halifax
S M Software Solutions Inc
Halifax, NS
- Full-time
Knowledge of data lifecycle and hands-on experience with application development and AI tooling.
Added 1 hour ago
DR
Director of Design
DMC Recruitment Group
Vancouver, BC
- Full-time
…role serves as a mentor to the design team, supporting the development of creative and professional capabilities while contributing to business development through networking, relationship…
Added 1 hour ago
WI
Electrical Project Manager/Estimator
Western Integrated Ltd.
Burnaby, BC
- Full-time
…join our dynamic and growing team. In this position, you’ll lead industrial and commercial construction projects through completion - managing budgets, timelines, and resources - while also…
Added 1 hour ago
WI
IT Automation Architect
WSP in Canada
Montreal, QC
- Full-time
Lead architecture reviews, design workshops, and governance activities to ensure solutions align with approved standards, security requirements, and operational objectives.
Added 1 hour ago
WI
IT Automation Architect
WSP in Canada
Halifax, NS
- Full-time
Lead architecture reviews, design workshops, and governance activities to ensure solutions align with approved standards, security requirements, and operational objectives.
Added 1 hour ago
A
Executive Assistant - Head Office
AutoCanada
AB · Edmonton, AB
- Full-time
Executive Project Management: Lead, track, and execute strategic executive initiatives, key organizational priorities, and cross-functional projects on behalf of the COO using formal…

Aaura Softwares

AWS Snowflake Architect

Markham, ON, Canada

Contract

Apply About employer

Applications open in a new tab.

Job details

Job type: Contract
Apply by: Nov 1, 2026
Posting language: English
Posted: Oct 2, 2026

Original job description

Experience and Capabilities:

· Extensive experience ( 8 + years) in data architecture and engineering, with a proven track record in large - scale

· data transformation programs, ideally in insurance or financial services.

· Proven experience in architecti ng and implementing advanced data solutions using Snowflake on AWS,

· Expertise in d esign and orchestrati ng data acquisition pipelines using AWS Glue for ETL/ELT , Snowflake

· OpenFlow and Apache Airflow for workflow automation, enabling seamless ingestion of different data from

· diverse sources.

· Proven experience in DBT to manage and automate complex data transformations within Snowflake, ensuring

· modular, testable, and version - controlled transformation logic.

· Experience in implementing the lake house solution, Medallion architecture for financial or insurance carriers

· Experience in o ptimiz ing and tune Snowflake environments for performance, cost, and scalability, including

· query optimization and resource management,

· Experience in architecting/lead migration of workloads from Cloudera to Snowflake

· Design Streamlit apps and define new capabilities and data products leveraging snowflake ML and LLOPS

· capabilities .

· Experience in evaluating the data technology platform including da ta governance suites, data security

· products

· Exposure to enterprise Datawarehouse solution like Cloudera , AWS Redshift and informatica tool sets - IDMC,

· powercenter, BDM

· Develop robust data models and data pipelines to support data transformation, integrating multiple data

· sources and ensuring data quality and integrity.

· Document architecture, data flows, and transformation logic to ensure transparency, maintainability, and

· knowledge sharing across teams.

· Strong knowledge of d ata lifecycle mgmt., data retention, data modelling and working knowledge of cloud

· computing, and modern development practices.

· Experience with data governance, metadata management, and data quality frameworks (e.g., Collibra ,

· Informatica ).

· Experience in converting policy/data conversion from legacy to modern platform

· Deep expertise in Snowflake (Snowpro advanced certification preferred), with hands - on experience delivering

· Snowflake as an enterprise capability.

· Hands - on experience with AWS Glue for ETL/ELT, Apache Airflow for orchestration, and dbt for

· transformation (preferably deployed on AWS ECS).

· Proficiency in SQL, data modeling, ETL/ELT processes, and scripting languages (Python/Java).

Apply About employer

More about this job

Responsibilities

Architect and deliver enterprise-scale Snowflake data solutions on AWS, including ingestion pipelines, transformations, data models, and workload migrations from Cloudera. Optimize platform performance, cost, and scalability; document architecture and data flows; and develop data products using Snowflake ML and Streamlit.

Requirements

Requires 8+ years of data architecture and engineering experience, ideally in insurance or financial services, with deep hands-on Snowflake expertise. Candidates should have experience with AWS Glue, Airflow, dbt, SQL, data modeling, ETL/ELT, scripting, governance, and data quality; SnowPro Advanced certification is preferred.

Skills

Snowflake Architecture
AWS Glue
Apache Airflow
dbt
SQL
Data Modeling
ETL/ELT
Python
Java
Data Governance
Data Quality
Snowflake Performance Optimization
Data Migration
Medallion Architecture
AWS
Streamlit

Visa sponsorship

Not detected in the job text

Keywords

Snowflake
AWS
AWS Glue
Snowflake OpenFlow
Apache Airflow
dbt
Cloudera
AWS Redshift
Informatica IDMC
Informatica PowerCenter
Informatica BDM
Streamlit
Snowflake ML
MLOps
SQL
Python
Java
ETL/ELT
Data Architecture
Data Engineering
Data Modeling
Data Governance
Metadata Management
Data Quality
Medallion Architecture
Lakehouse
Data Migration
Query Optimization
Data Lifecycle Management
SnowPro Advanced

Report this job