Data Modeller (12 Month Contract)

Clio

Vancouver, Calgary, Toronto

Hybrid

CAD 94,000 - 127,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Hybrid work environment
20 days off per year
Counseling benefit
RRSP matching

Job summary

Clio is seeking a Data Modeller to join our Business Operations Team. This role can be based in Vancouver, Calgary, or Toronto, and offers a hybrid work environment with local colleagues in key Canadian cities.

You will design, build, and maintain scalable data models, partnering with Product, Revenue Operations, and Data Engineering to deliver trusted datasets that empower self-service analytics and AI-ready data products.

Qualifications

  • 2–4 years of experience in analytics engineering or data modelling.
  • Deep SQL skills and experience with databases/data warehouses; Python is a plus.
  • Familiarity with cloud data warehouses (Databricks, Redshift, Snowflake).
  • Experience with dbt or similar transformation tools is an asset.
  • Ability to translate business requirements into reusable data models and collaborate with stakeholders.
  • Fluency with AI-powered development tools and automation to accelerate data modeling.

Responsibilities

  • Design, build, and maintain scalable data models using dbt or similar tools.
  • Collaborate with Product, Revenue Operations, Finance, and Data Eng to translate questions into datasets.
  • Develop tests, monitoring, and validation for data freshness and quality.
  • Contribute to standards, documentation, and governance for analytics.
  • Leverage AI development tools to improve productivity and data pipelines.

Skills

SQL
Data modelling
Analytics engineering
AI tools

Tools

dbt
Databricks
Redshift
Snowflake
Looker

Job description

Clio is the global leader in legal AI technology, empowering legal professionals and law firms of every size to work smarter, faster, and more securely.

We are currently seeking a Data Modeller to join our Business Operations Team. This role is available to applicants based in Vancouver, Calgary, or Toronto.


Who you are:

We are looking for someone who is passionate about data and enjoys solving business problems through thoughtful, scalable data solutions. You thrive in a collaborative, fast-paced environment and are excited to partner with technical and non-technical stakeholders to make data more accessible, trustworthy, and actionable.


You are curious, detail-oriented, and continuously looking for ways to improve how data is modelled, governed, and consumed. You enjoy learning new technologies—including AI-powered development tools—and applying them to improve productivity and deliver better outcomes.


What your team does:

Our Data Modelling team is part of the broader Data Insights Team. We build trusted, scalable data products that empower teams across Clio to make informed decisions. By transforming complex data into reusable, well-governed models, we enable self-service analytics, operational reporting, product insights, and emerging AI initiatives.


What you'll work on:
  • Design, build, and maintain scalable data models: Transform raw and complex data into well-tested, reusable data models using dbt (or similar tools) that support analytics, dashboards, operational reporting, self-service analytics, and AI-ready data products.
  • Partner with stakeholders and communicate clearly: Collaborate with Product, Revenue Operations, Finance, Data Engineering, and business stakeholders to translate business questions into trusted datasets, and present technical concepts and findings in a way that is clear and actionable for both technical and non-technical audiences.
  • Ensure data quality and reliability: Develop automated tests, monitoring, and validation to ensure data freshness, schema stability, and logic accuracy, and to proactively resolve data quality issues.
  • Promote data modeling best practices: Contribute to standards, documentation, and governance that improve consistency, scalability, and long-term maintainability across the analytics ecosystem.
  • Leverage AI to improve productivity: Use AI-powered development tools and assistants to accelerate data modeling, improve code quality, and contribute to AI-ready data pipelines and workflows.

What you bring:
  • 2–4 years of experience in analytics engineering or data modeling, ideally in SaaS, building and maintaining production data models from raw source data across multiple systems.
  • Deep SQL skills and hands-on experience working directly in databases and data warehouses, with Python or a similar language an asset. This role is focused on the backend modeling layer rather than visualization or dashboard building.
  • Solid understanding of dimensional modeling and data warehousing concepts, with familiarity working in cloud data warehouses (e.g., Databricks, Redshift, or Snowflake).
  • Experience building data models with dbt or a similar transformation framework is an asset, though not required if you bring strong SQL and database fundamentals.
  • Ability to translate business requirements into reusable data models and collaborate effectively with technical and non-technical stakeholders.
  • Fluency working with AI-powered development tools—such as VS Code, Claude Code, and similar assistants—and the ability to apply skills, agents, and automation to accelerate data modeling work.

Bonus points if you have:
  • Experience with Looker or other modern BI platforms.
  • Experience implementing data quality testing and monitoring frameworks.
  • Experience supporting self-service analytics
  • Experience working with AI-assisted development tools such as GitHub Copilot, Cursor, or similar technologies.
  • Exposure to building data products that support machine learning or generative AI applications.

Clio is the global leader in legal AI technology, empowering legal professionals and law firms of every size to work smarter, faster, and more securely.

We are transforming the legal experience for all by bettering the lives of legal professionals while increasing access to justice .

Summary:

We are currently seeking a Data Modeller to join our Business Operations Team. This role is available to applicants based in Vancouver, Calgary, or Toronto.


Who you are:

We are looking for someone who is passionate about data and enjoys solving business problems through thoughtful, scalable data solutions. You thrive in a collaborative, fast-paced environment and are excited to partner with technical and non-technical stakeholders to make data more accessible, trustworthy, and actionable.


You are curious, detail-oriented, and continuously looking for ways to improve how data is modelled, governed, and consumed. You enjoy learning new technologies—including AI-powered development tools and applying them to improve productivity and deliver better outcomes.


What your team does:

Our Data Modelling team is part of the broader Data Insights Team. We build trusted, scalable data products that empower teams across Clio to make informed decisions. By transforming complex data into reusable, well-governed models, we enable self-service analytics, operational reporting, product insights, and emerging AI initiatives.


What you'll work on:
  • Design, build, and maintain scalable data models: Transform raw and complex data into well-tested, reusable data models using dbt (or similar tools) that support analytics, dashboards, operational reporting, self-service analytics, and AI-ready data products.
  • Partner with stakeholders and communicate clearly: Collaborate with Product, Revenue Operations, Finance, Data Engineering, and business stakeholders to translate business questions into trusted datasets, and present technical concepts and findings in a way that is clear and actionable for both technical and non-technical audiences.
  • Ensure data quality and reliability: Develop automated tests, monitoring, and validation to ensure data freshness, schema stability, and logic accuracy, and to proactively resolve data quality issues.
  • Promote data modeling best practices: Contribute to standards, documentation, and governance that improve consistency, scalability, and long-term maintainability across the analytics ecosystem.
  • Leverage AI to improve productivity: Use AI-powered development tools and assistants to accelerate data modeling, improve code quality, and contribute to AI-ready data pipelines and workflows.

What you bring:
  • 2–4 years of experience in analytics engineering or data modeling, ideally in SaaS, building and maintaining production data models from raw source data across multiple systems.
  • Deep SQL skills and hands-on experience working directly in databases and data warehouses, with Python or a similar language an asset. This role is focused on the backend modeling layer rather than visualization or dashboard building.
  • Solid understanding of dimensional modeling and data warehousing concepts, with familiarity working in cloud data warehouses (e.g., Databricks, Redshift, or Snowflake).
  • Experience building data models with dbt or a similar transformation framework is an asset, though not required if you bring strong SQL and database fundamentals.
  • Ability to translate business requirements into reusable data models and collaborate effectively with technical and non-technical stakeholders.
  • Fluency working with AI-powered development tools—such as VS Code, Claude Code, and similar assistants—and the ability to apply skills, agents, and automation to accelerate data modeling work.

Bonus points if you have:
  • Experience with Looker or other modern BI platforms.
  • Experience implementing data quality testing and monitoring frameworks.
  • Experience supporting self-service analytics
  • Experience working with AI-assisted development tools such as GitHub Copilot, Cursor, or similar technologies.
  • Exposure to building data products that support machine learning or generative AI applications.
This role is a backfill for an existing position.

What you will find here:

Compensation is one of the main components of Clio’s Total Rewards Program. We have developed a series of programs and processes to ensure we are creating fair and competitive pay practices that form the foundation of our human and high-performing culture.

Some highlights of our Total Rewards program include:

  • Competitive, equitable salary with top-tier health benefits, dental, and vision insurance

  • Hybrid work environment, with expectation for local Clions (Vancouver, Calgary, Toronto, Dublin, London, New York City and Sydney) to be in office min. twice per week.

  • Flexible time off policy, with an encouraged 20 days off per year.

  • $2000 annual counseling benefit

  • RRSP matching and RESP contribution

  • Clioversary recognition program with special acknowledgement at 3, 5, 7, and 10 years

The expected salary range for this role is $93,700 to $126,700 CAD. Initial placement within the range is informed by geographic region, experience, and skillset, with room to progress as impact and tenure grow. Final offer amounts will vary based on candidate profile.

Diversity, Inclusion, Belonging and Equity (DIBE) & Accessibility

Our team shows up as their authentic selves, and are united by our mission. We are dedicated to diversity, equity and inclusion . We pride ourselves in building and fostering an environment

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer
Senior Data Engineer

Clio • Toronto

Hybrid
CAD 157,000 - 213,000
Health benefits
Dental insurance
Vision insurance
+6
Senior Data Engineer
Senior Data Engineer

VLEX NETWORKS • Toronto

Hybrid
CAD 157,000 - 213,000
Health benefits
Dental and vision insurance
Hybrid work environment
+4
Senior Manager, Talent Development & Learning (13 Month Contract)
Senior Manager, Talent Development & Learning (13 Month Contract)

Clio • Calgary

Hybrid
CAD 137,000 - 206,000
Competitive salary
Hybrid work environment
Flexible time off
+3
Senior Machine Learning Engineer
Senior Machine Learning Engineer

Clio • Toronto, Calgary, Burnaby

Hybrid
CAD 155,000 - 209,000
Hybrid work environment
20 days off per year
$2000 annual counseling benefit
+3
Manager, Machine Learning (Canada)
Manager, Machine Learning (Canada)

Clio • Vancouver, Calgary, Toronto

Hybrid
CAD 181,000 - 272,000
Top-tier health benefits
Hybrid work with in-office twice pera
20 days paid time off
+4
Senior Systems Specialist, FP&A
Senior Systems Specialist, FP&A

Clio • Quebec

Hybrid
CAD 117,000 - 158,000
Hybrid work environment
Top-tier health benefits
RRSP matching and RESP contribution
+2
Senior Machine Learning Engineer
Senior Machine Learning Engineer

Themis Solutions Inc. • Burnaby

Hybrid
CAD 155,000 - 209,000
Top-tier health benefits
Hybrid work environment
20 days off per year
+2
Senior R&D Operations Specialist
Senior R&D Operations Specialist

Clio • Burnaby, Calgary, Toronto

Hybrid
CAD 127,000 - 172,000
Competitive salary
Hybrid work environment
Medical, dental, and vision coverage
+3
Pricing Analyst
Pricing Analyst

Clio • Toronto, Vancouver, Calgary

Hybrid
CAD 97,000 - 132,000
Health benefits
Dental insurance
Vision insurance
+3
Senior Financial Analyst
Senior Financial Analyst

Clio • Toronto

Hybrid
CAD 102,000 - 138,000
Competitive salary with top-tier heath
Hybrid work environment with in-office
Flexible time off policy: 20 days
+3