Find work in Canada.

495,277 jobs across our Canadian network. How we count

Jobs in Canada

Email me new jobs Save this search

Added 10 days ago
SM
RQ11716 – Systems Testing/QA Specialist – Intermediate
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11716
Added 10 days ago
ES
Business Objects Power BI Engineer
Enterprise Solutions Inc.
Mississauga, ON
- Contract
PySpark Python Spark SQL and TSQL Fabric Notebooks Delta Tables and Delta Lake dimensional data modeling metadata driven frameworks data transformation validation and business rule…
Added 10 days ago
TB
Hitting Analyst
Toronto Blue Jays
Toronto, ON
- Full-time
Proficiency with analytical and visualization tools such as Python, R, and SQL
Added 10 days ago
C
Senior Consultant, Business System Analysis
CIBC
Toronto, ON
- Full-time
You can demonstrate experience with: 3-4+ years in a BSA in a BSC role leading projects and designing solutions. With the ability to elicit requirements and write strong documentation.…
Added 10 days ago
A
Services Business Applications Owner / Responsable des Applications pour Services
Airbus
Montreal, QC · Mirabel, QC
- Full-time
Atout : Connaissances avancées python, sql+, java, html, skywise et méthodologie AGILE.
Added 10 days ago
Senior Manager, Digital Channel Performance
Scotiabank
Toronto, ON
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.
Added 10 days ago
W
Data Scientist II
Wiraa
Canada
- Full-time
Process and analyze large-scale datasets using Python, SQL, Spark, and other distributed data processing tools.
Added 10 days ago
A
Senior Manager, Forward deployed Decision Scientist
AstraZeneca
Mississauga, ON · Canada - Mississauga
- Full-time
Proficiency in Python and SQL, with experience using relevant statistical and machine learning libraries.
Added 10 days ago
Business Systems Analyst-C1425
City of London
London, ON
Database Development – Strong Microsoft SQL Server skills including schema design, complex queries, permissions, performance troubleshooting, and data reconciliation.
Added 10 days ago
BI Platform Engineer
The Canada Life Assurance Company
London, ON · Toronto, ON
Automate platform operations using PowerShell, Python and DevOps tooling (Azure DevOps/GitHub; Fabric/Power BI REST and Admin APIs; Infrastructure‑as‑Code such as Bicep/Terraform).
Added 10 days ago
TI
Developer
TekStaff IT Solutions
ON · Ontario, Canada
- Contract
TekStaff's Client has a current vacancy for " Developer”
Added 10 days ago
OS
Python Developer
Open Systems Technologies
Montreal, QC
- Contract
Develop and maintain backend services using Python.
Added 10 days ago
SE
Senior AI Data Engineering Specialist
Schneider Electric
Montreal, QC
- Full-time
Proficiency in building reliable data pipelines using Python, SQL, or comparable technologies.
Added 10 days ago
B
Software Application Developer
BMO
Calgary, AB · GCS
- Full-time
As a Gen AI Software Application Developer at BMO, you will focus on building and integrating Generative AI capabilities into enterprise applications. Working with technology and business…
Added 10 days ago
RB
Associate Director, Market Risk Stress Testing
Royal Bank of Canada
Toronto, ON
- Full-time
Detailed knowledge of MS Excel, SQL, and Python
Added 10 days ago
F
Senior Software QA Specialist – FortiGate Cloud
Fortinet
Burnaby, BC
- Full-time
Database Knowledge: Familiarity with database technologies and query languages (SQL, etc.).
Added 10 days ago
VS
Solution Architect - CRM
vTech Solution Canada
Toronto, ON
- Contract
Strong Oracle SQL and DB2 query/script development skills
Added 10 days ago
R
Associate Director, Market Risk Stress Testing
RBC
Toronto, ON
- Full-time
Detailed knowledge of MS Excel, SQL, and Python
Added 10 days ago
M
Senior Data Architect
Miratech
Toronto, ON
- Full-time
Write and review production-grade transformation logic in T-SQL, Spark SQL and Python/PySpark.
Added 10 days ago
M
Senior Data Architect
Miratech
Toronto, ON
- Full-time
Write and review production-grade transformation logic in T-SQL, Spark SQL and Python/PySpark.
Added 10 days ago
SM
RQ11716 – Systems Testing/QA Specialist – Intermediate
S M Software Solutions Inc
Toronto, ON
- Internship
Client: Ministry of Public and Business Service Delivery and Procurement – RQ11716
Added 10 days ago
CO
Application & Integration Technical Analyst
City of Saint John
Saint John, NB
- Full-time
Database querying and transformation: dbt, SQL (writing queries, joins, stored procedures)
Added 10 days ago
LI
Sr. Data Engineer
Livingston International
Toronto, ON
- Full-time
6 years of related experience. Strong proficiency in SQL and other programming languages commonly used in data engineering (e.g., Python, Apache).
Added 10 days ago
TI
Senior Data Developer
TS Imagine
Montreal, QC
- Full-time
As a Senior Data Engineer, you will own production data systems built with Snowflake, dbt, SQL, and Python. You will help modernize established pipelines, improve the platform’s shared…
Added 10 days ago
EC
Applications Developer (Contract)
ECO Canada
Calgary, AB
- Contract
As a key member of the Applications Development team, the Applications Developer will be responsible for developing and maintaining our web applications. While each member of ECO Canada has…

Miratech

Senior Data Architect

Toronto, ON, Canada

Full-time

Apply About employer

Applications open in a new tab.

Job details

Job type: Full-time
Apply by: Apr 14, 2027
Experience: 5+ years of hands-on experience with Databricks/Delta Lake and Snowflake or API-driven ingestion.
Posting language: English
Posted: Oct 16, 2026

Original job description

Miratech helps visionaries change the world. We are a global IT services and consulting company that brings together enterprise and start-up innovation. Today, we support digital transformation for some of the world's largest enterprises. By partnering with both large and small players, we stay at the leading edge of technology, remain nimble even as a global leader, and create technology that helps our clients further enhance their business. We are a values-driven organization and our culture of Relentless Performance has enabled over 99% of Miratech's engagements to succeed by meeting or exceeding our scope, schedule, and/or budget objectives since our inception in 1989.

Miratech has coverage across 5 continents and operates in over 25 countries around the world. Miratech retains nearly 1000 full-time professionals, and our annual growth rate exceeds 25%.

Job Description

We are looking for a Senior Data Architect to design the end-to-end data platform for APEX. The platform ingests contact centre telephony and quality data from the Genesys A3S Snowflake database and Verint Workforce Management (WFM) feeds, and delivers it through a Bronze/Silver/Gold (Medallion) architecture on Databricks into a Kimball-style reporting layer.

You will own the architecture: ingestion strategy and cadence per source, incremental loading and batch control, data integrity standards, and the Gold-layer dimensional model. You will also partner with the existing CCARS pipeline team through parallel run and decommissioning of the legacy pipelines.

This role suits a hands-on Senior or Lead Data Architect who can turn complex reporting requirements into robust, auditable data solutions and explain architectural trade-offs to both engineers and business stakeholders.

Working Model: This is a hybrid role requiring 2 days per week in a downtown Toronto office.

Responsibilities:

Design the Bronze/Silver/Gold data flow for the new Genesys A3S Snowflake and Verint sources, with clear standards for ingestion, transformation, validation, and consumption.
Define ingestion cadence and watermarking strategy per source, based on each source's true data freshness.
Design the Gold-layer Kimball star schema (facts, dimensions, grain, SCD Type I/II) to support sales, telephony, agent activity, and quality reporting.
Choose between pure lakehouse and hybrid lakehouse-to-data-warehouse patterns based on source characteristics, volumes and performance needs.
Build and optimize Databricks and Delta Lake pipelines, and set cost and performance practices for cluster sizing, job versus all-purpose compute, and Photon.
Design ingestion from the external Genesys Snowflake source, including secure connectivity, incremental extraction and source-to-target reconciliation.
Integrate Verint and other vendor feeds delivered as flat files, SFTP drops or REST APIs, normalizing inconsistent formats and tolerating schema drift.
Design API ingestion that handles pagination, rate limits, asynchronous submit-poll-retrieve jobs and per-entity fan-out at scale.
Define data integrity checks, batch control, idempotency and failure-recovery patterns for each pipeline, including row-count and checksum reconciliation and late-arriving data handling.
Design orchestration with Azure Data Factory, Databricks Workflows or equivalent, with independent batch tracking and failure isolation per source feed.
Write and review production-grade transformation logic in T-SQL, Spark SQL and Python/PySpark.
Document architecture decisions and trade-offs for engineering and business audiences.
Partner with the existing CCARS pipeline team on parallel-run validation, cutover planning and legacy pipeline decommissioning.

Qualifications

10+ years of designing data warehouse and lakehouse solutions.
5+ years of hands-on experience with Databricks/Delta Lake and Snowflake or API-driven ingestion.
Deep hands-on dimensional modeling expertise: Kimball star schema, fact and dimension design, grain definition, SCD Type I/II.
Proven experience designing Medallion (Bronze/Silver/Gold) architectures, including the trade-offs between pure lakehouse and hybrid lakehouse-to-DW designs.
Strong Delta Lake expertise: Delta tables, ACID transactions, Z-ordering, OPTIMIZE/VACUUM, and Databricks workload tuning at scale.
Expert-level T-SQL and Spark SQL, including complex joins, window functions, query tuning, indexing and partitioning.
Deep knowledge of relational databases (SQL Server preferred) and of OLTP versus OLAP design.
Track record enforcing data integrity across pipeline boundaries: referential integrity, deduplication, reconciliation, checksum/hash validation, and detecting upstream schema drift.
Experience consuming REST APIs at scale, including pagination, rate limiting, async job patterns and endpoint-specific freshness.
Experience ingesting from external Snowflake sources and non-standardized vendor exports (flat files, SFTP, vendor APIs).
Experience designing high-volume pipelines (millions of records per day, hourly-to-real-time) with backpressure, retry and failure isolation.
Experience with orchestration tools such as Azure Data Factory or Databricks Workflows.
Proficiency in Python or PySpark, and familiarity with Azure (Databricks, ADF, SQL Managed Instance, Key Vault).
Strong communication skills for documenting decisions and explaining trade-offs to technical and business audiences.

Nice to have:

Prior experience with Genesys Cloud, Genesys A3S or Verint data models.
Contact centre or telephony domain knowledge: call detail records, agent activity, quality evaluations, IVR and routing.
Experience running parallel-run migration strategies, with legacy and new systems live simultaneously during cutover.
Experience with enterprise schedulers such as AutoSys is a plus.

Additional Information

We offer:

Culture of Relentless Performance: join an unstoppable technology development team with a 99% project success rate and more than 30% year-over-year revenue growth.
Competitive Pay and Benefits: enjoy a comprehensive compensation and benefits package, including health insurance, and a relocation program.
Work From Anywhere Culture: make the most of the flexibility that comes with remote work.
Growth Mindset: reap the benefits of a range of professional development opportunities, including certification programs, mentorship and talent investment programs, internal mobility and internship opportunities.
Global Impact: collaborate on impactful projects for top global clients and shape the future of industries.
Welcoming Multicultural Environment: be a part of a dynamic, global team and thrive in an inclusive and supportive work environment with open communication and regular team-building company social events.
Social Sustainability Values: join our sustainable business practices focused on five pillars, including IT education, community empowerment, fair operating practices, environmental sustainability, and gender equality.
Miratech is an equal opportunity employer and does not discriminate against any employee or applicant for employment on the basis of race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity, or any other protected status under applicable law.

Apply About employer

More about this job

Responsibilities

Design and own the end-to-end Databricks data platform, including source ingestion, Bronze/Silver/Gold transformations, data quality and recovery controls, and a Kimball-style reporting model. Build and optimize pipelines, document architectural decisions, and coordinate parallel-run validation, cutover, and decommissioning of legacy pipelines.

Requirements

Requires 10+ years designing data warehouse and lakehouse solutions, including at least five years of hands-on Databricks/Delta Lake experience and strong Snowflake or API-ingestion experience. Candidates should have deep dimensional modeling and data integrity expertise, advanced SQL and Python/PySpark skills, orchestration experience, and the ability to communicate architectural trade-offs to technical and business audiences.

Skills

Data Architecture
Databricks
Delta Lake
Snowflake
Kimball Dimensional Modeling
Medallion Architecture
T-SQL
Spark SQL
Python
PySpark
Azure Data Factory
REST API Ingestion
Data Integrity and Reconciliation
Data Pipeline Orchestration
Data Warehouse Design
Genesys and Verint Data Integration

Benefits

Health Insurance
Relocation Program
Professional Development Opportunities
Certification Programs
Mentorship Programs
Internal Mobility Opportunities

Visa sponsorship

Not detected in the job text

Keywords

Databricks
Delta Lake
Snowflake
Azure Data Factory
Databricks Workflows
SQL Server
T-SQL
Spark SQL
Python
PySpark
Genesys A3S
Verint Workforce Management
Medallion Architecture
Kimball Star Schema
Dimensional Modeling
SCD Type I and II
Lakehouse
Data Warehouse
REST APIs
SFTP
Incremental Loading
Watermarking
Data Reconciliation
Data Integrity
Schema Drift
Pipeline Orchestration
Batch Control
Idempotency
Parallel-Run Migration
Contact Centre Telephony

Report this job