Database Analyst - Foundation
Role details
Job location
Tech stack
Job description
The Illinois Central College (ICC) Educational Foundation is a non-profit 501 (c)(3) organization, governed by a volunteer Board of Directors. The mission of the ICC Educational Foundation is to serve the College by assuring access to higher education for our community. The Foundation Database Analyst is responsible for supporting the overall health and well-being of the ICC Educational Foundation through managing the Foundation's donor database. The Analyst serves as a highly visible team member to identify, gather, produce, and present strategic prospect information on corporations, foundations, and individuals from a wide variety of sources as they relate to philanthropic capacity and inclination., This list is meant to be representative, not exhaustive. Some incumbents may not perform all the duties listed while in other cases related duties may also be assigned. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Provide general and confidential duties including data and accounting processing, preparing and maintaining records, and managing deposits and expenditures for a $40+ million portfolio.
- Responsible for utilization of the College's fundraising management software, including database management and reporting, security and integrity, and supporting staff on the use of the software and data.
- Design and execute comprehensive system cleanup projects, data enrichment initiatives, and database integrations to modernize the platform and ensure the highest level of data accuracy and strategic utility.
- Lead the transition to and maintain Merchant Services within the database online giving solution to modernize the digital giving experience, streamline processing, and implement automated, timely gift acknowledgments.
- Provide day-to-day maintenance of constituent, event and financial records for the ICC Educational Foundation through database maintenance, data entry, and general bookkeeping of departmental accounts and funds.
- Reconcile financial data with the Controller's office.
- Design and lead the Employee Gifting Program.
- Provide support for all special events in the department.
- Design and lead a prospect research management program to provide information facilitating the solicitation of corporations, foundations and individuals.
- Oversee extraction of information from database to meet reporting and research needs of the Foundation team, including dashboard development and management.
- Process donations and reconcile accounts using ICC accounting standards, while ensuring adherence to Foundation policies, procedures and internal controls.
- Provide relevant statements, queries and reports to stakeholders.
- Ensure compliance with industry standards and guidelines, including filing appropriate paperwork with the Internal Revenue Service, state of Illinois and as needed for the annual audit.
- Research and manage alumni records in coordination with Foundation staff to identify and track prospects for alumni relations marketing and solicitation.
- Participate in the ICC Educational Foundation Board of Directors meetings, including the finance committee meetings.
- Perform related duties as required.
Requirements
- Associate's degree, or three years of experience in bookkeeping, accounting, fundraising or related field.
- One of more years of experience with Blackbaud Raiser's Edge NXT donor software or equivalent.
- Proficient in Microsoft Office Suite.
- Ability to work effectively as a team leader with the capability to train staff.
- Ability to anticipate needs and recognize opportunities.
- Must be a self-starter with strong attention to detail, organizational and problem-solving skills with the ability to prioritize tasks for completion with limited oversight while utilizing independent judgment.
- Strong verbal and written communication skills.
- Ability to maintain professionalism and confidentiality with staff, donors and governing boards.
- Strong interpersonal skills with a friendly, pleasant personality, diplomacy and tact, to establish and maintain cooperative and professional working relationships with others., * Bachelor's degree in related field.
- Experience in a non-profit foundation or organization, preferably in higher education.
- Experience with general fundraising principles and practices.
- Ability to support and understand the development process: identification, qualification, cultivation, solicitation, and stewardship.
Benefits & conditions
Childcare, 403(b), Health insurance, Paid time off, Vision insurance, Dental insurance, Life insurance, Disability insurance