Foundation Administrative Analyst

Position is 40 hours per week. The position will collect and analyze data and develop recommendations and reports to support the work of the Foundation.  Additional responsibilities include administrative and accounting support as well as other duties as assigned.
This individual will negotiate competing timelines while supporting the Foundation office.
This position requires a high level of analytical ability, organization, ability to multi-task and willingness to take initiative. This person will work independently and be responsible for specific projects. The ability to concentrate and pay close attention to details and maintain a large amount of paperwork pertinent to foundation work is necessary. This person must have strong interpersonal, oral, and written communication skills. This person must also have solid computer skills in a PC environment. Proficiency with Microsoft office suite, and the Internet are required. Additional computer skills in Adobe, Blackbaud Raisers Edge and Colleague (Ellucian) are preferred.
Reports to Foundation Director of Operations.
Requirements:

• Associates Degree in a Business, Accounting, or Information Technology related field
• Must have some experience in accounting or have taken at least one accounting class.
• Adhere to code of confidentiality related to constituent information and donors.

• Database

• Mastery of Raisers Edge Software data program is critical. Enter and update data to maintain accurate lists(s) for all the Foundation campaigns, projects, events, etc. Data health will be a vital component of database software. Example: uploads new alumni yearly for Alumni Director.
• Access to and understanding of College software, i.e, Ellucian, is required.
• Input and reconcile of monthly payroll deductions.
  • Creates detailed queries and reports and mailing lists from Raisers to support the work of the Foundation
  • Provides support and guidance for data gathering, management, and reporting for the Foundation
  • Analyzes collected data for trends and outliers with an eye toward improving the Foundation’s efficiency and fundraising.
  • Provides assistance to leadership in tracking and retrieval, measurement, and analysis of fundraising methods, goals, and territory assignments.
  • Protects Donor Privacy and works with database company to assure compliance.
  • Manages relationship with database company and all updates to data.

• Administrative Task

• Assists Director of Operations with the day-to-day operation of the Foundation Office i.e., various clerical tasks to include filing, copying, preparing mailings, etc.
• Provide coverage for office while other staff are away from the office, i.e., answer phones, greet constituents, etc.
• Prepares thank you letters and invoices for outstanding pledges sent to donors.
• Engages with CCC employees, retirees, donors and other constituents of the Foundation
• Attends staff meetings bi-monthly and foundation staff finance meetings- monthly
• Orders and maintains stock of office supplies, i.e. stationary, items for special mailings, etc. in conjunction with the Director of Operations. This includes organization of workroom, storage room, and other areas within the Foundation office.

• Accounting

• Records deposits on a spreadsheet to balance with Director of Operations’ entries in Raisers. After balance is confirmed, deposit is made using online banking app. If cash is included in deposit, deposit must be made at local bank.

• Balances endowed funds annually and restricted funds as directed.  Prepares letters and statements to select donors as required

• Assist Treasurer with audit preparation

• Events

• Provides support as needed with CCC Retiree Events, Rotary Event, Pro Am Golf Tournament, and other events. Some evenings and weekends may be required.

• Website
  • Manage website ticketing system, reporting, online payment portals, logistics of site.