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 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. What You’ll 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 You’ll 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 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. 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 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. The expected new hire base pay for this role is $46,000 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 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. About Clio Clio is on a mission to transform the legal experience for all. Clio is the global leader in legal AI, building the platform that powers the future of legal work. With the scale, data, and ambition to redefine how the legal industry operates, we are advancing a comprehensive strategy that spans the full lifecycle of legal work—from knowledge and insight to execution and outcomes. At the center of this vision is the Intelligent Legal Work Platform, the legal industry’s first System of Action. By combining Clio’s core product suite with Clio Work and AI-native capabilities, the platform turns information into insight and insight into action. As we expand into the enterprise, Clio for Enterprise extends this foundation to support the complexity, scale, and operational rigor of global organizations through solutions like Clio Operate and Vincent by Clio. Backed by industry-leading data and intelligence, Clio is building the infrastructure that enables legal teams to operate with greater speed, confidence, and impact. Clio’s leadership and momentum have been recognized globally. In 2022, we achieved Centaur status, a milestone reached by fewer than 200 private SaaS companies worldwide. We are a proud honoree of the Forbes Cloud 100 and Fortune’s Future 50, have been named Innovator of the Year, and are a Platinum Club member of Canada’s Best Managed Companies. We are consistently recognized as one of Canada’s Top 100 Employers and a Top Employer for Young People, with our international offices also earning placements on Great Place to Work’s Best Workplaces lists. Headquartered in Vancouver, Canada, Clio has grown to more than 2,000 employees across offices in Toronto, Calgary, Dublin, Manchester, Sydney, Barcelona, and Bogotá—bringing together diverse perspectives to solve one of the world’s most complex and impactful professional challenges. Join Clio and help define the future of legal work through AI. Learn more at clio.com/careers.