Grants Coordinator

Urgent Requirement:

Job Title : Grants Coordinator

Location : Indianapolis IN (OSNITE)

Duration :12 Months with possibility to extension

The incumbent is responsible for financial management activities of the program to ensure compliance with State and Federal regulations regarding subawards.

Purpose of Position/Summary:

The Subaward Grants Coordinator is responsible for assisting the Subaward Grant Manager with IDOH subaward identification audits risk management and federal reporting. The Subaward Grants Coordinator will work with the programs to review IDOH budgets in order to identify existing and future subawards. This position will assist in performing subaward audits. They will assist in creating a risk management policy to be used when choosing subawards. The position will collect compile and upload any subaward financial reporting i.e. notification of subawards change of subawards equipment management etc. The platforms for these submissions are but are not limited to Grants.gov GrantSolutions RedCap TVIS Electronic Handbook (EHB) CAMP PERFORMS and eCivis

The Grant Coordinator assists in the critical oversight and risk management review of financial and grant activity. They will be working with teams including accountants and deputy controllers.

The Grant Coordinator provides assistance to the Program directors who is their business partner to ensure success in managing grants goals timelines providing expertise in review of financial activities and purpose. The Grant Coordinator will assist in ensuring reconciled reports presenting information for decision making and understanding by the customer and as directed by the federal grant requirements.

The Grant Coordinator may have additional federal requirements of reporting subaward audits county support or state review of federal grant funds initiated by OMB/SBA and MOU to IDOH as well as State agency MOU of grant participation and accountabilities.

Essential Duties/Responsibilities:

State Responsibilities:

Act as knowledgeable resource for finance and administration to Division Directors.

Utilize PeopleSoft Financials to monitor and report subaward spending throughout the fiscal year

Coordinate with Procurement staff for necessary spending of funds

Maintain and make accessible financial files.

The Grant Coordinator works with the Grant Manager for analysis risk management and decision making on behalf of the Program and on behalf of the state to ensure proper fund use and reporting. They are implementing Federal Grant regulations and requirements.

The volume and complexity of the work being reviewed requires the knowledge and communication by the Grant Coordinator to ensure adherance to each grant and ensure the ability to provide service to the state and the health of every Hoosier.

Perform related tasks as needed.

Federal Grant Functions:

Assist in preparing required financial and grant reports to Federal funder.

Assist the Grant Manager in oversight of financial aspects related to Federal grants subawards and required reporting.

Assist in preparation of subaward related closeout reports at the end of each fiscal year.

Assist in coordination and submission of progress reports for operational or budget adjustments as required by funder.

Gather and compile all requested information for performance measures and programmatic reporting.

Financial Management:

Maintain and monitor PeopleSoft Financials queries to prevent overspending.

Assist in monitoring inventory for subaward equipment purchased with Federal funds.

Assist in the coordination and performance of subaward financial management reviews/audits to ensure accuracy of accounts.

Assist in providing financial consultation and grant technical assistance to subawards.

Monitor and analyze financial and grant reports from subawards.

Assist in conducting subaward reviews to ensure compliance with policies and make recommendations for improvement.

Maintain contract budget grant and financial files.

Utilize PeopleSoft Financials for review and approval of vendor claims processing of payments and oversight of other expense transactions.

Job Requirements:

Knowledge of the purpose philosophy and operation of the Divisions

Knowledge of Federal and State laws policies and procedures as they pertain to the Finance Grants and Programmatic Divisions

Knowledge of business administration practices and procedures and basic accounting:

GASBGovernment Accounting Standards Board

GAASGenerally Accepted Auding Standards

GAAPGenerally Accepted Accounting Principals

Risk Management

Some ability to extend standard procedures and methods and develop new procedures and methods to deal with unprecedented situations.

Thorough ability to work cooperatively with staff and representatives of state local and federal agencies

Extensive ability to read data processing printouts analyze data and prepare reports

Advanced knowledge of appropriate PeopleSoft Financials modules

Advanced knowledge of Microsoft Excel Outlook Word and other Microsoft products

Ability to learn and navigate reporting system such as but not limited to RedCap and GrantSolutions

Ability to develop new or modify existing policies and procedures

Considerable ability to apply problem solving techniques to address issues at the State and local level

Considerable ability to communicate verbally and in writing with individuals or in group situations

Extensive communication skills both verbal and written

Must have knowledge of the:

State of Indiana statute on funding revenues laws by legislation

General ledger oversight Standard Accounting rules maintained by the AOS

State Budget Agency Circulars and application of those circulars.

Ability to coordinate and evaluate staff activities and recommend actions to improve productivity and efficiency.

Ability to establish the program goals and set priorities among competing demands

Must be able to work under pressure prioritize tasks and meet timesensitive deadlines

Supervisory Responsibilities/Direct Reports:

The incumbent will not supervise.

Difficulty of Work:

The incumbent receives general direction from the director and performs work in accordance with generally accepted management and business administration practices. The incumbent uses considerable judgment in developing tools procedures and policies for coordinating and conducting financial and grant management activities required to maintain compliance with Federal and State regulations.The incumbent will be expected to perform reporting and reconciliation procedures for risk management program support and federal grant requirements.

Responsibility:

The incumbent is responsible for financial management activities of the program to ensure compliance with State and Federal regulations regarding subawards.

Personal Work Relationships:

The incumbent works with Federal and State representatives as well as program division staff and contract representatives for the purpose of answering questions providing information and resolving problems.

Physical Effort:

This position requires work at a desk computer for the majority of the day.

Working Conditions:

Work is performed in a standard office environment. Some travel is required.

Prior exp. w/ grant oversight to include analysis risk management and decision making and required reporting on behalf of a government program.

Required

3

Years

Prior wrking exp. w/People Soft Financials.

Required

2

Years

Prior exp. preparing financial and grant reports to Federal Funder.

Required

2

Years

Prior exp. gathering and compiling all required information for performance measures & programmatic reporting.

Required

2

Years

Extensive ability to read data processing printouts analyze data and prepare reports.

Required

Advanced knowledge of Microsoft Excel Outlook Word and other Microsoft products

Required

Ability to learn and navigate reporting system such as but not limited to RedCap and GrantSolutions

Required

Knowledge of the State of Indiana statute on funding revenues laws by legislation general ledger oversight & standard accounting rules.

Required

2

Years

Knowledge of laws regulations and standards of federal grants.

Required

2

Years

Associates Degree in fiscal or business management.

Highly desired

Prior auditing experience

Highly desired

2

E Mail: