• Job Type: Officer of Administration
• Regular/Temporary: Regular
• Hours Per Week: 35
• Salary Range: $90,000 - $103,500

Position Summary

The Senior Financial Analyst manages, processes, reconciles, and interprets financial and endowment-related information for Columbia University Irving Medical Center (CUIMC). Aggregates and organizes such information into standard reporting formats for Central Office and Departments. The Senior Financial Analyst will gain thorough knowledge of Columbia's financial systems and reports, and articulate big-picture and detailed information to team members.

The Senior Financial Analyst will also support efforts to monitor, reconcile and report on school and departmental use of space. Such analysis will include analyzing cost of space and incorporating space information into school budget tool.

The ideal candidate should be inquisitive, motivated, and a big-picture thinker with the ability to drill down to the details. Candidate should also have strong analytical skills and seek the opportunity to learn quickly in a challenging and fast-paced environment.

Candidates should also possess the ability to analyze and coalesce data from multiple systems and present it in a straightforward format. The Analyst should also be very comfortable preparing and manipulating integrated spreadsheets, database and PowerPoint presentations.

Responsibilities

• Assist in the analysis and reporting of the recruitment budget with input from

Director of Financial Planning;

• Transact on quarterly recruitment budget updates and year end actuals updates in ARC and Budget Tool.
• Review quarterly departmental recruitment requests and spending against budget and provide explanations for variances to Director of Financial Planning and Analysis.

25%

• Assist in the implementation of campus and school-level funds flow and FAIR budget submission under the direction of Director of Financial Planning and Analysis;
• Assist in background analysis required to set funds flow "recovery rates"
• Responsible for entering budgeted and actual funds flow transactions on monthly and quarterly basis as necessary.

25%

• Assist in managing gift and endowment funds, primarily for VP&S Administration.

20%

• Support Associate Director of Capital Budget in preparing and presenting capital plan.
• Monitor and reconcile campus and school space allocation assessments and package up ARC monthly journal entries as required.
• Collaborate with campus space planning teams and forecast space allocation assessments and subsidies.
• Maintain space assessment projections in University's proprietary budget tool.

20%

• Provide regular, detailed reporting support to Director; and
• Perform other duties and "ad hoc" analyses as assigned.

5%

• Develop solutions to improve general efficiency of financial, analytical and endowment-related processes.
• Consider clearer and more informative ways of presenting information in excel, PowerPoint presentations, etc, and implements such suggestions.
• Train and offer process, presentation and technical advice to other team members as appropriate.

5%

Minimum Qualifications

• Bachelor's degree, as well as at least 4 years of progressively comprehensive experience in budgeting and financial analysis, Experience in higher education, an academic medical center or hospital or in an equivalent environment preferred.

Preferred Qualifications

• MPA, MBA or comparable advance degree, or equivalent experience, preferred.

Other Requirements

• Excellent oral and written communication and customer service skills.
• Attention to detail, plus the ability to work closely and collaboratively with a diverse group of administrators is essential.
• Expert-level computer proficiency (Microsoft Excel and Word) is required, including an in-depth knowledge of spreadsheet functions and pivot tables.

Equal Opportunity Employer / Disability / Veteran

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