Data Modeling Co-op

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:

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

What Youll Do

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

What You Bring

Required

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

Nice to Have

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

What Youll Learn

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

About the Team

Youll join the Data Insights team within Clios Business Operations organization. The team owns Clios 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. Youll be supported by experienced data modelers and have a clear mandate to contribute real work from day one.

Details

• Duration: 8 months from Sept 2026-Apr 2027 (co-op)

• Location: Vancouver or Toronto- Hybrid

This is a new role.

What you will find here:

Compensation is one of the main components of Clios 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.

The expected new hire base pay for this role is $46000 CAD.

Diversity Inclusion Belonging and Equity (DIBE) & Accessibility

Our team shows up as their authentic selves and are united by our mission. We are dedicated todiversity 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 a Human and High Performing AI company meaning we use artificial intelligence to improve all of our recruitment AI helps us streamline the process for greater efficiency. However weve 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 @ email addresses.

Employment Type : Full-Time
Experience: years
Vacancy: 1