Senior Analytics Solutions Lead – Power BI & Fabric
- Salary
- CA$110K–CA$130K
- Hiring from
- Canada
- Work type
- Remote
- Posted
626,918 remote jobs, straight from company career pages
100% free · New jobs every minute
Show job descriptionHide job description
Build your Career at Cooper Equipment Rentals
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!
- Flexible remote work arrangement in Canada, with competitive compensation (base + bonus), benefits & RRSP match.
- Own analytics solutions end to end, from business problem through semantic model to the reports executives and branch leaders use every day, on an enterprise Fabric platform that is already in production.
- Work the way analytics will be done from here on: AI will handle the bulk of the implementation, and your time will go to modelling judgement, business understanding, and making sure what ships is right and clear.
- Join a data team that values rigour and modern tooling over report factories.
Location: Canada (Remote)
About Us
Cooper Equipment Rentals is Canada’s leading, Canadian-owned rental company, offering a wide range of compact, aerial, and heavy construction and industrial equipment to contractors nationwide. With over 85 branches and a commitment to safety, reliability, and exceptional service, we’re dedicated to supporting our clients’ success on every jobsite.
Our enterprise analytics platform runs on Microsoft Fabric: OneLake, Bronze/Silver/Gold Lakehouses, Direct Lake semantic models, and a shared semantic layer that supports enterprise reporting and AI-assisted analytics across the business.
Role Overview
We are seeking a Senior Analytics Solutions Lead to design and own the semantic models and Power BI solutions that the business runs on. This is a senior, hands-on individual-contributor role with end-to-end ownership of analytics solutions; it is not a people-management position.
AI tools such as Claude and ChatGPT will write most of the DAX, SQL, and PySpark on our platform. The value you bring is knowing what to build and whether what was built is right: defining the model, the grain, the measures, and the business rules precisely enough that the solution can be generated quickly, then validating the result from three angles. Does it match how the business actually works and the decision it is meant to support? Does the report present it clearly, so a branch manager or executive can read it correctly at a glance? And is it technically sound, so a generated measure behaves correctly under every filter context it will meet? You should be able to look at a generated solution and answer all three, and fix it when the answer is no.
You will work directly with stakeholders to understand the decisions they need to make, shape the analytical approach, and deliver solutions across lakehouse transformation, semantic modelling, and Power BI reporting on a Direct Lake platform that is already in production.
Key Responsibilities
- Partner with business stakeholders to understand their problems and decision needs, and translate them into well-defined measures, dimensions, business rules, and report designs.
- Design and own enterprise semantic models on Direct Lake, including star-schema and grain decisions, relationship design, and reusable measure definitions aligned to clear business definitions.
- Direct AI tools to generate, refactor, document, and test DAX, SQL, and PySpark, supplying the context and requirements they need and critically validating everything they produce before it reaches production.
- Validate every solution against the business before release: reconcile results to known figures and source systems, test edge cases and business rules with stakeholders, and confirm the numbers mean what users will assume they mean.
- Own the visual quality of reports: choose the right visuals and layouts for the decision at hand, apply consistent design conventions, and review reports as the end user will experience them, not just as the model behind them.
- Diagnose and resolve incorrect results, performance problems, and usability issues in semantic models and reports, including those introduced by AI-generated implementations.
- Build and investigate analytical datasets in Fabric notebooks using SQL and PySpark, following the Bronze/Silver/Gold medallion pattern in partnership with data engineering.
- Design and test row-level security so that models remain correct and performant for every audience.
- Work within the team’s source-controlled development and deployment practices for Power BI and Fabric content.
- Raise standards for solution design, semantic modelling, documentation, and testing across the analytics function.
Qualifications & Skills
- 5+ years delivering enterprise Power BI solutions, with deep hands-on experience designing and maintaining semantic models rather than only authoring reports against existing ones.
- Strong DAX understanding. You may no longer write most of it by hand, but you can read it fluently, reason about filter context and context transition, and explain why a measure returns the number it does.
- Strong dimensional modelling skills: grain, relationships, role-playing dimensions, bridge tables, and the trade-offs between model simplicity and flexibility.
- Hands-on Microsoft Fabric experience across OneLake, Lakehouse, Direct Lake semantic models, and notebooks.
- Solid SQL plus practical PySpark or Spark SQL experience for building and investigating analytical datasets.
- Proven, effective use of AI coding assistants for analytics development, with the judgement to catch and correct their mistakes.
- Excellent business and analytical problem-solving skills, including turning loosely defined questions into decision-oriented analytical products.
- A habit of validating results against the business, not just against the code: you reconcile, you test the rules, and you are not satisfied until the numbers can be trusted by the people who use them.
- Strong report design judgement: clear visual hierarchy, sensible use of visuals, consistent conventions, and an eye for whether a report actually communicates what it is supposed to.
- Clear communication with technical and non-technical stakeholders, including the confidence to challenge assumptions and explain trade-offs.
- Familiarity with Tabular Editor, DAX Studio, and working with Power BI content in source control.
Nice to Have
- Microsoft certifications such as PL-300 or DP-600.
- Experience with Fabric Data Agents, Copilot in Power BI, or preparing semantic models for AI consumption.
- Exposure to equipment rental, construction, distribution, or other asset-intensive operational businesses.
Want to learn more about career opportunities at Cooper Equipment Rentals? Visit our Careers page to view Day in the Life videos cooperequipment.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:
$110,000 - $130,000 annuallyLocation:
255 Longside Drive, Unit 103
Mississauga, ON L5W 0G7
About Us
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.
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.
Check out our 'Day in the Life' videos to learn more about careers at Cooper!