Data Modeller: Build AI-Ready Data Models

Clio; Vancouver; Hybrid; CAD 94,000 - 127,000; Full time

Benefits offered by this job

Top-tier health benefits

Dental & vision insurance

RRSP matching

RESP contribution

Counseling benefit

Job summary

Clio is seeking a Data Modeller to join the Data Modelling team within the Data Insights Group. The role focuses on backend data modelling, building scalable models to power analytics, reports, and AI-ready datasets.

The successful candidate will have 2–4 years in analytics engineering, deep SQL skills, and experience with cloud data warehouses. Hybrid work setup in Vancouver, Calgary, or Toronto with collaboration across Product, Finance, and Data Engineering.

Qualifications

• 2–4 years of experience in analytics engineering or data modelling, 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.
• Solid understanding of dimensional modelling and data warehousing concepts, with familiarity working in cloud data warehouses (Databricks, Redshift, Snowflake).
• Experience with transformation frameworks like dbt is a plus, but strong SQL/database fundamentals are sufficient.

Responsibilities

• Design, build, and maintain scalable data models transforming raw data into reusable models using dbt or similar tools.
• Partner with Product, Revenue Operations, Finance, Data Engineering, and stakeholders to translate business questions into trusted datasets.
• Ensure data quality with automated tests, monitoring, and validation for freshness and schema stability.
• Promote data modelling standards, documentation, and governance across the analytics ecosystem.
• Leverage AI-powered development tools to accelerate data modeling and improve code quality.

Skills

Analytics engineering

Data modeling

SQL

Python

dbt

Cloud data warehousing

Tools

Databricks

Redshift

Snowflake

Looker

VS Code

Claude Code

GitHub Copilot

dbt

Job description

Clio is seeking a Data Modeller to join the Data Modelling team within the Data Insights Group. The role focuses on backend data modelling, building scalable models to power analytics, reports, and AI-ready datasets.

The successful candidate will have 2–4 years in analytics engineering, deep SQL skills, and experience with cloud data warehouses. Hybrid work setup in Vancouver, Calgary, or Toronto with collaboration across Product, Finance, and Data Engineering.