POSITIONSUMMARY: Performs duties necessary to manage the daily operation of the Advancement module (Banner Advancement), which tracks contributions, alumni, donor, and prospect information. Ensures the accuracy and integrity of the Foundation's information systems, including data input and output, technology management, and end-user training and support. Provides support to Foundation staff by assisting with the creation of reports, ensuring that advancement staff is trained in the proper use of the data, developing and implementing policies to guide data entry, and making sure that the system effectively captures alumni and donor information and generates accurate financial and analytical reports. The data analyst will ensure that all gifts from donors are accurately processed, tracked, acknowledged and reconciled with the finance function. Serves as the first point of contact for Foundation staff with questions about or problems with the use of the system and serves as the liaison to vendors and the IT department in maintaining the system and troubleshooting problems. PRIMARYDUTIESPERFORMED:
Manage and enter data for all gift records and alumni dues, ensuring the processing, tracking, reporting and acknowledgement of private gifts and alumni memberships are performed in accurate and timely fashion. Ensure that the data derived from these activities is maintained in accurate and up-to-date status, and can easily be accessed.
Serve as the software system manager, applying all Banner Advancement updates in a timely manner.
Design functional specs for custom queries for data extraction.
Provide training and technical support for the Banner Advancement alumni/donor database. Including developing written training materials.
Interpret and apply IRS tax laws and regulations regarding gift administration.
Establish and maintain a structure within the system to effectively identify specific segments of data for various analysis and targeted marketing efforts.
Develop and apply procedures to safeguard data security.
Ensure accurate gift processing, demographic records management, and donor acknowledgement. Prepare, update and issue thank-you letters to donors.
Manage the generation of financial, analytical, and demographic reports, as well as mailing lists, invitation lists, recognition lists, and other data extractions as requested.
Develop standards and policies for data entry, and ensure compliance.
Develop and enforce policies and procedures to ensure the integrity of the alumni/donor database.
Builds and maintains positive working relationships with team members, internal customers, and external vendors.
Responsible for cleanup of current system to areas such as proposal use, constituent codes or other necessary areas needing clarity.
Maintain current knowledge of Banner programs. Utilize advanced computer analysis skills, including the use of software to create documents, spreadsheets, timelines, and reports. Develop and generate all reports requested by the Foundation in a timely fashion.
Research data to identify prospective donors for the Foundation.
Help recommend data collection best practices to all staff who come in contact with potential data for the organization.
Assist with research and ongoing process improvement of organization’s data management policies and practices.
Bachelor's degree and a minimum of three years' work experience within the nonprofit organization or higher education environment.
Experience managing development and/or alumni databases.
Proficiency in prospect and constituent management, data imports and exports, developing reports.
Experience with online donor giving tools.
Familiarity with e-communications tools (i.e. Constant Contact, etc.)
Experience with Banner and Cognos Reports
Marketing, communications, and social media experience preferred.
Ability to organize and prioritize work, be proactive, take initiative, resolve problems, follow through, and simultaneously manage multiple priorities, with competing deadlines, to ensure goals are met in a timely manner.
Ability to understand development and alumni staffs' needs so as to accurately translate their requests into effective queries and reports. Skill in making presentations and training individuals in software applications is highly desirable.
Must possess excellent analytical, organizational, and communication skills.
Office software packages, including MS Excel and Access.
Knowledge of applicable tax laws, the fund-raising process, and the concept of donor relations as well as some bookkeeping.
Strong customer service orientation.
High aptitude for relational databases and data management.
St. Louis Community College is the largest community college system in Missouri and the second largest institution of higher education in the state with current credit enrollment each semester of almost 30,000 students. The College is accredited by the North Central Association/Higher Learning Commission. The College includes four campuses, three education centers and district administrative offices enrolling 20,000 students. We offer 15 college-transfer and 90-plus career programs in the areas of art and design, business, civil and community service, engineering and technology, health and office professions; plus continuing education, developmental, and business/industrial training programs. The College employs 1,400+ full-time faculty and staff and 2,300+ part-time faculty and staff