Finance Analyst

Job Type

Full Time




722 West 168th Street
New York
New York
United States



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.


  • Bachelor’s degree in Accounting, Finance or Economics required


  • 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)


  • 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


  • May require 1-2 local or international trips per year

Professional Level

None specified

Minimum Education Required

No requirement