Senior Dimensional Data Modeler

Shape enterprise analytics from Richmond Hill as a Senior Data Modeler, using dimensional modelling and SQL in a hybrid corporate-office setting.

This senior specialist designs and evolves analytical data models for reporting, self-service analytics, planning, and data science. The work emphasizes dimensional architecture, Kimball methodologies, and clear business definitions. You will collaborate with stakeholders, analysts, BI developers, data engineers, and governance partners.

Key Responsibilities:

• Design conceptual, logical, and physical analytical data models
• Define fact grain, measures, dimensions, hierarchies, keys, and relationships
• Build conformed dimensions and reusable business entities
• Implement models using dbt and validate business logic
• Provide modelling leadership through reviews, standards, and mentoring

Requirements:

• Seven or more years in data warehousing or related disciplines
• Hands-on dimensional warehouse design using Kimball methodologies
• Strong SQL skills for profiling, validation, and testing
• Understanding of slowly changing dimensions and surrogate keys
• Experience modelling data for reporting, BI, and self-service analytics

Apply dimensional modelling, SQL, and dbt expertise to create governed analytical structures for enterprise data consumers.