Finance Analyst

Job Type

Full Time

Published

05/29/2018

Address

722 West 168th Street
New York
New York
10032
United States

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.


MAJOR ACCOUNTABILITIES


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


EDUCATION


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


MINIMUM REQUIRED QUALIFICATIONS, EXPERIENCE, AND SKILLS


  • 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 EXPERIENCE AND OTHER 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


TRAVEL REQUIREMENTS


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

Professional Level

None specified

Minimum Education Required

No requirement


Share:

Share: