Job Title CO-Foundation Office Data Analyst Posting Number 2193 Position Number D99322 Minimum Salary Commenserate with experience Employee Group Professional Full/Part Time Full Time Temporary/Continuing Continuing 52 or 36 weeks 52 FLSA Status Exempt Suggested Starting Date 12/03/2018 Usual Hours of Work Monday-Friday 8am-5pm; some evenings and weekends will be required. Department Foundation
Position Duties and Responsibilities
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.
PRIMARY DUTIES PERFORMED:
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.
Special Instructions to Applicants Open Date
(mm/dd/yyyy) 09/26/2018 Closing Date
(mm/dd/yyyy) 10/19/2018 Open Until Filled No Quick Link http://jobs.stlcc.edu/postings/7685 Affirmative Action Statement
St. Louis Community College is an Affirmative Action /Equal Opportunity Employer and welcomes individuals with diverse backgrounds, experiences, and ideas who embrace and value diversity and inclusivity.
Special Instructions Summary
If the position requires transcripts, licenses, certificates, etc., please upload this information in order for your application to be considered further.
St. Louis Community College