The Financial Analyst (FA) reports to the Associate Dean of Grants & Contracts and Director of MSPH Operations, Sponsored Projects Administration (SPA) and works closely with other staff members (both pre- and post-award) in the day-to-day operations.
The Financial Analyst is responsible for the post-award analysis of grants, subcontracts and contracts in order to prepare, process and approve all restricted purpose fund authorizations. The FA is assigned a full caseload of departments and will assume primary responsibilities for the portfolio of accounts under these departments.
Responsibilities Award Review and Account Set up â€¢ Review and analyze grants, contracts and cooperative agreements in order to prepare, process and approve all sponsored projects accounts and budget authorizations, which include new awards, continuations, transfer-funds, supplements, modifications, no cost extensions, re-budgeting and carryovers; â€¢ Review award documents for accuracy and consistency with proposal applications and with sponsor and institutional policies and sponsor regulations/guidelines; â€¢ Under the guidance of the Associate Dean of Grants & Contracts and Director of MSPH Operations, work with Principal Investigators (PIâ€™s), Department Administrators (DAâ€™s), Sponsored Projects Finance (SPF), and sponsoring agencies to document and analyze pertinent regulations, policies and procedures that govern the stewardship of sponsored project funds; â€¢ Ensure compliance with award regulatory terms and University policies, such as Conflicts of Interest, Human Subjects & IACUC approvals, etc.; â€¢ Acquire and maintain knowledge of and interpret sponsoring agency, Federal, State and University policies and regulations regarding the receipt and administration of sponsored projects; â€¢ Process awarded information into SPA grants management system for account creation and/or modifications; â€¢ Review and reconcile the data fed from the grants management system (InfoEd) to the Universityâ€™s financial system (ARC), to ensure accuracy; Research Department Support â€¢ Advise PIs and DAs regarding budgetary issues affecting project accounts and respond in a timely and effective manner to PI and DA inquiries at all times; â€¢ Utilize sound fiscal accounting practices, analysis and procedures to account for the receipt of sponsored projects funds and prepare necessary reports, including analysis of sponsored projects for account set-up, monitoring of financial activities, overdraft resolution and account closeout, review and approval of rebudgets (coordinating with SPF, as appropriate). Other Duties â€¢ Maintain current knowledge of changes of indirect costs rates, fringe benefit rates and other University sponsored project related policies and procedures; â€¢ Under the guidance of Associate Dean of Grants & Contracts and Director of MSPH Operations, CUMC, establish and maintain appropriate communication with sponsoring and regulatory agencies, PIs and DAs and other designated University members regarding sponsored project account status; â€¢ Exercise good judgment in clarifying and resolving issues of concern and maintain complete records and documentation both in hardcopy files as well as electronic records in InfoEd; â€¢ Under the direction of the Associate Dean of Grants & Contracts and Director of MSPH Operations, provide necessary support in the on-going audit processes, for both internal and external clients; â€¢ Make ongoing recommendations for improvement of current practices; â€¢ Perform other duties as assigned.
Bachelor's degree or equivalent in education and experience required
2 years related experience
Proficiency in Microsoft Office (Word, Excel, PowerPoint, Outlook) required
Experience using other Microsoft applications and accounting software required.
Strong oral and written communication skills
Proven ability to communicate positively and effectively with sponsoring and regulatory agencies, as well as faculty, administrators and other members of the University is important;
Knowledge of grants and OMB, Federal and State laws and regulations strongly preferred;
Strong analytical and critical thinking abilities, organizational, time management, and proactive problem solving skills;
Proven ability to operate independently in a fast paced and high volume environment with frequently changing priorities;
Experience with financial reporting of sponsored projects.
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
Internal Number: 516481
About Columbia University
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.