Senior Business Analytics Lead

Build your Career at Cooper Equipment Rentals

We are looking for customer-oriented, motivated individuals to join our professional team.

Please note, to be considered for this position applicants should currently be residing in Canada and legally entitled to work.

Why Work with Us? Perks!

• Competitive salary
• Excellent benefit package with premiums paid by the company
• RRSP Match
• Safety-minded organization
• Stable, year-round employment
• Continuous training, learning and development opportunities
• Fun-loving work environment with strong social responsibility

Role Overview

We are seeking a Senior Business Analytics Lead to turn important business problems into high-quality analytics solutions across Cooper Equipment Rentals. We are expanding an enterprise analytics environment on Microsoft Fabric, with OneLake, Lakehouse, Direct Lake semantic models, shared governance standards, and a growing semantic layer supporting enterprise reporting and AI-assisted analytics.

You will work directly with business stakeholders to understand the decisions they need to make, challenge proposed approaches where appropriate, and determine what should be built. You will then help deliver the solution hands-on across data transformation, semantic models, and Power BI reporting, using AI tools such as ChatGPT and Claude to accelerate development while critically validating the result.

This is a senior individual-contributor role with end-to-end ownership of analytics solutions; it is not a people-management position.

Key Responsibilities

• Partner with business stakeholders to understand problems, decision needs, and analytical questions - not simply implement predefined report requirements.

• Translate business problems into analytical solutions, defining the right measures, dimensions, business rules, comparisons, drill paths, and report experience.

• Design and build enterprise semantic models and Power BI reports that are intuitive, reusable, performant, secure, and aligned to clear business definitions.

• Use ChatGPT, Claude, and other AI tools to rapidly create, modify, refactor, document, and test analytics solutions while critically validating their output.

• Work with source-controlled Power BI artifacts such as TMDL and PBIP/PBIR, alongside Git-based development and deployment practices.

• Develop analytical transformations in Fabric using SQL, Fabric notebooks, Spark SQL, and PySpark where appropriate, partnering with data engineering on larger platform needs.

• Design Direct Lake solutions and make sound choices between Direct Lake, Import, DirectQuery, and composite patterns based on business and technical requirements. Diagnose data, model, DAX, performance, security, and usability issues, including problems in AI-generated implementations.

• Raise standards for analytics solution design, semantic modelling, metadata, documentation, security, testing, source control, and release management.

Qualifications & Skills

• Minimum of 5 years of experience delivering enterprise BI or analytics solutions, with strong hands-on Power BI experience.

• Excellent business and analytical problem-solving skills, including turning loosely defined questions into useful, decision-oriented analytical products.

• Strong dimensional and semantic modelling skills across grain, relationships, measures, business definitions, and reusable model design.

• Hands-on Microsoft Fabric experience across Power BI, OneLake, Lakehouse/Warehouse, Direct Lake, semantic models, and governance.

• Strong SQL skills plus practical experience with Fabric notebooks, Spark SQL, and/or PySpark for analytical transformation and investigation.

• Strong understanding of DAX and semantic-model behaviour, with the ability to diagnose and validate complex calculations whether written manually or generated by AI.

• Proven ability to use advanced AI tools effectively, providing clear context and requirements and critically reviewing the result.

• Strong stakeholder communication and solution-oriented problem solving, with the confidence to challenge assumptions and explain trade-offs clearly.

• Experience with RLS/OLS, Git-based workflows, deployment pipelines, and structured promotion of Power BI/Fabric content across environments.

Want to learn more about career opportunities at Cooper Equipment Rentals? Visit our Careers page to view Day in the Life videoscooperequipment.ca/careers.

At Cooper Equipment Rentals, we believe our people are our greatest strength. We are committed to fostering an inclusive, respectful, and accessible workplace where everyone has an equitable opportunity to succeed. If you require an accommodation at any stage of the recruitment process, please let us know. We use AI-assisted technology to support parts of our recruitment process; however, all hiring decisions are made by our team using human judgment.

Pay Range:

Location: