0918- RES Sponsored Projects Admin
Officer Full-Time Regular
If temporary, indicate duration
Hours Per Week
Commensurate with Experience
Advertised Summary Job Description
The Associate Financial Analyst (AFA) reports to the Post Award Director of Sponsored Projects Administration and works closely with the other staff members (both pre- and post-award) under the coordination of the Team Lead in the day-to-day operations at the two campuses. The Associate Financial Analyst position is the first level position in a three-tiered series of positions: Associate Financial Analyst (AFA), Financial Analyst (FA), and Financial Analyst-Team Lead (Lead FA). The AFA position is part of a three-tiered career ladder and will work under the close supervision of the Post Award Director and the mentorship of the Team Lead and Financial Analysts. The AFA is assigned a caseload of departments and will assume primary responsibilities for a lower volume and less complex portfolio of accounts. 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 all awards assigned for accuracy and consistency with proposal applications and with sponsor and institutional policies and regulations per established standard operating procedures; - Under the guidance of the Team Lead and Post-Award Director, 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; - Data enter awarded information into SPA grants management system for account creation and account modifications; - Post data entry, review and reconcile the information and attributes fed from the grants management system to the University's financial system (FAS), to ensure both systems are synchronized. PI and 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 Post-Award Director and Team Lead, 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 Post Award Director, 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.
Minimum Qualifications for Grade Applicant MUST meet these minimum qualifications to be considered an applicant
Additional Position-Specific Minimum Qualifications Applicant MUST meet these minimum qualifications to be considered an applicant
- Bachelor's degree, preferably in accounting, finance or business administration or equivalent combination of education and business experience required. - 2-4 years' related experience
? Proficiency with Excel required; ? Experience using other Microsoft applications and accounting software required
? Strong oral and written communication skills; ? Strong analytical and critical thinking abilities, organizational, time management, and problem solving skills; ? Bachelor's degree in accounting, finance or business ? Knowledge of grants and OMB, Federal and State laws and regulations; ? Experience with financial reporting of grants.
Special Indications This position works with:
There are no special indications for this position
HIPAA Compliance training required
Participation in Medical Surveillance required
What type of posting? Is this a waiver request?
Requisition Open Date
Requisition Close Date
Open Until Filled
Columbia University is an Equal Opportunity/Affirmative Action employer.
Columbia University is committed to the hiring of qualified local residents.
Founded in 1922, Columbia University's Mailman School of Public Health pursues an agenda of research, education, and service to address the...