Fundraising Operations Senior Analyst

KQED; San Francisco (CA); Hybrid; USD 80,000 - 100,000; Full time

Job summary

KQED is looking for a Fundraising Operations Senior Analyst who will manage and optimize our donor database while supporting the Major Gifts, Grants and Foundations, and Planned Giving teams. The ideal candidate has strong data management skills and will ensure accurate data collection and entry, analyze fundraising data, and generate insightful reports.

This hybrid role requires a Bachelor's degree and strong proficiency in SQL and data analysis tools like Google Looker Studio.

Qualifications

• Experience in managing donor databases and data entry.
• Proficiency in data analysis and reporting.
• Ability to collaborate with various teams for fundraising support.

Responsibilities

• Manage and maintain the Development donor database for accuracy.
• Conduct data audits, cleansings, and updates.
• Process transactions for grants and donations efficiently.
• Support campaign data tracking and reporting needs.
• Design dashboards for actionable insights.

Skills

Database management

Data analysis

SQL proficiency

Customer relationship management (CRM)

Communication skills

Collaboration

Education

Bachelor's degree in a relevant field

Tools

Google Looker Studio

Excel

Job description

Overview

Title: Fundraising Operations Senior Analyst. 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. The Development Operations Senior Analyst reports to the Executive Director, Membership Operations. This position ensures accurate data collection and entry, analyzes data, and provides insights to inform fundraising strategies. This position will generate reports and dashboards, maintain data integrity, and is essential for optimizing data-driven fundraising strategies.

KQED envisions a public media organization with a culture that centers on human dignity, equity, and belonging. This will enable us to better serve and reflect the Bay Area through diverse and inclusive storytelling.

This role will work hybrid between working in KQED’s newly renovated headquarters and working remotely.

Responsibilities

• Data Management & Maintenance: Manage and maintain the Development donor database, ensuring the accuracy and completeness of donor records, membership status, renewal dates, gift payments and pledge tracking in each record.
• Conduct regular audits to maintain data integrity, including cleansing, de-duplication, and updating contact information.
• Process complex transactions for grants, foundations, stocks and estate gifts, as well as pledge commitment entry, payment tracking, and invoicing.
• Finalizes gift transaction batches and processes deposits.
• Identifies workflow for management of Challenge gifts in collaboration with Major gifts and Membership teams.
• Monthly Renewals: Responsible for the data production of monthly fundraising renewal letters in partnership with Major Gift Officers. Assists with mailings as needed (i.e., merges and prints letters, stuffs and addresses envelopes, generates labels, etc.).
• Assist with the preparation of spreadsheets and workbooks for projects requiring mail merge; Help create and distribute tax letters and other important donor information.
• Data Analysis & Reporting: Updates the monthly dashboards and extracts data from the CRM donor database system for tracking revenue, goals, and metrics.
• Support Campaign data tracking and dashboard creation.
• Analyze Major Donor data to identify trends, patterns, and opportunities for fundraising growth and improved donor engagement.
• Generate regular and ad hoc reports for development and fundraising teams, including metrics on donor retention, acquisition, giving trends, and ongoing monthly and quarterly performance reports.
• Segment donor lists for targeted digital communications, appeals, and stewardship efforts.
• Showcase SQL proficiency to perform data extractions, identify audience segments, and audit donor data integrity within the database.
• Design and maintain interactive dashboards (Google Looker Studio or similar platform) to translate raw technical data into actionable visual insights for non-technical stakeholders to support executive decision-making.
• Fundraising Support: Provide data-driven insights to inform fundraising strategies, planning, and donor cultivation.
• Collaborate with development officers to analyze the performance of portfolios and fundraising 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 industry best practices and emerging technologies related to database management and fundraising analytics.
• Collaboration & Training: Collaborate with the fundraising team to understand their data needs and provide appropriate tools and resources.
• Support Major Gift officers, Planned Giving team, Grants, and Foundations team to ensure they adequately use the database and are comfortable with donor data entry and reporting functions.
• Work closely with the Finance team to reconcile donations and ensure financial data accuracy.
• Track grant deliverables in collaboration with the Foundations and Grants team.
• Create presentations for leadership and KQED Board, including PowerPoint, Excel spreadsheets, and data visualizations.
• Compliance & Security: Ensure all Major donor data complies with data protection regulations and organizational policies.
• Implement security protocols to safeguard sensitive donor information.
• Support annual audits by providing necessary documentation and reports.