Senior Power BI Developer

About the Role

Work Arrangement

• This is a hybrid role based out of the Surrey, British Columbia office, combining days in the office with days working from home.

Reporting Product Development

• Lead the design, development, deployment, and support of enterprise reporting and analytics products using Microsoft Power BI and Microsoft Fabric.
• Design executive dashboards, operational scorecards, KPI frameworks, and advanced analytical reporting solutions.
• Develop advanced DAX calculations, measures, calculated tables, and optimized reporting models.
• Ensure reporting products meet standards for performance, usability, UI/UX, accessibility, maintainability, and data quality.

Semantic Model Governance

• Design, develop, and maintain enterprise semantic models that support trusted self-service analytics.
• Own the certified Power BI dataset layer used by organizational reports.
• Partner with the Data Architect on Microsoft Fabric and enterprise data architecture alignment.
• Define and enforce KPI standards, governance practices, and semantic model documentation.

Catalogue and Stakeholder Partnership

• Manage the reporting product catalogue, including prioritization, lifecycle management, stakeholder alignment, and retirement of obsolete assets.
• Maintain a prioritized analytics product backlog aligned with organizational goals.
• Gather requirements, conduct stakeholder reviews and dashboard demonstrations, and translate business objectives into reporting products.
• Drive adoption of Power BI products, data-driven decision-making, data literacy, and self-service analytics.

Technical Leadership and Governance

• Mentor BI developers, data analysts, and reporting professionals and provide technical leadership without direct authority.
• Establish Power BI and Fabric development standards and continuous improvement initiatives.
• Maintain technical documentation, reporting inventories, governance artifacts, and development standards.
• Participate in sprint planning, backlog refinement, estimation, demos, and retrospectives.

Required Experience

• At least 5 years of experience developing business intelligence, reporting, and analytics solutions.
• Bachelor's degree in a relevant discipline, with equivalent combinations of education and experience considered.
• Experience designing and maintaining enterprise semantic models.
• Experience with Microsoft Fabric, data warehousing, Lakehouse, and modern analytics architecture.
• Strong experience with SQL, relational databases, star schemas, and dimensional modeling.
• Experience developing executive dashboards and operational reporting solutions.
• Experience in Agile/Scrum delivery environments.
• Experience mentoring technical resources, leading technical decisions, facilitating senior-leader discussions, and translating business requirements into technical solutions.

Preferred Experience

• Experience in insurance, group benefits, financial services, or another regulated environment.
• Experience supporting enterprise KPI frameworks and performance management programs.
• Experience with Power BI Embedded for external client portal development.
• Experience with wireframing tools such as Figma or Balsamiq.
• Microsoft Power BI PL-300 and/or Fabric certifications are strongly preferred.
• Experience in UI/UX design, graphic design, or analytical visual storytelling.

Compensation

• The estimated annual base salary is CAD 90,000–CAD 100,000.
• Individual compensation depends on job-related skills, relevant experience, and education or training.

Benefits and Culture

• The organization offers paid time off, extended health and dental benefits, RRSP matching, flexible work options, wellness support, and mental health resources.
• The company describes a collaborative, supportive culture with opportunities for growth.