Advertised Summary Job Description: Reporting to the Research Administrator, the Research Finance Coordinator is responsible for reporting on and monitoring financial activities and processing financial transactions for the Department's Basic Science Research Group (BSRG) and Clinical Research Unit (CRU). Prepares detailed financial reports for grants, clinical trials, gifts and department accounts and monitors variances.
1.Financial Reporting: Creates spreadsheets with detailed, multi-year project budgets, including revenue and expenditure projections. Prepares monthly, quarterly and annual financial reports for BSRG and CRU grant, clinical trial, gift and departmental projects. Prepares, reviews, and maintains records of expenditures and income. Acquires and maintains sound knowledge of departmental research projects and monitors for variances and sponsor compliance issues. Reports variances to Divisional Administrator and participates in the reconciliation and project closeout process. Prepares monthly P&L reports for each Investigator, Center Grant, and BSRG and CRU departmental projects. Prepares attestation reports and participates in quarterly PI meetings to review expenditures and salary allocations.
2.Financial Transactions: Works closely with the Senior Director of Finance & Operations and the Divisional Administrator and to process financial transactions for all research related projects and activities. Resolves all routine matters related to financial activities, including journal entries, AP journal vouchers, and budget tool transactions. Manages salary suspense account and charges salaries as deemed appropriate across the various sources of revenue. Clears suspense, overdrafts, and closes open commitments. Coordinates with Sponsored Projects Finance (SPF) on project close-outs including final reconciliation and cost overrun transfers.
3.Post-Award Management: Assists the Grants Manager in the post-award financial analysis of grants, clinical trials, subcontracts and contracts. Tracks financial milestones and due dates for all progress reports and expiration dates of protocols and awarded research grants. Establishes and maintains appropriate communication with sponsoring and regulatory agencies, Principal Investigators, Sponsored Projects Finance (SPF), and other designated University members regarding grant/account status. Works closely with subcontractors to establish a budget, ensure accurate and timely billing, payments, and the renewal of subcontract agreements.
4.Pre-Award Process: Assists the Grants Manager and Investigators with grant budget preparation. Ensures grant budget accuracy and consistency with ongoing expenditure rates and staff salaries; assists with budget setup upon notice of award. Provides assistance to the Grants Manager in the pre-award grant preparation and submission process. During peak submission times, provides backup support for proposal preparation and submission. Communicates with the research team to maintain knowledge of all award submissions and detailed records of currently pending awards.
General Minimum Qualifications: Bachelor's degree or equivalent in education, training and experience and at least three years related experience required. Exceptional organizational skills, the ability to work independently and under pressure while simultaneously executing multiple tasks is required. Must possess effective interpersonal communication skills.
Additional Specific Minimum Qualifications:
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.
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.