Financial Analyst
Columbia University Irving Medical Center · New York, NY · 3 wk ago
Finance$66k/yrFull-time
Responsibilities
- Affords PIs in the development, review, submission and renewal of various types of sponsored project proposals from a variety of sponsors, including NIH, private foundations and industry.
- Ensures all programmatic reporting requirements (quarterly and/or annual progress and financial reports) are completed according to sponsor and institutional requirements and timeframes.
- Liaises with Sponsored Projects Administration (SPA) office to ensure timely setup of award, pre-award compliance requirements are met, and all sub-awards are established.
- Assigns and reconciles expense allocations (payroll and non-payroll) to funding sources with adherence to pertinent regulations, policies and procedures that govern the nature of funds.
- Performs budget vs. actual reconciliation of sponsored and non-sponsored funding sources and salary allocations of faculty and staff on both project year and fiscal year basis.
- Maintains funding overviews/forecasts for faculty in assigned divisions and meets with faculty to review on a regular basis.
- Stays abreast of regulations, policies, and guidelines related to conduct of research; analyzes specific issues, budget requests, and policy changes to provide feedback and recommendations to principal investigators.
- Supports annual budgeting process and quarterly reforecasts through data entry into budget tool.
- Completes routine internal reporting requirements required for sponsored projects (i.e. effort reporting, PI attestations, etc) and participates in regulatory audits and inspections.
- Other projects as assigned.
Qualifications
- Bachelor's degree or equivalent in education and experience.
- 1-2 years of experience in non-profit environment with direct experience in grants and financial management.
Minimum Qualifications
- Bachelor's degree or equivalent in education and experience.
Preferred Qualifications
- 1-2 years of experience in non-profit environment with direct experience in grants and financial management.
Other Requirements
- This is a high-pressure position as there are many internal and external deadlines.
- Requires a bright, competent and organized individual that is self-motivated, reliable, conscientious, and able to solve analytical problems, as well as plan independently.
- Must be able to work with all levels of staff.
- Position requires establishing and maintaining relationships within and across departments, as well as servicing the grant and accounting needs of Principal Investigators.
- The ideal candidate will possess excellent verbal and written communication skills.
- Proficient or Advanced Proficiency in creating and using MS Excel spreadsheets.
- Highly skilled in MS Word.
- Able to meet deadlines and maintain required confidentiality.
- Knowledge of government and foundational granting requirements, grants administration and PeopleSoft financials required.