Senior Business Analytics Lead

Cooper Equipment Rentals Limited; Mississauga; On-site; CAD 110,000 - 130,000; Full time

Benefits offered by this job

RRSP Match

Training & development

Safe work environment

Competitive salary

Job summary

Cooper Equipment Rentals in Mississauga, Ontario, seeks a Senior Business Analytics Lead to turn business problems into high-quality analytics solutions. You will work across data transformation, semantic models, and Power BI reporting, using AI tools to accelerate development while validating output.

You will partner with stakeholders to define measures, create intuitive reports, and design secure, scalable analytics with governance and best practices in mind.

Qualifications

• Minimum 5 years delivering enterprise BI or analytics solutions.
• Strong Power BI experience and business problem solving.
• Experience with semantic modelling and governance.

Responsibilities

• Partner with stakeholders to understand problems and analytical needs.
• Translate problems into analytical solutions with measures and rules.
• Design enterprise semantic models and Power BI reports.
• Use AI tools to accelerate development and validate results.
• Develop Fabric-based transformations and collaborate with data engineering.
• Choose Direct Lake/Import patterns based on requirements.
• Diagnose data, DAX, and performance issues; ensure security and usability.

Skills

Power BI

Business analytics

Stakeholder comms

Problem solving

AI tooling

SQL

Data modeling

Tools

Git-based workflows

Fabric notebooks

Spark SQL

PySpark

Job description

Why Work with Us?

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

Benefits & Culture

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.

Location and Pay

Pay Range: $110,000 - $130,000 annually. Location: 255 Longside Drive, Unit 103 Mississauga, ON L5W 0G7. At Cooper Equipment Rentals, it’s about more than equipment - it’s the people behind it. Proudly Canadian owned since 1972, we are one professional team driven by honesty, reliability, and fresh thinking. We’re known for top-quality equipment, but what truly sets us apart is our expertise, customer service, and safety-first mindset. Every role at Cooper plays a part in building and maintaining the communities we live and work in.

Who We Are

If you’re looking for a workplace where your contributions matter, your ideas are valued, and your career can grow with a company that’s going places — welcome to the Cooper Difference.