Working Hours:        

Specific work hours to be agreed upon by the supervisor and employee prior to the onset of employment.

NOTE:   this position may require evening and weekend work on occasion. The employee has the option of working this time, in addition to, or in lieu of regular hours.

Summary:   

The Database and Advancement/Alumni Support Specialist reports to the Manager of Foundation in activities related to fundraising and constituent engagement for the Foundation for RACC, the Miller Center for the Arts, and the college itself.  This position manages all donor records and is responsible for the quality standards of the data, provides ongoing fundraising reports to gift officers, and provides communication and customer service to all constituent groups.

Essential Duties and Responsibilities: 

1. Manage the Foundation’s CRM system (DonorPerfect) to fulfill the following duties:
   1. Input gifts and pledges and process acknowledgment letters for both the Foundation for RACC and the Miller Center for the Arts.
   2. Reconcile gifts and pledges with the foundation’s accountant during financial audits to ensure that gift data is properly coded and communicated in the accounting software.
   3. Create and run complex queries, exports and reports to support fundraising efforts for staff and volunteer use.  This includes annual giving, planned gifts, matching gifts, events, campaign reporting, as well as weekly, monthly, quarterly and annual fundraising reports. 
   4. Report on gift revenue progress and goals for both the Foundation for RACC and the Miller Center for the Arts.
   5. Create and implement data oversight functions and train staff to ensure a high standard of “clean” data is being maintained.
   6. Ensure the ongoing documentation of the database setup, data entry procedures, and data output procedures.
   7. Implement a comprehensive email and communication plan for donors to the Foundation for RACC, the greater college community and the RACC Alumni population.
   8. Responsible for creating a culture of data quality by following and establishing quality assurance protocols, processes, documentation and training.
   9. Manage user access across the department.
2. Serve as the administrator for the college’s alumni base, with responsibilities, including but not limited to, managing alumni-related databases, alumni correspondence, and assisting with alumni-focused events.
3. Collaborate with gift officer(s) to implement, evaluate and standardize prospect management policies and procedures in the database and create prospect management reports for staff and volunteer use.
4. Actively participate as an integrated member of the Advancement team; attend and actively participate in staff meetings, fundraising meetings, retreats and department events.
5. Other duties as assigned.

Supervisory Responsibilities:                                             

This job has no supervisory responsibilities.

Qualifications: 

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education and/or Experience:

 Required       

1. High school diploma required.
2. Minimum one year of experience in a development/advancement office environment, non-profit setting, or advanced use of an integrated CRM database, or an equivalent combination of experience.
3. Strong demonstrated experience with Microsoft Office suite and accounting/budgeting software systems.

Preferred

1. B.A/B.S. degree from an accredited college or university.
2. DonorPerfect software experience.
3. Bilingual: English / Spanish.

Other Skills and Abilities:

• Excellent communication skills.   
• Excellent interpersonal skills.  Ability to work well with people.
• Excellent written communication skills especially in the areas of report writing and business correspondence. 

Computer Skills:

To perform this job successfully, an individual should be proficient in the use of Microsoft Office (especially Word, Excel, and PowerPoint) and Internet skills.  Knowledge of Ellucian Colleague or other administrative software a plus.

Certificates, Licenses and Registrations:

None

Communication Skills:                                           

Ability to write reports, business correspondence, and procedure manuals.  Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.

Reasoning Ability:                                                   

Ability to solve practical problems and deal with a variety of concrete variables in situations.

Mathematical Skills:

Intermediate Skills: Ability to calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, area, circumference, and volume.

Physical Demands: 

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to talk or hear. The employee is frequently required to stand, to sit and to reach with hands and arms. The employee is occasionally required to walk and stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 25 pounds.

Work Environment:

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.  The noise level in the work environment is usually moderate.