Database & Donor Relations Coordinator

Description:

The Database & Donor Relations Coordinator plays a pivotal role within AWA’s Development Department by ensuring the integrity, accuracy, and strategic use of donor and constituent data. This position is responsible for the maintenance and optimization of AWA’s donor database systems, donor analytics, and reporting functions that support fundraising growth and donor stewardship efforts. 

ESSENTIAL FUNCTIONS:

Data Maintenance

Maintain and update AWA constituent records with pertinent contact information as needed to ensure contact information is accurate and complete. Review constituent records for duplications and merge or eliminate records as needed to maintain data integrity. Create new constituent records as required.
Globally update constituent records with campaigns/appeal fields and action tracks
Run quarterly (or EOM) duplication records reports and eliminate duplicate constituent records to ensure continued accuracy
Collaborate with GoFundMe Pro, PayPal and other vendors to resolve issues related to constituent data, donation processing, reporting, system functionality, and integrations
Creation and maintaining SalesForce campaigns
Responsible that updates issued for vendor databases (SalesForce, GoFundMe Pro etc.) are completed as per time requirements
Perform other duties as assigned, including assisting with periodic evaluation of potential data/system vendors
Data Administration and Management

Oversee aspects of donor database including constituent gift entry, record maintenance, and general donor acknowledgement
Manage AWA’s online giving process – online appeals, event income, IHO/IMO, general donations
Ensuring proper gift coding, tracking, and reconciliation
Manage monthly online giving recurring gift programs and matching gift processes, including donor stewardship and payment monitoring
Track donor communications and acknowledgement activities within SalesForce
Generate donor reports to coordinate donor acknowledgement letters, ensuring timely recognition of contribution and identifying donors requiring personal notes, phone calls, or enhanced stewardship.
Manage on-line donation flow daily with GoFundMe Pro and SalesForce
Assist with entering of donations received from AWA events and outreach
Reconciliation of AWA bank statement when electronic development deposits are made. This involves going to a number of company websites to access donor information for each deposit and entering appropriately into SalesForce and the bank statement spreadsheet
Follow daily protocols for clean-up of SalesForce data
Assist with managing timeline for major mailings and production of information/reports to meet deadlines
Creation of annual, quarterly, monthly and ad-hoc donor reports assigned
Creation of donor email/mail segmentation lists using SalesForce for donor communication
Create data reports and exports for AWA mailings (invitations, special appeals, newsletters, events etc.) and including suppression lists
Import of data into Salesforce, and utilize external information about our donors
Coordinate and plan for handling large volume of gifts during peak times
Assist with donation entries into SalesForce as needed
Pull weekly Petpoint reports from shelter and enter donations and adoptions into Salesforce
Pull weekly Idexx Neo reports from clinic entering all data into database as engagements. Pull donations from clinic weekly
Overseeing continued accuracy of account engagement automations in SalesForce and creation of new automations as needed
Perform other duties as assigned, including assisting with periodic evaluation of potential data/system vendors and assisting with new donor and database vendor reporting
GoFundMe Pro Fundraising Platform

Oversight of GoFundMe Pro campaigns
Creation and updating yearly campaigns as needed for AWA departments
Responsible for monitoring the donation/ticketing flow from GoFundMe Pro into Salesforce for correct data, CoA, and Salesforce reporting capability
Addressing and correcting issues identified
Working with Marketing & Communications Manager to ensure appropriate flow of campaigns with AWA website
Additional coordination and updating of platform for AWA departments as needed
Perform additional duties with GoFundMe Pro platform as assigned
Campaign Oversight and Donor Relations

Corporate Partnerships
Assist with managing assigned corporate partnerships
Facilitate communication and updates regarding AWA and the impact of their support
Giving Campaigns
Research of data and submission of applications to ensure AWA participation in Giving Campaigns
Cultivation of donors that engage with AWA through Giving Campaigns
Including updating donors about AWA
Recurring Donations
Review and maintenance of Constant Companion monthly payments including declined payments and/or duplication of payments
Work with Development Manager to create regular communication to ensure CC donors continue to be engaged with AWA