Columbia University Financial Analyst in New York, New York

Job TitleFinancial Analyst

Job Code Title

Job Requisition Number 095586

Department 6803- ZUC Finance General

Location Manhattanville

Job Type Officer Full-Time Regular

Bargaining Unit

If temporary, indicate duration

Hours Per Week 35

Job Family Grants Management

Salary Grade 12

Salary Range Commensurate with Experience

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.

Minimum Qualifications for Grade

Applicant MUST meet these minimum qualifications to be considered an applicant 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 Position-Specific Minimum Qualifications

Applicant MUST meet these minimum qualifications to be considered an applicant 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.

Special Instructions

Preferred Qualifications

Essential Functions

Additional Essential Functions (Limit to 3950 characters.)

Special Indications

This position works with:

HIPAA Compliance training required No Response

Participation in Medical Surveillance required No Response

What type of posting? Is this a waiver request? Standard Posting

Requisition Open Date 11-09-2018

Requisition Close Date Open Until Filled

Quick Link jobs.columbia.edu/applicants/Central?quickFind=173064

EEO Statement Columbia University is an Equal Opportunity/Affirmative Action employer --Race/Gender/Disability/Veteran.

Local Hiring Columbia University is committed to the hiring of qualified local residents.

This organization is a federal contractor subject to the Vietnam Era Veterans' Readjustment Assistance Act of 1974, as amended by the Jobs for Veterans Act of 2002, 38 U.S.C. 4212 (VEVRAA). The final rules now require contractors and subcontractors to invite applicants to self-identify as protected veterans or individuals with disabilities.

You can update your demographic information by logging in and clicking on "EDIT APPLICATION".

The information is being requested on a voluntary basis, and will be kept confidential. Refusal to provide this information will not subject the applicant to any adverse treatment, and will not be used in a manner inconsistent with the act.