Assistant Director, Philanthropy Reporting & Analytics

Reporting to the Deputy Director, Philanthropy Data Strategy, the Assistant Director, Philanthropy Reporting & Analytics serves as the analytics focal point and product owner within the Philanthropy Division for Direct Response fundraising. This role delivers actionable intelligence across integrated full-funnel work — spanning both online and offline channels — and partners directly with the Vice President of Donor Marketing and Journeying and their team to develop data-driven campaign strategy, driving decisions on audience segmentation, channel investment, donor retention, and revenue optimization.

As the primary analytics partner for one of the organization's largest revenue-generating functions, this role maintains the fundraising reporting ecosystem, partnering with Technology teams, to ensure that Direct Response data needs are represented, prioritized, and effectively translated across technical and strategic stakeholders. Where marketing analytics intersect with broader organizational needs, this role partners closely with the COE as a collaborative contributor, ensuring Direct Response online and offline programs are fully represented in integrated analysis.

• Serve as the primary analytics partner to the Direct Response team; build trusted relationships through responsiveness, accuracy, and strategic insight.
• Manage the evergreen reporting pipeline for all Direct Response analytics requests — including but not limited to digital revenue, end-of-year, and Giving Tuesday reporting — ensuring timely delivery and clear prioritization.
• Conduct ad hoc analyses and cyclical reporting projects as requested by leadership and stakeholders, including annual donor survey analysis; prepare and present findings for Monthly and Quarterly Business Reviews, leveraging Excel workbooks, PowerPoint decks, and effective data visualization to convey key insights.
• Translate senior leadership business questions into analytical frameworks; advise on full-funnel KPI definitions and build online/offline acquisition KPIs and reporting to measure lead generation activations; monitor campaign and channel performance to identify trends, anomalies, and data integrity issues.
• In partnership with Technology, architect and maintain the Power BI dashboard ecosystem for Direct Response, including development, maintenance, and enhancement of sustainable evergreen reports and ad hoc deliverables.
• In alignment with enterprise data governance definitions, analyze performance across online and offline channels— including but not limited to donor counts, response rates, cost per acquisition, cost per dollar raised, ROI/ROAS, break-even points, and donor file health metrics (retention, reactivation, attrition, lifetime value).
• Monitor sustainer/monthly giving program performance including conversion, retention, upgrade, and average gift trends; develop segmentation frameworks to support targeting and personalization strategies.
• Contribute fundraising domain expertise to lifetime value calculations, multi-click attribution models, and cross-functional modeling initiatives to optimize channel mix investment; participate in weekly paid media calls to stay aligned on platform changes, campaign performance, and modeling efforts led by Technology or external partners.
• Assume maintenance of revenue budgeting cycles and iterate and execute revenue projection methodologies in partnership with Technology and with input from key stakeholders including Deputy Director, Philanthropy Data Strategy, Vice President, Donor Marketing & Journeys, and Vice President, Philanthropy Insight; collaborate with online and offline vendors on projections and modeling inputs — learning their methodologies to inform internal forecasting and validate external estimates.
• Support real-time emergency fundraising activations with rapid analytics, cross-channel performance tracking, and donor response monitoring; validate FundraiseUp form structure and configuration to ensure accurate attribution and reporting during emergency campaigns.

• Bachelor's degree in Statistics, Economics, Business Analytics, Mathematics, or related quantitative field; or equivalent combination of education and professional experience.
• 5–7 years of progressive experience in fundraising analytics, direct response marketing analytics, or nonprofit business intelligence.
• Demonstrated experience analyzing and optimizing multi-channel direct response programs — including digital, direct mail, email, and telemarketing — with working knowledge of direct response fundraising metrics and sustainer/monthly giving program mechanics.
• Experience with multi-channel attribution methodologies, statistical methods including lifetime value calculations and segmentation, and donor modeling techniques.
• Advanced proficiency in Power BI (DAX, data modeling, dashboard development), SQL for data manipulation and cross-system queries, and Excel (pivot tables, VLOOKUP/XLOOKUP, INDEX-MATCH, Power Query, and complex formulas).
• Advanced proficiency in BBCRM or comparable enterprise CRM; familiarity with FundraiseUp or similar online giving platforms.
• Understanding of revenue recognition, reconciliation processes, nonprofit GL structure, and fund accounting basics; experience with budgeting and forecasting cycles.
• Ability to translate business questions into analytical frameworks, conduct root cause analysis, and manage competing deliverables under tight deadlines; strong documentation and knowledge management skills.
• Demonstrated stakeholder management skills at the VP level with clear written and verbal communication skills.
• Experience with emergency/disaster fundraising response, paid media platforms, marketing data, and donor survey analysis preferred.