Fundraising Operations Senior Analyst

Title: Fundraising Operations Senior Analyst Schedule Format – Location: Hybrid – San Francisco Pay Information: Salary Range: $86,427 - $108,034 The Development Operations Senior Analyst will play a critical role in supporting the Major Gifts, Grants and Foundations, and Planned Giving teams at KQED by managing and optimizing the organization’s donor database for Major Gifts, Planned Giving, and Grants and Foundations donors, and supporting KQED’s philanthropy campaigns. This position ensures accurate data collection and entry, analyzes data, and provides insights to inform fundraising strategies. It will generate reports and dashboards, maintain data integrity, and is essential for optimizing data‑driven fundraising strategies. We value the contributions of marginalized people in society — including Black, Indigenous, and all people of color, people with disabilities, and LGBTQIA+ people — and we believe that these communities must be centered in the work we do, and we strongly encourage members of these communities to apply. Essential Functions Data Management & Maintenance Manage and maintain the Development donor database, ensuring accuracy and completeness of donor records, membership status, renewal dates, gift payments, and pledge tracking. Conduct regular audits to maintain data integrity, including cleansing, de‑duplication, and updating contact information. Process complex transactions for grants, foundations, stocks, estate gifts, pledge commitments, payment tracking, invoicing, and finalize gift transaction batches and deposits. Identify workflow for management of Challenge gifts in collaboration with Major Gifts and Membership teams. Monthly Renewals Produce monthly fundraising renewal letters in partnership with Major Gift Officers; assist with mailings, merges, printing, stuffing, addressing envelopes, and labeling. Prepare spreadsheets and workbooks for mail merge projects; create and distribute tax letters and other donor information. Data Analysis & Reporting Update monthly dashboards and extract data from the CRM donor database for tracking revenue, goals, and metrics. Support campaign data tracking, dashboard creation, and analyze Major Donor data to identify trends, patterns, and opportunities for growth and engagement. Generate regular and ad hoc reports on donor retention, acquisition, giving trends, and performance for development and fundraising teams. Segment donor lists for targeted digital communications, appeals, and stewardship. Use SQL for data extraction, audience segmentation, and audit donor data integrity. Design and maintain interactive dashboards (e.g., Google Looker Studio) to translate technical data into actionable insights for non‑technical stakeholders. Fundraising Support Provide data‑driven insights to inform fundraising strategies, planning, and donor cultivation. Collaborate with development officers to analyze performance of portfolios and initiatives. Systems Optimization Support acquisition, implementation, and modification of new analytics tools. Troubleshoot database issues and collaborate on system upgrades, integrations, and process improvements. Stay updated on best practices and emerging technologies related to database management and fundraising analytics. Collaboration & Training Collaborate with the fundraising team to understand data needs and provide appropriate tools and resources. Support Major Gift Officers, Planned Giving, Grants, and Foundations teams with database usage, donor entry, and reporting. Work closely with the Finance team to reconcile donations and ensure financial data accuracy. Track grant deliverables with the Foundations and Grants teams. Create presentations for leadership and the KQED Board using PowerPoint, Excel, and data visualizations. Compliance & Security Ensure compliance of Major donor data with data protection regulations and organizational policies. Implement security protocols to safeguard sensitive donor information. Support annual audits by providing necessary documentation and reports. #J-18808-Ljbffr Kqed Inc