Data & Reporting Analyst (12-month contract)

"The best prescription I've ever given is a wish."

• Dr. Jeremy Friedman, Associate Paediatrician-in-Chief, SickKids Hospital & Medical Advisor for Make-A-Wish Canada

WHAT IS YOUR BIGGEST WISH?

Is it to be part of an organization that is child-focused, values employee experience and is an inspiring workplace? If so, Make-A-Wish is for you

Make-A-Wish Canada creates life-changing wishes for children with critical illnesses. We are on a quest to bring every eligible child's wish to life because a wish is an integral part of a child's treatment journey. Research shows children who have wishes granted can build the physical and emotional strength they need to fight a critical illness.

"It's been wonderful to have this wish to look forward to... It's wonderful to see [Rowan] with something that brings him pure joy after all he's been through and missed out on"

–Melissa, mom to wish kid Rowan (age 5, leukemia), who wished for an indoor jungle gym.

MISSION, VISION AND VALUES

Our mission is, together, we create life-changing wishes for children with critical illness. Supported by our vision to grant the wish of every eligible child.

Our values are Child-Focused, Integrity, Impact, Innovation, and Community.

WHAT'S IN IT FOR YOU?

• Meaningful opportunities to make an impact and change the lives of children with critical illnesses within your community and across Canada
• A collaborative team environment where you feel valued and inspired
• An attractive compensation package that includes group health and dental premiums which are fully covered by the Foundation & Wish paid hours
• Annual vacation starting at three weeks & additional paid leaves
• Hybrid work model
• Work/life balance and flexibility
• Employee Wellness Program
• Corporate discounts
• Continuous learning, development and internal training opportunities
• Fun employee activities, contests, and more

Make-A-Wish Canada is committed to fostering a culture that aims to change lives while offering a rewarding employment experience where your contributions make a true difference every day

WHERE YOU COME IN

We are looking for a Data & Reporting Analyst to join our team at Make-A-Wish Canada. Reporting to the Director, Business Applications, this role works closely with mission, fund development, leadership, and operations teams to understand data needs and translate them into actionable insights. You will play a key role in transforming organizational data into intelligence that supports fundraising, marketing, operational efficiency, and strategic decision-making.

This role can be based out of Toronto or Pickering offices and is a full-time, hybrid, 12-month contract position.

WHAT YOU WILL DO

• Create, implement, and maintain standard reports, dashboards, and alerts to support business decision-making.
• Develop segmentation strategies to support enhanced and personalized supporter journeys.
• Monitor, control, and improve data quality, resolving errors and performing updates as required.
• Collaborate with governance teams to influence how data is collected and reported in alignment with organizational strategy.
• Analyze donor segmentation, engagement levels, campaign performance, and fundraising and marketing metrics.
• Design and maintain interactive, drill-down dashboards and reports within CRM and related platforms.
• Extract, transform, and load data from multiple sources to support cross-application analysis.
• Identify trends related to attrition, donations, engagement, and mission-related metrics.
• Develop processes and reports to monitor data quality and identify anomalies.
• Prepare complex contact lists and final campaign files for communications and database uploads.
• Maintain expertise in data models and standards, and support users with reporting tools.
• Support ad hoc and mass data updates to align with standards and system integrations.
• Provide expertise on information management projects and ongoing support requests.
• Work with management and departmental leaders to prioritize data and reporting needs.
• Perform other duties as assigned.

WHAT YOU BRING

• Education in Mathematics, Information Management, Computer Science, Statistics, or equivalent experience, training and education.
• 7+ years of experience as a data or reporting analyst or in a related field.
• Strong experience working with large datasets and relational databases.
• Experience developing reports and dashboards in Salesforce.
• Proven experience using analytics and visualization tools such as Tableau, Power BI, Excel, SPSS, or SAS.
• Expert knowledge of database and programming languages such as SQL, Python, R, or JSON.
• Strong skills in data modelling, identity reconciliation, duplicate management, and segmentation.
• Expert level Excel skills.
• Salesforce certifications (Administrator, Data Cloud Consultant, Tableau CRM, Einstein Discovery, Marketing Cloud) are an asset.
• Strong analytical, mathematical, and statistical skills with exceptional attention to detail.
• A clear Criminal Background Check is required.

YOUR WORK ENVIRONMENT

• Hybrid work model, with 2 days in-office per week and 3 days remote. Occasional requirement to work outside of regular office hours.

Physical/Mental Effort

• Work under pressure of tight deadlines, balancing high volume workload, and with multiple demands and changing priorities.

Our Commitment to IDEA

Make-A-Wish Canada (MAWC) is committed to Inclusion, Diversity, Equity, and Access (IDEA). We believe that it is essential to our mission that we build a diverse, balanced, and vibrant workforce that reflects the diversity of the communities we serve and seek to serve. Research has shown that candidates from underrepresented groups often only apply when they feel 100% qualified. Therefore, we ask that even if you do not see yourself fully reflected in every job requirement listed on this posting, to still apply.

Recruitment process

Our recruitment process is swift in pace. Once applications are reviewed, we will contact our shortlisted candidates. Our typical process includes a phone screen, one or two interviews, and reference checking, followed by an offer and a criminal background check for the successful candidate.

We would like to thank all applicants for their interest in working with us

ABOUT MAKE-A-WISH CANADA

In the past 40 years, Make-A-Wish Canada has granted over 40,000 wishes across the country, with 2,000 of them last year alone. As an independently operating affiliate of Make-A-Wish International, Make-A-Wish Canada is part of the network of the world's leading children's wish-granting organization. We serve children in every community in Canada, and in more than 50 countries worldwide.