Senior Analytics Solutions Lead – Power BI & Fabric
Free to start · No card · 5 credits the moment you sign up
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 103Mississauga, ON L5W 0G7Originally posted on Himalayas
Prepare your application
Use the description above to assess your fit for Cooper Equipment Rentals Limited. This checklist is guidance from Resumize, rather than additional requirements from the employer. Imported listings can be shortened or change after collection, so confirm the complete description and current availability before sending an application.
Match requirements to evidence
Identify the responsibilities and skills the employer explicitly names. For each important requirement, choose one example from your work, education, training, or projects. Explain what you did, how you did it, and what changed as a result. Include a measurable outcome when you can support it. If you lack a requirement, describe related experience accurately instead of adding an unfamiliar skill to your resume.
Put the most relevant examples near the top of your resume. Keep job titles, dates, qualifications, and contact details consistent across your application materials. Use the employer’s terminology when it describes your experience accurately; a copied list of keywords does not explain your contribution. A short, specific bullet is easier to review than a paragraph that mixes several unrelated duties.
Check the working arrangement
Confirm the location, schedule, employment type, and any eligibility requirements on the employer’s site. A remote label does not establish worldwide eligibility or flexible hours. If compensation, benefits, equipment, travel, or contract duration are missing from this listing, write down your questions for the recruiter. Do not assume details from another opening at the same company apply to this role.
Review before submitting
Follow the employer’s requested file format and application instructions. Open your exported resume and check that its text is selectable, its sections read in order, and its links work. Proofread names, dates, and contact information. Share confidential work samples only when you have permission, and use an anonymized example when necessary.
Submit through a trusted employer or recruiting destination. If the original listing has disappeared, search the employer’s careers page for the title rather than assuming the vacancy remains open. Save the application date, job reference, and the version of your resume you sent. Those details help you prepare for a later conversation and avoid submitting conflicting information through several job boards.
Review your resume for writing and readability feedback, or browse other openings if this opportunity is unavailable.