Senior Power BI Developer

Role Overview

We are seeking a Senior Power BI Developer to lead the design, optimization, and governance of enterprise semantic models and reports across the business.

This is not a basic dashboard-authoring role. You will operate as a senior technical lead for Power BI and the semantic layer: shaping dimensional models, DAX patterns, report standards, performance tuning, deployment discipline, and AI readiness for Copilot and Fabric data agents.

You will work closely with data engineers, analytics stakeholders, and platform leaders to ensure Fabric data products are performant, reusable, secure, and easy for the business to consume.

What You'll Be Doing

Duties and Responsibilities:

• Design enterprise semantic models using strong dimensional modeling, reusable measures, hierarchies, calculation groups.
• Build high-quality Power BI reports and self-service templates with strong usability, accessibility, storytelling, and performance.
• Optimize models and reports using DAX best practices, simplification, query reduction, and tools such as Performance Analyzer, DAX Studio.
• Develop Direct Lake semantic models in Fabric and understand when Direct Lake, import, or composite approaches are appropriate.
• Partner with data engineering on lakehouse/warehouse design, curated tables, SQL endpoints, and refresh strategies for a stable semantic layer.
• Establish standards for naming, measure design, calculation groups, documentation, certification, and release management.
• Apply modern lifecycle practices including Git integration, deployment pipelines, workspace discipline, and TMDL where appropriate.
• Prepare models for AI-assisted analytics through business-friendly schemas, verified answers, AI instructions, and strong metadata.
• Support secure, governed analytics through effective RLS/OLS, workspace standards, endorsement, and OneLake-aligned governance.
• Monitor adoption, refresh health, semantic model quality, and Fabric activity using Monitoring Hub, capacity insights, and service diagnostics.
• Support near-real-time reporting where justified, partnering with teams using Real-Time Intelligence or event-driven patterns.
• Mentor developers and raise standards across Power BI, semantic modeling, report design, and Fabric practices.

Qualifications And Requirements

What You'll Bring to the Team

• Bachelor's degree in computer science, information systems, data analytics, mathematics, software engineering, business analytics, finance, economics, or a related field, or equivalent practical experience. Master’s degree is an asset.
• 5+ years in BI / analytics development, including substantial hands-on experience designing enterprise Power BI semantic models and reports.
• Expert-level DAX, strong knowledge of VertiPaq and semantic model performance tuning, and deep experience with star schema / dimensional design.
• Strong SQL skills and the ability to work effectively with curated analytical data in lakehouse, warehouse, or SQL endpoint patterns.
• Hands-on Microsoft Fabric experience, especially with Power BI, OneLake, semantic models, Direct Lake, lakehouse / warehouse integration, and Fabric workspace governance.
• Experience with calculation groups, field parameters, reusable measure patterns, and model organization for enterprise-scale reporting.
• Experience with RLS/OLS, security-aware model design, and governed self-service reporting.
• Experience with Git-based workflows, deployment pipelines, and structured promotion of Power BI / Fabric content across environments.
• Strong communication skills and the ability to translate business questions into durable semantic-layer and reporting solutions.

Nice to Have

• Experience with Tabular Editor, XMLA / TOM / TMDL, Power BI REST APIs, or semantic model automation.
• Experience preparing models for Copilot, Prep for AI, verified answers, or Fabric data agents.
• Exposure to Fabric notebooks, Spark SQL / PySpark, or Data Factory pipelines.
• Experience with paginated reporting, legacy SSRS modernization, or migration of legacy BI assets into Fabric.

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

Additional Information

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