Talent.com
Data Modeler
Data ModelerAkkodis • Calgary, AB, CA
Data Modeler

Data Modeler

Akkodis • Calgary, AB, CA
1 day ago
Job type
  • Full-time
Job description

Our client is looking for a Senior Data Modeler to design and evolve trusted, analytics-ready data models that power reporting, self-serve analytics, and data products across the business.

In this role, you will be a key technical leader who partners with data engineering, BI, governance, and business stakeholders to translate business processes into scalable dimensional models, establish consistent metric definitions, and drive modeling standards across domains. You’ll influence how data products are shaped—from conceptual design through implementation—ensuring clarity, performance, and long-term maintainability.

This role is ideal for someone who combines deep modeling expertise with strong business acumen, and who can mentor others while raising the overall quality bar for analytics models.

What You’ll Do

  • 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.

What You Bring

  • 7+ years of experience in data modeling / analytics engineering / BI modeling, including ownership of enterprise models and standards.
  • Star / snowflake schema design, fact table patterns, conformed dimensions
  • SCD Type 1 / 2 (and when to use each), role-playing dimensions, bridge tables
  • Strong SQL skills and strong analytical methods for data profiling, reconciliation, and validation.
  • Demonstrated ability to translate complex business processes into clear models, explain trade-offs, and align multiple stakeholders to a shared design.
  • Strong documentation and communication skills—able to create artifacts that enable scalable delivery.
  • Experience working in Agile, cross-functional delivery teams and providing technical direction.
  • Preferred / Nice-to-Have

  • Experience with Azure data platforms and modern analytics stacks.
  • Experience with Power BI semantic modeling (tabular concepts, metrics governance, deployment patterns).
  • Familiarity with governance and security concepts (cataloging, lineage, RBAC / ABAC, auditing, data classification).
  • Experience with modeling / documentation tooling (e.g., ERwin, SQLDBM, dbt docs, Lucidchart, etc.).
  • Understanding of master / reference data management concepts.
  • Core Competencies

  • Business-first modeling : You anchor models in real-world processes and user outcomes.
  • Pragmatic standardization : You establish standards that enable speed without sacrificing quality.
  • Clarity & documentation : You create models and definitions that others can trust and extend.
  • Collaboration & influence : You align stakeholders and lead through expertise.
  • Quality mindset : You prioritize correctness, reconciliation, repeatability, and reusability.
  • Technical Environment

  • Seniority level : Mid-Senior level
  • Employment type : Contract
  • Job function : Information Technology
  • Industries : IT Services and IT Consulting
  • #J-18808-Ljbffr

    Create a job alert for this search

    Data Data • Calgary, AB, CA

    Similar jobs
    Geometry Private Tutoring Jobs Okotoks

    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
    Data Project Manager - Akkodis

    Data Project Manager - Akkodis

    Akkodis • airdrie, ab, ca
    Temporary
    Data and Analytics Project Manager.Location : Calgary or Edmonton Hybrid.Length : Initial 12 month contract.We are seeking a highly organized and detail-oriented Data and Analytics Project Manager to...Show more
    Last updated: 3 days ago • Promoted
    Lead technique BI (back-end / ingénierie des données) - Technical Lead (back-end / data engineer) - calgary

    Lead technique BI (back-end / ingénierie des données) - Technical Lead (back-end / data engineer) - calgary

    Groupe Amiel • calgary, ab, ca
    Full-time
    Le siège social, moteur d’innovation où chaque projet prend forme grâce à une vision stratégique et des solutions modernes. Lead technique BI (back-end / ingénierie des données).Chez Groupe Amiel, nou...Show more
    Last updated: 16 hours ago • Promoted • New!
    Data Engineer - Flexstaf I.T. Inc.

    Data Engineer - Flexstaf I.T. Inc.

    Flexstaf I.T. Inc. • calgary, ab, ca
    Permanent
    We’re Hiring : Data Engineer (Permanent | Hybrid – Ontario).We are currently seeking a Data Engineer to join our growing data and analytics team. This role is ideal for a technically strong, curious,...Show more
    Last updated: 12 hours ago • Promoted • New!
    Data Scientist

    Data Scientist

    Targeted Talent • Calgary, AB, Canada
    Permanent
    We are looking for a Junior to Intermediate.Our client is a global enterprise company with a product that you've likely used. The role will be responsible for delivering high quality data scienc...Show more
    Last updated: 30+ days ago • Promoted
    Data Solutions Client Director

    Data Solutions Client Director

    Spaulding Ridge • Calgary, AB, Canada
    Full-time
    Spaulding Ridge is an advisory and IT implementation firm.We help global organizations get financial clarity into the complex, daily sales, and operational decisions that impact profitable revenue ...Show more
    Last updated: 8 days ago • Promoted
    Lead Product Designer

    Lead Product Designer

    Data Theorem • Calgary, AB, CA
    Full-time
    Quick Apply
    At Data Theorem, we’re building a next-gen SaaS platform for preventing data breaches.We’re passionate about helping organizations operate in the cloud securely and ensure t...Show more
    Last updated: 30+ days ago
    FinOps Data Analyst AWADC5715582

    FinOps Data Analyst AWADC5715582

    Compunnel Inc. • calgary, ab, ca
    Full-time
    Location : Monreal, QC (Hybrid Role).Drive adoption of Cloud FinOps capabilities and best practice for cloud cost management within the organization. Monitor, analyze, and report on cloud spend acros...Show more
    Last updated: 12 hours ago • Promoted • New!
    Machine Learning Engineer

    Machine Learning Engineer

    Iris Software Inc. • calgary, ab, ca
    Full-time
    Iris's direct client, one of the leading Fortune 500 Company, is looking to hire.Please take a look at the below mentioned job description and let me know if you would be interested.The following j...Show more
    Last updated: 1 day ago • Promoted
    Machine Learning Software Developer (2025-044)

    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
    Data Analyst

    Data Analyst

    Actalent • Calgary, AB, Canada
    Full-time
    Actalent's oil and gas client is looking for a long term data analyst to join their team in Calgary.They will be analyzing data on how they do projects, how they operate, and how this could imp...Show more
    Last updated: 1 day ago • Promoted
    Lead Data Engineer

    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: 29 days ago • Promoted
    Accounting Data Advisor

    Accounting Data Advisor

    Baker Tilly • Calgary, AB, Canada
    Permanent
    At Baker Tilly, we care about the impact you make.Thats why were invested in your growth from day onebecause the steps you take today define your tomorrow. We are currently seeking an experienced, m...Show more
    Last updated: 30+ days ago • Promoted
    Project Manager, Data & Analytics - Part Time Limited Term

    Project Manager, Data & Analytics - Part Time Limited Term

    Iteration Insights • Greater Calgary Metropolitan Area, Canada
    Part-time +1
    Project Manager, Data and Analytics – Part Time, Limited Term.Calgary, AB (Hybrid – primarily remote with occasional client onsite work) . Contract or Short-Term Employment .At Iteration Insights, w...Show more
    Last updated: 8 hours ago • Promoted • New!
    Data Analyst

    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
    UT / UTCD Data Analyst [Level 3] - Calgary, Canada

    UT / UTCD Data Analyst [Level 3] - Calgary, Canada

    Pipecare Group • Calgary, AB, Canada
    Full-time
    UT / UTCD Data Analyst [Level 3].By providing technology and service focused solutions to the international arena of the oil and gas industry, the PipeCare Group of companies has been helping our cus...Show more
    Last updated: 30+ days ago • Promoted
    Data Analyst - airdrie

    Data Analyst - airdrie

    InSync Systems • airdrie, ab, ca
    Temporary
    Must be legally entitled to work in Canada.This position is 100% onsite in downtown Calgary.The ideal candidate will focus on using data and automation to solve business problems and improve effici...Show more
    Last updated: 7 days ago • Promoted
    Data Analyst - Dexian

    Data Analyst - Dexian

    Dexian • calgary, ab, ca
    Full-time
    Data Governance Analyst - Rates Trading.Location : Mississauga, ON (Hybrid).Support the execution of Data Consent Order remediation programmes, contributing to delivery in line with regulatory commi...Show more
    Last updated: 17 hours ago • Promoted • New!