Grants Financial Manager - General Medicine

• Job Type: Officer of Administration
• Regular/Temporary: Regular
• Hours Per Week: 35
• Salary Range: $85,000.00 - $90,000.00 Annual

Position Summary

Reporting to the Divisional Administrator and collaborating closely with Sr. Grants Manager(s) the candidate will be responsible predominantly for pre/post-award management in the Division of General Medicine. Responsible for oversight of all components of the grants cycle, including pre-award budget development, post-award monitoring, program sub-contract management, and grant closeout procedures. Provides technical assistance and guidance in the preparation, submission, processing and management of research grants, contract proposals, awards and all agreements for Research Teams within the division. Ensures that the administration of sponsored programs related to research is compliant with federal, state and private agency rules and regulations, as well as those of Columbia University Medical Center.

Responsibilities

• Develop proposal and study budgets working closely with the Principal Investigators (PIs); enter proposals into RASCAL; initiate and monitor IRB submissions; collaborate with other Divisions/Department/Institutions on grants submission; and work on Progress Reports and JITs.
• Track proposals, budgets, contracts and other documents through the Research Administration office, IRBs as appropriate, and Sponsored Projects Finance Administration, with facilitation as needed. Create IPASS and submit timely requests to the Subaward team.
• Execute electronic grants submissions. Assist in assuring a timely quarterly completion of Sponsored Projects Attestation Statements. Attend university sponsored project trainings and meetings.
• Review statements for budget and expense items and advise the PIs and Division Administrator of significant under/over budget expenditures.
• Ensure establishment of consulting agreements and subcontracts; approve and monitor subcontractors' timely invoicing and received payments; and update the subcontractors' database accordingly.
• Provide designated PIs with regular, structured updates on their projects' financial status, including proper allocation of research personnel salaries.
• Analyzes monthly grant activity, monitors grant funds spending reports and expenditures posted to assigned grant projects, and serves as liaison to Grants & Contracts Office, Sponsored Projects, and Finance Department and other collaborating departments to ensure grants are being properly managed.
• Update divisional grants master sheet. Maintain a shared database with research and academic documentation, submission dates, reporting dates and other deadlines as well as NIH style bio sketches, update of other support information, shared resources, and other proposal support documentation.
• Coordinate project and grant closeouts, including final reconciliation and time effort documentation, as well as a final report to the University's Controller Office. Maintain financial and scientific records of projects. Monitor and clear expense overruns on projects.
• Responsible for generating monthly research profit and loss statements for distribution and review with PIs and the Administrator. Monitor projects for overruns, and ensure costs are being charged appropriately. Create budgets for new grants through budget tool, and requisitions for purchase orders.
• Perform other related duties as assigned.

Minimum Qualifications

• Bachelor's degree or equivalent in education and experience, plus four years of related experience
• Master's degree would substitute in part for experience
• Excellent knowledge of Microsoft Office with proficiency in Excel
• Good organizational, interpersonal, and communication skills and ability to work well with others and as part of a team are an essential part of this position.
• Strong work initiative and ability to work independently, and meet sponsor deadlines

Preferred Qualifications

• Knowledge of Institutional Financial Systems, eRA Commons, ASSIST, NIH and other Federal Agencies compliances, GAAP

Other Requirements

• Successful completion of applicable compliance and systems training requirements

Equal Opportunity Employer / Disability / Veteran

Columbia University is committed to the hiring of qualified local residents.