Business Analyst; STLCC Foundation

The Business Analyst (STLCC Foundation) objective is to record the financial impact of ongoing events and transactions, within the appropriate fund accounts, in a manner that is consistent with generally accepted accounting principles; perform duties necessary to monitor the Foundation’s fiscal activity; stay abreast of transactions that have a financial impact and that require financial statement reporting; serve as liaison to college and third parties for all Foundation funds, including activities related to the investment portfolio monitoring and transactions.

• Prepares annual audit draft with associated footnotes, year-end schedules, documentation, and reports for external auditors.
• Provides financial detail annually for IRS 990 tax filing and files other IRS forms as appropriate.
• Monitors accuracy of data and financial information in Banner Advancement, Foundation Finance Chart, and subsidiary general ledger accounts.
• Reconciles general ledger accounts with the student accounting, financial aid, and daily bank activity statements.
• Reconciles monthly financial and investment statements through external systems and processes, such as UMB banking, Mercer Comerica, Edward Jones investments, Elavon credit card system, Merchandise Services, and other third-party systems.
• Performs quarterly reviews of market activity and assess cash flow, updating endowment fund budgets and execute fund transfers to Mercer, when appropriate.
• Distributes investment unallocated income to permanently restricted disbursement funds and other select funds.
• Completes general Foundation financial activities related to daily procedures and annual Foundation events, such as, but not limited to, processing check requests, entering direct student payments into Banner Advancement, coordinating internal college transfers with various college departments, assist Foundation staff with banking and financial questions for grant application and donor reports, expense allocation, and maintenance of Foundation revenue log.
• Oversees the process for employee payroll donations, including the creation of new payroll pledge commitments and termination of expired pledges. Coordinate all payroll pledges with Payroll department to ensure accurate processing.
• Analyzes Foundation accounts, corrects identified errors and initiates all accounting entries as necessary, including but not limited to prepaid expense, deferred revenue, pledge discounts, etc. weekly.
• Serves as Foundation liaison to campus Business Manager, regarding budget development for Foundation grant applications and post grant financial tracking.
• Creates new designations in Banner Advancement, assigns new funds in Banner Finance and communicate all updates to college business office, financial aid, and student accounts, as needed.
• Develops, implements, and maintains guidelines to ensure adherence to IRS non-profit regulations and college policies while improving standardization, efficiency and workflow as needed.
• Serves as financial liaison with college administration and staff, Foundation Board of Directors, Foundation Board Finance committee, auditor, and third-party vendors.
• Prepares monthly statement of financial position and statement of activities reports. Including, the drafting of internal comments for Foundation Board Finance committee chair and communicating with the Finance committee, answering questions, and providing additional feedback when requested.
• Attends Finance committee meetings and assist with the preparation of meeting agenda and minutes.
• Provides fiscal training and instruction to Foundation staff as needed.
• Periodically reviews existing Cognos reports, checking for accuracy. Work with Foundation Data Analyst to create new reports as needed.

• Bachelor’s degree or equivalent and over three (3) years of relevant nonprofit accounting experience.

• Office working environment.

Physical Requirements:

• Negligible