Reporting to the Associate Director of Finance & Administration, the Grants & Finance Manager will be responsible for management and oversight of the Grants and other sponsored activities and will provide leadership and guidance on all sponsored projects, particularly on post award operations and research management for Earth Institute. He/she will serve as Earth Institute Primary contact for Grant Management and Uniform Guidance and other related matters with the University's central administration offices including Sponsored Project Administration, Sponsored Project Finance, Office of General Counsel, Columbia Technology Ventures, Office of the Controller and other central administration units.
Grant Management: 75%
Serve as primary contact for Earth Institute with CU's Sponsored Project Administration (SPA), Sponsored Project Finance (SPF) and Research Policy & Indirect Costs (RPIC) groups. Work closely with Department Administrators on grant closeout reconciliations, including grant expenses, payables, and budgets. Provide principal investigators (PIs) and their administrators with post-award financial administration support, including financial status reports, invoicing details and project closeouts.
Review notices of award, agreements, contracts, and MOUs to ensure consistency with proposal scope, mission, and policies of EI and CU. Coordinate sub award agreement issuance, execution and set-up in CU's financial system.
Lead and coordinate award implementation meetings and monitoring (usually in conjunction with other EI Divisions).
In charge of leading and coordinating internal and external audit inquires, working closely with University's internal auditors as well as with outside auditors to determine that expenditures and procedures were appropriate, allowable, and allocable to the award.
Develop and deliver training materials to the EI community related to the post-award management of sponsored programs. Provide group as well as one-on-one training.
Assist in annual budget preparation primarily on the sponsored project side.
Facilitate Principal Investigator waiver request and review process.
Grants & Finance Manager will lead Uniform Guidance implementations across EI, including PI quarterly reviews, Effort Reporting and various sponsored project audits.
Other Responsibilities: 15%
Review and monitor major equipment purchases and maintain annual inventories and lists for the CU Risk Management Team and Capital Asset Accounting Team.
Serve as primary contact for EIM with CU's Global Support team and International Safety and Travel Risk Management. Including:
Represent EIM on CU's International Administrative Working Group.
Oversee The Earth Institute's contribution to the University Form 990 Schedule F (report of expenditures outside of the US, by country and type)
Communicate and implement the Travel Security Assessment and managing EI's SharePoint International Travel Approval Form
Other Duties: 10%
Complete as assigned by the Associate Director of Finance and Administration.
Bachelor's degree required and a minimum of 4-6 years related experience.
Masters Degree in public administration, business, accounting/finance or related field strongly preferred. Manager and or supervisory experience preferred.
Excellent interpersonal skills, including experience collaborating with a multi-disciplinary, diverse and driven team. Strong hands-on background in budgeting, planning, financial analysis and reporting, particularly in non-profit organizations with multiple funding streams including private and federal grants. Flexible self-starter who can multi-task with a high level of attention to detail. Ability to exercise discretion and handle confidential information. Advanced knowledge of Microsoft Excel (vlookups, pivot tables, macros, and formulas).
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
Internal Number: 502080
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.