Finance and Grants Analyst

• Job Type: Officer of Administration
• Bargaining Unit:
• Regular/Temporary:
  Regular
• End Date if Temporary:
• Hours Per Week: 35
• Standard
  
  Work Schedule:
• Building:
  Morningside
• Salary Range: $66,300 - $70,000

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.

Columbia University School of Engineering is seeking a Finance and Grants Analyst to join the Grants Team of their Computer Science Department. Reporting to the Associate Director of Grants and Finance, the Finance and Grants Analyst will provide support for all restricted/unrestricted-related pre- and post-award administrative activities of the Department of Chemical Engineer.

(70%)

• Award/Contract/Subaward set-up
• Works with Grants and Finance, Dean’s Office, and SPA to establish new accounts and revise existing accounts in a timely manner.
• Maintains and updates school-wide and departmental templates, checklists and pre-award filing system;
• Analyzes Notice of Award (NOAs) to verify accuracy of award and obligated amounts against prime award records, adherence to funded proposal budgets, computer-tracking codes and specific agency regulations.
• Sponsored Awards Reporting and Deliverables:
• Work with PIs to ensure progress reports are prepared and submitted per sponsoring agency requirements;
• Under the Direction of the Associate Director of Grants and Finance, the role triages the shared email system and internal administrative calendar to ensure incoming requests are managed efficiently.

(25%)

• Restricted/Unrestricted Account Management.
• Works closely with the Associate Director of Grants and Finance, the Grants Team, the Payroll team, and faculty in the effective and efficient administration/management of restricted and unrestricted departmental sources:
• prepares of quarterly grants attestation and financial analysis with the goal of identifying and forecasting trends in spending that exceed current funding levels, recommending budget modifications and strategies to effectively manage spending patterns and mitigate risk, reviewing and closing all open commitments, and clearing overruns;
• Interface regularly with SPA, SPF and SEAS Dean’s offices in the preparation and submission of all budgetary changes/updates to include the modifications of sub-award budgets (i.e., increment adjustments, etc), start-up funding arrangements and other faculty sources of support;
• Analyze with the departmental finance/business operations staff to initiate day to day transactions (i.e., journals, payroll accounting/suspense clearance, accounts receivable and accounts payable)
• Conducts other periodic and ad hoc analyses and reporting to the department and School.
• Other Post-award Administrative Duties:
• Subcontracts: assist in preparation, submission, and track of subcontract paperwork, invoicing and final subaward closeout.
• Annual Effort Certification: assist the grants team with the annual effort certification process as needed.
• Closeout: provides support to the grants team in the management of the post-award closeout process to include the calculation of cost-share, the preparation and submission of financial reconciliations for project or fiscal year-end (i.e., SPF validation of sponsored award expenses and the completion of agency required sponsored funding award schedules);
• Compliance & Records Management: works closely with the Associate Director of Grants and Finance to ensure all financial activities on projects are compliant with university and agency guidelines. Maintains all pertinent records, files, and documents.
• Assists with the review and clearance of payroll suspense; identifies incorrect salary disbursements against salary budgets, researches errors, and implements the necessary corrections using the University's Labor…