Reporting & Financial Analyst

Columbia University
United States, New York, New York
Dec 19, 2024
Job Type: Officer of Administration Bargaining Unit: Regular/Temporary: Regular End Date if Temporary: Hours Per Week: 35 Standard Work Schedule: Salary Range: $70k - $72k 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 Working under the direct supervision of the Supervisor of Financial Monitoring & Planning, the Reporting and Financial Analyst develops and provides the information necessary to help 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 (CU). Develops and provides a range of financial information and reports to ICAP leadership for the purpose of decision making. 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 - 25% Prepare and analyze monthly and quarterly pipeline reporting, spending and burn rate ratios, distribute and communicate with internal project coordinators, Principle Investigators, finance director and in country finance managers - 20% Prepare annual Federal Financial Reports (FFR) for ICAP's sponsored projects for submission to CU's Sponsored Projects Finance (SPF). Prepare interim and/or periodic financial reporting request of a specialized nature as may be required by funders - 10% Prepare monthly and quarterly invoices to be submitted to donor agencies as outlined by the underlying sponsored project agreement - 15% Prepare quarterly budget vs. actual reporting of the status of grant activity as required by CUMC - 10% Prepare Quarterly Attestations reports- 5% Lead monthly pipeline meetings across teams between HQ and operating countries - 20% Perform other duties as assigned - 5% Minimum Qualifications Bachelor's Degree or equivalent in education and experience Strong analytical and organizational skills, and strong attention to detail Strong interpersonal skills in order to deal effectively with various internal ICAP units, other Columbia University departments and centers, as well as other stakeholders Demonstrated experience working in a team environment and independently Intermediate level Microsoft Office Suite (e.g., Excel, Word, Outlook, and Access). Intermediate knowledge of pivot tables, formulas, and functions in MS Excel. Ability to conduct meetings across domestic and international teams. Preferred Qualifications Bachelor's Degree or equivalent in education and experience Equal Opportunity Employer / Disability / Veteran Columbia University is committed to the hiring of qualified local residents.