Advertised Summary Job Description: Reporting to the Manager of Research Finance, the post-award Financial Research Analyst & Reporting is responsible for assisting with the post award financial administration of a diverse portfolio of government, private, public grants, internal grants, and contracts of varied complexity, ensuring that they are administered in a fiscally responsible manner, complying with all applicable rules and regulations established by both the sponsor agency and the University and in coordination with the Manager of Research Finance. Ensures that salary and non salary grant expenses are allocated as budgeted on a timely manner. Secures timely and accurate quarterly attestations from Principal Investigators in coordination with their Division Administrators, for the assigned grants portfolio following Sponsored Projects and University requirements, utilizing Web Viewer and any other Sponsored Projects developed tools. Maintains records in accordance with internal procedures, demonstrating compliance with sponsor and the sponsor agreements and University regulations concerning equipment, project expenditures and other fiscal concerns. Provide efficient and effective post-award accounting services to faculty and administrators, including monthly grant reconciliations, grants financial reporting. Prepares monthly/quarterly financial reports including P&L for assigned PIs/Faculty in coordination with Manager of Research Finance. Assists in transacting and documenting grants related non-salary cost transfers, salary cost transfers, and salary distributions. Obtains and safeguards necessary PI approvals and required documentation.
Assist, as required, in quarterly and annual budget procedures including loading grants fiscal year budgets and salary to budget tool. Assists, as required, in budget variance analysis. Assists in the University year end closing procedures, including, but not limited to, ensuring there is no grant overrun, all necessary grant expenses have been posted, SAPOS and POs are correctly accounted for and encumbered in ARC Sponsored Projects Financial reports. In coordination with the pre- award team assists, as required, in grants invoicing, closeout and validations. Assists as required in the effort certification process.
General Minimum Qualifications: Requires a bachelor's degree or equivalent in education and experience, plus three years of related experience.
Additional Specific Minimum Qualifications: Must be comfortable working with databases and computerized financial systems.
Must be able to identify priorities within multiple assignments in a high-pressured, short-deadline environment, and be able to work with diplomacy and efficiency in such an environment.
Must be able to demonstrate excellent organizational, analytical, critical thinking, interpersonal, written and oral communication skills. In addition, the successful candidate must have demonstrated ability to develop and maintain effective working relationships with faculty, must be able to work well with all levels of employees, be flexible in nature, have sound judgment with an open and collaborative style that encourages teamwork and cooperation beyond the immediate team to the broader organization. Must have a passion for excellent customer service and commitment to exceptional quality.
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.