Position Summary

Working under the general guidance of the Interim Director of Financial Planning, the Senior Financial Analyst will serve as the lead analyst for internal and external reporting matters;  Provides first-level financial review and oversight from the New York headquarters office for funder and internal (pipeline) reporting for ICAP???s portfolio;  Serves as the lead analyst in the development and generation of information necessary to ensure that ICAP fulfills its financial reporting obligations to all US Government donor agencies, private foundations, partners and the relevant internal departments within Columbia University.

Subject to business needs, we may support flexible and hybrid work arrangements. Options will be discussed during the interview process.

Responsibilities

• Responsible for financial monitoring of assigned portfolio. Collaborate with country offices and NY HQ to respond to inquiries on reporting matters, identify and analyze errors, ensure that expenses are properly classified and appropriately charged to budgets/awards  and ensure appropriate units are informed if corrections are needed 30%
• Responsible for the direct oversight and preparation of some of the more complicated and larger awards within ICAP???s portfolio, including the development and submission of monthly, quarterly, and annual internal and external financial progress reports to ensure that they are in compliance with funder requirements 30%
• Provides guidance and first level review of analyst???s internal and external deliverables. Reviews and provides assistance to the Analysts in the preparation of monthly reports that will serve as a valuable tool for all NY and Country teams to better monitor expenditures against awarded funds by analyzing project burn rates, alerting country teams of budget over runs and training country finance teams to better manage their spending  20%
• Review quarterly budget vs. actual reporting of the status of grant activity as required by CUMC, and obtains PI attestation/certification, as needed. -4%
• In collaboration with members of the team, perform routine assessments of existing process flow and develop strategies to streamline financial reporting process, standardize financial reports and improve efficiency-2%
• Coordinate and train existing and new reporting and financial analysts on COB and ARC as they relate to reporting matters 2%
• Prepares and coordinates quarterly and annual COB payroll budgeting updates-5%
• Serve as lead analysts for budget exception errors and diagnostics of COB issues-2%
• Performs other duties as assigned -5%

Minimum Qualifications

• Bachelor???s degree in Accounting, Business, Finance or related field of study or equivalent in education, training or experience.
• Minimum four (4) years of experience
• Demonstrated supervisory experience;
• Strong analytical and organizational skills
• Strong interpersonal skills in order to deal effectively with varied internal clients, management groups and vendors
• Demonstrated experience working in a team environment and independently
• Excellent customer service skills
• Advanced knowledge of Microsoft Office Suite (e.g., Excel, Word, Outlook)

Preferred Qualifications

• Knowledge of US Government Rules and Regulations on Reporting and Expenses
• Demonstrated experience working in a fast paced environment, coupled with experience with international protocols, non-profit organizations or academic institutions is highly desirable
• Working knowledge of Columbia University systems

Other Requirements 

• No international travel required at this time

Equal Opportunity Employer / Disability / Veteran

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