Find work in Canada.

625,161 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 10 mins ago
OC
SCADA Technician
Oxford County
Woodstock, ON
- Full-time
…the Oxford County’s water and wastewater related Supervisor Control and Data Acquisition (SCADA) systems and related communications network. Assists with the multi-year SCADA Master Plan…
Added 41 mins ago
KG
Data Architect (Databricks)
K&K Global Talent Solutions INC.
ON · Ontario, Canada
- Full-time
Data Integrity & Idempotency: Define data integrity checks, batch control, idempotency, and failure-recovery patterns for each ingestion pipeline.
Added 2 hours ago
MS
Guidance, Navigation & Control (GNC) Systems Engineer
MDA Space
Sainte-Anne-de-Bellevue, QC
- Full-time
Produce System Requirements, Interface Control document (ICD), and Description Document.
Added 2 hours ago
TA
Technical Publications Author-FR
Top Aces
Dorval, QC
- Full-time
Version Control and Controlled Document procedures
Added 4 hours ago
MS
Guidance, Navigation & Control (GNC) Systems Engineer
MDA Space
Sainte-Anne-de-Bellevue, QC
- Full-time
Produce System Requirements, Interface Control document (ICD), and Description Document.
Added 7 hours ago
SM
Unit Assistant, Emergency
Stevenson Memorial Hospital
Alliston, ON
- Internship
Accurately document physician orders in patient care plan.
Added 7 hours ago
C
Health Care Aide, Paediatric Intensive Care Unit – Permanent Part-Time (0.6)
CHEO
Ottawa, ON
- Part-time
As appropriate, obtain vital sign measurements, report findings to RN/RPN and document appropriately
Added 8 hours ago
R|
Project Manager
RI-MUHC | Research Institute of the MUHC | #rimuhc
Montreal, QC
- Contract
Data quality and research operations: Identify and resolve data-quality issues, develop standardized procedures, and quality-control processes.
Added 8 hours ago
R|
Clinical Trial Financial Control Analyst, Oncology Portfolio
RI-MUHC | Research Institute of the MUHC | #rimuhc
Montreal, QC
- Full-time
We are seeking a Clinical Trial Financial Control Analyst to provide independent financial control and reconciliation for Oncology-sponsored clinical research studies. Reporting within the…
Added 8 hours ago
LC
Pharmacy Assistant, Hourly Full Time Flexible Shifts
Loblaw Companies Limited
Calgary, AB
- Full-time
Maintain and control the cash register in the dispensary
Added 11 hours ago
AI
Embedded Software Developer
Aversan Inc.
Montreal, QC
- $120,000 to $140,000 CAD / year
- Full-time
Develop, document, implement, test, and maintain complex embedded flight software modules for space applications, including satellite and communications systems.
Added 11 hours ago
C
Security and Healthcare Technician
Convergint
Dartmouth, NS · CA NS Dartmouth
- Full-time
…direct involvement in multi-system integrations including Access Control, Video Management, RTLS, Nurse Call, PSIM, and supporting IT…
Added 12 hours ago
C
Senior Database Engineer (Snowflake)
Cvent
Fredericton, NB · NB · Virtual, New Brunswick
- Full-time
access control (RBAC), and cost optimization strategies
Added 12 hours ago
C
Senior Database Engineer (Snowflake)
Cvent
Fredericton, NB
- Full-time
access control (RBAC), and cost optimization strategies
Added 12 hours ago
C
Senior Site Reliability Engineer (Edge Security)
Cvent
Fredericton, NB
- Full-time
Added 12 hours ago
SS
Quality Manager
SkyCan Systems
Barrie, ON
- Full-time
Run document control and records management for the quality management system, including the master list, revision control and point-of-use access
Added 12 hours ago
Aircraft Maintenance Engineer - Edmonton
WestJet Group
AB · Edmonton International Airport, AB
Proven technical aptitude with strong airframe, powerplant, and flight control experience required
Added 12 hours ago
Aircraft Maintenance Engineer - Regina
WestJet Group
Regina, SK
Proven technical aptitude with strong airframe, powerplant, and flight control experience required
Added 12 hours ago
Aircraft Maintenance Engineer - Montreal
WestJet Group
Dorval, QC
Proven technical aptitude with strong airframe, powerplant, and flight control experience required
Added 12 hours ago
CM
ACTT Team Leader
Canadian Mental Health Association
Kenora, ON
- Full-time
Carry out and document quality-assurance activities and reviews of program services
Added 12 hours ago
CE
Tower Crane Technican - Electrician, Millwright
Cropac Equipment Inc
Abbotsford, BC
- Full-time
Diagnose and repair electrical and electronic issues involving motors, variable frequency drives, control systems, and related components.
Added 12 hours ago
M
Designer technique / Technical Designer
MACKAGE
Montreal, QC
- Full-time
Dans le présent document, le masculin est utilisé dans le seul but d’alléger le texte.
Added 13 hours ago
P
Gestionnaire de projets sénior - Senior Project Manager
Planiform
Montreal, QC · Greater Montreal Metropolitan Area
- Full-time
Added 13 hours ago
PI
Quantity Surveyor
Phoenix Industrial Group of Companies
AB · Edmonton, AB
- Full-time
Awareness of construction terms, planning, scheduling, quality control, hydro, and document control is required.
Added 13 hours ago
PI
Quality Control Administrator
Phoenix Industrial Group of Companies
AB · Edmonton, AB
- Full-time
…assisting with weld mapping and NDE tracking, and maintaining document control throughout all phases of industrial construction…

K&K Global Talent Solutions INC.

Data Architect (Databricks)

ON, Canada
Ontario, Canada, Canada

Full-time

Apply About employer

Applications open in a new tab.

Job details

Job type: Full-time
Apply by: Dec 9, 2026
Experience: Experience: 10+ years designing data warehouse and lakehouse solutions, with at least 5+ years of hands-on Databricks/Delta Lake and Snowflake/API-driven ingestion experience.
Posting language: English
Posted: Nov 9, 2026

Original job description

Position: Data Architect (Databricks & Medallion)

Location: Hybrid- Toronto, ON

Job type: Full-time/Permanent hiring

The Senior Data Architect will design the end-to-end data platform for APEX, ingesting call center telephony and quality data from Genesys A3S Snowflake and Verint WFM feeds, and delivering it through a Bronze/Silver/Gold (Medallion) architecture into a Kimball-style reporting layer. This role requires deep hands-on expertise in dimensional modeling, Databricks/Delta Lake, Spark SQL, and API-driven ingestion to deliver reliable, production-grade analytics for sales and telephony reporting.

Roles & Responsibilities

Medallion Architecture: Design Bronze/Silver/Gold data flow for Genesys A3S Snowflake and Verint sources.
Ingestion Strategy: Define ingestion cadence and watermarking strategy per source, based on true data freshness.
Star Schema Design: Design Gold-layer star schema (facts, dimensions) to support sales and telephony reporting.
Data Integrity & Idempotency: Define data integrity checks, batch control, idempotency, and failure-recovery patterns for each ingestion pipeline.
Architecture Documentation: Document architecture decisions and trade-offs for both engineering and business audiences.
Parallel-Run & Decommission: Partner with the existing CCARS pipeline team during the parallel-run and decommission phases.
Dimensional Modeling: Lead Kimball star schema, fact/dimension design, grain definition, and SCD Type I/II modeling.
Databricks Optimization: Tune Databricks workloads for cost and performance at scale (cluster sizing, job clusters vs. all-purpose, Photon).
SQL Expertise: Write and review production-grade transformation logic in both T-SQL (SQL Server) and Spark SQL.
Data Integrity Enforcement: Enforce referential integrity, deduplication, reconciliation, validation/audit checks, and late-arriving data handling.
API Integration at Scale: Consume and design around REST APIs at scale (pagination, rate limiting, async job patterns, per-entity fan-out APIs).
Multi-Source Ingestion: Ingest from external Snowflake sources, vendor exports (flat files, SFTP, APIs), normalizing non-standardized formats during landing.
High-Volume Pipeline Design: Design pipelines handling millions of records/day, with backpressure, retry, and failure isolation.
Orchestration & Scheduling: Work with Azure Data Factory, Databricks Workflows, and job scheduling (AutoSys or similar).
Azure Ecosystem: Work with Azure ecosystem tools (Databricks, ADF, SQL Managed Instance, Key Vault) and Python/PySpark for pipeline/transformation logic.

Required Technical Competencies

Experience: 10+ years designing data warehouse and lakehouse solutions, with at least 5+ years of hands-on Databricks/Delta Lake and Snowflake/API-driven ingestion experience.
Dimensional Modeling (Primary): Deep, hands-on Kimball star schema, fact/dimension design, grain definition, SCD Type I/II expertise.
Medallion Architecture (Primary): Proven experience designing Bronze/Silver/Gold Lakehouse architectures.
Databricks & Delta Lake (Primary): Strong hands-on expertise with Delta tables, ACID transactions, Z-ordering, optimize/vacuum, and workload tuning for cost/performance at scale.
SQL (Primary): Expert-level T-SQL and Spark SQL - complex joins, window functions, query tuning, indexing, partitioning strategy.
Data Integrity: Strong track record enforcing referential integrity, deduplication, reconciliation, validation/audit checks, and late-arriving data handling.
Databases (In and Out): Deep hands-on knowledge of relational databases (SQL Server preferred), understanding OLTP vs. OLAP design differences.
API Integration: Experience consuming and designing around REST APIs at scale (pagination, rate limiting, async job patterns).
Multi-Source Ingestion: Experience integrating Genesys Snowflake, vendor exports (Verint-style flat files, SFTP, APIs), with schema drift tolerance.
High-Volume Pipelines: Track record designing pipelines handling millions of records/day, with backpressure, retry, and failure isolation design.
Programming & Tooling: Python or PySpark for pipeline/transformation logic; familiarity with Azure ecosystem (Databricks, ADF, SQL Managed Instance, Key Vault).
Orchestration: Experience with Azure Data Factory, Databricks Workflows, or equivalent; job scheduling (AutoSys or similar a plus).
Preferred Domain: Prior experience with Genesys Cloud or Verint data models, contact center/telephony domain knowledge, and parallel-run migration strategies.

Apply About employer

More about this job

Responsibilities

Design and deliver a production-grade Databricks lakehouse using Bronze, Silver, and Gold layers, including ingestion from Genesys Snowflake and Verint sources and a Kimball-style reporting layer. Define dimensional models, data quality and recovery controls, scalable API and batch pipelines, workload optimization, and architecture documentation while supporting parallel-run and decommissioning activities.

Requirements

Requires 10+ years designing data warehouse and lakehouse solutions, including at least 5 years of hands-on Databricks/Delta Lake and Snowflake or API-driven ingestion experience. Candidates need strong Kimball modeling, T-SQL and Spark SQL, data integrity, high-volume pipeline, API integration, and Azure orchestration expertise; contact center or Genesys/Verint experience is preferred.

Skills

Kimball Dimensional Modeling
Medallion Architecture
Databricks
Delta Lake
Spark SQL
T-SQL
Python
PySpark
Snowflake
REST API Integration
Azure Data Factory
Databricks Workflows
Data Integrity
Pipeline Orchestration
Performance Optimization
Schema Design

Visa sponsorship

Not detected in the job text

Keywords

Databricks
Delta Lake
Medallion Architecture
Bronze/Silver/Gold
Kimball Modeling
Star Schema
Dimensional Modeling
Slowly Changing Dimensions
Spark SQL
T-SQL
Snowflake
Genesys A3S
Verint
REST APIs
Python
PySpark
Azure Data Factory
Databricks Workflows
SQL Server
Azure SQL Managed Instance
Azure Key Vault
Data Ingestion
Data Integrity
Idempotency
Data Reconciliation
Schema Drift
High-Volume Pipelines
AutoSys
Contact Center Analytics
Parallel-Run Migration

Report this job