Data and Reporting Specialist (Whitchurch-Stouffville)

Data and Reporting Specialist (Whitchurch-Stouffville)

31 Oct
|
The Ontario SPCA and Humane Society
|
Whitchurch-Stouffville

31 Oct

The Ontario SPCA and Humane Society

Whitchurch-Stouffville

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 workplace 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

📌 Data and Reporting Specialist (Whitchurch-Stouffville)
🏢 The Ontario SPCA and Humane Society
📍 Whitchurch-Stouffville

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: data and reporting specialist (whitchurch-stouffville) / whitchurch-stouffville

Subscribe to this job alert:

Get the latest job offers by email for: data and reporting specialist (whitchurch-stouffville) / whitchurch-stouffville