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

Data Modeler

Akkodis • Calgary, AB, CA
2 days 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: 4 days ago • Promoted
    Data Management Consultant

    Data Management Consultant

    Katalyst Data Management • Calgary, AB, Canada
    Full-time
    At Katalyst Data Management, we are dedicated to delivering innovative solutions that drive success for our clients.Our commitment to excellence and continuous improvement has established us as a l...Show more
    Last updated: 30+ days ago • Promoted
    Data Annotator - Morpheus Talent Solutions

    Data Annotator - Morpheus Talent Solutions

    Morpheus Talent Solutions • calgary, ab, ca
    Full-time +1
    Flexible, part-time or full-time hours.Our client, a fast-growing company working at the intersection of gaming and AI, is seeking. This is an excellent opportunity for candidates with strong attent...Show more
    Last updated: 8 hours ago • Promoted • New!
    ETL Developer - DataStage, PL / SQL, Shell Scripting

    ETL Developer - DataStage, PL / SQL, Shell Scripting

    Astra North Infoteck Inc. • Calgary, AB, ca
    Full-time
    Quick Apply
    ETL tools (DataStage preferred).Control-M, StoneBranch, or similar to manage batch processes.Monitor ETL jobs, perform root-cause analysis, and resolve production issues. Collaborate with business a...Show more
    Last updated: 9 days ago
    Remote Senior SQL Engineer - AI Trainer

    Remote Senior SQL Engineer - AI Trainer

    SuperAnnotate • Okotoks, Alberta, CA
    Remote
    Full-time
    As a Senior SQL Engineer, you will work remotely on an hourly paid basis to review AI-generated SQL queries, database designs, and data-processing logic, as well as generate high-quality reference ...Show more
    Last updated: 26 days ago
    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: 2 days ago • Promoted
    Data Scientist

    Data Scientist

    Helcim • Calgary, AB, Canada
    Full-time
    Helcim was founded with a mission at heart : to be the worlds most loved payment system.We believe that by offering small businesses in North America a decidedly human payment solution where it is e...Show more
    Last updated: 30+ days 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: 30+ days ago • Promoted
    EMAT Data Analyst Level 3 - Canada

    EMAT Data Analyst Level 3 - Canada

    Pipecare Group • Calgary, AB, CA
    Full-time
    Quick Apply
    PIPECARE Group is currently looking for EMAT Data Analyst Level 3 to join our team in Calgary, Canada.By providing technology and service focused solutions to the international ar...Show more
    Last updated: 30+ days ago
    R Developer

    R Developer

    Targeted Talent • Calgary, AB, Canada
    Permanent
    We are looking for an experienced.Our client is a fintech company based out of Vancouver.Years experience working in Data Engineering / Data Science utilizing R (purrr, tidyr, dplyr, tibble, & th...Show more
    Last updated: 30+ 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
    Market Research Data Analyst

    Market Research Data Analyst

    The Wohl Group - Recruitment Made Easy! • Calgary, AB, Canada
    Full-time
    Research and analyze global and regional environments and markets for our aircrafts, with a focus on aerial firefighting, emergency response, and special mission operations.Gather, interpret, and s...Show more
    Last updated: 5 days ago • Promoted
    Dayforce HCM Implementation Consultant

    Dayforce HCM Implementation Consultant

    PayTech • calgary, ab, ca
    Full-time
    Note : Dayforce XML and SQL programming knowledge.Dayforce Data Conversion knowledge - - Dayforce Consulting Experience Required. We are seeking a Data Integration & Export Specialist with hands-on e...Show more
    Last updated: 22 days ago • Promoted
    Senior Lead Clinical Data Manager

    Senior Lead Clinical Data Manager

    Warman O'Brien • calgary, ab, ca
    Permanent
    Senior Lead Clinical Data Manager – Top CRO – Fully Remote – Permanent.My client is a global CRO who have revolutionized the field of data science and are rapidly expanding their data management te...Show more
    Last updated: 22 days ago • Promoted
    BAS Designer

    BAS Designer

    Ainsworth Inc. • Calgary, AB, Canada
    Full-time
    If you thrive in a team-oriented workplace that challenges your skills, to drive your career development, embraces diversity and rewards innovation, with competitive pay and great employee programs...Show more
    Last updated: 30+ days ago • Promoted
    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
    Data Scientist

    Data Scientist

    Actalent • Calgary, AB, Canada
    Full-time
    The Data Scientist will leverage modern AI / ML technologies to develop applications that address challenges in process and equipment reliability, as well as optimization within process industries.Th...Show more
    Last updated: 10 days ago • Promoted