Advertised Summary Job Description: Reporting to the Manager of Grants and Finance, the Finance and Grants Analyst will manage a portfolio of restricted/unrestricted accounts (ex. sponsored project accounts, discretionary and gift accounts) for departmental Principal Investigators (PIs), collaborate closely with a team of grants professionals (SPA&SPF) to manage the preparation of grant funding proposals, budget development, submission, negotiation, and monitoring of pending applications; and will provide high-level administrative support in the setup of restricted/unrestricted accounts. The Finance and Grants Analyst will provide ongoing monitoring of expenditures, coordinate with the finance team to initiate purchases and obtain reimbursements, analyze spending patterns and propose recommended modifications to manage spending levels, and generate periodic and ad hoc reporting; reconcile expenses on a monthly, annual, and as-needed basis to conform with agency and University reporting guidelines; prepare agency reports, manage subcontracts, and coordinate all closeout procedures. S/he monitors expenditure of restricted/unrestricted accounts from federal, industrial, and private agencies; monitor expenditure of restricted/unrestricted accounts for compliance and appropriateness; assist with budget variance analysis and expense reimbursements; review supplemental approval requests for compliance with existing policies. S/he will assist with development of ad hoc financial reports for PI's. This position will involve advanced use of MS Excel including creation of pivot tables and use of formulas (i.e. VLOOKUP) to create reports and analyze variances on a variety of data sets.
General Minimum Qualifications: Required:
Bachelor's degree and/or its equivalent required, with a preference for training in a technical field or scientific/technical writing, Finance, Accounting, or other relevant fields. Minimum 2 to 4 years of related experience in Finance administration. Must have the ability to utilize sound fiscal accounting practices and have analytical skills to prepare necessary reports.
Must have excellent interpersonal, communication, and organizational skills. Ability to establish priorities, work under pressure, and exercise independent judgment and discretion is necessary. Ability to react quickly and effectively to other inquiries from a variety of management levels with comprehensive and accurate information in a wide variety of contexts and changing priorities is needed. Positive, forward-thinking, mission-oriented attitude and sense of humor a must.
Additional Specific Minimum Qualifications:
Preferred Qualifications: Preferred:
Minimum 2 to 4 years of related experience in grants administration.
Working knowledge of applicable federal, state, and other sponsor regulation related to sponsored projects, including OMB Uniform Guidance, with strong preference for knowledge of Columbia policies governing sponsored projects and grant research compliance, and internal procedures and systems for pre- and post-award financial management.
Experience in higher education or other large, complex institution desirable. Familiarity with Columbia financial systems, particularly the Accounting at Columbia (ARC) system, is also desirable, along with experience with running financial report for project reconciliation, budgeting in the University Budget Tool, handling labor accounting in People @ Columbia (PAC), working in the Financial Front End (FFE) and RASCAL systems.
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_171576
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.