Senior Power BI Specialist (Development and Administration)

Proudly Canadian. Driven by Purpose. Rooted in Care.

Join a national team where people purpose and community come first. Western Financial Group was named a 2025 Top Insurance Employer by Insurance Business Canada and is home to more than 2300 team members supporting over one million customers across 200 locations across Canada.

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 Westerns 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.

Role Details

• Hours: Full-time 37.5 hours per week
• Requisition Number: 82311
• Salary Range: $95000 - $110000
• Location: Remote within Canada
• Current Vacancy: Yes

Why Western

Westerns peoplefirst culture grounded in our guiding principles of Truthfulness Fairness Value and Loyalty is recognized across Canada and strengthened by our commitment to wellness flexibility and meaningful community impact.

Highlights include:

• 14 Paid Wellness Days 3 weeks vacation companymatching savings programs and 100% employerpaid group benefits for eligible employees
• Over 1500 volunteer hours supporting 160 charities in through the Western Financial Group Communities Foundation.

Our Commitment to Inclusion: At Western we strive to create an accessible equitable and inclusive workplace where everyone feels valued and can thrive. As an equal opportunity employer we encourage applicants of all backgrounds to apply even if your experience doesnt perfectly match every qualification. If you need assistance or an accommodation during the hiring process please contact or visit our Careers page.

Our HumanFirst Hiring Approach: We do not use artificial intelligence to screen assess or select applicants. All applications are personally reviewed by Westerns Talent Acquisition Consultants. As part of our hiring process we use standardized scientifically validated skills assessments (nonAI) and all results are reviewed by our hiring team.

Ready to Apply

If making a meaningful impact in your community and growing your career in a supportive purposedriven environment excite you wed love to hear from you.