Report Developer Intern

Union: Non-Union
Site: 700 University Avenue
Department: Customer and Business Operations
Reports to: Director Business Intelligence
Hours: 35 hours
Hourly Rate: $21/hour
Status: Temporary Full Time (12 months contract)
Posted Date: June 6 2025
Closing Date: June 22 2025

We are seeking a 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 Senior Developer 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 wont 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 welcomes all applicants including but not limited to: all religions and ethnicities LGBTQ2s 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.

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.

Remote Work :

No

Employment Type :

Contract