Data & Reporting Analyst – Salesforce

“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 anywhere in Canada and is a full-time, hybrid, permanent position. The hiring range for this role is $75,000 – $85,000.

WHAT YOU WILL DO

• Design, develop, and maintain standard and interactive (drill-down) reports, dashboards, and alerts to support business decision-making.
• Analyze donor segmentation, engagement, campaign performance, and fundraising metrics; identify trends related to attrition, donations, and mission impact.
• Develop and implement segmentation strategies to enable personalized supporter journeys and targeted campaigns.
• Extract, transform, and integrate data from multiple sources to support cross-platform analysis and reporting.
• Monitor, maintain, and improve data quality by developing processes, resolving errors, and identifying anomalies.
• Collaborate with governance teams to ensure data collection, management, and reporting align with organizational standards and strategy.
• Prepare complex contact lists and campaign files for communications, ensuring accuracy and compliance with data standards.
• Maintain expertise in data models, reporting tools, and systems; provide user support and guidance on reporting and data practices.
• Partner with management and stakeholders to prioritize reporting needs and support information management initiatives and ad hoc requests.

WHAT YOU BRING

• Education in Mathematics, Information Management, Computer Science, Statistics, or equivalent experience, training and education.
• Strong experience working with large datasets and relational databases.
• Experience developing reports and dashboards in Salesforce.
• Experience in data reporting and visualization tools such as Tableau or Power BI.
• Experience in analytical tools such as SPSS or SAS.
• Strong skills in data modelling, identity reconciliation, duplicate management, and segmentation.
• 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.

How to apply

If everything you’ve read so far sounds like you, we encourage you to apply now! 

To apply, please navigate to:  https://jobs.dayforcehcm.com/en-CA/makeawishca/CANDIDATEPORTAL/jobs/1281 

Make-A-Wish Canada provides equal opportunity in employment and encourages applications from all qualified candidates. Reasonable accommodations due to disability are available on request at any stage of the hiring process.  

Recruitment process

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 1,800 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.

To find great jobs for youth, check out www.canadayouthworks.ca