Columbia University Senior Grants Analyst in New York, New York

Position Information

Job Title

Senior Grants Analyst

Job Code Title

Job Requisition Number

089565

Department

5214- ENG Electrical Engineering

Location

Morningside

Job Type

Officer Full-Time Regular

Bargaining Unit

If temporary, indicate duration

Hours Per Week

Job Family

Administrative Support

Salary Grade

11

Salary Range

Advertised Summary Job Description

The Department of Electrical Engineering of the Fu Foundation School of Engineering and Applied Science is looking for an energetic and dynamic individual to join the team. Reporting to the Business Manager, the Senior Grants Analyst is responsible for providing comprehensive pre- and post- award grants management for Principal Investigators (PIs) in the Department of Electrical Engineering. The Senior Grants Analyst will collaborate closely with a team of grants professionals to manage the preparation of grant funding proposals, budget development, submission, negotiation, and monitoring of pending applications; and will provide high-level administrative support in the setup of new sponsored project accounts. The Senior Grants Analyst will manage a portfolio of sponsored projects for departmental PIs, providing ongoing monitoring of expenditures, coordinate with the finance team to initiate grant purchases and obtain reimbursements, analyze spending patterns and propose recommended modifications to manage spending levels, and generate periodic and ad hoc reporting; reconcile grant expenses on a monthly, annual, and as-needed basis to conform with agency and University reporting guidelines; prepare agency reports, manage subcontracts, and coordinate all closeout procedures. In addition, the Senior Grants Analyst will calculate the salary distributions per semester and create suspense reports.

Minimum Qualifications for Grade

Applicant MUST meet these minimum qualifications to be considered an applicant

Bachelor's degree and/or its equivalent required. Minimum 2-4 years grant-related financial experience required.

Additional Position-Specific Minimum Qualifications

Applicant MUST meet these minimum qualifications to be considered an applicant

Special Instructions

Preferred Qualifications

Prefer related experience in an academic environment or engineering background

Essential Functions

Pre-Award Support: 30%

Budget Preparation and Proposal Development. Reviews and assists in the preparation of grant applications, contract proposals, and other related documents to ensure adherence to departmental, School, and University policies and standard operating procedures (SOPs), funding agency specifications, and other relevant rules and regulations. Assists in data collection, writing, collating, and editing and proofing. Coordinates the proposal budget preparation, review of proposal against requirements, and submission to sponsoring agencies, often within tight timeframes. Collaborates closely with the Manager of Grant Accounting, the Grants and Contracts Managers in the Dean's Office, and with SPA/SPF as required.

Post-Award Support: 60%

Grant Account Management. Develops and monitors a dashboard of grant portfolios for departmental PIs. Coordinates with the departmental finance staff to initiate all expenditures and reimbursements; monitors project expenses for compliance, identifying and forecasting trends in spending that exceed current funding levels, recommending budget modifications and strategies to effectively manage spending patterns and mitigate business risk, reviewing and closing all open commitments, and clearing all overdraft. Performs monthly, annual, and other periodic reconciliations of grant accounts for PI review and approval. Conducts other periodic and ad hoc analyses and provides reporting to the department and School.

Subcontracts. Work with PIs, Administrators and other Columbia offices to prepare and process subcontracts. Responsible for receipt of subcontract award documents, closeout documents, invoicing and final account closeout.

Agency Reporting. Collaborates with PIs and SPA on all mid-award reports, including developing projected budget for coming year, initiating reports, ensure compliance requirements have been met, and reviewing all finalized report documents. Assist in the preparation of reports regarding the School's grant funded activity.

Closeout. Provides post-award closeout support including cost-share and other administrative matters.

Internal Collaboration & Records Management. Liaises with central offices, collaborates with outside departments, works closely with the Manager of Grant Accounting to ensure all financial activities on projects are within University and agency guidelines. Maintains all pertinent records, files and documents.

Negotiation and Award Review Support. Provides guidance and administrative support for PIs in the review and negotiation of awards, including scope of work, reporting requirements and special terms and conditions. Serves as point of contact on grant matters, subcontracts and other agreements for the development of assigned award applications.

Monitors Proposal Status. Provides active monitoring of the status of proposals under review by various funding agencies. Coordinates with the Manager of Grant Accounting, Dean's Office, and SPA to establish new accounts and revise existing accounts in a timely manner. 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.

Other Pre-Award Support. Assists PIs in all other aspects of pre-award grants management to ensure timeliness, accuracy, and compliance.

Performs other tasks, duties, and responsibilities as assigned. 10%

Additional Essential Functions (Limit to 3950 characters.)

Special Indications

This position works with:

There are no special indications for this position

HIPAA Compliance training required

No Response

Participation in Medical Surveillance required

No Response

What type of posting? Is this a waiver request?

Standard Posting

Requisition Open Date

09-10-2017

Requisition Close Date

Open Until Filled

Quick Link

jobs.columbia.edu/applicants/Central?quickFind=164634

EEO Statement

Columbia University is an Equal Opportunity/Affirmative Action employer --Race/Gender/Disability/Veteran.

Local Hiring

Columbia University is committed to the hiring of qualified local residents.