Advanced Non-MAGI Analyst (Information Systems Analyst I, Opt. M)

State of Illinois•Springfield, IL

41d•$6,952 - $10,130

About The Position

The Department of Healthcare and Family Services, Division of Eligibility is seeking to hire an Information Analyst I in the Bureau of Eligibility Integrity. As an Information Systems Analyst I, you will work provide advanced professional support to end users of the Eligibility Integrity Non-Modified Adjusted Gross Income (MAGI) rules engine. You will have a unique opportunity to shape the development of a Bureau tasked with monitoring and improving Medicaid eligibility processes. You would join a team of healthcare professionals providing new and creative solutions for the largest overhaul of Medicaid in the 50 years of its existence. The ideal candidate will have extensive applicable knowledge of SQL query tools in reviewing, analyzing and extracting data from a relational databases management systems. Candidate will also have applicable experience in preparing extensive spreadsheets for data analysis for end users. The candidate will also have verbal and written communication skills as well as exhibit time management skills to ensure task are completed accurately and timely. In addition, you will participate on projects as a team member for assignments in relationship to the Illinois Eligibility System being supported. HFS values employees with different backgrounds, life experiences, and talents.

Requirements

Requires knowledge, skill and mental development equivalent to four (4) years of college, with course work in computer science or directly related fields and requires one (1) year of professional experience in a related Information Technology field
Requires one (1) year of experience writing SQL to pull data from a relational data, based on business requirements and/or policies
Requires one (1) year of experience creating and updating complex spreadsheets with formulas in Excel or comparable software and knowledge of Medicaid eligibility policies
Requires completion of a background check and self-disclosure of criminal history
Requires the ability to travel in the performance of duties, with overnight stays as appropriate
Requires the ability to utilize and maintain state issued equipment such as a laptop
Requires the ability to attend seminars, conferences, and trainings to stay current on methods, tools, ideologies, or other industry related topic relevant to the job duties
The conditions of employment listed here are incorporated and related to any of the job duties as listed in the job description

Nice To Haves

Minimum of one (1) year of experience writing SQL to pull data from a relational data, based on business requirements and/or policies
Minimum of one (1) year of experience creating and updating complex spreadsheets with formulas in Excel or comparable software and knowledge of Medicaid eligibility policies
Minimum of one (1) year of experience programming with SQL query tools
Minimum of one (1) year of experience extracting data from relational databases
Minimum of one (1) year of experience in data processing, information technology concepts and principles, including the theories and functions of computer systems and the principles and techniques of Information Technology documentation
Minimum of one (1) year of experience developing reports

Responsibilities

Under general direction, serves as an Advanced Non-MAGI Analyst by developing management and analytical reports and files using the Integrated Eligibility System (IES) Replica Database and the Enterprise Data Warehouse (EDW) to monitor IES Rules Engine eligibility processing outcomes and to identify potential issues and resolution
Responds to user inquiries regarding the system
Provides advanced professional support to end users of the Non-Modified Adjusted Gross income (Non-MAGI) rules engine hardware and software
Provides training and problem resolution to users of the Non-MAGI rules engine system
Performs other duties as required or assigned which are reasonably within the scope of the duties enumerated above

Benefits

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)