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

Position Summary

Overseen by the Director of Research Administration, the Grants Analyst will be responsible for managing a research portfolio of faculty members with a range of research projects. The main responsibilities will include pre and post award management, with emphasis on grant submissions as well as financial reconciliation, planning and projection across the assigned accounts in accordance with departmental processes. The successful candidate will be responsible for ensuring compliance with federal, sponsor and institutional regulations such as attestations, effort certifications, salary allocations, cost transfer requirements, etc. The candidate will also assist in managing, analyzing and reconciling departmental budgets for various areas as needed.

Responsibilities

Pre-award management, 30%

• Assist investigators and faculty with identifying appropriate funding sources
• Developing time lines for grant submission and reviewing grant submission guidelines
• Developing budgets and completing administrative paperwork
• Ensuring internal and external administrative systems are managed and completed
• Review of all administrative and submission paperwork
• Reviews grant documents for style, formatting, grammar, etc.
• Liaising with central offices to ensure timely grant application review and sign off

Reporting and record keeping, 25%

• Maintaining internal records
• Developing and updating record keeping systems for grants administration
• Analysis of budget tool and CUCON reports
• Financial forecasting and analysis
• Creation of deliverables for senior leadership
• Tracking of interdepartmental research commitments
• Analysis of departmental and faculty deficits
• Tracking and reconciliation of fund balances

Operational management, 15%

• Work with the development office to set up new gifts and philanthropic efforts
• Tracking and monitoring space allocations
• Managing compliance processes, including attestations, effort certifications, back up
• documentation
• Updating budget tool and financial systems quarterly

Post award, 20%

• Monthly budgeting, projecting and reconciling research finances
• Managing and coordinating the proper set up of research grants, subawards and contracts
• Ensuring research funding is allocated and spent in accordance with all applicable guidelines
• Coordinating effort and salary allocations across research and discretionary accounts
• Reviewing and approving all expenses, including requisitions, POs, Pcards and Concur
• Managing the award close-out process with liaising departments
• Assisting faculty with progress reports, final financial reports, lab closures and necessary compliance documents

Other, 5%

• Other tasks as assigned

Minimum Qualifications

• Requires a bachelor's degree or equivalent in education, training and experience, plus a minimum of 1-2 years of related experience

Preferred Qualifications

• Knowledge of accounting and grants management best practices is preferred
• Advanced knowledge of sponsors and sponsor requirements is preferred
• The individual must possess strong financial analysis skills, multi-tasking skills and be able to organize and prioritize independently based on competing timelines
• Familiarity with Columbia Systems preferred.

Equal Opportunity Employer / Disability / Veteran

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