Lead Data Analyst (PSA, Option 3)

 Agency :  Department on Aging 
Closing Date/Time: 07/05/2024 
Salary:   Anticipated Starting Salary (Effective 7/1/24) $7,712 monthly; Full Range $7,712 - $11,759 monthly  
Job Type:   Salaried 
County:   Sangamon  
Number of Vacancies:   1  
Plan/BU:   RC063 

This position is a union position; therefore, provisions of the relevant collective bargaining agreement/labor contract apply to the filling of this position.

All applicants who want to be considered for this position MUST apply electronically through the illinois.jobs2web.com website. State of Illinois employees should click the link near the top left to apply through the SuccessFactors employee career portal.

Applications submitted via email or any paper manner (mail, fax, hand delivery) will not be considered.

Posting Identification Number  38266 

Essential Functions

1. Conducts complex data analysis or research on existing or proposed Agency programs. Reports findings to the Division Manager and develops recommendations to establish/revise policies, procedures, and practices that improve the quality of programs and services. Within the Division, directs activities of subordinate staff who’s primary job function supports operational analytics/data analysis. 
2. Informs and drives program development, ad-hoc and annual reporting and modifications through data analysis. Confers with the Division Manager if data supports directives/policies have not been followed. Provides consultation to the Division Manager on matters pertaining to Operational Analytics, development of program/data analysis plans and effective methods aimed to support data-driven decision making. 
3. Directs the development of the annual budget projections and monitors program expenditures for the Bureau of Operational Analytics.  Oversees and reports on historical program spending, client enrollment, and performance trends. Formulates, drafts, and determines financial costs and resources for current and future fiscal years. 
4. Confers with Division Manager and other staff in the development, dissemination, and analysis of program data, policies, procedures, rules and regulations, guidelines, standards, and technical assistance material. Recommends alternatives to administrative, policy, and procedures in response to findings/outcomes stemming from data analytics.
5. Develops management reports for the Department’s Leadership and Executive Teams related to Care Coordination Unit’s (CCU) performance and Departmental with the federal Medicaid Elderly Waiver Program. Determines standards of measurement, that when analyzed, drive intended program outcomes and the provision of quality Home and Community-Based services. Leads and supports all reporting efforts as it relates to the Persons Who are Elderly Waiver, Community Care Program, as required by Healthcare and Family Services (HFS) and federal Centers for Medicare and Medicaid Services (CMS).
6. Assists Division Manager with coordinating the CCP annual budget with the Office of Budget and Service Procurement. Performs complex analysis of the Community Care Program (CCP) expenditures to formulate projections of spending and budget requests and develops modules to track budgetary operations. Conducts cost benefit analysis of proposed changes to CCP and other home and community based alternative services offered through the Department, including estimating, and monitoring all related potential federal Medicaid receipts.
7. Serves as working supervisor.  Assigns and reviews work. Provides guidance and training to assigned staff. Counsels staff regarding work performance.  Reassigns staff to meet day-to-day operating needs. Establishes annual goals and objectives. Approves time off. Prepares and signs performance evaluations.
8. Performs other duties as required which are reasonably within the scope of the duties enumerated above.

Preferred Qualifications

1. Prefers three years or more of experience demonstrating advanced knowledge of Microsoft Excel by conducting Power BI queries, SQL queries, and advanced functions and formulas.
2. Prefers three years or more of experience providing statistical analysis of program data.
3. Prefers three years or more of experience providing input into and executing a budget.
4. Prefers three years or more of experience developing, preparing, and delivering programmatic reports to internal and external stakeholders.
5. Prefers at least two years of experience ensuring programmatic compliance with federal and state rules, laws, and or regulations.
6. Prefers at least two years or more experience supervising staff.

Minimum Qualifications

1. Requires three (3) years of progressively responsible administrative work experience managing a comprehensive program in health and human services environment.
2. Requires a Bachelor of Science in Data Science.

Conditions of Employment

1. Requires ability to pass a criminal background check.
2. Requires monthly travel in state and minimal travel out of state.

Work Hours:  8:30am - 5:00pm Monday-Friday  
Work Location: One Natural Resources Way, Springfield, IL 62702-1813  
Agency Contact: 

Nick Gilmore

Email: aging.hr.assist@illinois.gov

Phone #:217-900-0013

Posting Group:  Science, Technology, Engineering & Mathematics  

This position DOES NOT contain “Specialized Skills” (as that term is used in CBAs).

APPLICATION INSTRUCTIONS

Use the “Apply” button at the top right or bottom right of this posting to begin the application process.

If you are not already signed in, you will be prompted to do so. 

State employees should sign in to the career portal for State of Illinois employees – a link is available at the top left of the Illinois.jobs2web.com homepage in the blue ribbon. 

Non-State employees should log in on the using the “View Profile” link in the top right of the Illinois.jobs2web.com homepage in the blue ribbon.  If you have never before signed in, you will be prompted to create an account.

If you have questions about how to apply, please see the following resources:

State employees: Log in to the career portal for State employees and review the Internal Candidate Application Job Aid

Non-State employees: on Illinois.jobs2web.com – click “Application Procedures” in the footer of every page of the website.

The main form of communication will be through email. Please check your “junk mail”, “spam”, or “other” folder for communication(s) regarding any submitted application(s). You may receive emails from the following addresses:

• donotreply@SIL-P1.ns2cloud.com
• systems@SIL-P1.ns2cloud.com