Advertised Summary Job Description: 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 two (2) Financial Analysts to join the finance team. Reporting to the Assistant Director of Post Award & Financial Management, this is an exciting opportunity for a talented individual with a breadth of expertise in financial activities who can handle diverse tasks simultaneously, embrace change and be independent decision-makers. The Financial Analyst is responsible for supporting the financial and administrative activities and functions of the Institute. (Two open positions currently available in the Department) 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; * Creates financial models and financial reports, summaries, projections, and analyses. Collects and analyzes data to provide feedback and recommendations to PIs; * 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; * Provides support on special projects and performs other job related duties, as required.
General Minimum Qualifications: At least an Associate Degree required. Bachelor Degree preferred. Must possess a minimum of three (3) years' related experience.
Strong computer proficiency with an expertise in Excel, facility creating financial models and a strong working knowledge of Pivot tables is essential. A demonstrated ability to prepare financial reports, summaries, projections, and analyses, along with the ability to collect and analyze data and evaluate information is required. Willingness to embrace change and grow with the position. Knowledge of University financial policies and financial systems is preferred (ARC/Budget Tool). Experience with Microsoft Word and PowerPoint is a plus.
Must be detail-oriented with excellent organizational, interpersonal, written and communication skills, and have the ability to interface effectively with all levels of staff and management. 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.
Additional Specific Minimum Qualifications: Strong computer proficiency with an expertise in Excel, facility creating financial models and a strong working knowledge of Pivot tables is essential. A demonstrated ability to prepare financial reports, summaries, projections, and analyses, along with the ability to collect and analyze data and evaluate information is required.
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_173064
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.