Advertised Summary Job Description: Reporting to the Director of Financial Planning and Analysis, the Assistant Director contributes to the management and execution of Columbia College's approximate $340 million operating budget by providing a wide range of fiscal and technical support in a manner consistent with ensuring the highest level of service. The incumbent works closely with the Director of Financial Planning and Analysis and the Executive Director of Finance Administration to assemble the College's annual budget and to monitor the budget on a routine basis. In addition, the Assistant Director will assist with the financial administration for a specific unit or set of financial activities within the College.
CHARACTERISITIC DUTIES & RESPONSIBILITIES: A. Contribute to the development of the College's annual budget and to monitoring the budget on a routine basis, which includes but is not limited to: 1. Preparing worksheets and gathering key data to inform budget process. 2. Assisting with budget submission, updating entries into the University's budget tool, and helping with the reconciliation of that information to the College's internal budget planning model. Reviewing the University's COB (consolidated operating budget) reports and assisting with variance analysis. 3. Processing journal entries for monthly, quarterly, and year-end close.
B. Provide analysis of financial information and/or the preparation of regular ad hoc financial reports at the direction of the Director and senior members of the Columbia College Finance Team: 1. Providing reconciliation and trend analyses for the purposes of projecting and managing revenues and expenses of a specialty area, which may include but is not limited to analyses of gifts and endowments, application fees, indirect cost recovery, administrative fees, etc.
C. Support the financial planning and analysis of a specific program or designated set of financial activities within the College, which includes but is not limited to: 1. Learning the business and operations of the designated program or set of financial activities. 2. Initiating transactions for relevant set of financial activities. As needed, may take on approval for approving routine transactions. 3. Reconciling monthly financial statements and analyzing budget variance reports; together with the Director, meeting regularly with relevant stakeholders to review year-to-date activity and identifying trends that will impact the budget plans for future periods. Preparing reports regarding financial activity as needed. 4. Update and reconcile complex financial and budgetary spreadsheets. Record expenditures and/or payments ensuring they are posted to proper accounts.
D. Perform other related duties, assignments, and/or special projects as assigned.
General Minimum Qualifications: Bachelor's degree and/or the equivalent required. Minimum of 2-4 years' of related work experience required (or equivalent combination of education and experience).
Additional Specific Minimum Qualifications: Must be detail-oriented with strong organizational skills and have the ability to prioritize and manage multiple projects simultaneously. Must be a self-starter and capable of operating with minimal supervision. Excellent interpersonal, oral, and written communication skills with a strong customer service focus essential. Ability to work closely and effectively with a diverse group of administrators. Ability to exercise discretion and handle confidential information essential. Proficiency in Microsoft Office applications required, specifically superior Excel skills including demonstrated experience in using Pivot Tables. Demonstrated ability to compile, manipulate, and analyze data and present financial data to end-users in a useful manner.
**Applications received without a resume and cover letter will not be considered.**
Preferred Qualifications: Strong preference for related financial analysis or operations experience in higher education, non-profit, and/or complex organization. Demonstrated experience in database management system preferred. Knowledge of the PeopleSoft Financials or a similar type financial management application preferred.
As a member of the National Collegiate Athletic Association (NCAA) and the Council of Ivy Group Presidents (Ivy League), it is imperative that members of the Columbia University community, in all matters related to the intercollegiate athletics program, exhibit the highest professional standards and ethical behavior with regard to adherence to NCAA, Conference, University, and Department of Intercollegiate Athletics and Physical Education rules and regulations.
Columbia University is an Equal Opportunity/Affirmative Action employer.
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.