Data and Reporting Specialist

The Ontario SPCA and Humane Society; Whitchurch-Stouffville; Sur place; CAD 60 000 - 85 000; Plein temps

Avantages offerts par ce poste

Medical, dental and vision benefits

Employee Family Assistance Program

3 weeks vacation to start

Free onsite parking

Discount on Ontario SPCA apparel and P

Résumé du poste

The Ontario SPCA and Humane Society is seeking an analytical, detail-oriented Data and Reporting Specialist to lead donor segmentation, fundraising analytics, donor segmentation, and performance reporting.

You will be the data anchor for our annual giving program, evaluating campaign performance and extracting data to inform growth opportunities across direct mail, email, and digital appeals to help drive revenue.

Qualifications

• 1+ years of data and reporting experience within a not-for-profit organization
• Diploma or degree in data analytics, statistics, marketing, finance, non-profit management or 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); Power BI a plus
• Proven ability to turn complex dataset findings into plain-language strategic recommendations
• Clear, confident communicator with ability to explain data insights and build relationships across the organization
• Builds strong relationships and acts as trusted business partner across the organization
• Strong analytical and problem-solving skills with judgment and a solution-focused approach
• Ability to manage multiple priorities without losing detail

Responsabilités

• Lead donor segmentation and fundraising analytics to drive revenue growth
• Build, maintain, and automate dashboards tracking fundraising metrics (response rate, average gift, net revenue, ROI, CPA, retention, churn)
• Analyze donor cohorts and lifetime value to identify upgrade opportunities and donor win-back strategies
• Deliver monthly and quarterly analytical summaries to inform budget allocations and campaign strategy
• Manage data queries and segmentation in CRMs for direct marketing and email campaigns
• Collaborate on A/B testing models to optimize messaging, offers, and timing
• Ensure data integrity and attribution with CRM administrators and cross-functional partners
• Model annual giving projections and monitor industry benchmarks for performance context

Connaissances

Data analytics

Reporting

Communication

Team collaboration

Formation

Diploma or degree in data analytics, statistics, marketing, finance, non-profit management

Outils

Raiser's Edge

Engaging Networks

Salesforce NPSP

Virtuous

EveryAction

Bloomerang

Power BI

Excel

Description du poste

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.