Job Title |
Development Information Systems Specialist - Development Records
Job Requisition ID
Ofc of Dev & Alumni Relations
031000:DAR: Info Services & Finance
Minimum Hourly $
Midpoint Hourly $
Minimum Annual $
Midpoint Annual $
JOB DESCRIPTION: Responsible for recording gifts received and/or creating, maintaining, and updating constituent biographical records in support of University and Healthcare development activities in high-volume office that processes more than 50,000 gifts annually and maintains a constituent records database of 500,000+ entities. Uses knowledge of relational database concepts, CRM system requirements, and referential integrity to ensure that donor and gift information is accurate and up to date. Manages customer requests using enterprise wide service request software (Service Now).
Gift records processing consists of accurately determining donor intent and gift purpose in recording gift checks and other giving instruments in the donor records CRM system (AWA) by reviewing relevant documentation and CRM data; preparing gift batches in front end processes by using OCR scanning tools and transaction processing technology to capture gift input data and generate balancing and routing documents; reviewing and checking data printouts for accuracy and making appropriate corrections; and managing and conducting large mailings. Pulls gift transaction data for Telefund and online giving activities from third party credit card processor website and uses spreadsheet formulas and functions to prepare data for input and perform reconciliations. Processes gifts, pledges, and deferred gifts in accordance with Emory policies, IRS regulations, and FASB and the Council for Advancement and Support of Education guidelines.
Biographical records involves performing biographical updates and maintaining data integrity through use of relational database integrity functions and spreadsheet formulas & functions to ensure that records are logical and consistent; reviewing and checking data function and query results for accuracy and making appropriate corrections; performing biographic updates and data cleansing in AWA; managing and conducting large mailings; and working with customers to ensure that data integrity standards are followed. Researches current address, employment, and other biographical information using technological resources including Lexis-Nexis and other online demographic tools and databases. Performs related responsibilities as required.
MINIMUM QUALIFICATIONS: A high school diploma or equivalent and three years of office support experience. A bachelor's degree or college coursework will be considered on an equivalent basis in lieu of office support experience. Good basic math skills and analytical abilities are required. Demonstrated ability to use correct grammar, punctuation, and spelling in both written and oral communications. Strong computer skills, including facility with Microsoft Word and Excel. Reliability imperative.
A bachelor’s degree. Three to five years experience with supporting information systems and\or charitable gift processing. Strong understanding of relational databases and reporting tools such as Microsoft Office Suite. Effective organizational skills, oral and written communication skills, strong computer skills, attention to detail and a collaborative work style are required.
Additional Job Details
The Information Systems Specialist is responsible for recording biographic record changes in the various information systems tools and applications that support the Office of Development and Alumni Relations (DAR). Additional responsibilities include document imaging, biographical research, ad-hoc reporting, and general office management support.
Principle Duties and Responsibilities
1. Create, maintain and update constituent records in the information systems that support the Office of Development and University Relations.
2. Maintain the integrity of all biographical data stored in the Development and Alumni Relations database.
3. Review lists, reports and rosters from various campus departments, clubs, and organizations in an effort to maintain a historical record of student interests and involvement during their tenure at the university.
4. Review campus publications for biographical updates needed in the database.
5. Use a variety of web-based search engines as well as third party vendor applications and internal reference resources to research and locate new and updated contact information on constituent records.
6. Generate and review reports to identify inaccurate or incomplete information in the database.
7. Perform routine data modifications and analysis to ensure data conformity within the database.
8. Maintain business documentation as it relates to DAR data conformity standards
9. Advise management and end-users on adhering to data standards.
10. Image and catalogue documents associated with constituent records.
11. Provide ancillary office management support.
12. Utilize Service Now helpdesk software application to manage client requests, work flow, and task management responsibilities.
This position involves: