Senior Development Operations Analyst

Years of Experience: 4 to 5 years of working experience in the non-profit education or for-profit sector.

The Senior Development Operations 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 organizations donor database for Major Gifts Planned Giving and Grants and Foundations donors and supporting KQEDs philanthropy campaigns. The Senior Development Operations Analyst reports to the Director of Development Operations. This position ensures accurate data collectionandentry analyzes data and provides insights to inform fundraising strategies. The Senior Development Operations Analyst will generate reports and dashboards maintain data integrity and is essential for optimizing data-driven fundraising strategies.

This role is a hybrid work position with three days a week (Tuesday Wednesday Thursday) at KQEDs San Francisco office and two days work-from-home (with occasional exceptions). As part of our year-end fundraising efforts this position should be available to work in the office during the last two weeks of December except for major holidays.

Data Management & Maintenance:

• Manage and maintain the Development donor database ensuring theaccuracy and completeness of donor records membership status and 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
• Collaborate with theDirector of Operations to close gift transaction batches and process deposits as needed.
• Track and reconcile Challenge gifts in collaboration with Major gifts and Membership teams.

Monthly Renewals:

• Responsible for the production of monthly fundraising renewal letters in partnership with Major Gift Officers. Assisting with mailings (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:

• Support the Director of Operations in updating the monthly dashboards and extracting 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.

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.
• Work with the Director of Operations and the Membership team to optimize Major Donor database systemsfor performance scalability and reporting needs.
• 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.
• Collaborate with 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.

Qualifications:

• Bachelors degree in business administration data analytics computer science information systems or any related field.
• 4 to 5 years of experience working with donor databases in a nonprofit setting (experience with ROI database Raisers Edge Salesforce or other CRM tools is preferred).
• Strong analytical skills with experience in data management reporting and trend analysis.
• Skilled in Microsoft Excel data visualization tools pivot tables and VLookups.
• Understanding of fundraising and donor stewardship processes.
• Knowledge and understanding of SQL or other programming languages.
• Strong communication skills and ability to collaborate with cross-functional teams.
• Experience with data protection regulations (GDPR CCPA) and nonprofit compliance requirements.

Key Attributes

• Ability to work effectively in a fast-paced environment
• Highly organized and able to effectively manage competing priorities
• Natural collaborator positive attitude flexible reliable team player
• Skilled at learning new software and tools
• Ability to effectively manage deadlines
• Ability to work in-office three days per week at KQEDs headquarters in the Mission district in San Francisco