Senior Coordinator, Financial and Data Reporting

Position Title:

Job Description:

POSITION SUMMARY
This position is responsible for maintaining the Climate & Equitable Jobs Act (CEJA) budget, data tracking and data reporting for the CEJA Joliet hub. Plan and coordinate programs so the performance goals and objectives and Department of Commerce and Economic Opportunities' (DCEO) requirements of state laws and regulations are met. Assesses effectiveness of grant program and provide recommendations for program improvement. Prepare various reports to provide narrative and statistical data. Write grant proposals and prepare progress and financial reports for workforce grant programs. Work with Workforce Development staff to process sponsorships and expenses related to grants.

ESSENTIAL JOB DUTIES AND KEY RESPONSIBILITIES
1. Maintain the grant records of workforce programs including: creating and recording spend authorizations, expense reports and journal entries; review of computer-generated reports, account/department analysis and/or reconciliations.
2. Build and manage grant budgets. Monitor and maintain ongoing account of grant revenues and expenditures, including fund requests, for adequate documentation and compliance with workforce grant agreement/regulations. Make budget decisions and recommendations based upon analysis and evaluation of statistics. Recommend resource allocation and capital expenditures related to program development.
3. Oversee and implement program and participant data tracking and utilize DCEO reporting systems to enter and report data on a timely basis as required by grant. Data includes participant information, programmatic and service data, and outcome metrics.
4. Develop and implement assessment tools to track program activities, outcomes, and effectiveness. Utilize data collected to recommend changes to improve quality of the program.
5. Assist in managing the operational, budget, and personnel functions of CEJA programs and assume leadership responsibilities in the absence of the Manager, Clean Jobs Initiatives.
6. Oversee outreach and recruitment process including leading staff to enroll new students to the CEJA program, assess grant eligibility factors, organize completion of assessments, collection of personal/confidential documents, completion of intake paperwork and ensure and maintain confidentiality of records.
7. Formulate, interpret and implement accounting procedures/controls for continuous process improvement and to insure workforce grant program financials are operating in accordance with accounting, board policies and meeting grant requirements. Serve as the primary point of contact with funding agencies for grant programs.
8. Analyze workforce program performance measures and financial data, which includes developing forecasts, plans, processes, reports, statements, recommendations and ensuring accuracy of the financial data.
9. Prepare and submit periodic financial reports on a monthly basis in the format required by DCEO. Assist the Manager of Clean Jobs Initiatives to prepare periodic performance reports.
10. Write grant proposals and analyze, evaluate and report statistical data and student outcomes. Participate in grant-writing and grant-proposal development with outside organizations to facilitate project development, grant application and proposal submission by creating budget proposals and review of narrative of programmatic pieces of the CEJA grant programs.
11. Assist with program monitors and with external auditor including during annual and year-end closing audits. Provide requested schedules, pull requested documentation, provide timely correspondence, and draft management responses to any audit findings.
12. Maintain CEJA grant program's capital asset records and auxiliary, budget and general accounting issues as necessary.
13. Develop policies, guidelines, and systems to ensure an effective operation of the grants process.
14. Lead regular audits of participant data, tracking, incentive, and supportive services to ensure accurate records for grant reporting and maintaining grant compliance.
15. Prepare any necessary regulatory/grant reporting and assist in preparation of CEJA grant reports as per the grant agreements.
16. Maintain an accounting of Title IV, Student Financial Aid in conjunction with the Financial Aid Department.
17. Uphold core values of diversity, inclusion, accessibility and equity to increase access, enrollment and completion for program eligible persons.
18. Use analytical skills to resolve questions or problems that may arise.
19. Perform other related duties as assigned.

MINIMUM QUALIFICATIONS
1. Bachelor degree in business, finance or related field.
2. Three (3) years of professional work experience.
3. Strong organizational and project management skills.
4. Proficient with Microsoft Office Suite.
5. Ability to effectively work under minimal supervision.
6. Effective verbal, written and interpersonal skills.
7. Ability to establish and maintain cooperative and effective working relationships with other members of the college and community, displaying cultural competence as well as emotional intelligence.
8. Demonstrated commitment to the college's core values of respect and inclusion, sustainability, integrity, collaboration, humor and well-being, innovation and quality.

PREFERRED QUALIFICATIONS
1. Two (2) years of recent experience in education and/or grant bookkeeping and reporting.
2. Prior experience in Workday and Smartsheet software.
3. Prior experience working in an educational environment.
4. English and Spanish verbal and written communication proficiency.
5. Demonstrated multicultural competence.

PHYSICAL DEMANDS
1. Normal office physical demands.
2. Ability to travel between campus locations and to and from community events.

WORKING CONDITIONS
1. Duties are performed indoors in the usual office environment.

Full Time/Part Time:

Union (If Applicable):

Scheduled Hours: