Data and Reporting Specialist

Who We Are

The Ontario SPCA and Humane Society is a registered charity and has been operating for 150 years. The Society provides care, comfort and compassion to animals in need in communities across Ontario; we value all animals and advocate to treat them with respect and kindness. We strive to keep pets and families together and do so through a variety of community support services.

Our Values

Our core values include having compassion for the people and animals we serve. Being transparent with the individuals we interact with every day and the team members we work with. Each day striving for excellence in relation to animal welfare. Collaborating with one another to ensure a team spirit in caring for the animals. We take accountability for our actions and the impact we are making in pet-related care. All our values add up to ensure the upmost care, comfort and compassion and to treat the animals and the communities we serve with respect and kindness.

• Compassion
• Transparency
• Excellence
• Collaboration
• Accountability

Why You Should Join Our Team

• Be part of an energetic team environment with others who share your passion for animal wellbeing!
• Competitive compensation package including medical, dental and vision benefits (For permanent full-time employees)
• Hybrid - Remote Opportunity
• Employee Family Assistance Program
• Paid sick time (For permanent full-time employees)
• 3 weeks of vacation to start!
• Predictable daytime hours
• Free onsite parking
• Discount on Ontario SPCA apparel, Paws & Give merchandise, Virtual pet care, and pet food too!
• Opportunities for professional development

Opportunity

We are seeking an analytical, detail-oriented Data and Reporting Specialist to lead our donor segmentation, fundraising analytics, donor segmentation, and performance reporting.

In this role, you will serve as the data anchor for our annual giving program, evaluating campaign performance, tracking donor lifecycle trends, extracting data for donor segments, and identifying growth opportunities across direct mail, email, and digital appeals to help drive revenue generation.
If you thrive on translating raw donor data into actionable strategic insights to improve donor acquisition, retention and lifetime value, this position is for you.

A Typical Day

Reporting, Analytics & Insights – 25%

• Build, maintain, and automate regular performance dashboards tracking key fundraising metrics (response rate, average gift, net revenue, ROI, cost-per-dollar-raised, retention rate, and churn).
• Perform deep-dive evaluations post-campaign to identify trends, channel effectiveness, and donor behaviour across direct mail, digital, and monthly giving programs.
• Analyze donor cohorts, giving levels, and lifetime value (LTV) to uncover opportunities for mid-level upgrades, lapsed donor win-back, and monthly donor conversion.
• Deliver monthly and quarterly analytical summaries to inform future budget allocations and campaign strategy.

Audience Segmentation & List Management – 50%

• Lead list selection and data queries within our CRMs for all direct marketing and email campaigns, ensuring accurate segmentation, ask-string logic, and suppression lists.
• In collaboration with the Manager, Digital Fundraising and the Director, Annual Giving, establish A/B testing models to evaluate messaging, call-to-action, ask amounts, and channel timing.
• Partner with the Database Administrator to ensure data integrity, consistent coding, and accurate attribution of annual gifts.

Program Strategy & Forecasting – 25%

• Model annual giving projections and scenario forecasts during budget planning cycles.
• Track donor funnel movement (Acquisition → Second Gift → Recurring → Mid-Level) and recommend data-driven retention strategies.
• Monitor industry benchmarks to measure organizational performance against sector standards.

Set up for Success!

• 1+ years of data and reporting experience within a not-for-profit organization is a must!
• Diploma or degree in data analytics, statistics, marketing, finance, non-profit management or a related field, or equivalent experience
• 3–5+ years of relevant experience in non-profit fundraising, annual giving, or marketing analytics.
• Advanced proficiency with reporting, queries, and segmentation in fundraising CRMs (e.g., Raiser's Edge, Engaging Networks, Salesforce NPSP, Virtuous, EveryAction, or Bloomerang).
• Mastery of Microsoft Excel (pivot tables, advanced formulas, VLOOKUP/XLOOKUP, data modeling); experience with Business Intelligence tools (ie. Power BI) is a plus.
• Proven ability to turn complex dataset findings into plain-language strategic recommendations.
• Clear, confident communicator, in writing and in person, who can explain the story behind the data and offer useful insight in analysis and reports
• Builds strong relationships at all levels and works as a trusted business partner and team player across the organization
• Strong analytical and problem-solving skills, with sound judgement and a solution-focused approach to decision-making
• Able to manage multiple priorities at once without losing attention to detail

We Can’t Wait to Meet You!

• Click Apply Now and upload your resume and cover letter.

We wish to thank all applicants for their interest in the Ontario SPCA and Humane Society, however only those selected for an interview will be contacted.

The Ontario SPCA and Humane Society is committed to fostering an inclusive and accessible workplace. Accommodation is available throughout the recruitment process upon request. For any questions, suggestions or required documents regarding accessibility in a different format, please contact us at 888-668-7722.

Our Commitment to a Human-Centered Hiring Process

Our organization complies with Ontario Employment Standards Act, 2000, and relevant privacy legislation. While we use technology to help manage applications efficiently, resumes are personally reviewed by a member of our recruitment team. From screening to interviews and final decisions, our process is rooted in a human-centered approach.