Grants Finance Analyst II

• Job Type: Officer of Administration
• Bargaining Unit:
• Regular/Temporary:
  Regular
• End Date if Temporary:
• Hours Per Week: 35
• Standard
  
  Work Schedule:
• Building:
• Salary Range: $66,300 - $85,000

The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above hiring range represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting.

The mission of the Vagelos College of Physicians and Surgeons (VP&S) Office for Research is to facilitate the highest caliber of biomedical research, from basic to translational to clinical, among the VP&S faculty, students, and staff at Columbia University Irving Medical Center (CUIMC).

As a member of the Post-Award Team, the Grants Finance Analyst II contributes to CUIMC’s research mission by supporting grant-related post-award administrative activities for the basic sciences and other participating departments in VP&S.

In this role, the Analyst II will independently manage a sponsored award portfolio for faculty members with a wide range of research projects, in order to ensure compliance with federal, sponsor, and institutional regulations. Key areas of responsibility will include setting up accounts and budgets; conducting budget planning and projections; performing financial reconciliation; performing payroll accounting; and assisting with close-outs and reporting.

Through this role, the Analyst II can expect to learn to independently perform the full scope of post-award grant management; further their skills in financial analysis and management of complex portfolios; and develop independence leading internal client relationships.

To be successful in this role, the Analyst II should be able to leverage grant management experience, knowledge of finance and accounting best practices, and strong critical thinking, Excel, and communication skills to support financial management of assigned portfolios, working collaboratively and independently in a deadline-driven environment. They will also be enthusiastic about building relationships with principal investigators and about contributing to the ongoing development of the post-award team.

Post-Award Grant Administration

• Independently maintains a portfolio of Sponsored Project accounts. Performs monthly budgeting, projecting, and reconciling of research finances for portfolio of accounts. Updates monthly portfolios and ensures continued accuracy of information.
• Leads monthly meetings with PIs to address financial portfolio. Drafts portfolio summaries to prepare for meetings, collaborates with manager on post-meeting summaries and action items.
• Sets up new grant accounts and budgets and modifies existing awards with new incoming funding, collaborating closely with Sponsored Projects Administration and senior team members as needed. Ensures that PIs have necessary information, such as chart string details, budget and account access information for expenses.
• Reviews and sets up subaward agreements, monitors and reviews all related subaward invoices to seek PI approval, ensure invoices are processed in a timely manner and set up new grant accounts and budgets.
• Trains under the direction of senior staff to deepen skills in financial analysis, management of multiple award types, and Notices of Awards and communication.
• Serves as initial point of review for accuracy of grant related invoice and expenditure payments, requisitions, purchase orders, interdepartmental invoices, expenditure corrections, and journal entries. Requests PI approval and initiates internal processing process.
• Ensures that research funding is allocated and spent in accordance with PI plan and all applicable guidelines. Tracks and monitors invoices throughout life of award to ensure that subawards are spending their funding in a timely manner.
• Performs accurate and timely payroll accounting for assigned grant-related personnel, including initiating and documenting salary distributions, cost transfers, clearing suspense and repository accounts.
• Tracks internal and external support for faculty and research personnel.
• Manages award close out process and the University year end close-out procedures, including, but not limited to, ensuring there is no grant overrun, all necessary grant expenses have been posted, SAPOS and POs are correctly accounted for and encumbered in ARC Sponsored Projects Financial reports.
• Maintains records in accordance with internal procedures, demonstrating compliance with sponsor and sponsor agreements, and University regulations concerning project expenditures, equipment, and other fiscal concerns.
• Assists faculty with grant progress reports, necessary compliance documents, review of summary statements and responses.
• Supports updates to team trackers based on PI meetings and regular Sponsored Project needs.
• Performs all…