Grant Database Analyst

Job Description

The New York City Department of Transportation’s (NYCDOT) provides safe, efficient, and environmentally responsible movement of pedestrians, goods, and vehicular traffic on the streets, highways, bridges, and waterways of the City's transportation network. NYCDOT rehabilitates and maintains the City's infrastructure, including bridges, tunnels, streets, sidewalks, and highways.
The NYC DOT Grants & Fiscal Management division maximizes grant funding opportunities to achieve the agency's strategic goals and objectives by monitoring federal and state legislative actions, seeking new funding opportunities, administering the program, obtaining reimbursement and ensuring compliance of the Department's federal and state grant programs.

The New York City Department of Transportation/Grants & Fiscal Management division is seeking a Technical Grant Database Analyst to join its Grants Reimbursement, Compliance & CGMS team (GRC). GRC’s mission is to oversee the timely planning, preparation, processing and submission of NYCDOT’s claim reimbursement requests to the New York State Department of Transportation (NYSDOT) for expenses that are eligible for state and federal funding. The unit also operates in conjunction with the NYC Office of Management and Budget (OMB), external audit entities, and internal audit units, including other support divisions/programs within the agency to oversee federal, state and city entities, and internal audit units, including other support divisions/programs within the agency to oversee federal, state and city audits, including the federal/state Single Audits that involve grants. Conducts monthly reconciliation exercises to remedy potential grants de-obligation risks and establishes the department's non-city grant records in the NYC/Citywide Capital Grants Management System (CGMS) managed by OMB/Comptroller’s. Under supervision, the major duties of the position include, but are not limited to, the following:

- Review invoice documentation for accuracy and completeness
- Examine vouchers and timekeeping records to prepare/confirm reports and prepare cost analyses, and documentation to submit federal and state reimbursements.
- Manage and monitor grant-funded Personnel Services (PS) and Other Than Personnel Services (OTPS) expenses related to the reimbursement claims incurred in the DOTs expense budget.
- Become proficient in the use of the City’s Financial Management System (FMS) and the City Human Resource Management System (CHRMS), including MS suite such as Excel, Word, Access and PowerPoint.
- Design database using MS suite such as Access and provide technical expertise on matters related to the upgrade/enhancements of existing/new grants databases/applications.
-Run reports related to FMS, FMIS and other citywide, state or federal applications.
- Liaison with the project managers in various divisions throughout DOT and other City Agencies to ensure compliance with city, state and federal rules and regulations associated with the different grants funding sources to avoid ineligible expenditures.
- Safeguard coordination with DOT/Fiscal Affairs and Budget units to ensure consistency with timing of expenditures incurred and revenue collections posted in FMS.
- Interact with internal and external auditors answering their questions, explaining questionable discrepancies and preparing reports.
- Perform related tasks as assigned by the Unit.

TO APPLY:
All resumes to be submitted electronically using one of the following methods: Please go to cityjobs.nyc.gov and find Job ID# 711233. Current employees please log on into Employees Self Service and follow the Careers Link. Most Public libraries have computers available for use. No phone calls, faxes or personnel inquiries permitted. Only applicants under consideration will be contacted. Appointments are subject to Mayor's Office of Management and Budget approval. For more information visit www.nyc.gov/dot.

***IN ORDER TO BE CONSIDERED FOR THIS POSITION CANDIDATE MUST BE SERVING PERMANENTLY IN THE TITLE OF ASSOCIATE STAFF ANALYST, OR REACHABLE ON THE OPEN- COMPETITIVE LIST, OR ELIGIBLE UNDER THE 55A PROGRAM ****

ASSOCIATE STAFF ANALYST - 12627

Qualifications

1. A master's degree from an accredited college in economics, finance, accounting, business or public administration, public health, human resources management, management science, operations research, organizational behavior, industrial psychology, statistics, personnel administration, labor relations, psychology, sociology, human resources development, political science, urban studies or a Juris Doctor degree from an accredited law school, and one year of satisfactory full-time professional experience in one or a combination of the following: working with the budget of a large public or private concern in budget administration, accounting,