Senior Power BI Specialist

Truthfulness | Fairness | Value | Loyalty
At Western Financial Group, we take pride in being one of Canada's largest insurance brokers. Our strength lies in our incredible team of over 2,200 dedicated professionals, spread across 180+ locations nationwide. Together, we create a supportive and collaborative environment that has earned us the recognition of one of Forbes Canada's Best Employers.

Discover a workplace where your well-being is a priority, and your contributions make a real difference. With competitive benefits, a strong community focus, and a commitment to work-life balance, Western is not just a place to work, it's a place to thrive

Western is on an exciting cloud modernization journey through our enterprise data and analytics program - modernizing our reporting, governance, and analytics platforms to drive data-informed decisions across the business.

Join our team and experience the Western difference – where caring for our customers, communities and team members is our passion

Senior Power BI Specialist (Development and Administration)
We are looking for an experienced Senior Power BI Specialist (Development and Administration) to join our Data and Analytics team. This hands-on role combines advanced dashboard development with enterprise-level Power BI administration and governance. You will play a key part in Western's ongoing cloud data modernization journey, enabling enterprise-wide reporting, automation, and self-service analytics.

Here Is What a Typical Day Looks Like
Power BI Development & Visualization

• Design, develop, and maintain advanced Power BI dashboards, reports, and semantic models that support decision-making across executive, management, and operational teams.
• Translate complex datasets into clear, intuitive, and interactive visualizations that highlight trends, risks, and opportunities.
• Partner with business stakeholders to gather requirements, define KPIs, and deliver reporting solutions that drive measurable business outcomes.
• Apply best practices in DAX, Power Query (M), and data modeling to ensure high performance, accuracy, and scalability.
• Support storytelling with data, ensuring dashboards are insightful, user-friendly, and aligned with business goals.
• Collaborate with business partners to understand priorities, define KPIs, and deliver insights that inform decision-making and drive measurable business outcomes

Power BI Administration & Governance

• Manage and administer the Power BI tenant, including workspaces, capacities, licenses, gateways, and user provisioning.
• Implement governance, security, and compliance standards across Power BI to ensure alignment with enterprise policies.
• Monitor usage, adoption, and system performance, identifying opportunities to optimize efficiency and reliability.
• Leverage automation (PowerShell, Python, REST APIs, or DevOps pipelines) to streamline Power BI administration, workspace provisioning, dataset refresh monitoring, and user/license management.
• Contribute to deployment automation and version control for Power BI assets to ensure consistent and governed delivery.
• Support ongoing governance initiatives as Western expands its Power BI adoption enterprise-wide.

Collaboration & Enablement

• Partner with Data Engineering and Cloud teams to ensure seamless integration of Power BI with enterprise data platforms including Snowflake and Databricks SQL.
• Support the rollout of self-service BI, including training business users, defining roles and permissions, and ensuring responsible adoption.
• Act as a subject matter expert, providing technical guidance and mentoring to both business stakeholders and technical teams.
• Stay up to date with new Power BI features and industry best practices, proactively recommending enhancements to improve adoption and scalability.
• Support the rollout of self-service BI capabilities, ensuring appropriate governance and quality controls are in place.
• Help strengthen BI delivery resilience and reduce dependency on key individuals through automation and knowledge sharing.

The value you bring

• Proven professional experience with Power BI, including advanced dashboard and report development in enterprise environments.
• Demonstrated experience with Power BI administration, including tenant management, capacity planning, governance, and security.
• Advanced knowledge of DAX, Power Query (M), data modeling, and performance tuning.
• Solid understanding of data warehousing concepts, data governance, and cloud-based data platforms such as Snowflake and Databricks SQL.
• Experience with automation and scripting for Power BI administration and deployments (PowerShell, Python, REST APIs, Azure DevOps).
• Strong problem-solving and analytical skills with high attention to detail.
• Excellent communication and stakeholder management skills; able to work effectively with both technical teams and business leaders.
• Proven ability to work in a cloud-first environment and contribute to ongoing modernization initiatives.
• Strong understanding of how BI and analytics drive business growth, with a passion for enabling data-informed decision-making.

Hours: Full-time, 37.5 hours per week

Requisition Number: 82311

Salary Range: $95,000 - $110,000

Location: Remote within Canada

At Western, we prioritize the well-being of our employees and are committed to fostering an inclusive environment that values diversity within our communities. We strive to create a workplace that is accessible, equitable, and supportive, ensuring that all team members feel valued and can thrive in their roles. As an equal opportunity employer, we welcome applicants from all backgrounds, and we encourage individuals to apply even if their experience does not fully meet all the criteria listed.

If you need assistance or have questions about requesting reasonable accommodation, please feel free to reach out to us at any time during the hiring process by contacting our Talent Acquisition team at or reviewing Careers Page on our website.

We value our employees and offer programs that enhance their lives. Eligible employees receive 3 weeks' vacation, 14 wellness days, company matching investment and savings programs, and 100% employer-paid group benefits.