Grant Database Analyst

NYC Department of Social Services; New York (NY); On-site; USD 60,000 - 80,000; Full time

Job summary

The NYC Department of Transportation is seeking a Technical Grant Database Analyst to manage grant reimbursement processes. The role involves reviewing documentation, managing expenses, and ensuring compliance with funding regulations. Candidates should have relevant educational backgrounds and strong analytical skills. This position offers opportunities for professional growth and participation in federal loan forgiveness programs.

Benefits

Federal loan forgiveness

State repayment programs

Qualifications

• Master's degree with 1 year experience or Bachelor's with 3 years.
• Experience in grant funding and IT in public sector preferred.

Responsibilities

• Review invoice documentation for accuracy and completeness.
• Manage grant-funded expenses and ensure compliance.
• Design and enhance grant databases using MS Access.

Skills

Organizational Skills

Communication Skills

Analytical Skills

Detail-oriented

Team Player

Education

Master's degree

Baccalaureate degree

Associate degree

High school diploma

Tools

MS Office

MS Access

FMS

Job description

The New York City Department of Transportation (NYCDOT) ensures the safe, efficient, and environmentally responsible movement of pedestrians, goods, and vehicles across the city's transportation network, including streets, highways, bridges, and waterways. The department maintains and rehabilitates infrastructure such as bridges, tunnels, streets, sidewalks, and highways.

Division Overview

The NYC DOT Grants & Fiscal Management division maximizes grant funding opportunities to support the agency's strategic goals by monitoring legislative actions, seeking new funding sources, administering programs, and ensuring compliance with federal and state grant requirements.

Position Summary

We are seeking a Technical Grant Database Analyst to join the Grants Reimbursement, Compliance & CGMS team (GRC). GRC oversees the timely processing and submission of NYCDOT’s reimbursement claims to the New York State Department of Transportation (NYSDOT) for eligible expenses. The team collaborates with various city and external agencies to oversee audits, manage grant records, and perform reconciliation exercises to mitigate grant risks.

Key Responsibilities

1. Review invoice documentation for accuracy and completeness.
2. Examine vouchers and timekeeping records to prepare reports and cost analyses for reimbursements.
3. Manage grant-funded Personnel Services (PS) and Other Than Personnel Services (OTPS) expenses.
4. Become proficient in the City’s Financial Management System (FMS) and Human Resource Management System (CHRMS), including MS Office tools.
5. Design and enhance grant databases using MS Access and related applications.
6. Generate reports from FMS, FMIS, and other applications.
7. Coordinate with project managers across divisions to ensure compliance with funding regulations.
8. Ensure consistency in expenditure timing and revenue posting with DOT/Fiscal Affairs and Budget units.
9. Interact with auditors, respond to inquiries, and prepare necessary reports.
10. Perform additional tasks as assigned.

Application Process

Submit your resume electronically via cityjobs.nyc.gov, Job ID# 711233. Current employees should use the Employees Self Service portal. For more details, visit www.nyc.gov/dot. Only shortlisted candidates will be contacted; no phone inquiries are accepted. Appointments are subject to Mayor’s Office approval.

Minimum Qualifications

Candidates must meet one of the following:

1. Master's degree in relevant fields and at least one year of professional experience, or
2. Baccalaureate degree with three years of experience, or
3. Associate degree or 60 college credits with five years of experience, or
4. High school diploma with seven years of experience, or
5. An equivalent combination of education and experience.

Preferred Skills

• Experience with grant funding and IT in the public sector.
• Proficiency with FMS, MS Office, and database design.
• Strong organizational, communication, and analytical skills.
• Ability to work under pressure, multi-task, and meet deadlines.
• Detail-oriented, self-motivated, and a team player.

Additional Benefits

Eligible employees may participate in federal loan forgiveness and state repayment programs. Residency within NYC or certain surrounding counties is generally required within 90 days of appointment.

Equal Opportunity Statement

The City of New York is committed to diversity and inclusion, providing a work environment free from discrimination and harassment based on legally protected characteristics.