Data Analysis & Support Specialist; Executive II

Position Overview

Salary:
Anticipated starting salary $6589/monthly;
Full salary range $6589 - $9541/monthly.

The Department of Healthcare and Family Services, Bureau of Professional and Ancillary Services is seeking 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 maintaining 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.

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 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 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.

• 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)

• 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.

• Requires knowledge, skill, and mental development equivalent to completion of four years of college, preferably with coursework in business or public administration.
• Requires two years of responsible administrative experience in a public or business organization.

• Minimum one year 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.
• Minimum one year experience utilizing Microsoft Excel to create and maintain spreadsheets, including writing complex formulas used to develop estimates of the budgetary impact of program changes.
• Minimum one year experience independently writing queries in Structured Query Language (SQL), used to access data in Database Management Systems.