Donor Data Operations Lead for Philanthropy

Rocky Mountain PBS; Denver (CO); On-site; USD 54,000 - 70,000; Full time

Job summary

Rocky Mountain Public Media in Denver seeks a Philanthropy Data Operations Coordinator to manage the donor CRM (ROI Solutions REV CRM), ensure data integrity, and support fundraising campaigns. You will maintain donor records, prepare gift reports, and collaborate with Philanthropy, Finance, Membership, and external vendors to ensure accurate data and timely reporting.

This role emphasizes data governance, campaigns data uploads, and stewardship support within a mission-driven public media

Qualifications

• Bachelor's degree in a related field, or equivalent combination of education and experience.
• 2-4 years of experience working with a donor or constituent database (e.g., ROI Solutions REV CRM, Raiser's Edge, Salesforce, or similar CRM platform).
• Demonstrated experience with gift entry, data management, and reporting in a fundraising or nonprofit environment.
• Strong analytical skills and comfort working with complex datasets, queries, and reporting tools.
• High level of accuracy and attention to detail, with strong organizational and time-management skills.
• Proficiency in Microsoft Excel; general proficiency with Outlook, Word, and related office software.

Responsibilities

• Serve as the primary administrator for the donor CRM (ROI Solutions REV CRM).
• Maintain the integrity, structure, and accuracy of donor records and gift information within the database.
• Establish and maintain data governance practices and data standards to ensure consistent database usage across the Philanthropy team.
• Develop and document processes and procedures related to gift entry, reporting, and data hygiene.
• Conduct routine database audits and maintenance to ensure accuracy and data health.
• Serve as the internal resource for database questions and provide staff guidance on proper database usage.
• Record philanthropic gifts (typically $1,200+) in the donor database and ensure donor information is updated and accurate.
• Collaborate with the Philanthropy and Finance teams to ensure timely gift processing and accurate documentation of donations.
• Support the preparation of weekly and monthly gift reports.
• Partner with Finance on monthly reconciliation of philanthropic revenue.
• Ensure gifts, pledges, and donor designations are accurately tracked and recorded.
• Pull routine and ad hoc reports from the donor database to support fundraising activities, donor stewardship, and leadership reporting.
• Generate donor lists, giving reports, campaign data, and other reports needed by the Philanthropy team.
• Create and maintain complex, "Level 2" reports using system queries and advanced reporting capabilities within Rev CRM.
• Prepare reports used in campaign planning, donor engagement discussions, and fundraising performance tracking.
• Participate in team conversations where donor and campaign data are reviewed and discussed, ensuring accurate information is available for decision-making.
• Monitor fundraising data to identify potential errors or inconsistencies and resolve them as needed.
• Create donor lists and segmentation reports to support fundraising campaigns, mailings, and events.
• Manage routine and annual data uploads and tracking related to donor communications, campaigns, and major donor activities.
• Coordinate with internal teams and third-party vendors to ensure accurate data is used in campaign outreach.
• Track campaign performance data and provide reports to support evaluation and planning.
• Provide lists and reports to support gift acknowledgments, stewardship outreach, and donor renewal efforts.
• Generate prospect lists and donor reports using the Audience Activation Platform and other available data tools.
• Assist in identifying donors with higher giving capacity or engagement potential for further review by the Philanthropy team.
• Serve as a liaison to other teams at RMPM when donor data, reports, or lists are needed.
• Coordinate data exchanges and reporting with third-party fundraising vendors and CDP.
• Manage requests related to donor data and ensure that information shared internally and externally meets established data standards.
• Maintain data uploads to platforms such as Simply Noted and other donor communication tools.
• Actively participates in RMPM's Diversity, Equity, and Inclusion (DEI) training program. Uses key standards and teachings of DEI training in day-to-day work.
• Other tasks as assigned and/or required.

Skills

Analytical skills

Written and verbal communication

Attention to detail

Time management

Education

Bachelor's degree in a related field

Tools

ROI Solutions REV CRM

Raiser's Edge

Salesforce

Microsoft Excel

Job description

Rocky Mountain Public Media in Denver seeks a Philanthropy Data Operations Coordinator to manage the donor CRM (ROI Solutions REV CRM), ensure data integrity, and support fundraising campaigns. You will maintain donor records, prepare gift reports, and collaborate with Philanthropy, Finance, Membership, and external vendors to ensure accurate data and timely reporting.

This role emphasizes data governance, campaigns data uploads, and stewardship support within a mission-driven public media