• Clio is hiring a Data Architect to design, build, and govern the data foundations that power company reporting, analytics, and our AI-first initiatives
• You’ll turn raw product and business data (structured and unstructured) into high-quality, documented, and governed datasets and a semantic layer that enables analysts, data scientists, and AI agents to trust a single source of truth
• This is a hands-on senior engineering role that blends deep SQL and modeling expertise with product sense, cross-functional collaboration, and ownership for standards and observability
• Design & deliver modular, production-grade data models: Translate raw data into well-tested, performant datasets and reusable building blocks for downstream consumers (analytics, dashboards, ML)
• Build and govern the semantic layer: Define and maintain standardized business metrics and semantic objects so teams and AI systems share a single source of truth
• AI data strategy & unstructured data tooling: Design data lifecycles for AI use cases—ingestion, embedding, RAG, and model-centric data plumbing—and convert unstructured signals (transcripts, documents, emails) into AI-ready assets
• Model observability & lineage. Implement monitoring, lineage, and auditability so we can trace what data influenced an analytic or AI output and detect data quality regressions
• Governance & cross-team enablement. Partner with Data Engineering, RevOps, Product, and other stakeholders to set modeling standards, manage dbt access and ownership boundaries, and enable “self-service” analytics across the company
• Engineering best practices. Apply software engineering principles to the data stack: dbt or similar transformation frameworks, Git, CI/CD, environments (dev/stage/prod), testing, and code review
• Mentorship & standards. Help grow the team by setting modeling standards, reviewing peer work, and mentoring junior modelers/analysts

Benefits

• Company equity
• 401k
• $500 contribution when you become a parent and/or guardian
• RRSP-matching
• Pension plans
• 4-week minimum vacation
• Work from home when you need to (role-specific)
• Parental leave options for moms and dads
• Customizable extended health benefits (including $2000 per year to spend on counseling)
• Wellness programs including an onsite naturopath physiotherapist, and RMT (location-dependent), healthy snacks, and exercise classes- Hands-on experience with dbt (or equivalent) and Git/CICD for data transformations and model deployment
• SQL expert. Able to write efficient, maintainable SQL for complex transformations and to optimize performance in a cloud warehouse
• Experience with observability & lineage tooling, or designing data quality and audit processes for analytic/ML outputs
• 5+ years experience in data architecture, data modeling, analytics engineering, or a related role building production data models and semantic layers
• Strong cross-functional communication skills; comfortable translating ambiguous business questions into reliable data artifacts and enabling non-technical consumers
• Proven track record designing metrics/semantic layers and ensuring a “single source of truth” for business definitions
• Experience working with AI/LLM workflows (RAG, embeddings, fine-tuning) or converting unstructured data into embeddings and retrieval assets
• Familiarity with cloud warehouses (Snowflake, BigQuery, Databricks) and reverse-ETL patterns
• Experience owning or contributing to data governance frameworks and enabling broad dbt access across functional teams