Reporting to the Associate Dean for Administration and the Executive Director of Human Resources and Financial Operations of the Columbia University School of International and Public Affairs (SIPA), the Assistant Director performs budget entry and analyses, prepares monthly reports for all units, develops expenditure and revenue forecasts, creates and modifies projects, initiatives and segments, performs transfers and expenditure corrections as needed, and provides ongoing monitoring of the School's 90M annual operating budget.
Responsibilities
Develop, update, analyze and report on a five-year budget of the School's core revenues and expenditures using the OMB model but focusing on core SIPA revenue and expense. Provide monthly forecast updates, including updates to the University's budget tool of projected revenues and expenditures for all SIPA, affiliated Center, Institute and agency accounts. Produce and analyze month-end balance reports, identifying emerging resource shortfalls, targets for fund reallocation, etc.
Create and deliver monthly financial reports on expenditures across SIPA cost centers and affiliated centers and programs, incorporating data from the University's Accounting and Reporting at Columbia (ARC) system. Work closely with the Assistant Director of Business Operations on outreach to SIPA's cost centers and centers/programs on the monthly expense review process and other financial policies and procedures.
Create monthly financial reports on expenditures across SIPA???s approximately 50 affiliated student organizations. Work closely with the Assistant Director of Business Operations on outreach to student organization leaders on the monthly review and reconciliation process of financial activities.
Assist in the development, implementation and management of the SIPA Finance Site.
Assist in the development and preparation of the School's annual operating budget including submission of the budget through the University's budget tool, and preparation of tuition and other statistical addenda.
Assist in the analysis and submission of Consolidated Operating Budget (COB) quarterly variance explanations to the University Budget Office for use in quarterly Trustee's updates. Review COB detail monthly and produce quarterly/monthly COB detail and summary analyses for senior management.
Coordinate government and private grants forecasting and proxy budgeting with the SIPA Assistant Director of Business Operations and appropriate staff and faculty from SIPA cost centers and affiliated Centers and Institutes.
Prepare ad hoc financial analyses and reports as necessary for senior management, the SIPA Advisory Board, the Faculty Finance Committee, the Office of Alumni and Development (OAD), the SIPA Annual Report, etc.
Minimum Qualifications
Bachelor's degree or equivalent and four years of full-time professional experience in financial administration in higher education required.
Must be thoroughly proficient in the use of computers, including spreadsheets (Excel) and database programs. Thorough proficiency in PowerPoint also required.
Excellent verbal/written communication, interpersonal and organizational skills essential.
Must be customer service-oriented and able to work with staff at all levels with diplomacy.
Must have a deep commitment to valuing diversity and contributing to an inclusive working and learning environment.
Must be detail-oriented and deadline driven with good time management skills.
Must be a team player and self-starter.
Preferred Qualifications
Advanced degree in a related field, such as higher education financial administration or business administration preferred.
Familiarity with Columbia University's accounting system, or a similar system, a plus.
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
Columbia University requires COVID vaccination for all Columbia University members who have any on-campus presence. Individuals may claim exemption from the vaccine requirement for medical or religious reasons. More information regarding the University???s COVID vaccination requirement and exceptions may be found at the University???s ???COVID-19 Vaccine Information??? webpage: https://covid19.columbia.edu/. Compliance with these measures is mandatory.
Internal Number: 520950
About Columbia University
Columbia University is one of the world's most important centers of research and at the same time a distinctive and distinguished learning environment for undergraduates and graduate students in many scholarly and professional fields. The University recognizes the importance of its location in New York City and seeks to link its research and teaching to the vast resources of a great metropolis. It seeks to attract a diverse and international faculty and student body, to support research and teaching on global issues, and to create academic relationships with many countries and regions. It expects all areas of the university to advance knowledge and learning at the highest level and to convey the products of its efforts to the world.
