Data Architect
Job Summary
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:
Role Overview
Clio is hiring a Data Architect to design build and govern the data foundations that power company reporting analytics and our AI-first initiatives. Youll 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.
Key Responsibilities
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 casesingestion embedding RAG and model-centric data plumbingand 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.
What were looking for must-have
5 years experience in data architecture data modeling analytics engineering or a related role building production data models and semantic layers.
SQL expert. Able to write efficient maintainable SQL for complex transformations and to optimize performance in a cloud warehouse.
Hands-on experience with dbt (or equivalent) and Git/CICD for data transformations and model deployment.
Proven track record designing metrics/semantic layers and ensuring a single source of truth for business definitions.
Experience with observability & lineage tooling or designing data quality and audit processes for analytic/ML outputs.
Strong cross-functional communication skills; comfortable translating ambiguous business questions into reliable data artifacts and enabling non-technical consumers.
Nice-to-have
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.
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:
Competitive equitable salary with top-tier health benefits dental and vision insurance
Hybrid work environment with expectation for local Clions (Vancouver Calgary Toronto Dublin London New York City and Sydney) to be in office min. twice per week.
Flexible time off policy with an encouraged 20 days off per year.
$2000 annual counseling benefit
RRSP matching and RESP contribution
Clioversary recognition program with special acknowledgement at 3 5 7 and 10 years
*Our salary bands are designed to reflect the range of skills and experience needed for the position and to allow room for growth at Clio. For experienced individuals we typically hire at or around the midpoint of the band. The top portion of the salary band is reserved for employees who demonstrate sustained high performance and impact at Clio. Those who are new to the role may join below the midpoint and develop their skills over time. The final offer amount for this role will be dependent on geographical region applicable experience and skillset of the candidate.
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.
Disclaimer: We only communicate with candidates through official @ email addresses.
Required Experience:
Staff IC
About Company
Run your law firm with Clio, the #1 choice of legal professionals for managing clients, cases, billing, and more. Try it for free today—no credit card required.