Financial Analyst

Columbia University in the City of New York; New York (NY); On-site; USD 66,000 - 75,000; Full time

Job summary

Columbia University in Kentucky seeks a Financial Analyst to support budget management and research administration for the Department of Neurology. You will work with faculty and staff to ensure fiscally sustainable operations.

Reporting to the Sr. Manager Director of Finance, you will assist with sponsor proposals, quarterly reporting, and budget forecasting while maintaining compliance with funding rules.

Qualifications

• Bachelor's degree or equivalent in education and experience.
• 1–2 years of experience in non-profit grants and financial management.
• Proficient in MS Excel, MS Word and PeopleSoft financials.

Responsibilities

• Assists PIs with development, review and renewal of sponsored project proposals.
• Ensures timely programmatic reporting per sponsor and institutional requirements.
• Liaises with SPA to set up awards and ensure compliance.
• Allocates payroll and non-payroll expenses to funding sources.
• Performs budget vs. actual reconciliation for funded projects.
• Maintains funding overviews and reviews with faculty regularly.
• Supports annual budgeting and quarterly re-forecasts.
• Completes routine reporting for sponsored projects and participates in audits.
• Performs other related duties as assigned.

Skills

Grants management

Budgeting

Financial analysis

Education

Bachelor's degree or equivalent

Tools

MS Excel

MS Word

PeopleSoft

Job description

• 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

• 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 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.
  • Perform other related duties and responsibilities as assigned/requested.

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 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.