Data Modeller (12 Month Contract)

Join Clio, a leading legal technology company, as a Data Modeller. In this role, you will be part of the Business Operations Team and will work on building trusted, scalable data products that empower teams across the organization to make informed decisions. You will collaborate with various stakeholders, ensure data quality and reliability, promote data modeling best practices, and leverage AI to improve productivity. This is a 12-month contract position available to applicants based in Vancouver, Calgary, or Toronto.

• Concevoir, construire et maintenir des modèles de données évolutifs, en transformant des données brutes et complexes en modèles de données réutilisables.
• Collaborer avec les parties prenantes pour traduire les questions commerciales en ensembles de données fiables, et présenter des concepts techniques de manière claire et actionable.
• Développer des tests automatisés, des outils de surveillance et de validation pour garantir la fraîcheur des données, la stabilité du schéma et l'exactitude de la logique.

• 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
• 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
• 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
• Solid understanding of dimensional modeling and data warehousing concepts, with familiarity working in cloud data warehouses (e.g., Databricks, Redshift, or Snowflake)
• 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
• 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