PowerBI Lead

PwC - Global; Ontario; Hybrid; CAD 80,000 - 120,000; Full time

Job summary

Join a forward-thinking firm as a PowerBI Lead, where you will be at the forefront of data-driven decision-making. In this pivotal role, you will lead the development of impactful dashboards and reporting solutions, ensuring data integrity and accessibility. Collaborate with a talented team to drive innovation and enhance operational efficiency while fostering a culture of learning and growth. This is a unique opportunity to shape the future of data analytics in a dynamic and inclusive environment, where your contributions will be valued and rewarded. Embrace the chance to make a significant impact in a role that champions ethical data use and strategic insights.

Benefits

Competitive compensation package

Inclusive benefits

Flexibility programs

Continuous development environment

Qualifications

• Experience leading PowerBI development and reporting solutions.
• Advanced knowledge of data visualization and data transformation.

Responsibilities

• Lead technical development of dashboards and reporting solutions.
• Collaborate with teams to manage project feasibility and resources.

Skills

PowerBI Development

Data Visualization

Data Transformation

Analytical Thinking

Communication

Coaching and Feedback

Data Quality

Data Analysis

Software Development

Business Intelligence

Education

Degree in a related field

Certification in Reporting or BI

Tools

PowerBI

Azure Synapse

Job description

Line of Service

Internal Firm Services

Industry/Sector

Not Applicable

Specialism

IFS - Information Technology (IT)

Management Level

Senior Manager

Job Description & Summary

A career in our Chief Data and Analytics Office offers the opportunity to be at the forefront of leveraging data and AI to drive strategic decision-making and create tangible value across the organization. Our office also leads the way in developing and executing advanced analytics, data science, and AI-driven strategies, while ensuring robust data trust and governance frameworks. By shaping and fostering a strong data strategy and culture, the team promotes ethical, secure, and compliant data use. Additionally, it oversees the data engineering and architecture functions, ensuring that our infrastructure is optimized for innovation, scalability, and AI integration. We are seeking visionary professionals to help lead the transformation of our data landscape, ensuring its integrity, accessibility, and impact across all business functions.

The development and delivery of strategic and operational dashboards is a key focus for the CDAO, providing business leaders with real-time insights to enhance decision-making and operational efficiency.

Meaningful work you’ll be part of

As a PowerBI Lead (Senior Manager), you’ll work as part of a team of problem solvers, helping to solve complex business issues from strategy to execution. Responsibilities include but are not limited to:

• Lead the technical development of dashboards, reports, and other visualizations
• Own the PowerBI infrastructure and coordinate with technical stakeholders
• Provide technical guidance for the development and deployment of complex reporting solutions
• Collaborate with the data visualization and data engineering teams to manage and assess feasibility based on forecasted internal project team’s time and resource availability
• Develop data model requirements based on reporting requirements and available data
• Coach and develop reporting team members through formal and informal upskilling, empowering them to contribute to increasingly complex projects
• Act as the Subject Matter Expert (SME) in design reviews to ensure feasibility of requirements, quality and performance of products and solutions
• Create and own technical best practices to be deployed across the team

Experiences and skills you’ll use to solve

• Experience in PowerBI Development role and as a primary development lead
• Certification in Reporting, BI or related field is an asset
• Experience in reporting solutions design and deployment
• Advanced knowledge of PowerBI (DAX, Access Controls and Data Ingestion, Complex Reporting)
• Knowledge of Azure Synapse in relation to PowerBI
• Advanced proficiency in developing dashboards and visualization models
• Data transformation and cleansing through data profiling and root cause analysis
• Proficiency in software development, testing and QA best practices
• Experience upskilling technical skills in junior staff members
• Experience in supporting multiple ongoing projects, providing support to junior developers and staff through the development lifecycle

Why you’ll love PwC

We’re inspiring and empowering our people to change the world. Powered by the latest technology, you’ll be a part of diverse teams helping public and private clients build trust and deliver sustained outcomes. This meaningful work, and our continuous development environment, will take your career to the next level. We reward your impact, and support your wellbeing, through a competitive compensation package, inclusive benefits and flexibility programs that will help you thrive in work and life.

The most connected firm through activity based working

PwC Canada is committed to cultivating an inclusive, hybrid work environment - one that is collaborative, supportive and productive. We work in-person and virtually, as is best suited for our clients, teams and people. We want you to be intentional with your work, how you do it and where it’s done. PwC offices are hubs of connectivity and learning. We strongly encourage our people to prioritize in-person work. We know that hybrid work is all about balance, and capturing the benefits of in-person work is essential to your growth at the firm. Exact expectations for your team can be discussed with your interviewer.

Education

Degrees/Field of Study required: Degrees/Field of Study preferred:

Certifications

Required Skills

Optional Skills

Accepting Feedback, Active Listening, Analytical Thinking, Business Case Development, Business Data Analytics, Business Intelligence and Reporting Tools (BIRT), Business Intelligence Development Studio, Coaching and Feedback, Communication, Competitive Advantage, Continuous Process Improvement, Creativity, Data Analysis and Interpretation, Data Architecture, Database Management System (DBMS), Data Collection, Data Pipeline, Data Quality, Data Science, Data Visualization, Embracing Change, Emotional Regulation, Empathy, Inclusion {+ 20 more}

Desired Languages

Travel Requirements

Not Specified

Available for Work Visa Sponsorship?

No

Government Clearance Required?

No

Job Posting End Date

At PwC Canada, our most valuable asset is our people and we grow stronger as we learn from one another. We’re committed to creating an equitable and inclusive community of solvers where everyone feels that they truly belong. We understand that experience comes in many forms and building trust in society and solving important problems is only possible if we reflect the mosaic of the society we live in. We’re committed to providing accommodations throughout the application, interview, and employment process. If you require an accommodation to be at your best, please let us know during the application process. To learn more about inclusion and diversity at PwC Canada: https://www.pwc.com/ca/en/about-us/diversity-inclusion.html. Be a part of The New Equation.