Financial Analyst

• Job Type: Officer of Administration
• Bargaining Unit:
• Regular/Temporary: Regular
• End Date if Temporary:
• Hours Per Week: 35
• Standard Work Schedule:
• Building:
• Salary Range: $75,000 - $85,000

Position Summary

The Financial Analyst will report to the Assistant Director as part of the Capital Finance group within Columbia University Facilities and Operations (CUFO) which is responsible for a wide array of tasks related to financial reporting and controls for all capital projects. The Financial Analyst will assist the Assistant Director with the oversight and management of the capital plan for the assigned clients, building portfolios, and funding portfolios. The Financial Analyst will be responsible for all financial reporting for all capital projects and investments. They will assist with the maintenance of compelling reports and dashboards to track financials, identify trends and monitor business operations, benchmark construction costs, and maintain portfolio specific key performance indicators. They will assist the Assistant Director with the capital project funding authorization process including the tracking, review and submission of all capital project funding authorization documents. They will conduct data analyses, prepare financial information, and provide ad hoc reporting for a wide variety of internal clients.

The Financial Analyst is also responsible for the tracking and verification of the Capital Finance group’s data, which originates from multiple sources. They will be responsible to identify variances or discrepancies and propose and/or perform resolutions to said variances.

Responsibilities

• Assists the Assistant Director with the oversight and management of the capital plan for the assigned clients, building portfolios, and funding portfolios
• Assists with the maintenance of compelling reports and dashboards to track financials, identify trends and monitor business operations, benchmark construction costs, and maintain portfolio specific key performance indicators
• Conducts data analyses, prepares financial information, and provides ad hoc reporting for a wide variety of internal clients; developing new and overseeing the production of year-end financial reports and presentations; reviewing the creation and assignment of capital projects; reviewing project information for reporting purposes; managing the reconciliation & close out of completed projects
• Supports with the management of the funding authorization process including the tracking, review and submission of all client funded capital project funding authorization documents; developing project cash flows Office of Management & Budget
• Provides final approval for financial transactions
• Supports with the management of the submission of all insurance claims to Risk Management; overseeing the reporting of the break down by component by project to the Controller for depreciation purposes; reconciling the billing of project management, internal design and commissioning fees; providing guidance and recommendations to project managers and working closely with senior CUFO staff on the financial management of projects; responding to internal and external audit inquiries
• Develops and monitors project cash flows for submission to the Office of Management & Budget
• Creates and assigns capital projects
• Reviews project information for reporting purposes 
• Assists with managing the submission of insurance claims to Risk Management
• Oversees the reporting of project costs by component to the Controller for depreciation purposes
• Reconciles the billing of project management, internal design, and commissioning fees
• Manages the reconciliation and closeout of completed projects
• Provides guidance and recommendations to project managers and works closely with senior CUFO staff on the financial management of projects
• Responds to internal and external audit inquiries
• Develops new year-end financial reports and presentations and oversees their production
• Provides final approval for financial transactions amounting to millions of dollars annually
• Prepares financial reports to meet government or grant requirements
• Performs related duties & responsibilities as assigned

Minimum Qualifications

• Bachelor's degree and/or its equivalent, plus a minimum of 3-5 years related experience required including experience or major in finance, budgeting and/or accounting
• Advanced Excel and statistical analysis skills
• Exceptional customer service skills
• Strong organizational skills
• Ability to follow through with assigned tasks efficiently and accurately 
• Ability to exercise solid judgement and establish priorities for workload 
• Ability to work independently and collaboratively 

Equal Opportunity Employer / Disability / Veteran

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