Senior Development Operations Analyst
KQED, San Francisco, CA, United States
Title: Senior Development Operations Analyst
Schedule Format - Location: Hybrid - San Francisco
Pay Information: $86,427 - $108,034
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 organization’s donor database for Major Gifts, Planned Giving, and Grants and Foundations donors, and supporting KQED’s philanthropy campaigns. The Senior Development Operations Analyst reports to the Director of Development Operations. This position ensures accurate data collection and entry, 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 KQED’s 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. This role will work hybrid between working in KQED's newly renovated headquarters and working remotely.
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.
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.
KQED Code of Ethics https://www.kqed.org/about/code-ethics
The mission that drives us:
KQED provides citizens of Northern California with a community‑supported alternative to commercial media. We provide citizens with the knowledge they need to make informed decisions; convene community dialogue; bring the arts to everyone and engage audiences to share their stories. We help students and teachers thrive in 21st‑century classrooms, and take people of all ages on journeys of exploration—exposing them to new people, places and ideas.
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 for 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 the Director 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. Assist with mailings (merges and prints letters, stuffing and addressing envelopes, generating 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.
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.
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.
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 systems for 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
Bachelor’s 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, Raiser’s 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 KQED’s headquarters in the Mission district in San Francisco
#J-18808-Ljbffr
Schedule Format - Location: Hybrid - San Francisco
Pay Information: $86,427 - $108,034
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 organization’s donor database for Major Gifts, Planned Giving, and Grants and Foundations donors, and supporting KQED’s philanthropy campaigns. The Senior Development Operations Analyst reports to the Director of Development Operations. This position ensures accurate data collection and entry, 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 KQED’s 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. This role will work hybrid between working in KQED's newly renovated headquarters and working remotely.
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.
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.
KQED Code of Ethics https://www.kqed.org/about/code-ethics
The mission that drives us:
KQED provides citizens of Northern California with a community‑supported alternative to commercial media. We provide citizens with the knowledge they need to make informed decisions; convene community dialogue; bring the arts to everyone and engage audiences to share their stories. We help students and teachers thrive in 21st‑century classrooms, and take people of all ages on journeys of exploration—exposing them to new people, places and ideas.
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 for 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 the Director 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. Assist with mailings (merges and prints letters, stuffing and addressing envelopes, generating 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.
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.
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.
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 systems for 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
Bachelor’s 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, Raiser’s 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 KQED’s headquarters in the Mission district in San Francisco
#J-18808-Ljbffr