Senior Grants & Research Budget Analyst

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

Job summary

Columbia University Irving Medical Center in New York, NY seeks a Senior Financial Analyst to support the financial management and research administration services for the Department of Neurology. The role collaborates with faculty and administrative staff to ensure financial sustainability and accurate reporting.

The analyst will assist PIs with sponsored project proposals, coordinate with SPA for awards, perform budget-to-actual reconciliations, maintain funding forecasts, and support audits

Qualifications

• Bachelor's degree or equivalent in education, training and experience.
• Three years of related experience.
• Knowledge of government and foundational granting requirements and grants administration.

Responsibilities

• Assists PIs in development, review, submission, and renewal of sponsored project proposals.
• Ensures programmatic reporting requirements are completed according to sponsor and institutional requirements and timeframes.
• Coordinates with Sponsored Projects Administration to ensure timely award setup and subaward establishment.
• Assigns and reconciles expense allocations to funding sources per regulations and fund rules.
• Performs budget vs. actual reconciliation for funded projects and salary allocations.
• Maintains funding overviews/forecasts and reviews with faculty regularly.
• Keeps abreast of regulations and policies related to conduct of research and provides feedback to PIs.
• Completes annual budgeting and quarterly re-forecasts via budget tool.
• Completes routine internal reporting and participates in regulatory audits and inspections.
• Trains and mentors new employees and supports onboarding.
• Collaborates on departmental projects to enhance team performance and efficiency.
• Performs other related duties as assigned.

Skills

Budgeting

Financial analysis

Verbal & written communication

Education

Bachelor's degree or equivalent

Tools

PeopleSoft

MS Excel

MS Word

Job description

Grade 104

• Job Type: Officer of Administration
• Bargaining Unit:
• Regular/Temporary: Regular
• End Date if Temporary:
• Hours Per Week: 35
• Standard Work Schedule:
• Building:
• Salary Range: 85,000.00 - 100,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 Senior Manager of Finance and Research Administration for the Department of Neurology, the Senior 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 financially 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 subawards 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 independently 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.
• Completes 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.
• Trains and mentors new employees by responding to inquiries, providing guidance, and supporting the onboarding process.
• Collaborates on departmental projects, contributing to the development of resources and managing key initiatives to enhance team performance and departmental efficiency.
• Perform other related duties and responsibilities as assigned/requested.
  
  

Minimum Qualifications

• Requires a bachelor's degree or equivalent in education, training and experience, plus three years of related experience.
  
  

Preferred Qualifications

• 2-4 years of experience in non-profit environment with direct experience in grants and financial management.
  
  

Other Requirements

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