Reporting to the Vice Chair of Research and Director of Finance, the Research Finance Manager is responsible for reporting on and monitoring financial activities and processing financial transactions for Dermatology's Basic Science Research Group (BSRG) and Clinical Research Unit (CRU). He/She prepares detailed financial reports for grants, clinical trials, gifts and department accounts and monitors variances. Processes budget transactions, salary distributions, and journal entries in compliance with sponsor and university policies. The Research Finance Manager is a key member of the Dermatology's Research and Finance teams and works closely with the Research Administrator, Principal and Clinical Investigators and Columbia University's SPA and SPF (Central Sponsored and Non Sponsored Executive Departments).
Financial Reporting: Responsible for creating 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 trials 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 the Vice Chair of Research and Director of Finance and participates in the reconciliation and project closeout process. Works with the Director of Finance in preparing monthly profit and loss (P&L) reports for each Investigator, Center Grant, BSRG and CRU departmental projects. Prepares attestation reports and participates in quarterly Pl meetings to review expenditures and salary allocations.
Financial Transactions: Works closely with the Director of Finance and the Research Administrator 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.
Budget Preparation: Prepares and develops project budgets. Works with finance staff to clear suspense, overdrafts, and liquidation of open commitments. Processes Labor Accounting transactions. Assists Department Finance staff in the preparation of the annual research budgets for progress reports and no-cost extensions.
Compliance: Works with Principal Investigators, faculty, and finance to ensure adherence to pertinent regulations, policies and procedures that govern sponsored grant funds. Stays abreast of NIH and external agency regulations, policies and guidelines related to the conduct of research. Participates in regulatory audits and inspections; corrects deficiencies. Ensures compliance and regulatory requirements are fulfilled for each project and milestone deadlines met including Conflict of Interest and Effort Reporting. Manages PMCID submissions for grants.
Post-Award Management: Assists the Research Administration Team 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
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. Assists the Research Team 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.
Procurement and Accounts Payable: Provides assistance and backup to the Administrative Manager in placing p-Card orders, processing purchase orders and travel reimbursements. Reconciles procurement card. Ships, receives and tracks shipments. Negotiates with vendors for value pricing. Investigates and resolves problems. Keeps faculty and staff informed.
Cross covers other administrative positions and performs other duties as assigned.
Requires a bachelor's degree or equivalent in education and experience, plus three years of related experience. Prior experience with grant budgeting and pre-award grants procedures required. Ability to work under pressure with multiple and competing deadlines required. Must be highly organized, with excellent communication and follow up skills. Ability to work as part of a team, with administrative, clinical research, and financial staff.
Bachelor's degree and two years of experience in research finance, or a combination of training, education, and experience. Significant expertise using Microsoft Excel required. Must have the ability to utilize sound fiscal accounting practices and procedures to account for receipt of grant monies and prepare necessary reports. Experience with financial management and post grant awards procedures and process in a large and highly complex organization; familiarity with the University's complex
Financial system modules such as ARC and Budget Tool; and, knowledge of Federal, State, and University policies and regulations regarding the receipt and administration of grants and contracts is required.
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
Internal Number: 502269
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.