Advertised Summary Job Description: Grant funded - Working under the direct supervision of the Senior Manager, Allocation and Financial Reporting, the Temporary 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.
- 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.
- 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.
- In collaboration with CU's Sponsored Projects Administration (SPA) and other ICAP units, prepare and analyze account allocations to ensure conformity with funder and University guidelines.
- Prepare monthly and quarterly invoices to be submitted to donor agencies as outlined by the underlying sponsored project agreement.
- Provide quarterly updates to planned fiscal spending estimates in the COB system.
- Prepare quarterly budget vs. actual reporting of the status of grant activity as required by CUMC, and obtains PI attestation/certification.
- Liaise 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.
- In collaboration with members of the team, provide feedback of existing process flow and contribute to the improvement and increase efficiencies of financial reporting and allocation processes.
- Perform other duties as assigned.
General Minimum Qualifications: Requires a Bachelor's degree or equivalent in education and experience, plus three years of related 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.
- Proficient with Microsoft Office Suite (e.g., Excel, Word, Outlook, and Access).
Additional Specific Minimum Qualifications:
Preferred Qualifications: - Knowledge of the pre and post award management of government grants and contracts, with a heavy emphasis on the reporting requirements of the US government.
- Knowledge and experience with the various financial systems of Columbia University.
- Experience working in a multi-layered environment with a variety of reporting relationships and varying reporting responsibilities.
- Experience working in an environment where there are multiple and sometimes conflicting closing dates and time lines.
-Working knowledge of MS Access.
As a member of the National Collegiate Athletic Association (NCAA) and the Council of Ivy Group Presidents (Ivy League), it is imperative that members of the Columbia University community, in all matters related to the intercollegiate athletics program, exhibit the highest professional standards and ethical behavior with regard to adherence to NCAA, Conference, University, and Department of Intercollegiate Athletics and Physical Education rules and regulations.
Columbia University is an Equal Opportunity/Affirmative Action employer.
Columbia University is one of the world's most important centers of research and at the same time a distinctive and distinguished learning environment for undergraduates and graduate students in many scholarly and professional fields. The University recognizes the importance of its location in New York City and seeks to link its research and teaching to the vast resources of a great metropolis. It... seeks to attract a diverse and international faculty and student body, to support research and teaching on global issues, and to create academic relationships with many countries and regions. It expects all areas of the university to advance knowledge and learning at the highest level and to convey the products of its efforts to the world.