Sub-Award Grants Coordinator - American Technology Consulting

Purpose of Position/Summary:The Sub-award Grants Coordinator is responsible for assisting the Sub-awardGrant Manager with IDOH sub-award identification, audits, risk management, andfederal reporting. The Sub-award Grants Coordinator will work with the programsto review IDOH budgets in order to identify existing and future subawards. Thisposition will assist in performing sub-award audits. They will assist increating a risk management policy to be used when choosing sub-awards. Theposition will collect, compile and upload any sub-award financial reporting i.e.notification of sub-awards, change of sub-awards, equipment management, etc. Theplatforms for these submissions are, but are not limited to, Grants.gov,GrantSolutions, RedCap, TVIS, Electronic Handbook (EHB), CAMP, PERFORMS, andeCivisThe Grant Coordinator assists in the critical oversight, and risk managementreview 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 theirbusiness partner, to ensure success in managing grants, goals, timelines,providing expertise in review of financial activities and purpose. The GrantCoordinator will assist in ensuring reconciled reports, presenting informationfor decision making, and understanding by the customer and as directed by thefederal grant requirements.The Grant Coordinator may have additional federal requirements of reporting,sub-award audits, county support, or state review of federal grant fundsinitiated by OMB/SBA and MOU to IDOH, as well as State agency MOU of grantparticipation and accountabilities.Essential Duties/Responsibilities:State Responsibilities:• Act as knowledgeable resource for finance and administration to DivisionDirectors.• Utilize PeopleSoft Financials to monitor and report sub-award spendingthroughout 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, riskmanagement and decision making on behalf of the Program, and on behalf of thestate to ensure proper fund use and reporting. They are implementing FederalGrant regulations and requirements.•The volume and complexity of the work being reviewed requires the knowledge andcommunication by the Grant Coordinator to ensure adherance to each grant, andensure the ability to provide service to the state, and the health of everyHoosier.• 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 Federalgrants sub-awards and required reporting.• Assist in preparation of sub-award related closeout reports at the end of eachfiscal year.• Assist in coordination and submission of progress reports for operational orbudget adjustments as required by funder.• Gather and compile all requested information for performance measures andprogrammatic reporting.Financial Management:• Maintain and monitor PeopleSoft Financials queries to prevent overspending.• Assist in monitoring inventory for sub-award equipment purchased with Federalfunds.• Assist in the coordination and performance of sub-award financial managementreviews/audits to ensure accuracy of accounts.• Assist in providing financial consultation and grant technical assistance tosub-awards.• Monitor and analyze financial and grant reports from sub-awards.• Assist in conducting sub-award reviews to ensure compliance with policies andmake 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 pertainto the Finance, Grants and Programmatic Divisions• Knowledge of business administration practices and procedures and basicaccounting:• GASB-Government Accounting Standards Board• GAAS-Generally Accepted Auding Standards• GAAP-Generally Accepted Accounting Principals• Risk Management• Some ability to extend standard procedures and methods and develop newprocedures and methods to deal with unprecedented situations.• Thorough ability to work cooperatively with staff and representatives ofstate, local and federal agencies• Extensive ability to read data processing printouts, analyze data and preparereports• Advanced knowledge of appropriate PeopleSoft Financials modules• Advanced knowledge of Microsoft Excel, Outlook, Word and other Microsoftproducts• Ability to learn and navigate reporting system such as, but not limited toRedCap and GrantSolutions• Ability to develop new or modify existing policies and procedures• Considerable ability to apply problem solving techniques to address issues atthe State and local level• Considerable ability to communicate verbally and in writing with individualsor 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 toimprove productivity and efficiency.• Ability to establish the program goals and set priorities among competingdemands• Must be able to work under pressure, prioritize tasks, and meet time-sensitivedeadlines???Supervisory Responsibilities/Direct Reports:The incumbent will not supervise.Difficulty of Work:The incumbent receives general direction from the director and performs work inaccordance with generally accepted management and business administrationpractices. The incumbent uses considerable judgment in developing tools,procedures and policies for coordinating and conducting financial and grantmanagement activities required to maintain compliance with Federal and Stateregulations.?The incumbent will be expected to perform reporting andreconciliation procedures for risk management, program support, and federalgrant requirements.????Responsibility:The incumbent is responsible for financial management activities of the programto ensure compliance with State and Federal regulations regarding sub-awards.Personal Work Relationships:The incumbent works with Federal and State representatives as well as programdivision staff and contract representatives for the purpose of answeringquestions, 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.