Bi Developer Intern

Job Description

JOB TITLE: BI Developer Intern
Job Posting #:
Union: Non-Union
Site: OPG (700 University)
Department: Customer and Business Operations
Reports to: Director, Business Intelligence
Hours: 35 Hours
Wage range or Salary: $22.00 per hour. Start rate non-negotiable.
Status: Contract Full Time
Posted Date: July 19th, 2023
Closing Date: August 2nd, 2023

As one of the world’s leading cancer charities, The PMCF raises funds for Princess Margaret Cancer Centre, one of the top 5 cancer research centres in the world, to deliver future care now.

For more than a decade, The PMCF has been on an aggressive growth trajectory. Setting daring and audacious goals is a mindset that is driven by our culture and passion to perform. We have pioneered many successful fundraising programs, including our world-leading Princess Margaret Home Lottery, and some of the world’s largest cancer fundraising events. The foundation’s vision, which will be your vision, is to Conquer Cancer in Our Lifetime.

The Princess Margaret is a proud member of University Health Network, Canada’s largest research hospital network, which also includes Toronto General Hospital, Toronto Western Hospital, Toronto Rehab Institute and The Michener Institute for Education.

Position Summary

We are seeking a Business Intelligence Developer Intern who is passionate about utilizing data and analytics to help us deliver on our mission. We are looking for someone who will proactively drive improvements in performance across our businesses: philanthropy, lottery, events, and marketing.

In this role, you will be a key member of the team focused on creating supporter contact lists, delivering data requests, and supporting data governance. You will work with teams to ensure data solutions deliver value by deepening supporter engagement, driving results, and creating efficiencies. You are a resourceful problem solver that is motivated to learn and improve. This role will report to the Director of Business Intelligence & Analytics.

Duties

• Develop, test, and deploy data solutions using a high level of expertise in querying data from our data warehouse.
• Implement effective list management practices; automate/optimize the list build process, validate the data quality, track list usage, report on results, and recommend improvements.
• Work with Data Analyst to create tests within list pulls that incorporate predictive models.
• Partner with Data Engineer to create standard views in the data warehouse that integrate multiple data sources (CRM, MailChimp, Finance).
• Support Senior Developer in building dashboard solutions (Power BI) that deliver key performance metrics and forecasting.
• Support the Foundation’s data quality efforts by partnering with Business Operations to fix and maintain the integrity of our data.

Qualifications

• Current undergraduate or graduate student, preferably in computer science, mathematics, engineering, or related field. Co-op students are preferred.
• Proficient with SQL.
• Experience in dashboard development, data analysis, research, or similar field considered an asset.
• Strong communication skills, both written and verbal.
• Ability to shape and develop requirements into practical solutions.

Why join UHN?

In addition to working alongside some of the most talented and inspiring healthcare professionals in the world, UHN offers a wide range of benefits, programs and perks. It is the comprehensiveness of these offerings that makes it a differentiating factor, allowing you to find value where it matters most to you, now and throughout your career at UHN.

• Competitive offer packages
• Government organization and a member of the Healthcare of Ontario Pension Plan (HOOPP https://hoopp.com/)
• Close access to Transit and UHN shuttle service
• A flexible work environment
• Opportunities for development and promotions within a large organization
• Additional perks (multiple corporate discounts including: travel, restaurants, parking, phone plans, auto insurance discounts, on-site gyms, etc.)

Current UHN employees must have successfully completed their probationary period, have a good employee record along with satisfactory attendance in accordance with UHN's attendance management program, to be eligible for consideration.

Vaccines (COVID and others) are a requirement of the job unless you have an exemption on a medical ground pursuant to the Ontario Human Rights Code.

UHN is a respectful, caring, and inclusive workplace. We are committed to championing accessibility, diversity and equal opportunity. Requests for accommodation can be made at any stage of the recruitment process. Applicants need to make their requirements known in advance. Any information received related to an accommodation will be addressed confidentially.

University Health Network thanks all applicants, however, only those selected for an interview will be contacted.