Business Intelligence Data Modeller, Clio

CA$82.8-112.1k

SQL
Tableau
Looker
Redshift
Git
dbt
Mid and Senior level
Toronto
Vancouver
Clio

Legal practice management software

Job no longer available

Clio

Legal practice management software

1001+ employees

B2BSecurityComplianceLegalSaaS

Job no longer available

CA$82.8-112.1k

SQL
Tableau
Looker
Redshift
Git
dbt
Mid and Senior level
Toronto
Vancouver

1001+ employees

B2BSecurityComplianceLegalSaaS

Company mission

Clio's mission is to build cloud-based and client-centred technology that will transform the legal experience for all.

Role

Who you are

  • An undergraduate or graduate degree in a relevant quantitative discipline (computing science, statistics, mathematics, etc.)
  • 3+ years applied experience in business intelligence and/or data modeling
  • Proficiency in database modeling, SQL, and data warehousing principles
  • Proficiency in understanding business requirements and translating them to data sets in a data warehouse
  • Experience with version control concepts and tools (Git)
  • Experience building data models and sets to be consumed for reporting and analytics using dbt
  • Familiar with concepts involving data modeling techniques such as Star schema and knowledge of Normalization/DeNormalization concepts
  • Experience building analytics to drive operational efficiency and/or impact revenue (e.g., renewal models, TAM, churn analysis)
  • Proficiency with data visualization and data storytelling
  • Excellent written and verbal communication skills

Desirable

  • Have experience working with Redshift or other cloud data warehouses
  • Are an expert translating technical solutions to non-technical stakeholders
  • Proven experience with one or several cloud based business intelligence tools, incl. Tableau, PowerBI, and Looker

What the job involves

  • We are looking for someone who takes data seriously, thrives in a rapid-growth, high-velocity environment, and someone who lives and breathes their values
  • You will own our analytics infrastructure and be responsible for collecting, managing, and analyzing data to develop insights and recommendations to enable the business to take action and make better decisions
  • You will drive new analytics projects, maintain and evolve existing reporting and dashboards, respond to incoming data requests, and implement data best practices and processes for consistency and scalability
  • Partnering with stakeholders, self-serve report creators, data scientists, and data engineers, to create meaningful, intentional data solutions
  • Creating and editing data models for users to answer business questions and optimize queries and reports for performance
  • Decoupling analytics logic from BI dashboards and create unified data models using dbt that can be used to answer specific business questions
  • Similar to the above responsibility, in order to drive new analytics projects, envisioning and delivering data sets that encompass key data points for core business subject areas, such as customer success, and revenue operations
  • Understanding in-depth functioning of the business and how metrics related to business performance and leveraging your technical expertise and business acumen to make it easy for stakeholders to understand data
  • Maintaining and evolving existing reporting and dashboards, responding to incoming data requests, and implementing data best practices and processes for consistency and scalability
  • Effectively communicating findings and feedback to technical and non-technical stakeholders
  • Working with the Business Intelligence Manager to govern our BI environment to empower our self serve stakeholders leveraging data and dashboards
  • Working with the Business Intelligence Manager to proactively identify and resolve gaps in training, learning resources, and other roadblocks preventing stakeholders from leveraging data for decision making
  • Working closely with the data engineering team, software developers, and/or 3rd party vendors to turn newly acquired raw data into a report/analysis -ready shape

Otta's take

Sam Franklin headshot

Sam Franklin

CEO of Otta

Modern law firms increasingly manage their work digitally but the lack of a specialised remote solution means that workflows have become fragmented. This leads to legal practice managers having to juggle multiple software solutions across various devices.

Clio provides a legal practice management platform designed for law firms, allowing users to manage billing for legal aid cases, access and manage documents and store files across multiple devices. Whilst other startups are operating in this niche, Clio has uniquely focussed on synchronisation across remote devices and on a wide range of integrations, allowing the user to access information from other industry standard software such as Xero and Klyant from within a single interface.

Clio has raised a large amount of investment capital, most recently in a 2021 Series E round which saw the company attain unicorn status with a valuation exceeding $1 billion. This funding is being used to accelerate its product development, hire additional talent, and for expansion into new markets with a focus on the EMEA region, particularly the UK and Ireland.

Insights

Some candidates hear
back within 2 weeks

Company

Company benefits

  • Company equity
  • $500 contribution when you become a parent and/or guardian
  • 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
  • RRSP-matching

Company values

  • Giving Back - we’re committed to creating positive social change in the community
  • Creating Better Work Environments - we believe that a diverse and inclusive culture is a competitive advantage that benefits both our employees and customers
  • Thriving as a Team - we live by seven core values on how to thrive, have fun, and win as a team

Founders

Experience as Director of Product Development for Chenomx Inc. from 2004 to 2009. Advisor for Logikcull.com, dealcloser, and Athennian.

Rian Gauvreau

(Board Member)

Experience developing legal technology for Gowling Lafleur Henderson LLP from 2000 to 2008. Graduated the University of British Columbia with an M.B.A. in Strategic Management in 2011.

Salary benchmarks

We don't have enough data yet to provide salary benchmarks for this role.

Submit your salary to help other candidates with crowdsourced salary estimates.

Share this job

View 48 more jobs at Clio