Junior Report Developer (Intern), Analytics and Insights

Company Description

At The Princess Margaret Cancer Foundation (PMCF), our vision is to create a world free from the fear of cancer. Cancer remains the number one cause of death for Canadians and our top priority is to accelerate cancer research and care.

Our role is to garner support for Princess Margaret Cancer Centre, one of the world’s leading cancer research and treatment centres, through philanthropy, fundraising events, and our world-renowned lottery program. The work we accomplish drives groundbreaking research, relentless innovation, and a deep commitment to improving the lives of cancer patients and their loved ones.

Now, we have an opportunity to blaze an even brighter future for everyone affected by cancer.

We will Carry The Fire for cancer patients everywhere, lighting the way forward through discovery, reigniting our commitment to transform cancer outcomes and ease the profound suffering cancer causes patients and their loved ones.

At the PMCF, every one of us carries the fire for someone else. Join us as we inspire a movement and help us achieve our vision to change the way we understand, diagnose, and treat cancer.

Job Description

Union: Non-Union
Department: Customer and Business Operations
Reports to: Manager, Business Intelligence Reporting & Development
Hours: 35 hours
Hourly Rate: $
Vacancy: Existing Vacancy - Backfill
Status: Temporary, Full Time (12 months contract)
Posted Date: June 19, 2026
Closing Date: July 2, 2026

We are seeking a Junior Report Developer (Intern) who is passionate about utilizing data and analytics to help us deliver on our mission. In this role you will support the design, development, and optimization of Power BI dashboards and reports that provide insight into our fundraising programs, operations, and supporter engagement.

This role is ideal for a recent graduate who is curious, detail-oriented, and eager to learn. You enjoy solving problems with data, building reports that uncover trends, and collaborating with others to bring clarity and insight to complex questions.

You will:

• Collaborate with business stakeholders to understand requirements and translate them into dashboards that answer key business questions.
• Design, develop, and maintain Power BI dashboards and reports that are visually compelling, performant, and user-friendly.
• Support the Manager of Reporting & Development in delivering key performance metrics, forecasting models, and measurement frameworks.
• Collaborate with Data Engineer to create standardized data views in the data warehouse that integrate multiple data sources (CRM, MailChimp, Finance) and maintain clear, up-to-date documentation outlining data definitions, transformation logic, source mappings, and usage guidelines to support consistency and knowledge sharing across teams.
• Design, build, and test data models tailored for dashboard performance and scalability.
• Maintain and monitor Power BI data gateways to ensure reliable and timely data refreshes, while troubleshooting connectivity issues in collaboration with stakeholders
• Conduct data validation and quality assurance checks to ensure accuracy and reliability of reports.
• Ensure reports are well-documented, version-controlled, and follow a consistent design and naming convention.

Qualifications

• Recent graduate of an undergraduate or graduate program, preferably in computer science, mathematics, engineering, or related field is mandatory.
• Experienced with SQL – able to write structured and efficient queries.
• Experience building dashboards using Power BI (or equivalent tool) and creating calculated fields and measures using DAX.
• Proficiency in optimizing large datasets and refining slow-performing queries and reports to improve efficiency and responsiveness in Power BI
• Proficiency with Python considered an asset – understanding of core programming principles, able to transform data, and maintain automation scripts and internal utility libraries.
• Familiar with Git – able to version control scripts and collaborate using branching and pull requests.
• Strong documentation skills – able to clearly capture business processes and code logic to support collaboration and future maintenance.
• Attention to detail and commitment to data accuracy and presentation.
• Strong communication skills, both written and verbal.
• Ability to shape and develop requirements into practical solutions.

Additional Information

We believe that the way we work together is just as important as what we accomplish. By making choices and taking actions that align with our values, we achieve greater success, and our work lives become happier and more meaningful.

At PMCF, we strive to foster a culture built on Collaboration, Accountability, Respect, and Excellence (CARE). Central to these values is our commitment to IDEAA: Inclusion, Diversity, Equity, Accessibility, and Anti-Racism.

• Experience a sense of purpose that you won’t get anywhere else, in any other job. You will be making a difference for millions of people impacted by cancer
• We have an open and approachable culture that enables you to bring your best ideas forward
• We offer a hybrid work environment with Tuesday, Thursday and one other day per week in office, or as required subject to business needs

UHN is a respectful, caring, and inclusive workplace. We are committed to championing accessibility, diversity and equal opportunity and welcome all applicants including but not limited to: all religions and ethnicities, LGBTQIA2S+, BIPOC, persons with disabilities and all others who may contribute to the further diversification of ideas. Requests for accommodation can be made at any stage of the recruitment process providing the applicant has met the Bona-fide requirements for the open position. Applicants need to make their requirements known when contacted.

All applications must be submitted before the posting close date.

UHN uses email to communicate with selected candidates. Please ensure you check your email regularly. At University Health Network (UHN), artificial intelligence technologies may be used to assist in the screening, assessment, and selection of candidates for this position.

Please be advised that a Criminal Record Check may be required of the successful candidate. Should it be determined that any information provided by a candidate be misleading, inaccurate or incorrect, UHN reserves the right to discontinue with the consideration of their application.

UHN is an equal opportunity employer committed to an inclusive recruitment process and workplace. Requests for accommodation can be made at any stage of the recruitment process. Applicants need to make their requirements known.

We thank all applicants for their interest, however, only those selected for further consideration will be contacted.