Log In
Sign Up
Data Reporting Analyst – Toronto/Pickering Full Time
“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, RRSP, & Wish paid hours
- Annual vacation starting at three weeks & additional paid leaves
- Work/life balance and flexibility
- Hybrid working environment
- 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 of Business Applications, this role will be responsible for working closely with our mission, development, leadership and operations teams in understanding data needs and subsequently developing actionable and valuable intelligence from our data.
This role can be based in Toronto or Pickering and is a full-time, permanent, hybrid position.
WHAT YOU WILL DO
- Create, implement, and maintain standard reports, dashboards, and alerts to support business decision-making and efficient, accurate processing.
- Work closely with our business teams to develop segmentation and support enhanced personalized supporter journeys.
- Monitor and control data quality, resolve errors, and perform updates in the databases as necessary to ensure accuracy.
- Work closely with our governance team to analyze our data and influence how it is collected and reported in alignment with our organizational strategy.
- Track and analyse donor segmentation, engagement levels, campaign performance, and other important fundraising and marketing metrics to drive informed business decisions.
- Develop comprehensive, customized, and interactive drill-down dashboards and reports within the CRM environments and related platforms.
- Extract, transform, and load data from multiple sources into a comprehensive dataset to support cross-application data analysis and reporting.
- Conduct comprehensive data analysis to identify patterns in attrition, donation trends, overall engagement and mission-related metrics.
- Develop processes and reports to monitor and control the quality of data and support the process of identifying issues when anomalies occur.
- Collaborate with business to prepare contact lists for communications supporting complex segmentation and preparing final files for loading into database as campaign members.
- Maintain expertise in our data model and standards. Support and train users in working with canned reports and adjusting for unique scenarios if required.
- Support administrative team in preparing ad hoc and mass updates to data to address issues, align to standards, and to support integration between data sources.
- Provide expertise and support to information management projects and regular support requests.
- Work with management to prioritize business and information needs and with departmental managers to outline the specific data needs for each business unit.
- Other duties as assigned.
WHAT YOU BRING
- Post-secondary education in Mathematics, Information Management, Computer Science or Statistics, or an equivalent combination of education, training and experience.
- 7+ years of work experience as a data or reporting analyst or in a related field.
- 5+ years of work experience in handling large data sets and relational databases.
- 3+ years of work experience developing metrics, reports, and dashboards in Salesforce.
- Proven experience in developing complex analytic reports using statistical packages such as Tableau, Excel, Power BI, SPSS, and SAS.
- Demonstrated experience with Salesforce Marketing and Data Cloud products is an asset.
- Expert knowledge of database languages such as JSON, SQL, R, or Python.
- Proficient in data modelling, identity reconciliation, duplicate management and customer segment building.
- Proficient in Office 365, with expert-level skills in Excel.
- Adept at queries, report writing, and presenting findings.
- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
- Mathematical and statistical skills to help gather, measure, organize, and analyze data.
- High-level written and verbal communication skills.
• A clear Criminal Background Check will be required.
YOUR WORK ENVIRONMENT
- Hybrid work environment (2 days in-office, 3 days remote per week) with occasional requirement to work outside of traditional office hours.
- Occasional day/overnight travel.
Physical/Mental Effort
- Works under pressure of tight deadlines, with a high-volume workload, and with multiple demands & changing priorities.
How to apply
If everything you’ve read so far sounds like you, we encourage you to apply now! The deadline to apply is September 25th, 2024, at 11:59pm ET.
To apply, please navigate to: https://jobs.dayforcehcm.com/en-CA/makeawishca/CANDIDATEPORTAL/jobs/633
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.
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
Since 1983, Make-A-Wish Canada has granted over 39,000 wishes across the country, over 1,389 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.
JOIN OUR ONLINE COMMUNITY
For more information on how you can support Make-A-Wish® Canada or get involved please visit our website at makeawish.ca.
This position is eligible for Canadians of all ages