Advertised Summary Job Description: Reporting to the Director of Budget & Financial Planning, the Financial Coordinator is responsible for various projects within the Dean's Office that are focused on Finance processes and procedures. S/He will provide a wide range of reporting support and analyses for the finance team and the departments throughout the year. The Financial Coordinator's main responsibility will be to support the Dean's Initiatives and special projects and may be required to meet periodically with the Dean and Senior Vice-Dean to provide data and explain financial results. The Financial Coordinator will monitor and analyze the budget on a routine basis. The incumbent will monitor and coordinate expenditures for the School's accounts and manage the day-to-day financial activities in the Dean's office. In this capacity, the incumbent will develop reports and maintain reports for the Dean's office; reconcile University financial statements for specific Dean's office departments (including unrestricted projects, gifts, endowments and sponsored programs) against internal ledgers; summarize and update operating budgets and estimates, and provide guidance on best practices for spending and budgeting expenses. The incumbent will also help to standardize budget and reporting policies and procedures that promote adherence to University and School policies. This position will involve advanced use of MS Excel including creation of pivot tables and use of formulas (i.e. VLOOKUP) to create reports and analyze variances on a variety of data sets.
General Minimum Qualifications: Bachelor's degree in Finance, accounting, economics, or business related field and/or its equivalent required, or an equivalent combination of education and experience.
Excellent computer skills with extensive knowledge of spreadsheets (Excel) required. Ability to work with and manipulate large data sets is required.
Ability to communicate upward (school level senior leadership) clearly and to prepare and present financial data to a non- finance leadership using visual aids such as charts, graphs, and other data visualization tools.
Must be able to quickly learn university electronic processing systems for budgets and reporting (FDS, PAC) or have prior knowledge and experience with ARC.
Attention to detail and accuracy is essential; ability to manage multiple priorities with poise and discretion in a fast paced environment is required.
Positive, forward-thinking, mission-oriented attitude a must.
Additional Specific Minimum Qualifications:
Preferred Qualifications: Familiarity with Columbia University financial policies and systems is strongly preferred.
Knowledge of access is preferred.
Up to 2 years of experience in financial support strongly 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.
Internal Number: 126_167248
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.