Financial Analyst

Columbia University Irving Medical Center; New York (NY); On-site; USD 66,000 - 75,000; Full time

Job summary

Columbia University Irving Medical Center in New York seeks a Financial Analyst to support financial management and research administration for Neurology faculty. The role reports to the Sr.

Manager Director of Finance and handles funded project budgets, reporting, and compliance. Responsibilities include assisting PIs with grant proposals, coordinating with SPA on awards, performing budget reconciliations, and maintaining funding forecasts.

Qualifications

• Bachelor's degree or equivalent in education and experience.
• Experience in non-profit environment with grants and financial management.
• Proficiency in MS Excel and MS Word.
• Knowledge of government and foundational granting requirements, grants administration and PeopleSoft financials.

Responsibilities

• Assists PIs in developing, reviewing, submitting and renewing sponsored project proposals from NIH, private foundations and industry.
• Ensures all programmatic reporting requirements (quarterly and/or annual progress and financial reports) are completed on time.
• Liaises with SPA to set up awards, pre-award compliance, and sub-awards for awarded proposals.
• Assigns and reconciles expense allocations to funding sources in line with regulations and policies.
• Performs budget vs. actual reconciliations of funded projects and salary allocations.
• Maintains funding overviews/forecasts and reviews with faculty regularly.
• Keeps abreast of regulations and guidelines related to research grants and provides recommendations to PIs.
• Supports annual budgeting and quarterly reforecasts via data entry into budget tools.
• Completes routine internal reporting for sponsored projects and participates in audits.

Skills

Excel

Word

Grants administration

Budgeting

Analytical skills

Communication skills

Education

Bachelor's degree or equivalent in education and experience

Tools

PeopleSoft

Job description

Grade 103

• 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.00 $75,000.00

Position Summary

Reporting to the Sr. Manager Director of Finance and Research Administration for the Department of Neurology, the Financial Analyst will support the financial management and research administration services provided to faculty in the department. The position will work with both faculty and administrative staff to ensure the department operates in a fiscally sustainable manner.

Responsibilities

Specific responsibilities include, but are not limited to:

• Assists 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.
• For awarded proposals, 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.

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. Ability to meet deadlines and maintain required confidentiality. Knowledge of government and foundational granting requirements, grants administration and PeopleSoft financials required.

Equal Opportunity Employer / Disability / Veteran

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