Junior Report Developer; Intern), Analytics and Insights

Junior Report Developer (Intern), Analytics and Insights

• Contract
• Department:
  Princess Margaret Foundation
• Compensation: up to CAD 22.50/hour

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.

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.

Union: Non-Union

Department: Customer and Business Operations

Reports to: Manager, Business Intelligence Reporting & Development

Hours: 35 hours

Hourly Rate: $22.50/hour

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.

• 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 the Data Engineer to create standardized data views in the data warehouse that integrate multiple data sources (CRM, Mail Chimp, 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.

• Recent graduate of an undergraduate or graduate program, preferably in computer science, mathematics, engineering, or related field.
• 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…