Intern Databricks Data Engineer Jobs in Calgary, AB

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

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

What we're 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.

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:

• 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

The expected salary range* for this role is $109,100 to $128,400 to $147,700 CAD. There are a separate set of salary bands for other regions based on local currency.

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

Learn more about our culture atclio.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.