Senior Power BI Specialist (Development and Administration)

Truthfulness Fairness Value Loyalty

At Western Financial Group we take pride in being one of Canadas largest insurance brokers. Our strength lies in our incredible team of over 2200 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 Canadas 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 its 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 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.

Hours: Full-time 37.5 hours per week

Requisition Number: 82311

Salary Range: $95000 - $110000

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 ator reviewing Careers Page on ourwebsite.

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.