• Job Type: Officer of Administration
• Bargaining Unit:
• Regular/Temporary: Regular
• End Date if Temporary:
• Hours Per Week: 35
• Standard Work Schedule:
• Building:
• Salary Range: $64,500-$68,500

Position Summary

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 Computer Science.

Responsibilities

• (45%) Pre-Award Support (Grants and Unrestricted funding sources):
  • Proposal preparation:
    • Assists research faculty/PIs in the preparation/submission of federal, industry, foundation grants and contracts applications and other intramural sources. Ensures adherence to departmental, School, and University policies and standard operating procedures (SOPs), funding agency specifications, and other relevant rules and regulations;
      • Prepares and compiles all relevant components of individual grant submission. Ensures that the proposal is formatted, packaged, and submitted in accordance with granting agency requirements/specifications;
      • Manages timelines and the overall progression of submission to ensure timely, highquality, complete, responsive and compliant proposal applications. Ensures that the PI's budgetary submissions carry accurate rates, budgetary caps and other relevant information approved by the department, School, University and/or sponsor;
      • Maintains detailed, up-to-date records of PI's other support, biosketches, and grant submission documents;
  • Award/Contract/Subaward set-up:
    • Coordinates with the Associate Director of 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
• (45%) Post-Award Support (Grants and Unrestricted funding sources):
  • Restricted/Unrestricted Account Management:
    • Works closely with the Associate Director of Grants and Finance, the Grants Team, administrative team, and faculty in the effective and efficient administration/management of restricted and unrestricted departmental sources:
    • Assists in the preparation 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;
    • Coordinates 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 sub award 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.
• (10%) Performs other relative tasks, duties, and responsibilities as assigned.

Minimum Qualifications

• Bachelor's degree and/or its equivalent required, with a preference for training in a technical field or scientific/technical writing, Finance, Accounting, or other relevant fields.
• Minimum 1 to 2 years of related experience in Finance administration.
• Must have the ability to utilize sound fiscal accounting practices and have analytical skills to prepare necessary reports.
• This position will involve mid to advanced knowledge of MS Excel including creation of pivot tables and use of formulas to create reports and analyze variances on a variety of data sets.

Preferred Qualifications

• 1-2 years of related experience in grants/finance administration.
• Excellent analytical, organizational, interpersonal, oral and written communication skills.
• Working knowledge of applicable federal, state, and other sponsor regulation related to sponsored projects, including OMB Uniform Guidance, with strong preference for knowledge of Columbia policies governing sponsored projects and grant research compliance, and internal procedures and systems for pre- and post-award financial management.
• Experience in higher education or other large, complex institutions is desirable.
• Familiarity with Columbia financial systems.
• Must have excellent interpersonal, communication, and organizational skills.
• Ability to establish priorities, work under pressure, and exercise independent judgment and discretion is necessary.
• Ability to react quickly and effectively to other inquiries from a variety of management levels with comprehensive and accurate information in a wide variety of contexts and changing priorities is needed.
• Positive, forward-thinking, mission-oriented attitude and sense of humor a must.