Power BI Analyst

The Hospital for Sick Children; Toronto; Hybrid; CAD 75,000 - 105,000; Full time

Benefits offered by this job

Health and dental insurance

Life insurance

Staff wellness program

Job summary

The Hospital for Sick Children (SickKids) is seeking a Power BI Analyst to transform data into meaningful reports and dashboards for the Decision Support team. You will develop enterprise-grade Power BI solutions, connect data sources, and deliver visually compelling reports to support clinical and operational decisions.

Applicants should have 3+ years in BI, strong DAX/ETL/SQL skills, and experience with Azure SQL Data Warehouse.

Qualifications

• Bachelor's degree in an Information Technology related field.
• 3+ years of experience in developing and implementing BI Solutions required, with special consideration to experience with Power BI.
• Highly advanced, and demonstrated skills in DAX, M, ETL (Power Query), SQL, performance optimization.
• Experience in both database concepts and design, particularly experience with Azure SQL Data Warehouse.
• Effective interpersonal skills in a cross-functional environment. Able to interact with all levels of technical ability and comfortable with translating business requirements into technical reporting solutions.
• Problem solving skills, out of box thinking, drive for innovation and ability to execute ideas.
• Strong project management, time management and organizational skills.
• Excellent analytical skills, with the ability to create and derive meaning from data.
• A drive to ensure privacy and security standards are always adhered to.
• Inclination towards taking the organization from BI to AI landscape in long-term.
• Excellent written and verbal skills.
• The ability to work independently, and as part of a diverse team with on-site resources such as Decision Support, Finance, IS and end-users as well as external consultants.
• Demonstrated commitment and actions in advancing equity, diversity, and inclusion objectives.

Responsibilities

• Develop, build, test, deploy and maintain enterprise Power BI dashboards, reports and scorecards to track KPIs.
• Translate healthcare business requirements into scalable semantic data models, optimized queries, and robust calculations from multiple data sources using SQL and DAX.
• Perform data validation, cleaning, and testing to guarantee the accuracy and reliability of health information systems.
• Partner closely with clinical leaders, department managers, operational and administrative stakeholders to gather reporting requirements.
• Streamline dataflows, gateway configurations, and dataset refreshes for high-performance reporting.
• Manage health data assets in compliance with privacy legislation (PHIPA) and data governance frameworks.
• Create and maintain technical documentation for processes and provide end-user training and assistance to stakeholders across the organization to make data-driven decisions.

Skills

Power BI

DAX

SQL

ETL

Azure SQL Data Warehouse

Data analysis

Communication

Project management

Privacy & security

BI to AI

Written & verbal communication

Independent working

Equity, diversity & inclusion

Education

Bachelor's degree in Information Technology

Tools

SSAS

EPIC ADT

CIHI databases

Python

R

Job description

Dedicated exclusively to children and their families, The Hospital for Sick Children (SickKids) is one of the largest and most respected paediatric healthcare centres in the world. As innovators in child health, we lead and partner to improve the health of children through the integration of healthcare, leading-edge research and education. Our reputation would not have been built - nor could it be maintained - without the skills, knowledge and experience of the extraordinary people who come to work here every day. SickKids is committed to ongoing learning and development, and features a caring and supportive work environment that combines exceptionally high standards of practice.

When you join SickKids, you become part of our community. We share a commitment and determination to fulfill our vision of Healthier Children. A Better World.

Don't miss out on the opportunity to work alongside the world's best in paediatric healthcare.

The SickKids Enterprise Data & Analytics Office is looking for a Power BI Analyst to join the Decision Support team with the proven ability to transform data into meaningful reports and dashboards. The successful candidate will be responsible for all aspects of report development using Microsoft Power BI, including setting up connections to data sources, integrating the sources together and producing stunningly visual reports which meet data consumers' needs by leveraging your outstanding communication skills.

A problem-solver with attention to detail and strong process improvement skills, the candidate will need to be comfortable multi-tasking as the role supports both new reporting initiatives and ongoing reporting needs crossing numerous data sources. As the face to the Decision Support team, the position requires assuming the role of a consultant with internal stakeholders to ensure a thorough understanding of the requirements, as well as an ability to translate the needs of the business to the technical capabilities of Power BI.

Here’s What You’ll Get To Do

• Develop, build, test, deploy and maintain enterprise-grade Power BI dashboards, reports, and scorecards to track clinical, operational, and key performance indicators (KPIs).
• Translate healthcare business requirements into scalable semantic data models, optimized queries, and robust calculations from multiple data sources using SQL and DAX.
• Perform data validation, cleaning, and testing to guarantee the accuracy and reliability of health information systems.
• Partner closely with clinical leaders, department managers, operational and administrative stakeholders to gather reporting requirements
• Streamline dataflows, gateway configurations, and dataset refreshes to ensure seamless, high-performance reporting.
• Manage all health data assets in strict compliance with privacy legislation (such as PHIPA) and institutional data governance frameworks.
• Create and maintain thorough technical documentation for processes and provide end-user training and assistance to stakeholders across the organization to make data-driven decisions.

Essential

Here’s What You’ll Need:

• Bachelor’s degree in an Information Technology related field.
• 3+ years of experience in developing and implementing BI Solutions required, with special consideration to experience with Power BI.
• Highly advanced, and demonstrated skills in DAX, M, ETL (Power Query), SQL, performance optimization.
• Experience in both database concepts and design, particularly experience with Azure SQL Data Warehouse.
• Effective interpersonal skills in a cross-functional environment. Able to interact with all levels of technical ability and comfortable with translating business requirements into technical reporting solutions.
• Problem solving skills, out of box thinking, drive for innovation and ability to execute ideas.
• Strong project management, time management and organizational skills.
• Excellent analytical skills, with the ability to create and derive meaning from data.
• A drive to ensure privacy and security standards are always adhered to.
• Inclination towards taking the organization from BI to AI landscape in long-term.
• Excellent written and verbal skills.
• Attention to detail.
• Effective interpersonal skills in a cross-functional environment. Able to interact with all levels of technical ability and comfortable with translating business requirements into technical reporting solutions.
• The ability to work independently, and as part of a diverse team with on-site resources such as Decision Support, Finance, IS and end-users as well as external consultants.
• Demonstrated commitment and actions in advancing equity, diversity, and inclusion objectives.

Assets

• Previous experience working within acute healthcare setting and databases, such as EPIC ADT and CIHI databases.
• Intermediate skills in R/Python.
• An understanding in SQL Server Analysis Services (SSAS).
• Knowledge of AI, Machine Learning and Predictive/Prescriptive Analytics proven self-starter and idea generator.
• The ability to learn new tools, as needed.

Here’s What You’ll Love

• This position is eligible for employee benefits coverage including but not limited to; health, dental and life insurance. The full benefits package will be discussed at the time of offer.
• A focus on employee wellness with our new Staff Health and Well-being Strategy. Self-care helps us support others.
• A hospital that welcomes and focuses on Equity, Diversity, and Inclusion.
• The opportunity to make an impact. Regardless of your role or professional interest, you will be making a difference at SickKids and contributing to our vision of Healthier Children. A Better World.
• For more on why you’ll love working at SickKids, visit our careers site.

Employment Type: Temporary 2 Year Contract; 35 hours per week; Hybrid.

SickKids is committed to championing equity, diversity and inclusion in all that we do, fostering an intentionally inclusive and culturally safe environment that reflects the diversity of the patients, families and communities we serve. Learn more about workplace inclusion.

If you require accommodation during the application process, please reach out to our aSKHR team. SickKids can provide access and inclusion supports to eligible candidates to support their full engagement during the interview and selection process as well as to ensure candidates are able to perform their duties once successfully hired. If you are invited for an interview and require accommodation, please let us know at the time of your invitation to interview. Information received related to access, inclusion or accommodation will be addressed confidentially.

Technical difficulties? Email [e-mail] with a short description of the issues you are experiencing. We will not accept resumes sent to this inbox but we are happy to respond to requests for technical assistance.

Every application is reviewed by a human recruiter and all hiring decisions are made by people. In some cases, AI-assisted tools are used to help review applications based on job-related qualifications.

All positions posted on the SickKids Hospital's Careers Site represent current vacancies, unless otherwise posted in the job description.