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 the Department of Neurology's financial management and research administration services. The role collaborates with faculty and staff to ensure fiscal sustainability and compliance.

Reporting to the Sr. Manager Director of Finance and Research Administration, you will manage sponsored project budgets, prepare reports, and assist with budgeting and forecasts across divisions, while meeting deadlines and

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.
• Excellent verbal and written communication skills; proficient in MS Excel and Word.

Responsibilities

• Assist PIs in the development, review, submission and renewal of sponsored project proposals from NIH, foundations and industry.
• Ensure all programmatic reporting requirements are completed on time per sponsor and institutional requirements.
• Liaise with SPA to set up awards and establish sub-awards for awarded proposals.
• Assign and reconcile expense allocations to funding sources with relevant regulations.
• Perform budget vs. actual reconciliations for funded and non-funded sources.
• Maintain funding overviews and review with faculty on a regular basis.
• Support annual budgeting and quarterly re-forecasts via data entry into budget tools.
• Complete routine internal reporting and participate in audits and inspections.
• Handle other projects as assigned.

Skills

MS Excel

MS Word

Verbal communication

Written communication

Analytical skills

Education

Bachelor's degree

Tools

MS Excel

MS Word

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

The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above hiring range represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting.

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

• 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 re-forecasts 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 and plan independently. Must be able to work with all levels of staff. The 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 creating and using MS Excel spreadsheets. Highly skilled in MS Word. Ability to meet deadlines and maintain required confidentiality.

Equal Opportunity Employer / Disability / Veteran

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