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
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
16 days ago
Job type
- Full-time
Job descriptionEnforce 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.
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
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
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
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
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
Do you love interacting with people and take pride knowing you helped them leave with a big smile? Are you excited at the thought of helping a customer pick out that .Do you have a natural abi...Show more
As a Bailey Nelson Store Manager, you play a pivotal role in running your own business within our brand.Your leadership is instrumental in bringing our values to life for both customers and your te...Show more
We're seeking a dynamic and results-driven Retail Store Manager to lead our store operations and drive business growth.About the Role : As Store Manager, you'll oversee daily operations whil...Show more
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
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
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
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
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
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
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
This full-time position offers flexible work hours and ample opportunities for advancement into management roles.You will work remotely to serve clients and offer valuable advice and protection to ...Show more
Based in Canada - Start the new year with true autonomy and financial growth.Work locally, supported by an experienced, culture-first team.
Sell print and digital ad products & solutions, with i...Show more
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
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
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
Senior Data & Analytics Engineer
Wagepoint • Calgary, Alberta, CA
Full-time
Quick Apply
Last updated: 30+ days ago
Geometry Private Tutoring Jobs Okotoks
Superprof • Okotoks, Canada
Full-time +1
Last updated: 30+ days ago • Promoted
Flooring Technical Representative
MAPEI Inc. • Rocky View County, AB, Canada
Full-time
Last updated: 12 days ago • Promoted
Senior Beauty Sales Consultant
Chatters Limited Partnerships • Airdrie, AB, Canada
Permanent
Last updated: 30+ days ago • Promoted
Store Manager - CrossIron Mills
Bailey Nelson • T4A 0G3, AB, Canada
Full-time
Last updated: 9 days ago • Promoted
Retail Store Manager
Lovisa • T4A 0G3, AB, Canada
Full-time
Last updated: 5 days ago • Promoted
Work From Home - Sales Representative - 60k / Year
Spade Recruiting • Okotoks, Alberta
Remote
Full-time
Quick Apply
Last updated: 30+ days ago • Promoted
Machine Learning Software Developer (2025-044)
Circle Cardiovascular Imaging • Calgary, AB, Canada
Full-time
Last updated: 30+ days ago • Promoted
Merchandiser Retail Team Lead
Advantage Solutions Inc. • Okotoks, AB, Canada
Full-time
Last updated: 17 days ago • Promoted
Senior Controls Engineer
Propak Systems Ltd. • Airdrie, AB, Canada
Full-time
Last updated: 30+ days ago • Promoted
Collision Estimator
Fix - Airdrie • Airdrie, AB, Canada
Full-time
Last updated: 30+ days ago • Promoted
Lead Data Engineer
Sage Recruiting • Calgary, AB, Canada
Full-time
Last updated: 30+ days ago • Promoted
Senior Accountant
IPG Workforce • Foothills, AB, Canada
Full-time +1
Last updated: 30+ days ago • Promoted
Benefits Advisor - Work From Home (69k+ per year)
HMG Careers • Okotoks, Alberta
Remote
Full-time
Quick Apply
Last updated: 9 days ago • Promoted
Area Media Sales
Best Version Media • Okotoks, AB, Canada
Permanent
Last updated: 4 days ago • Promoted
Supervisor
Savers / Value Village • Airdrie, AB, Canada
Full-time
Last updated: 30+ days ago • Promoted
2 - Senior Data Engineer
Targeted Talent • Calgary, AB, Canada
Permanent
Last updated: 30+ days ago • Promoted
Data Analyst
Mobis Parts Canada Corporation • Rocky View County, Alberta, Canada
Full-time
Quick Apply
Last updated: 30+ days ago