Senior Data Modeler with Azure Databricks, MS Fabric and Python experience to design and evolve dimensional data models for power reporting and self-serve analyticsS.i. Systems • Calgary

No longer accepting applications

Senior Data Modeler with Azure Databricks, MS Fabric and Python experience to design and evolve dimensional data models for power reporting and self-serve analytics

S.i. Systems • Calgary

17 days ago

Job type

Full-time

Job description

Our client is looking for a Senior Data Modeler with Azure Databricks, MS Fabric and Python experience to design and evolve dimensional data models for power reporting and self-serve analytics

This role requires you to be onsite 3 days a week in Calgary or Edmonton

Must Haves :

7+ years' experience working within Data Analytics preferably in the following areas : data modeling, analytics engineering and / or BI modeling
Experience with SQL for data profiling, reconciliation, and validation.
Experience with Power BI semantic modeling (tabular concepts, metrics governance, deployment patterns).
Expert-level capability in dimensional modeling ( Kimball ) including :
Star / snowflake schema design, fact table patterns, conformed dimensions
SCD Type 1 / 2 (and when to use each), role-playing dimensions, bridge tables
Additive vs semi-additive measures, snapshots vs transaction facts, late-arriving dimensions
Experience with governance and security concepts (cataloging, lineage, RBAC / ABAC, auditing, data classification).

Key responsibilities

Enforce the design and evolution of dimensional models (facts, conformed dimensions, metrics) that support enterprise analytics and self-serve use cases.

Lead discovery with business stakeholders to define business processes, grain, measures, hierarchies, and conformed dimensions, translating these into model specifications and semantic definitions.

Define and enforce modeling standards (naming conventions, metric definitions, dimensional patterns, SCD strategies, documentation templates).

Partner with data engineering to ensure performant implementations on Azure platforms (e.g., curated layers, incremental patterns, scalability, and query performance).

Drive conformed dimension strategy and cross-domain consistency.

Establish and maintain a metrics and dimensional standards library, promoting consistent definitions across reports and data products.

Support semantic and consumption layers to ensure governed, consistent results for business users.

Define data quality and reconciliation approaches (balancing, exception handling, completeness / accuracy rules) and partner with teams to operationalize them.

Contribute to governance practices including metadata, lineage, classifications (e.g., PII), and access patterns aligned to enterprise controls.

Produce and maintain high-quality modeling artifacts : conceptual / logical / physical designs, model diagrams, data dictionaries, mapping documents, and change logs.

Provide technical leadership through design reviews, peer coaching, and mentorship for engineers / analysts building or extending models.

Create a job alert for this search

Senior Data Modeler with Azure Databricks MS Fabric and Python experience to design and evolve dimensional data models for power reporting and selfserve analytics • Calgary

Similar jobs

Senior Data & Analytics Engineer

Wagepoint • Calgary, Alberta, CA

Full-time

Quick Apply

Wagepoint is a small-but-mighty fintech on a mission to make payroll simple (and maybe even delightful).Our online software takes care of the “ugh” stuff — like wage calculations and tax reporting ...Show more

Last updated: 30+ days ago

Geometry Private Tutoring Jobs Okotoks

Superprof • Okotoks, Canada

Full-time +1

Superprof is Canada's #1 tutoring platform, and we're actively recruiting passionate tutors! Whether you're a student, a professional, or simply someone who loves teaching, join the largest communi...Show more

Last updated: 30+ days ago • Promoted

Flooring Technical Representative

MAPEI Inc. • Rocky View County, AB, Canada

Full-time

With over 80 years of experience, MAPEI is now one of the leading global manufacturers of chemical products for the building industry. We offer high-quality, durable products that care for both the ...Show more

Last updated: 13 days ago • Promoted

Merchandising Service Associate

RONA+ • Rocky View, AB, Canada

Full-time

At RONA, our employees let their passion blossom every day.Our teams are driven by the desire to help people bring their projects to life and are committed to making a difference in the communities...Show more

Last updated: 3 hours ago • Promoted • New!

Work From Home - Sales Representative - 60k / Year

Spade Recruiting • Okotoks, Alberta

Remote

Full-time

Quick Apply

We’re looking for enthusiastic, self-driven, individuals to assist existing and prospective clients within our organization. This position will work with multiple clients throughout the day pr...Show more

Last updated: 30+ days ago • Promoted

Machine Learning Software Developer (2025-044)

Circle Cardiovascular Imaging • Calgary, AB, Canada

Full-time

Circle Cardiovascular Imaging (Circle) designs, builds, and implements the best-in-class cardiovascular Magnetic Resonance Imaging solutions. At the heart of everything we do is our unrelenting driv...Show more

Last updated: 30+ days ago • Promoted

Merchandiser Retail Team Lead

Advantage Solutions Inc. • Okotoks, AB, Canada

Full-time

We want you to help us shape the future of shopping experiences and deliver on our purpose of connecting people with the products and experiences that enrich their lives. Joining Advantage Solutions...Show more

Last updated: 18 days ago • Promoted

Senior Controls Engineer

Propak Systems Ltd. • Airdrie, AB, Canada

Full-time

The position is responsible for planning and directing large engineering projects, setting priorities, allocating resources, and making necessary decisions on day-to-day operating matters within th...Show more

Last updated: 30+ days ago • Promoted

Collision Estimator

Fix - Airdrie • Airdrie, AB, Canada

Full-time

Want to join a supportive team where your expertise in estimating collision repairs is valued and rewarded?.Are you ready to play a key role in our collision repair process and help customers get b...Show more

Last updated: 30+ days ago • Promoted

Lead Data Engineer

Sage Recruiting • Calgary, AB, Canada

Full-time

Our client is a well-established energy analytics company that has achieved product-market fit and is now in a growth phase. They are a data-first organization.Data is not a support function here; i...Show more

Last updated: 30+ days ago • Promoted

Piping Designer (S3D Specialist)

Airswift • airdrie, AB, ca

Temporary

Airswift is seeking a Piping Designer (S3D Specialist) to join one of our O&G clients on a 12–18‑month contract in Calgary, AB. Responsible for creating detailed 3D piping layouts and drawings f...Show more

Last updated: 2 hours ago • Promoted • New!

Data Project Manager

Akkodis • airdrie, AB, ca

Temporary

Data and Analytics Project Manager Job Type : Contract Location : Calgary or Edmonton Hybrid Length : Initial 12 month contract ...Show more

Last updated: 2 hours ago • Promoted • New!

Earn more this Winter, deliver with Uber Eats

Uber eats • High River, AB, CA

Full-time +2

Delivering with Uber is an alternative to a part-time or full-time job and can get you earning cash quickly.Delivering with Uber allows you to earn quick cash while maintaining the flexibility your...Show more

Last updated: 4 days ago • Promoted

Senior Accountant

IPG Workforce • Foothills, AB, Canada

Full-time +1

Senior Accountant – Public Accounting (Hybrid, Full-Time, Permanent).Salary : $70,000 to $95,000 per year.Our client, a mid-sized public accounting firm located on the west side of downtown Ca...Show more

Last updated: 30+ days ago • Promoted

Supervisor

Savers / Value Village • Airdrie, AB, Canada

Full-time

As one of the largest for-profit thrift operators in the United States, Canada and Australia for value priced pre-owned clothing, accessories and household goods, our mission is to champion reuse a...Show more

Last updated: 30+ days ago • Promoted

2 - Senior Data Engineer

Targeted Talent • Calgary, AB, Canada

Permanent

We are looking for an experienced.This is a permanent position that is remote to start with later relocation to.Our client is a global enterprise company with a product that you've likely used....Show more

Last updated: 30+ days ago • Promoted

MS Dynamics 365 CE Consultant

NLB Services • calgary, AB, ca

Full-time

Required Qualifications - • Bachelor’s degree in Computer Science, Engineering, or related field (or equivalent experience). Strong proficiency in C#, JavaScript, TypeScr...Show more

Last updated: less than 1 hour ago • Promoted • New!

Data Analyst

Mobis Parts Canada Corporation • Rocky View County, Alberta, Canada

Full-time

Quick Apply

MOBIS Parts Canada ("MPCA") is a technological leader in the automotive industry focusing on the distribution of parts for Hyundai Motor Company and Kia Motors. Through collaboration, ingenuity and ...Show more

Last updated: 30+ days ago