Data and Reporting Specialist

Ontario SPCA and Humane Society; Whitchurch-Stouffville; On-site; CAD 58,000 - 65,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

Employee Family Assistance Program

3 weeks vacation to start

Free onsite parking

Apparel discount

Professional development

Job summary

Ontario SPCA and Humane Society is seeking a Data and Reporting Specialist to lead donor segmentation, fundraising analytics, and performance reporting. You will anchor data for the annual giving program, evaluate campaign performance, and extract insights to grow revenue across direct mail, email, and digital campaigns.

The role focuses on translating raw donor data into actionable strategies to improve acquisition, retention, and lifetime value, with a strong emphasis on dashboards and data

Qualifications

• 1+ years data and reporting experience in not-for-profit fundraising.
• Degree or diploma in data analytics, statistics, marketing, finance or related field.
• 3–5+ years in nonprofit fundraising analytics or annual giving.
• Advanced Excel with pivot tables, VLOOKUP/XLOOKUP, and data modeling; BI tools a plus.
• Experience with fundraising CRMs (Raiser’s Edge, Engaging Networks, Salesforce NPSP, Virtuous, EveryAction, Bloomerang).

Responsibilities

• Build and maintain dashboards tracking key fundraising metrics (donations, ROI, retention).
• Analyze donor cohorts, lifetime value, and upgrade opportunities in campaigns.
• Lead data queries and segmentation for direct mail, email, and digital appeals.
• Provide monthly and quarterly analytical summaries to inform budgeting and strategy.
• Ensure data integrity and attribution across campaigns with CRM teams.

Skills

Donor segmentation

Data analytics

A/B testing

CRM queries

Power BI

Excel advanced

Education

Data analytics degree (or related)

Tools

Raiser’s Edge

Engaging Networks

Salesforce NPSP

Virtuous

EveryAction

Bloomerang

Job description

Salary Range: $58,000.00 To $65,000.00 Annually

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
• 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)
• Employee Family Assistance Program
• 3 weeks of vacation to start!
• Free onsite parking
• Discount on Ontario SPCA apparel, Paws & Give merchandise, Virtual pet care, and pet food too!
• Opportunities for professional development

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.
• Model annual giving projections and scenario forecasts during budget planning cycles.
• 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 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.