Senior Power BI Developer

Willis Towers Watson; Toronto; On-site; CAD 130,000 - 145,000; Full time

Job summary

Willis Towers Watson in Toronto, Ontario, is seeking an experienced Power BI Developer to design and deliver enterprise reporting and analytics solutions. You will build dashboards and semantic models for Finance, HR, and Marketing, using Power BI, Fabric Lakehouse, and Synapse.

The role requires 4+ years in Power BI, strong SQL, and experience with Fabric Lakehouse/Warehouse. Collaboration with stakeholders and a DevOps mindset are essential for delivering scalable analytics.

Qualifications

• 4+ years hands-on experience developing Power BI solutions in enterprise environments.
• Strong experience with Power BI Desktop and Power BI Service.
• Proficient in DAX and Power Query (M).
• Experience with Microsoft Fabric Lakehouse and Warehouse.
• Experience building semantic models and implementing Row-Level Security.
• Strong SQL skills with SQL Server/Synapse/Oracle or similar.
• Experience in agile teams and DevOps processes.
• Excellent communication with technical and business stakeholders.

Responsibilities

• Design and develop Power BI dashboards, reports, and semantic models.
• Develop data solutions using Microsoft Fabric Lakehouse/Warehouse.
• Collaborate with stakeholders to translate requirements into data models and visuals.
• Build and optimize Power BI datasets, DAX calculations, and Power Query transformations.
• Integrate Power BI with Azure Data Lakehouse, Fabric Lakehouse, and Synapse environments.
• Perform data modeling and analytics to ensure high-quality insights.
• Optimize reports for performance and usability.
• Support enhancements and troubleshooting in the reporting environment.
• Follow governance and DevOps standards.
• Collaborate with data engineers to ensure data integrity.

Skills

Power BI dashboards

DAX

Power Query

Data modeling

Agile

DevOps

Stakeholder communication

Tools

Fabric Lakehouse

Fabric Warehouse

Azure Data Lakehouse

Azure Synapse

SQL Server

Synapse

Job description

Description

The Role:

WTW is seeking an experienced Power BI / Microsoft Fabric Developer to support the BI Analytics Reporting team in delivering enterprise reporting and analytics solutions. This role will focus on designing and developing Power BI dashboards/semantic models supporting Finance, HR, and Marketing teams.

Principle Duties & Responsibilities:

• Design and develop Power BI dashboards, reports, and semantic models that provide actionable insights to business users.
• Develop and maintain data solutions using Microsoft Fabric Lakehouse and Warehouse.
• Collaborate with business stakeholders to translate requirements into effective data models and visualizations.
• Build and optimize Power BI datasets, DAX calculations, and Power Query transformations.
• Integrate Power BI solutions with Azure Data Lakehouse, Fabric Lakehouse/Warehouse, and Azure Synapse environments.
• Perform data modeling and data analysis to ensure high-quality and performant analytics solutions.
• Optimize existing reports and dashboards for performance, scalability, and usability.
• Support enhancements and troubleshooting within the existing reporting environment.
• Follow established development standards, governance practices, and devops processes.
• Collaborate with data engineers and database teams to ensure data integrity and consistency.

Qualifications

The Requirements

• 4+ years of hands‑on experience developing Power BI solutions in enterprise environments.
• Strong experience with:
• Power BI Desktop, Power BI Service
• DAX, Power Query (M)
• Experience working with Microsoft Fabric, including:
• Fabric Lakehouse, Warehouse, including direct lake feature.
• Building Power BI semantic models and implementing Act-As and row level security.
• Strong experience with data modeling and analytics solution design.
• Advanced SQL skills and experience working with databases such as SQL Server, Synapse, Oracle, or similar platforms.
• Ability to quickly understand existing data models and reporting environments.
• Experience working within agile development teams and DevOps processes.
• Strong communication skills and ability to work effectively with both technical and business stakeholders.

Compensation

The base salary compensation range being offered for this role is $130,000 to $145,000 CAD per year.

This role is also eligible for an annual short‑term incentive bonus.

Artificial Intelligence (AI) tools may be used in the process to screen, assess, or select applicants for a position but all final decisions and determinations are made exclusively by authorized human personnel.

This job posting is an advertisement for an existing vacancy.

Equal Opportunity Employer