Business Analyst (STLCC Foundation)

St. Louis Community College•Corporate College, MO

12d

About The Position

The Business Analyst for the STLCC Foundation records the financial impact of ongoing events and transactions in the appropriate fund accounts in accordance with generally accepted accounting principles. The role monitors the Foundation’s fiscal activity, tracks transactions requiring financial statement reporting, and serves as a liaison to the college and third parties regarding Foundation funds, including investment portfolio monitoring and transactions. The position prepares audit materials and tax-filing information; monitors and reconciles financial data, accounts, and statements; reviews market activity and cash flow; manages fund transfers and investment income distributions; and performs daily and annual Foundation financial activities. It also oversees employee payroll donations, analyzes accounts and makes accounting entries, supports grant budgets and financial tracking, creates and maintains fund designations, and develops guidelines for regulatory and policy compliance. The Business Analyst prepares monthly financial statements and supports the Foundation Board Finance Committee, including communicating financial information, attending meetings, and assisting with agendas and minutes. The role provides fiscal training to Foundation staff, reviews Cognos reports, and works with the Foundation Data Analyst to develop reports as needed. The working environment is an office, and physical requirements are negligible.

Requirements

Bachelor’s degree or equivalent.
More than three years of relevant nonprofit accounting experience.

Responsibilities

Prepare the annual audit draft, including footnotes, year-end schedules, documentation, and reports for external auditors.
Provide annual financial detail for the IRS 990 tax filing and file other IRS forms as appropriate.
Monitor the accuracy of data and financial information in Banner Advancement, the Foundation Finance Chart, and subsidiary general ledger accounts.
Reconcile general ledger accounts with student accounting, financial aid, and daily bank activity statements.
Reconcile monthly financial and investment statements using external systems and processes, including UMB banking, Mercer Comerica, Edward Jones investments, Elavon credit card system, Merchandise Services, and other third-party systems.
Review market activity quarterly, assess cash flow, update endowment fund budgets, and execute fund transfers to Mercer when appropriate.
Distribute investment unallocated income to permanently restricted disbursement funds and other selected funds.
Complete daily and annual Foundation financial activities, including processing check requests, entering direct student payments into Banner Advancement, coordinating internal college transfers, assisting with financial questions for grant applications and donor reports, allocating expenses, and maintaining the Foundation revenue log.
Oversee employee payroll donations, create new payroll pledge commitments, terminate expired pledges, and coordinate pledges with the Payroll department to ensure accurate processing.
Analyze Foundation accounts, correct identified errors, and initiate accounting entries as necessary, including entries for prepaid expenses, deferred revenue, and pledge discounts, on a weekly basis.
Serve as Foundation liaison to the campus Business Manager regarding budget development for Foundation grant applications and post-grant financial tracking.
Create new designations in Banner Advancement, assign new funds in Banner Finance, and communicate updates to the college business office, financial aid, and student accounts as needed.
Develop, implement, and maintain guidelines to ensure adherence to IRS nonprofit regulations and college policies while improving standardization, efficiency, and workflow.
Serve as financial liaison with college administration and staff, the Foundation Board of Directors, the Foundation Board Finance Committee, the auditor, and third-party vendors.
Prepare monthly statements of financial position and statements of activities, draft internal comments for the Foundation Board Finance Committee chair, communicate with the committee, answer questions, and provide additional feedback when requested.
Attend Finance Committee meetings and assist with preparation of meeting agendas and minutes.
Provide fiscal training and instruction to Foundation staff as needed.
Periodically review existing Cognos reports for accuracy and work with the Foundation Data Analyst to create new reports as needed.