Columbia's Mortimer B. Zuckerman Mind Brain Behavior Institute supports interdisciplinary neuroscience research and discovery by scholars across the university and promises to be the most comprehensive institute for brain science.
The Zuckerman Institute is seeking a Senior Financial Analyst to join the finance team. This position will report to the Assistant Director of Post Award and Financial Management, this is an exciting opportunity for a talented individual with a breadth of expertise in financial activities. The Senior Financial Analyst is responsible for supporting the strategic development of financial and administrative activities and functions of the Institute.
Responsibilities include, but are not limited to the following:
Supports the management of all financial aspects of grant activities for their respective portfolio of projects and other financial budgets and operations of the Institute;
Provides post-award financial analysis of grants, clinical trials, subcontracts and contracts. Tracks 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 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;
Conducts account and variance analysis, budget analysis, and monitors grant and other funding activities; assists in grant budget reconciliations;
Assume a portion of the large volume of procurement monthly reconciliation of P-card transactions for PIs and Lab support;
Prepares complex ad hoc financial reports for senior management decision making; organizes information for presentation materials, as required.
Creates financial models and financial reports, summaries, projections, and analyses. Collects and analyzes data to provide feedback and recommendations to PIs;
Provides research labs with detailed salary analysis to adhere to University's effort compliance guidelines and grant-specific effort guidelines for PIs;
Assists in managing and confirmation of on-going salary allocations for the research labs at Zuckerman Institute;
Maintains salary allocations spreadsheets with approved salary level for all research personnel;
Assists in annual effort reporting certification completion;
Works with their portfolio of Principal Investigators (PI) and Pre-award Specialists to help develop budgets for grant application submissions;
Works closely with Pre-Award team to ensure proper hand over of new awards. Works with principal investigators to establish budget on new award budget periods depending on Notice of Grant award;
Works with Principal Investigators, faculty, and finance to ensure adherence to pertinent regulations, policies and procedures that govern sponsored grant funds. Stays abreast of regulations, policies and guidelines related to the conduct of research. Participates in regulatory audits and inspections; corrects deficiencies. Ensures compliance and regulatory requirements for grants are fulfilled and milestone deadlines met including Conflict of Interest and Effort Reporting;
Assists in the development, monitoring, and review of budgets for their portfolio of principal investigators; prepares reports and materials for review; analyzes specific issues, budget requests, and policy changes in support of the Institute; data entry for faculty P&L's and maintain financial reports of the principal investigators in their portfolio.
Clears suspense, overdrafts, and liquidation of open commitments. Supports processing of Labor Accounting transactions. Assists Department Finance staff in the preparation of the annual research budget;
Monitors effort for all principal investigators in their portfolio;
Gains an understanding of and familiarity with the Institute's financial models and forecasting tool. Develops a thorough working knowledge of the University's financial and reporting systems and work closely with Sponsored Projects Finance throughout the project lifecycle of the grant to closeout;
Manages special projects and performs other job related duties, as required.
Bachelor's Degree required, including a minimum of five (5) years' related experience.
Must be detail-oriented with excellent organizational, interpersonal, written and oral skills, and have the ability to communicate effectively with all levels of staff and management. Strong computer proficiency with an expertise in Excel with strong knowledge of Pivot tables is essential. A demonstrated ability to prepare reports, summaries and analyses, along with the ability to collect and analyze data and evaluate information, required. Experience with relational database software a plus. Knowledge of University financial policies and financial systems is preferred (ARC/Budget Tool).
Excellent interpersonal and communications skills necessary. Ability to work as a member of a collaborative team while exercising independent judgment essential.
The successful candidate must be flexible in nature, have a sound judgment with a collaborative style that fosters teamwork and cooperation beyond the immediate team to the broader organization. Must have a passion for excellent customer service and commitment to exceptional quality.
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
Internal Number: 499224
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.