Jobs in Canada

Group jobs by employerEmail me new jobs Save this search

Added 5 days ago
P
Senior Data Warehouse Developer
Pinnacle
Toronto, ON
- Full-time
As a senior data engineer, you will design, implement, and optimize the full-stack data infrastructure - from Snowflake clusters setup to data ingestion, transformation and report…
Added 5 days ago
QA
Data Engineer II - QuantumBlack, AI by McKinsey
QuantumBlack, AI by McKinsey
Toronto, ON
- Full-time
…the sole determinative factor at any stage of the application process nor the decisionmaker. All AI-generated assessments are reviewed by a McKinsey recruiter before any decision is made…
Added 5 days ago
EN
Program Manager
Extreme Networks
Toronto, ON
- Full-time
Added 5 days ago
HA
Intern Bachelors Elect Eng
Honeywell Aerospace
Ottawa, ON · Kanata, ON
- Full-time
YOU MUST HAVE
Added 5 days ago
HA
Intern Bachelors Mech Eng
Honeywell Aerospace
Ottawa, ON · Kanata, ON
- Full-time
YOU MUST HAVE
Added 5 days ago
W
Senior Project Manager, Municipal Engineering
WSP
Fort McMurray, AB
- Full-time
Professional Engineer, P.Eng., or Certified Engineering Technologist, C.E.T., designation, or eligibility for registration with APEGA or ASET.
Added 5 days ago
VP
System Integration Project Manager
Vista Projects Limited
Calgary, AB
- Full-time
This is not a traditional project administration role. The right candidate thinks like an engineer, manages like a delivery lead, and is energized by applying AI tools to real industrial…
Added 5 days ago
Aircraft Maintenance Engineer Apprentice
Rise Air
Saskatoon, SK
This position requires flexibility to work a variety of scheduled shifts, including night shifts, based on operational and maintenance requirements
Added 5 days ago
P
Engineer In Training
Precinmac
Milton, ON
- $22 to $24 CAD / hour
Must possess organizational abilities in regard to task prioritization, multi-tasking, use of timelines and time management
Added 5 days ago
BS
Validation Engineer
Bartech Staffing
Windsor, ON
- $34 to $35.64 CAD / hour
- Contract
…has engaged us to assist them in hiring a contract Validation Engineer (Windsor, Ontario). If you are interested in an opportunity to get your foot in the door with leading company, we want…
Added 5 days ago
W
Junior Process Engineer
Worley
Sarnia, ON
- Full-time
We are currently recruiting for a Junior Process Engineer. Our team includes world class experts and dynamic go-getters. This is a full-time position based in Sarnia, Ontario.
Added 5 days ago
Q-
MONTRÉAL [HYBRID] - SIEM Security Engineer Senior
QUANTEAM - North America (RAINBOW PARTNERS Group)
Montreal, QC
- Full-time
We are looking for a SIEM Security Engineer (Senior) to work with one of our clients.
Added 5 days ago
V
Bilingual Energy Sales Representative - Montreal, QC
Victaulic
Montreal, QC · Quebec, QC
- Full-time
Added 5 days ago
V
Jr. Infrastructure Sales Representative - GTA
Victaulic
Brampton, ON · Toronto, ON · Ontario - Toronto
- Full-time
We engineer change for a more stable and sustainable world.
Added 5 days ago
V
Energy Sales Representative - GTA
Victaulic
Brampton, ON · Toronto, ON · Ontario - Toronto
- Full-time
We engineer change for a more stable and sustainable world.
Added 5 days ago
E
Environmental Engineer/Geoscientist/Qualified Person
EXP
Windsor, ON
- Full-time
Must have a valid driver’s license, insurance and their own transportation; and,
Added 5 days ago
S
BIM Modeller - Electrical
SYSTRA
Toronto, ON
- $65,000 to $85,000 CAD / year
- Full-time
BIM Coordinator / BIM Manager / Electrical Lead Engineer
Added 5 days ago
A
Substation Designer
AtkinsRéalis
Toronto, ON
- Full-time
The Substation Electrical Designer specialist is required to work within a multi-discipline team to Design and Engineer efficient and reliable Electrical substation and distribution network.
Added 5 days ago
Manufacturing & Process Engineer - Senior PMO / Change & Transformation Lead
Capgemini
Montreal, QC
Added 5 days ago
Software Development Engineer, AFT Sortation Material Flow
Amazon
Toronto, ON
…and make decisions in real-time? As a Software Development Engineer, you will be responsible to develop our next generation of systems, work that includes managing sorters and workcells…
Added 5 days ago
GD
Intermediate Systems Engineer – ISTAR
General Dynamics Missions System International
Ottawa, ON
- $80,000 to $88,000 CAD / year
- Full-time
We are currently seeking an Intermediate Systems Engineer to join our Land Command, Control, Communications, Computers, Cyber, Intelligence, Surveillance and Reconnaissance (LC5ISR) team,…
Added 5 days ago
GD
Junior Systems Engineer – ISTAR
General Dynamics Missions System International
Ottawa, ON
- $75,000 to $80,000 CAD / year
- Full-time
We are currently seeking a Junior Systems Engineer to join our Land Command, Control, Communications, Computers, Cyber, Intelligence, Surveillance and Reconnaissance (LC5ISR) team,…
Added 5 days ago
GD
Working Level Systems Engineer – ISTAR
General Dynamics Missions System International
Ottawa, ON
- $88,000 to $105,000 CAD / year
- Full-time
We are currently seeking an experienced Systems Engineer to join our Land Command, Control, Communications, Computers, Cyber, Intelligence, Surveillance and Reconnaissance (LC5ISR) team,…
Added 5 days ago
CO
Senior Water Resources Engineer
City of Pickering
Canada
- Full-time
Must have a personal vehicle for use in the performance of duties and possess a valid Class “G” Ontario Drive
Added 5 days ago
TI
Machine Learning Engineer - Senior
TekStaff IT Solutions
Toronto, ON
- Contract
The Senior Machine Learning Engineer will deploy, integrate, monitor, and operationalize AI and machine-learning solutions using modern MLOps practices. The role will establish reusable…

Pinnacle

Senior Data Warehouse Developer

Toronto, ON, Canada

Full-time

Apply on LinkedIn About employer

Applications open in a new tab.

Job details

Job type: Full-time
Apply by: Dec 4, 2026
Experience: 6+ years of experience in cloud data warehousing, dimensional modeling and data integration solutions.
Posting language: English
Posted: Nov 4, 2026

Original job description

Job Title: Senior Data Warehouse Developer

Reports to: Data Warehouse Technical Lead

About us:

Welcome to Pinnacle, the ultimate destination for sports enthusiasts seeking an exhilarating sportsbook and gaming experience! Established in 1998, we have solidified our position as one of the globe's foremost licensed online gaming companies. With our cutting-edge offerings, we guarantee an electrifying experience that will keep you on the edge of your seat.

Pinnacle invites you to join our team and become an instrumental figure in the exciting realm of sportsbetting. Our vibrant team is fueled by passion and driven by innovation, working together to redefine the landscape of sports betting and gaming. Together, we constantly strive to surpass limitations and deliver unparalleled experiences to sports enthusiasts worldwide. Prepare yourself for a thrilling journey and discover sports in an entirely new dimension with Pinnacle!

Role Overview

As part of the Data Governance team, you will play a strategic and hands-on role in modernizing our enterprise data architecture. This position is critical to migrating our SQL Server data warehouse to Snowflake, while ensuring stability and business continuity for the legacy systems that will remain in production throughout the transition.

As a senior data engineer, you will design, implement, and optimize the full-stack data infrastructure - from Snowflake clusters setup to data ingestion, transformation and report migration. You will drive data governance frameworks aligned with enterprise cataloging, access control, sizing and monitoring Snowflake virtual warehouses.

Key Responsibilities

Build and maintain end-to-end cloud-native pipelines that ingest data into ADLS and Snowflake, orchestrate data load using ADF, and design transformations with curated DBT models.
Setup and maintain DevOps pipelines committing CI/CD-driven deployments.
Apply dimensional modeling and schema design best practices to build performant, well-governed Snowflake marts consumed by BI and analytics, apply SDC Type 2 to support “point-in-time” reporting.
Optimize Snowflake compute (warehouse sizing, clustering, query performance) and dbt model performance (materializations, incremental strategies) for cost-efficient and fast pipelines.
Provide light-touch support for legacy on-premises SQL Server systems only as needed to keep them stable during the transition.
Define and enforce engineering standards for pipeline development: version control, code review, dbt testing, and CI/CD automation across ADF and dbt/Snowflake deployments.
Implement and promote data governance foundations, including data cataloging, lineage tracking, access control, data integrity checks and alerts; and quality monitoring (e.g. Snowflake Horizon, Microsoft Purview).
Work closely with project managers, QA, and other developers; provide support to business users and application developers.

Skills & Qualifications

Strong verbal and written communication skills with the ability to translate business requirements into scalable technical solutions.
Proven analytical, conceptual, and problem-solving skills with a focus on root-cause analysis and continuous improvement.

Knowledge & Experience

6+ years of experience in cloud data warehousing, dimensional modeling and data integration solutions.
Strong production experience with Snowflake - virtual warehouses, Snowflake Scripting/stored procedures, Streams & Tasks, Time Travel, zero-copy cloning, and warehouse/query performance tuning.
Strong hands-on experience with dbt (dbt Core or dbt Cloud) - building and maintaining models, tests, documentation and CI/CD-driven deployments.
Experience with Azure Data Lake Storage (ADLS) and Azure Data Factory (ADF) for cloud-native data ingestion and orchestration.
Proficiency in Azure DevOps CI/CD, version control, and deployment automation.
Familiarity with data governance and cataloging tools - Snowflake Horizon, Microsoft Purview, or comparable third-party catalogs.
Strong SQL skills (ANSI SQL / Snowflake SQL) for building and tuning analytical queries at scale.
Bachelor's or Master's degree in Computer Science, Information Systems, Data Engineering, or a related field.

Equal Opportunity Employer

We are an equal opportunity employer dedicated to fostering an inclusive and diverse workplace. We prioritize hiring the best candidates based on their skills and qualifications, irrespective of race, gender, age, religion, or any other characteristic. Our strength lies in our diverse teams, and we proudly celebrate and empower everyone to embrace and promote diversity throughout their time with us.

AI Usage

As part of our recruitment process, Pinnacle may use technology-assisted tools, including AI-based systems, to support the review and assessment of applications. These tools are used to assist our team and do not make final decisions. All screening, interviewing, and hiring decisions are made by our recruitment and hiring team.

Agency Disclaimer

To all recruitment agencies – Pinnacle does not accept agency resumes. Please do not forward resumes to our jobs alias, Pinnacle employees or any other organization location. Pinnacle is not responsible for any fees related to unsolicited resumes.

Apply on LinkedIn About employer

More about this job

Responsibilities

Build and optimize cloud-native data pipelines and Snowflake data marts, including ingestion, orchestration, transformations, dimensional modeling, and report migration. Establish engineering and governance standards, tune Snowflake and dbt performance, and provide limited support for legacy SQL Server systems during the migration.

Requirements

Requires 6+ years of experience in cloud data warehousing, dimensional modeling, and data integration, with production expertise in Snowflake, dbt, ADLS, ADF, Azure DevOps, and SQL. A bachelor's or master's degree in computer science, information systems, data engineering, or a related field is specified, along with strong communication, analytical, and problem-solving skills.

Skills

Snowflake
Dbt
Azure Data Lake Storage
Azure Data Factory
Azure DevOps
SQL
Data Warehousing
Dimensional Modeling
Data Integration
Data Pipeline Development
Data Governance
CI/CD
Data Cataloging
Query Performance Tuning
Data Quality Monitoring
Slowly Changing Dimensions Type 2

Visa sponsorship

Not detected in the job text

Keywords

Snowflake
Dbt Core
Dbt Cloud
Azure Data Lake Storage
Azure Data Factory
Azure DevOps
SQL Server
Snowflake SQL
ANSI SQL
Data Warehousing
Dimensional Modeling
Data Integration
Data Ingestion
Data Transformation
Data Pipelines
CI/CD
DevOps
Data Governance
Data Cataloging
Data Lineage
Access Control
Microsoft Purview
Snowflake Horizon
Snowflake Streams and Tasks
Snowflake Time Travel
Zero-Copy Cloning
Virtual Warehouse Sizing
Query Performance Tuning
Incremental Models
Slowly Changing Dimensions Type 2

Report this job

Work requirements

Jobs in Canada