Jobs in Canada

Group jobs by employerEmail me new jobs Save this search

Added 2 months ago
R
Software Engineering Designer
RTX
Midland, ON
- Full-time
Qualifications You Must Have:
Added 2 months ago
CU
Senior Web Applications Developer
Concordia University of Edmonton
Edmonton, AB
- Full-time
Reporting to the Information Technology (IT) Applications Manager, the Senior Web Applications Developer is responsible for providing support, maintenance, and developing enhancements for…
Added 2 months ago
II
Sr. Java Full Stack Engineer
ITC Infotech
Vancouver, BC
- Full-time
Added 2 months ago
IG
Adobe Analyst
Insight Global
Toronto, ON
- $32 to $42 CAD / hour
- Contract
Added 2 months ago
CA
Operations Officer
Crédit Agricole
Montreal, QC
- Full-time
Proficiency with Microsoft Excel; knowledge of VBA, Access, SQL or financial operating systems is an asset.
Added 2 months ago
IH
Junior Business Central Developer Analyst
Inspired HR
Calgary, AB
- Full-time
Experience with programming in procedural languages like AL, C#, VB.NET, SQL, JavaScript;
Added 2 months ago
Principal Development Architect
SAP
Montreal, QC
…Platform (SAP BTP, AWS, GCP, Azure), Kubernetes, Git, CI/CD,…
Added 2 months ago
Business Systems - ERP Software Developer
Price Industries Limited
Winnipeg, MB
An ERP Software Developer designs, develops, and implements ERP solutions that enhance our business processes and improve efficiency. The ideal candidate will have a strong background in…
Added 2 months ago
GF
Senior Software Engineer- Ruby on Rails
Global Fleet Management
Burnaby, BC
- Full-time
…Engineer to join our dynamic team. Whether you're a seasoned RoR developer or one with a background in other technologies and a desire to dive deep into Rails and Angular, we have a place…
Added 2 months ago
A
Software Developer Backend - (Forma Admin Access)
Autodesk
Toronto, ON · Montreal, QC · Vancouver, BC · AMER - Canada - Ontario - Toronto - University Ave
- Full-time
26WD100670, Software Developer, BackEnd - (Forma Admin)
Added 2 months ago
S
Tech Lead - Java fullstack (Angular)
Synechron
Montreal, QC · MDC – Montreal
- Full-time
Connaissance des bases de données, du SQL et des outils d’intégration de données.
Added 2 months ago
R
Manager, New Product Risk
Relay
Remote, Canada
- Full-time
- Remote
You’re proficient in SQL and can independently retrieve and analyze data using joins, aggregations, CTEs, subqueries, and window functions
Added 2 months ago
K
Senior Consultant, Payments Transformation & Banking Technology
KPMG
Montreal, QC
- Full-time
Experience with Jira, Confluence, ServiceNow, SQL, Power BI or similar delivery and analysis tools.
Added 2 months ago
S
Customer Success Operations Specialist (Gainsight Administrator)
ScalePad
Vancouver, BC
- Full-time
Added 2 months ago
A
Tech Support Engineer
AVEVA
Calgary, AB
- Full-time
Proficient in Microsoft SQL Server development tools and languages, including SQL, PL/SQL, and T-SQL.
Added 2 months ago
Technical Business Analyst
Sapsol Technologies Inc
Montreal, QC
Communication Skill: (Must have): Ability to analyse business case
Added 2 months ago
TA
Manager, Analytics Consulting (Retail/CPG)
Tiger Analytics Inc.
Remote, Canada
- Full-time
- Remote
Working familiarity with analytical tools such as Excel, SQL, BI/visualization tools and/or Python.
Added 2 months ago
G
Spécialiste en tests logiciels / Software Test Specialist - Mobile & Web Apps
Genetec
Montreal, QC
- Full-time
Connaissance de Microsoft SQL Server ou d'autres bases de données relationnelles
Added 2 months ago
G
Développeur(euse) logiciel en test / Software Developer - SC Video Systems
Genetec
Montreal, QC
- Full-time
Added 2 months ago
G
Spécialiste en analyse numérique / Digital Analytics Specialist
Genetec
Quebec, QC
- Full-time
Créer et maintenir des tableaux de bord et des ensembles de données évolutifs à l'aide de Looker Studio, BigQuery, SQL et des requêtes planifiées
Added 2 months ago
G
Spécialiste en analyse numérique / Digital Analytics Specialist
Genetec
Sherbrooke, QC
- Full-time
Créer et maintenir des tableaux de bord et des ensembles de données évolutifs à l'aide de Looker Studio, BigQuery, SQL et des requêtes planifiées
Added 2 months ago
CS
Senior Technical Architect, Application Development & Support
Canadian Standards Association
Toronto, ON
- Full-time
Acts as lead developer and technical design authority for applications in scope, setting coding standards, design patterns, branching strategy, and definition of done for internal and…
Added 2 months ago
TH
Marketing Cloud (Agentforce Marketing) Specialist, Askuity division
The Home Depot Canada
Toronto, ON
- Full-time
Technical fluency in AMPScript, HTML, SQL, and Microsoft Excel.
Added 2 months ago
4E
Technical Lead
407 ETR
Woodbridge, ON
- Full-time
407 ETR is seeking a highly skilled and hands-on Sr. Developer to design and develop for the Strata platform, a mission-critical revenue-generation system supporting tolling operations and…
Added 2 months ago
VR
Senior Data Modeler - 6 Month Contract
Venterra Realty
Richmond Hill, ON
- Contract
Strong SQL skills and the ability to profile source data, validate assumptions, and test whether a model represents business processes correctly.

Venterra Realty

Senior Data Modeler - 6 Month Contract

Richmond Hill, ON, Canada

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

Apply on jobs.jobvite.com About employer

Applications open in a new tab.

Job details

Pay: SALARY: $60/h - $80/h
Job type: Contract
Posting language: English
Posted: Sep 4, 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:

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 on jobs.jobvite.com About employer

More about this job

Responsibilities

The Senior Data Modeler will design and evolve enterprise analytical data models to support reporting, self-service analytics, and data science. They will translate complex operational data into durable, business-centered structures while collaborating with data engineers and business stakeholders.

Requirements

Candidates must have 7+ years of experience in data warehousing and analytics engineering with deep expertise in Kimball dimensional modeling. Strong SQL skills and proficiency with transformation frameworks like DBT are required to build and validate analytical models.

Skills

Data Modeling
Dimensional Modeling
Kimball Methodology
SQL
Data Warehousing
DBT
Business Intelligence
Data Architecture
Star Schemas
Data Governance
Metadata Management
Snowflake
Power BI
Git
Analytical Data Modeling

Visa sponsorship

Not detected in the job text

Keywords

Data Modeling
Dimensional Modeling
Kimball
Data Warehousing
Analytics Engineering
Business Intelligence
Data Architecture
SQL
DBT
Star Schemas
Fact Tables
Dimensions
Data Governance
Snowflake
Power BI
Git
Medallion Architecture
Data Lineage
Metadata Management
Surrogate Keys
Slowly Changing Dimensions
Bridge Tables
Business Analytics
Data Engineering
Conceptual Modeling
Logical Modeling
Physical Modeling
Reporting
Self-service Analytics
Data Quality

Report this job

Work requirements

Jobs in Canada