Advertised Summary Job Description: Reporting to the Executive Director for the Office of Student Financial Aid & Planning (SFA&P) for Columbia's medical (VP&S) and dental (CDM) schools, the Financial Aid Coordinator functions with minimal supervision, and provides administrative support for a number of areas.
The Finance Coordinator will provide oversight for over 400 financial aid funds in Columbia's accounting system (ARC) for both the medical school (VP&S) and the dental school (CDM). This will include budget tool entries, journal entries as needed, reconciliation of transactions in ARC, the Student Information System (SIS), and the financial aid system (PowerFAIDS), and monitoring funds for accuracy of transactions.
-Assist with preparation of materials for financial aid 'forecasting' (budget cycle). Compile data and update budget presentation materials; -Assist with data collection and preparation of statistical reports and presentations for various audiences, using Excel, Word and PowerPoint; -Use various SIS Desktop and PowerFAIDS reports to assist with internal reporting needs; -Process transactions via ARC for department expenses. This includes accounts payable and purchasing transactions, travel/business expense reports, check requests, purchase orders, interdepartmental invoices, and requisitions, and resolution of billing discrepancies. Monitor operating budgets, and prepare reports to aid in budgeting, financial tracking, and projections; -Develop and maintain electronic administrative and financial filing systems; -Work with Associate Directors to develop and maintain an electronic system to facilitate matching financial aid recipients to donor's preferences for both medical and dental students. Maintain financial aid fund files; -Administer department's website and work with the Associate Director for content and design, creation of new entries, editing, and coordination with other departments and related sites. Using Drupal and Qualtrix software, assist with development and revision of financial aid forms and publications, and website content to improve general office procedures and student consumer information; -Work with SFA&P Enterprise Data Management system (OnBase) for student financial aid files ? includes developing and maintaining Qualtrix and Drupal online financial aid form submission system; indexing financial aid documents. Track and monitor OnBase activities in production and test; -Manage logistical aspects debt management and financial literacy programs ? update materials, scheduling, notification to participants and related offices; -Provide back up to the Financial Aid Coordinator with 'front desk' duties in assisting applicants, students and families with all aspects of the financial aid process, answer office mail; index documents in OnBase for student files; -Provide continuity of basic office functions when professional staff attends workshops, seminars or conferences; -Responsible for other projects and duties as they arise.
General Minimum Qualifications: Requires a bachelor's degree or equivalent in education, training and experience, plus two years of related experience.
Additional Specific Minimum Qualifications: Requires strong organizational skills and a very strong customer service orientation. Ability to multitask in a fast paced environment. Ability to maintain confidentiality of tasks required.
-Proficient with Microsoft Office; -Advanced Excel and PowerPoint skills; -Ability to compile and analyze data, and prepare user-friendly presentations; -Excellent verbal and written communication skills, including the ability to effectively communicate with various audiences and interact with a highly diverse group of internal and external constituents.
Preferred Qualifications: -1 to 2 years related experience in financial aid or other student service area; experience with a graduate/professional financial aid population a plus; -Experience with PowerFAIDS or other mainframe and PC-based financial aid systems; -Experience with an Enterprise Data Management (EDM) system; -Ability to work with Qualtrix and Drupal software to create new forms and website content; -Experience with Columbia's ARC system a plus.
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_172635
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.