Vancouver, British Columbia, Canada
Onsite
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.
Clio is looking for a Data Modeling Co-op to join our Data Insights team for an 8-month term. You will work alongside senior analytics engineers to build and maintain the data models that power Clio’s business intelligence, reporting, and data products. This is a hands-on role — you will write real dbt models, contribute to our production data warehouse, and collaborate directly with business stakeholders.
This role is ideal for a student who is curious about how data powers business decisions and wants to go beyond dashboards to understand the engineering underneath.
Build and maintain dbt models that transform raw source data into clean, tested, and well-documented datasets for downstream use by analysts, BI tools, and business stakeholders.
Write and optimize SQL queries to answer business questions and support ad hoc data requests.
Contribute to data quality by writing dbt tests and helping monitor data freshness and accuracy.
Partner with team members across Data Engineering, BI, and business units to understand requirements and translate them into data models.
Help document data assets — model descriptions, column-level metadata, and business definitions — to support self-service analytics.
Participate in code reviews and apply software engineering best practices (Git, pull requests, CI/CD) to data work.
Support ongoing projects across areas like revenue modeling, product usage analytics, or go-to-market data pipelines, depending on team priorities during your term.
Enrolled in a degree program in Computer Science, Data Science, Statistics, Engineering, or a related field.
Solid SQL skills — comfortable writing queries with JOINs, aggregations, and CTEs.
Familiarity with at least one programming or scripting language (Python preferred).
Ability to work independently, ask good questions, and communicate clearly with teammates.
Genuine interest in how data is structured and how it powers business decisions.
Exposure to dbt (Core or Cloud) — even from a course, tutorial, or personal project.
Experience with a cloud data warehouse (Databricks, Snowflake, BigQuery, or Redshift).
Familiarity with BI tools such as Looker, Tableau, or Power BI.
Understanding of data modeling concepts (star schemas, fact/dimension tables).
Experience with Git and version control workflows.
How to build production-grade data models using dbt in a real enterprise environment.
How analytics engineering bridges the gap between raw data and business intelligence.
Best practices in data testing, documentation, and governance.
How to work with cross-functional stakeholders to translate business questions into data requirements.
How a high-growth SaaS company uses data to drive decisions across revenue, product, and go-to-market.
You’ll join the Data Insights team within Clio’s Business Operations organization. The team owns Clio’s core data models, semantic layer, and business metrics — the foundational data infrastructure used by every part of the business. We care deeply about code quality, documentation, and making data trustworthy and accessible. You’ll be supported by experienced data modelers and have a clear mandate to contribute real work from day one.
Duration: 8 months, from Sept 2026-Apr 2027 (co-op)
Location: Vancouver or Toronto- Hybrid
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:
Hybrid work environment, with expectation for local Clions (Vancouver, Calgary, Toronto, Dublin and Sydney) to be in office minimum twice per week.
4% vacation pay for hours worked.
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 where our teams feel included, valued, and enabled to do the best work of their careers, wherever they choose to log in from. We believe that different perspectives, skills, backgrounds, and experiences result in higher-performing teams and better innovation. We are committed to equal employment and we encourage candidates from all backgrounds to apply.
Clio provides accessibility accommodations during the recruitment process. Should you require any accommodation, please let us know and we will work with you to meet your needs.
Learn more about our culture at clio.com/careers
We're a Human and High Performing AI company, meaning we use artificial intelligence to improve all of our operations. In recruitment, AI helps us streamline the process for greater efficiency. However, we've built our systems to ensure that a human always reviews AI-generated output, and we never make automated hiring decisions.
Disclaimer: We only communicate with candidates through official @clio.com email addresses.
Want to know if this job is worth applying to?