Grant Management Specialist (Executive I)

DGS Office of External Affairs; Illinois; On-site; USD 65,000 - 90,000; Full time

Job summary

The Grant Management Specialist (Executive I) at the Illinois Department on Aging, within the DGS Office of External Affairs, handles complex grant activities for Area Agencies on Aging, analyzes cash requests, and prepares performance reports for federal and state programs.

Candidates should have strong attention to detail, proficiency with grant management software, and expertise in governmental accounting and budgeting. Illinois-based government role.

Qualifications

• One year of grant management experience.
• One year of advanced MS Excel functions (VLOOKUP, HLOOKUP, INDEX + MATCH, pivot tables, power queries, macros, or VBA).
• Four years of college coursework, preferably in business or public administration, plus one year of responsible administrative experience.
• Preferred: one year managing multiple grants simultaneously with error rate less than 1%.
• Preferred: knowledge of governmental accounting, program budgeting, personnel administration, statistics, and procurement.
• Preferred: experience with Amplifund or equivalent grant management software.

Responsibilities

• Analyze cash requests and compile financial data for grant programs.
• Track programmatic outcomes and prepare performance reports for federal and state funds.

Skills

Grant management experience

Advanced MS Excel functions

Multi-grant management

Governmental accounting

Program budgeting

Procurement

Statistics

Amplifund or grant software

Education

Four years of college coursework (business/public administration)

Tools

Amplifund

Job description

The Grant Management Specialist (Executive I) supports the Illinois Department on Aging by managing complex grant activities for Area Agencies on Aging. The role involves analyzing cash requests, compiling financial data, tracking programmatic outcomes, and preparing performance reports for federal and state funded programs. This position requires strong attention to detail, proficiency with grant management software, and expertise in governmental accounting and budgeting.

Key qualifications

• One year of grant management experience
• One year of advanced MS Excel functions (VLOOKUP, HLOOKUP, INDEX + MATCH, pivot tables, power queries, macros, or VBA)
• Four years of college coursework, preferably in business or public administration, plus one year of responsible administrative experience
• Preferred: one year managing multiple grants simultaneously with error rate less than 1%
• Preferred: knowledge of governmental accounting, program budgeting, personnel administration, statistics, and procurement
• Preferred: experience with Amplifund or equivalent grant management software