Budget & Financial Analyst
Reporting to the Director, Finance and Payroll, the Budget and Financial Analyst thoroughly analyses and develops expenditure and revenue forecasts. He/she provides ongoing monitoring of the Libraries $50+million annual operating budget. Responsibilities include:
1.Prepare monthly forecast projection, including updates to the University's budget tool, for all Libraries general income operations accounts including detailed payroll forecasting by position, salary turnover savings projection, and projected spending for all non-payroll operations accounts.
2.Assist with the development of the annual personnel roster identifying funding sources for all officers of the libraries, officers of administration, and union support staff positions. Update monthly and distribute to Library Directors and other senior staff. Produce monthly headcount report, by funding source, for all Libraries personnel.
3.Assist in the development and preparation of the Libraries annual operating budget including submission of the budget, by account, through the University's budget tool.
4. Prepare monthly student employee forecast report incorporating year-to-date spending by student by account and projections for balance of the year spending.
5.Assist in the submission of COB (consolidated operating budget) quarterly variance explanations to the University Budget office for their use in quarterly Trustee's updates. Review COB detail monthly and produce monthly COB detail report for senior management.
6. Prepare ad hoc financial analyses and reports as necessary.
BA/BS and at least two years of related work experience required. Must have payroll forecasting experience and strong excel skills including use of PIVOT Tables.
Columbia University is an Equal Employment Opportunity/Affirmative Action Employer