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 anywhere in Canada 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. - 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