Financial Analyst

Job Type: Officer of AdministrationBargaining Unit:Regular/Temporary: RegularEnd Date if Temporary:Hours Per Week: 35Standard Work Schedule:Building:Salary Range: $75,000 - $85,000 The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above hiring range represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting. 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 portfoliosAssists 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 indicatorsConducts 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 projectsSupports 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 & BudgetProvides final approval for financial transactionsSupports 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 inquiriesDevelops and monitors project cash flows for submission to the Office of Management & BudgetCreates and assigns capital projectsReviews project information for reporting purposes Assists with managing the submission of insurance claims to Risk ManagementOversees the reporting of project costs by component to the Controller for depreciation purposesReconciles the billing of project management, internal design, and commissioning feesManages the reconciliation and closeout of completed projectsProvides guidance and recommendations to project managers and works closely with senior CUFO staff on the financial management of projectsResponds to internal and external audit inquiriesDevelops new year-end financial reports and presentations and oversees their productionProvides final approval for financial transactions amounting to millions of dollars annuallyPrepares financial reports to meet government or grant requirementsPerforms 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 accountingAdvanced Excel and statistical analysis skillsExceptional customer service skillsStrong organizational skillsAbility 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.