Find work in Canada.

484,419 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 9 hours ago
UO
Scientific Assistant
University of Victoria
Victoria, BC
- Full-time
…and by coordinating with other technical staff, such as the Manager of Laboratories (ML), Senior Scientific Assistants (SSAs), and Scientific Assistants (SAs), as needed for the day-to-day…
Added 10 hours ago
SE
Senior Specialist, Offer Lifecycle Procurement
Schneider Electric
Calgary, AB · Montreal, QC
- Full-time
Build Strategic Partnerships & Influence Decisions
Added 10 hours ago
FH
Climate Change and Planetary Health Lead
Fraser Health
BC · Tri-Cities / Coquitlam / Port Coquitlam / Port Moody, British Columbia
- Full-time
Reporting to the Manager Environmental Health Services, the Climate Change and Planetary Health Lead provides subject matter expertise, project management, and strategic leadership on…
Added 10 hours ago
R
Manager, Business Development - Canada
ReVisionz
Remote, Canada
- Full-time
- Remote
8–10 years in business development, sales, consulting or senior operations, engineering or capital project roles where success depends on building client relationships and advancing…
Added 11 hours ago
R
Manager, Business Development - Canada
ReVisionz
Calgary, AB
- Full-time
8-10 years in business development, sales, consulting or senior operations, engineering or capital project roles where success depends on building client relationships and advancing…
Added 11 hours ago
B
Operational Technology Cybersecurity Lead
BGIS
Toronto, ON
- Full-time
…drive innovation for our clients’ businesses. Globally, we manager over 320 million square feet of client portfolios across 30,000+ locations in North America, Europe, Middle East,…
Added 13 hours ago
E
Principal Software Engineer
EngRadar
Kitamaat 2, BC
- Full-time
As a Principal Software Engineer on Conga’s B2B Platform Engineering, Core Services team, you’ll own the security, identity, and access management capabilities that every Conga B2B product…
Added 18 hours ago
UO
Substation Engineer
University of Alaska Fairbanks Petroleum Engineering
Engineer, BC
- Full-time
This position will have assignments designed to develop professional skills and competent technical knowledge within the area of substation engineering.
Added 18 hours ago
SM
RQ00813 – DevOps/Cloud Engineer – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
We are seeking a Senior DevOps/Cloud Engineer to support the Ontario Clinical Report Exchange (OCRE) project. The successful candidate will have extensive hands-on experience with AWS cloud…
Added 21 hours ago
R
Content Strategist
Ratehub
Remote, Canada
- Full-time
- Remote
This is a mid-level individual contributor role reporting to the Senior Organic Growth Manager. You’ll work closely with the Senior Director of Everyday Banking and Partnerships, the…
Added 21 hours ago
H
Senior Electrical Engineer
HDR
Toronto, ON · Ottawa, ON · Richmond Hill, ON · Victoria, BC · Vancouver, BC · Calgary, AB
- Full-time
Reporting to the Electrical Section Manager, the Senior Electrical Engineer is a member of the integrated project team that contributes Electrical engineering knowledge and analysis during…
Added 21 hours ago
H
Senior Mechanical Engineer
HDR
Calgary, AB
- Full-time
Reporting to the Mechanical Section Manager, the Senior Mechanical Engineer is a member of the integrated project team that contributes Mechanical engineering knowledge and analysis during…
Added 21 hours ago
H
Senior Project Manager
HDR
Calgary, AB
- Full-time
We believe building engineering is more than systems and structures, it’s about powering progress and enabling innovation. As part of HDR’s Building Engineering Services Group, you’ll help…
Added 22 hours ago
WF
Senior Human Resources Manager, Total Rewards
West Fraser
Vancouver, BC
- Full-time
Senior Human Resources Manager - Total Rewards, Vancouver, BC
Added 1 day ago
N
Senior Product Manager
nesto
Montreal, QC
- Full-time
We're looking for a Senior Product Manager to lead 0→1 product development on one of nesto's most strategic bets. In this role, you'll own the vision, roadmap, and execution for a new…
Added 1 day ago
IE
Manager, Supply Chain & Innovation
IMAX Enhanced | Streaming & Consumer Technology
Mississauga, ON
- Full-time
The Manager, Supply Chain Analytics & Innovation reports to the Senior Director, Supply Chain Operations and partners with Supply Chain leaders to identify, design and implement…
Added 1 day ago
ST
Senior Data Engineer
Sensor Tower
Remote, Canada
- Full-time
- Remote
As Sensor Tower continues to grow as a global company, we are looking for a Senior Data Engineer to build amazing products together. We have a wonderful team of more than a hundred…
Added 1 day ago
C
Quality Control Manager
Confidential
Markham, ON
- Full-time
I’m recruiting for a confidential client seeking an experienced Quality Control Manager to lead quality strategy across its asphalt and aggregate operations. This senior role oversees two…
Added 1 day ago
BR
Senior Cloud Engineer (AWS)
BITS Recruiting
Toronto, ON
- Contract
Our client is seeking a Senior DevOps / Cloud Engineer to support the Ontario Clinical Report Exchange (OCRE) project. The successful candidate will design, provision, automate, operate,…
Added 1 day ago
SM
RQ00813 – DevOps/Cloud Engineer – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
We are seeking a Senior DevOps/Cloud Engineer to support the Ontario Clinical Report Exchange (OCRE) project. The successful candidate will have extensive hands-on experience with AWS cloud…
Added 1 day ago
SM
RQ00813 – DevOps/Cloud Engineer – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
We are seeking a Senior DevOps/Cloud Engineer to support the Ontario Clinical Report Exchange (OCRE) project. The successful candidate will have extensive hands-on experience with AWS cloud…
Added 1 day ago
SM
RQ00813 – DevOps/Cloud Engineer – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
We are seeking a Senior DevOps/Cloud Engineer to support the Ontario Clinical Report Exchange (OCRE) project. The successful candidate will have extensive hands-on experience with AWS cloud…
Added 1 day ago
Delivery Manager
Konrad
Toronto, ON
Konrad is looking for an experienced Delivery Manager to drive the seamless execution and delivery of our digital and AI solutions. You've successfully managed cross-functional project…
Added 1 day ago
LM
DIRECTOR OF INFORMATION TECHNOLOGY
Lacroix Médecine Privée
Quebec, QC
- Full-time
A positive and committed leader with a strong sense of Accountability, the ability to build high-performing teams, manage rigorously, challenge the status quo, and transform technological…
Added 1 day ago
C
Sr. Consulting Manager, P&C insurance- Claims transformation
Cognizant
Mississauga, ON
- Full-time
As a Senior Consulting Manager, Insurance Consulting, you will make an impact by helping property and casualty (P&C) insurers transform their claims operations with emerging technologies…

Venterra Realty

Senior Data Modeler - 6 Month Contract

Richmond Hill, ON, Canada

SALARY: $60/h - $80/h · Contract

Apply About employer

Applications open in a new tab.

Job details

Pay: SALARY: $60/h - $80/h
Job type: Contract
Apply by: Nov 12, 2026
Posting language: English
Posted: Oct 13, 2026

Original job description

ROLE: Senior Data Modeler – 6 Months Contract

REPORTS TO: Manager, Digital Analytics

LOCATION: Hybrid / Corporate Office in Richmond Hill, Ontario

SALARY: $60/h - $80/h

About the Role: We are seeking a senior data modelling specialist to design and evolve the enterprise analytical data model that supports reporting, self-service analytics, planning, and data science. You will translate complex operational data into durable, business-centered structures that make measures, dimensions, and relationships clear and reusable across analytical use cases.

This role sits within Data Engineering and works closely with business stakeholders, analysts, BI developers, data engineers, and data governance partners. The primary focus is dimensional modelling and analytical data architecture, not pipeline orchestration or cloud infrastructure engineering.

Key Responsibilities:

Design conceptual, logical, and physical analytical data models across major business subject areas.
Define the grain of fact tables; design measures, dimensions, hierarchies, keys, and relationships; and select appropriate patterns for historical change.
Build conformed dimensions and reusable business entities that support consistent analysis across source systems and functional domains.
Abstract transactional and operational source structures into intuitive analytical models rather than reproducing source-system schemas.
Develop dimensional models using Kimball-style techniques, including star schemas, role-playing dimensions, bridge tables, factless fact tables, and slowly changing dimensions.
Partner with business stakeholders and analysts to understand analytical questions, reporting workflows, definitions, and required levels of detail.
Define business meaning, calculation intent, lineage, naming standards, and model documentation so that analytical assets are understandable and governed.
Implement models using DBT and validate that delivered structures preserve the intended grain and business logic.
Review existing warehouse structures, identify duplication or tightly coupled designs, and guide their evolution towards reusable and supportable analytical models.
Provide modelling leadership through design reviews, standards, mentoring, and constructive challenge.

What Success Looks Like:

Analysts can answer new questions by combining well-defined facts and conformed dimensions without repeatedly rebuilding business logic.
Different reports and subject areas use consistent definitions for shared business concepts.
Models are stable enough to absorb source-system change while remaining clear to analytical consumers.
Fact table grain, history, relationships, and calculation rules are explicit, tested, and documented.
Data engineering pipelines implement governed model designs instead of exposing operational structures directly to reporting tools.

Qualifications:

7+ years of experience in data warehousing, analytics engineering, business intelligence, data architecture, or a related discipline, with substantial hands-on responsibility for analytical data modelling.
Demonstrated experience designing dimensional data warehouses using Kimball methodologies.
Deep understanding of dimensional modelling concepts, including fact table grain, conformed dimensions, slowly changing dimensions, surrogate keys, hierarchies, additive and non-additive measures, and many-to-many relationships.
Experience creating conceptual, logical, and physical models that abstract data from multiple transactional source systems.
Strong SQL skills and the ability to profile source data, validate assumptions, and test whether a model represents business processes correctly.
Working knowledge of dbt or similar SQL-based transformation frameworks.
Experience modelling data for reporting, BI, semantic models, and self-service analytics.
Ability to facilitate requirements and model-design discussions with both business and technical participants.
Ability to explain modelling choices, trade-offs, and constraints clearly through diagrams, definitions, examples, and design documentation.
Experience reviewing implemented models for structural quality, usability, consistency, and alignment with modelling standards.
Experience modelling data across multiple enterprise applications or integrating similar business concepts from different source systems.
Familiarity with medallion-style data platform architecture and the role of curated, business-oriented models within that architecture.
Exposure to Git and automated deployment practices for database and transformation changes.

Preferred Qualifications:

Experience implementing analytical models in Snowflake or a comparable cloud data platform.
Experience supporting Power BI or another enterprise BI platform, including collaboration on semantic layer design.
Experience with data governance, metadata management, lineage, data quality rules, and business glossaries.

Education:

Bachelor's or master's degree in computer science, information systems, engineering, mathematics, business analytics, or a related field, or equivalent practical experience.

COMPANY OVERVIEW

Venterra Realty is a growing developer, owner, and operator of multifamily apartments with 90 mixed-use and multifamily communities across 22 major US cities. Over 50,000 people and more than 10,000 pets call Venterra "home"! The Venterra Team is focused on achieving excellence in serving its three major stakeholders: residents, employees, and investors. Venterra has enjoyed tremendous growth and financial success over its 24-year history. This success has been achieved through the exceptional commitment and dedication of Venterra's approximately 950 team members. Find out more about Venterra Realty and its award-winning company culture at Venterra.com.

Canada Awards:

2025 Best Workplaces™ for Professional Development
2025 Best Workplaces™ for Inclusion
2025 Best Workplaces™ for Mental Wellness 2025
2025 Best Workplaces™ in Canada
2025 Best Workplaces™ with Most Trusted Executive Team
2025 Best Workplaces^™ for Young Talent
2025 Best Workplaces™ in Real Estate & Property Development 2025

Explore our communities at VenterraLiving.com, and visit Venterra.com to learn more about how we’re out-caring the competition by staying true to our value proposition: “We care more about renter experiences, which drives superior results.”

Venterra Realty is an equal opportunity employer. Accessibility accommodations are available on request for candidates taking part in all stages of the selection process. We are actively recruiting for an existing position; Artificial Intelligence (AI) is used during our recruitment process for this role.

*The base salary range is intended to reflect the role's base salary rate in locations throughout Canada. Salary ranges are determined through interviews and a review of education, experience, knowledge, skills, abilities of the applicant, equity with other team members, alignment with market data, and geographic location. The base salary range does not include any bonuses or benefits.

Work Authorization Requirement: Applicants must be legally authorized to work in Canada at the time of application and throughout employment. The company does not provide visa sponsorship for this role.

Apply About employer

More about this job

Responsibilities

Design and evolve conceptual, logical, and physical analytical data models, including dimensional structures, reusable business entities, and documented business definitions. Partner with business and technical teams to implement and validate models using dbt, review existing warehouse designs, and provide modeling standards and leadership.

Requirements

Requires 7+ years of relevant experience with substantial hands-on analytical data modeling and demonstrated expertise in Kimball-style dimensional data warehousing. Candidates should have strong SQL, experience with dbt or similar tools, and the ability to facilitate modeling discussions and document design decisions; a relevant degree or equivalent practical experience is specified.

Skills

Dimensional Data Modeling
Kimball Methodology
SQL
dbt
Data Warehousing
Fact Table Grain Design
Conformed Dimensions
Slowly Changing Dimensions
Data Architecture
Data Governance
Data Lineage
Data Quality
Business Intelligence
Self-Service Analytics
Snowflake
Power BI

Visa sponsorship

Not detected in the job text

Keywords

Dimensional Modeling
Kimball Methodology
Star Schema
Fact Tables
Conformed Dimensions
Slowly Changing Dimensions
Surrogate Keys
Role-Playing Dimensions
Bridge Tables
Factless Fact Tables
SQL
dbt
Data Warehousing
Analytics Engineering
Data Architecture
Snowflake
Power BI
Semantic Layer
Medallion Architecture
Git
Automated Deployment
Data Governance
Metadata Management
Data Lineage
Data Quality
Business Glossary
Self-Service Analytics
Business Intelligence
Enterprise Applications
Real Estate

Report this job