Advertised Summary Job Description: POSITION SUMMARY
Working under the supervision of the Finance Project Manager, the Finance Analyst will provide reporting, analysis, and systems support for the Sub-award Management team, and other ICAP Finance teams. The Finance Analyst will carry out sub-award management operations including processing payments and reconciliation, and liaising with relevant ICAP/Columbia University departments to solve potential issues. The Finance Analyst will work on other finance related projects as assigned by the Finance Project Manager, Associate Director of Procurements or Director of Financial Management.
- Provide support for ICAP Finance team's, especially the Sub-award Management team's, utilization of ICAP and Columbia University software systems such as web portals, subrecipient information and document submission website, and web-based restricted party screening tools, including, but not limited to, Visual Compliance.
- Process cash advance requests and payment vouchers through Columbia University's accounting system.
- Process reconciliation of advance payment vouchers in Columbia University's accounting system.
- Troubleshoot barriers to payment, advance reconciliation, sub-award purchase order issues, and the return of funds through collaboration with Columbia University's Accounts Payable Department, the Office of Sponsored Projects Administration and the Office of Sponsored Projects Finance.
- Routinely generate open voucher reports to determine which vouchers remain open and follows up with Sub-award Managers on delayed expenditure report submission.
- Prepare monthly advances exception reports for Senior Leadership review and follows through on resolution of reportable items; contributes to the preparation of the quarterly amortization of advances and accrual report and other financial reports and analyses as required for internal reporting purposes.
- At close-out of awards and sub-award agreements, audit the reconciliation of expenses to ensure expenses reported are properly and are posted in Columbia University's accounting and reporting system ("ARC").
- Monitors submission of sub-awards monitoring deliverables to the Sub-awards Team by subrecipients.
- Assist with developing and implementing improvements to ICAP Finance processes and systems; provides processing, reporting and analytical support on various projects as assigned.
- Assist with preparing and delivering in-person and online accounting and financial management related trainings.
- Assist with subrecipient audit processing by completing related projects and tasks, as assigned.
- Assist with ICAP component of the Columbia University Uniform Guidance Audit by compiling and submitting information and documents, as assigned.
- Assist with any other projects as assigned by the Finance Project Manager, Associate Director of Procurements or Director of Financial Management.
General Minimum Qualifications: - Bachelor's degree in Accounting, Finance or Economics required
Additional Specific Minimum Qualifications: - Minimum three (3) years of experience in financial management, sub recipient award accounting, or project accounting
- Strong analytical and organizational skills
- Strong interpersonal skills in order to deal effectively with varied internal and external clients
- Advanced Excel Skills (finalists for the position may be tested on their Excel skills)
Preferred Qualifications: - Demonstrated experience working in a fast paced environment, coupled with experience with international protocols, non-profit organizations or academic institutions is highly desirable
- Knowledge of Columbia University systems, ARC, ERP
-Knowledge of Columbia University systems, ARC, ERP
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_169544
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.