Advertised Summary Job Description: The Grants Finance Analyst will join the new Post-Award Finance Shared Service team in the College of Physicians and Surgeons (P&S). Reporting to the Grants Finance Manager, the Analyst will track multiple funding portfolios, advising individual Principal Investigators (PIs) on the status of their sponsored and non-sponsored funding and implementing accounting changes as directed by PIs. The Analyst will coordinate a high volume of funds and transactions in a busy, deadline-driven environment.
Primary Duties: -Maintain a suite of PI Portfolio Update reports for multiple PIs and meet monthly with each PI to review the PI's individual funding portfolio, which may consist of grant, contract, gift, endowment, and other types of restricted and unrestricted funding; -Capture and implement PI feedback and changes from meeting; -Maintain labor schedules for faculty and research personnel and submit labor cost transfers; -Ensure completion of quarterly expense certifications with each PI; -With departmental effort coordinator, coordinate annual effort reporting; -Monitor project balances. Ensure ongoing clearing of suspense account and grant overruns; -Review grant-related transactions (such as requisitions and vouchers) for compliance; -May assist/train departmental staff on initiation of grant-related transactions; -Coordinate with departmental finance staff and with P&S Finance on maintaining accurate budget information in Budget Tool for sponsored projects (and research support in funds flow); -Coordinate with departmental pre-award staff and with central sponsored research offices (SPA and SPF) on new project setup; -Coordinate with departmental pre-award staff, SPA, and SPF on progress reports and closeouts Provide pre-award staff with financial data for incorporation into progress and final reports; -Provide cross-coverage for other analysts during leaves, vacancies, and other transitions; -Maintain familiarity with evolving regulatory and compliance context. Stay up to date on new grant-related rules and procedures.
General Minimum Qualifications: Requires a bachelor's degree or equivalent in education, training and experience, plus two years of related experience.
Additional Specific Minimum Qualifications: -Ability to set priorities and exercise sound judgment; -Ability to work independently, meet deadlines, and multi‐task; -Ability to work effectively as part of a team; -Excellent interpersonal and communications skills. Must be able to communicate clearly and accurately directly with principal investigators. Must be able to communicate effectively with financial personnel in central offices and sponsoring agencies; -Must be detailed oriented, possess analytical skills, and be highly organized; -Must have high comfort level with Microsoft Office applications, including familiarity with Excel; -Ability to learn complex policies and processes and to implement them independently in grant management activities.
Preferred Qualifications: Experience with grants and contracts management in a university environment is desirable. However, candidates who meet the minimum qualifications, including two years of administrative or financial support experience, but without grants-specific experience will be considered, as this position will offer the ideal candidate the opportunity to develop grant administration skills.
As a member of the National Collegiate Athletic Association (NCAA) and the Council of Ivy Group Presidents (Ivy League), it is imperative that members of the Columbia University community, in all matters related to the intercollegiate athletics program, exhibit the highest professional standards and ethical behavior with regard to adherence to NCAA, Conference, University, and Department of Intercollegiate Athletics and Physical Education rules and regulations.
Columbia University is an Equal Opportunity/Affirmative Action employer.
Internal Number: 126_167754
About Columbia University
Columbia University is one of the world's most important centers of research and at the same time a distinctive and distinguished learning environment for undergraduates and graduate students in many scholarly and professional fields. The University recognizes the importance of its location in New York City and seeks to link its research and teaching to the vast resources of a great metropolis. It seeks to attract a diverse and international faculty and student body, to support research and teaching on global issues, and to create academic relationships with many countries and regions. It expects all areas of the university to advance knowledge and learning at the highest level and to convey the products of its efforts to the world.