Data Analysis & Support Specialist (Executive II)
Springfield, IL, US, 62704
Job Requisition ID: 52434
Closing Date: 01/14/2026
Agency: Department of Healthcare and Family Services
BPIS: 09140
Class Title: EXECUTIVE II - 13852
Skill Option: None
Bilingual Option: None
Salary: Anticipated starting salary $6589/monthly; Full salary range $6589 - $9541/monthly
Job Type: Salaried
Category: Full Time
County: Sangamon
Number of Vacancies: 1
Bargaining Unit Code: RC062 Technical Employees, AFSCME
Merit Comp Code:
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.
Why Work for Illinois?
Working with the State of Illinois is a testament to the values of compassion, equity, and dedication that define our state. Whether you’re helping to improve schools, protect our natural resources, or support families in need, you’re part of something bigger—something that touches the lives of every person who calls Illinois home.
No matter what state career you’re looking for, we offer jobs that fit your life and your schedule—flexible jobs that provide the gold standard of benefits. Our employees can take advantage of various avenues to advance their careers and realize their dreams. Our top-tier benefits and great retirement packages can help you build a rewarding career and lasting future with the State of Illinois.
Position overview:
The Department of Healthcare and Family Services, Bureau of Professional and Ancillary Services is seeking to hire a highly skilled and analytical individual to join our team. This position plays a critical role in driving data-informed decision making by analyzing complex datasets, developing and maintain advanced spreadsheets with complex formulas, and preparing accurate budget estimates.
The ideal candidate will bring strong SQL experience and the ability to interpret and apply federal laws and regulations while contributing to the formulation, development, and implementation of agency policies, including those impacting pharmacy services. This role requires exceptional organizational skills, critical thinking, and the ability to approach challenges with innovative, solutions-oriented thinking. Collaboration is essential, as this position works closely with Bureau and Agency teams to deliver complex data analyses and ensure policies and practices align with organizational goals.
HFS values employees with different backgrounds, life experiences, and talents.
Employees receive a robust benefit package including:
- Monday-Friday work schedule
- Flexible work schedules are available in many program areas. (Remote work may be an option for certain positions.)
- Health, Life, Vision, and Dental Insurance
- Pension Plan
- Paid Parental Leave
- Deferred Compensation Program and other pre-tax benefit programs (Medical/Daycare)
- Employees earn (12) paid Sick Days annually.
- New Employees earn (10) paid Vacation Days their first year of service and can earn up to (25) paid Vacation Days annually.
- Employees earn (3) paid Personal Days annually.
- (13-14) paid holidays annually (based on start date)
If you are seeking a new opportunity, and this position appeals to you, please apply today!
At the Illinois Department of Healthcare and Family Services (HFS), we value staff as our greatest asset. We work in a spirit of teamwork to help millions of Illinoisans access high quality healthcare and fulfill child support obligations to advance their physical, mental, and financial well-being. We provide healthcare coverage for children and adults through Medicaid and other medical programs, and we help ensure that children receive financial resources from both their parents through Child Support Services. The HFS Office of the Inspector General investigates, audits and reviews program activity to ensure the integrity of our programs is maintained.
HFS is committed to promoting and preserving a workplace culture that embraces diversity, equity, and inclusion. We welcome and value employees with different backgrounds, life experiences, and talents. It is the collective sum of our individual differences that provides a broad perspective, leading to greater innovation and achievement. In recruiting for our team, we recognize the unique contributions of each applicant regardless of culture, ethnicity, race, national origin, sex, gender identity and expression, age, religion, disability, and sexual orientation. HFS is an equal opportunity employer.
Essential Functions
- Under general direction, serves as a Data Analyst and Support Specialist who organizes, plans, and evaluates the statewide Budgetary Analysis Program as it relates to the Illinois Medicaid program
- Analyzes Illinois Medicaid Program utilization data maintained in various data management systems to determine budgetary implications for planned program changes, including those resulting from changes to state and federal rules and regulations
- Analyzes and interprets state and federal laws, rules, and regulations and coordinates the formulation, development, and implementation of policies to ensure compliance with such
- Coordinates the development and implementation of Pharmacy and/or Medical Services policies in accordance with state and federal rules and regulations
- Performs other duties as required or assigned, which are reasonably within the scope of the duties enumerated above
Minimum Qualifications
- Requires knowledge, skill, and mental development equivalent to completion of four (4) years of college, preferably with coursework in business or public administration
- Requires two (2) years of responsible administrative experience in a public or business organization
Specialized Skills
- A minimum of one (1) year of experience performing complex analyses of state and federal laws, regulations and legislative proposals and summarizing the results for the purpose of formulating policies that are compliant with such
- A minimum of one (1) year of experience utilizing Microsoft Excel to create and maintain spreadsheets, including writing complex formulas used to develop estimates of the budgetary impact of program changes
- A minimum of one (1) year of experience independently writing queries in Structured Query Language (SQL), used to access data in Database Management Systems
Preferred Qualifications
- A minimum of one (1) year of experience performing complex analyses of state and federal laws, regulations and legislative proposals and summarizing the results for the purpose of formulating policies that are compliant with such
- A minimum of one (1) year of experience utilizing Microsoft Excel to create and maintain spreadsheets, including writing complex formulas used to develop estimates of the budgetary impact of program changes
- A minimum of one (1) year of experience independently writing queries in Structured Query Language (SQL), used to access data in Database Management Systems
- A minimum of one (1) year of experience evaluating the structure and functions of state government and intergovernmental relationships to support policy analysis, program development, and compliance with legislative and regulatory requirements
- A minimum of one (1) year of experience with governmental accounting, budget analysis, and statistical methods as they relate to program planning and evaluation
- A minimum of one (1) year of experience developing and managing a supportive budgetary analysis program for a public or private organization
- A minimum of one (1) year of experience exercising judgement and discretion in developing, implementing, and interpreting policies and procedures for a public or private organization
- A minimum of one (1) year of experience fostering collaborative working relationships in a professional environment
Conditions of Employment
- Requires completion of a background check and self-disclosure of criminal history
- Requires the ability to utilize and maintain state issued equipment such as a laptop
- The conditions of employment listed here are incorporated and related to any of the job duties as listed in the job description
Work Hours: Monday - Friday 8:30 a.m. - 5:00 p.m.
Headquarter Location: 201 S Grand Ave E, Springfield, Illinois, 62704
Work County: Sangamon
Email: HFS.DMPApps@illinois.gov
Posting Group: Leadership & Management
This position DOES 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
Nearest Major Market: Springfield