Senior Data Modeller, Business Intelligence
We are currently looking for a new Sr. Data Modeller to join our Business Intelligence team in one of our Vancouver, Calgary, or Toronto locations. Some exceptions for remote work in Canada may apply.
What your team does:
Our Business Intelligence team is part of the larger Data & AI group. Together, we’re focused on stewarding a scientific culture to drive better decisions. Along with the Manager of Business Intelligence, you will be working across departments to empower all stakeholders to make better decisions through data-oriented solutions, with a focus on making data easy and accessible at Clio. You will help our business grow, help our customers succeed, and continuously improve the way we operate.
Who you are:
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. We’re looking for an innovator and a thought leader! We’re looking for someone who is:
Passionate about driving growth empirically;
Always looking to innovate with data and explore open-ended questions;
Strategically minded and never shies away from a challenge;
Self-motivated and able to work autonomously and collaboratively;
Agile and responsive, and comfortable with constant change.
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.
What you’ll work on:
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.
What you may have:
An undergraduate or graduate degree in a relevant quantitative discipline (computing science, statistics, mathematics, etc.);
6+ 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);
Python for data analysis and creating data pipelines;
Experience building data models and sets to be consumed for reporting and analytics using dbt;
Experience with 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.
Serious bonus points if you:
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 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:
The expected salary range* for similar roles within Clio is: $105,800.00 - $146,300.00
Competitive, equitable salary with top-tier health benefits, dental, and vision insurance
Hybrid work environment, with expectation for local Clions (Vancouver, Calgary, Toronto, and Dublin) to be in office min. once per week on our Anchor Day
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
Please note that the expected new hire salary range provided is derived from a group of like roles within Clio. 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 to diversity, 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 at clio.com/careers