INFORMATION SYSTEMS ANALYST II (Special Skills) Agency : Department of Healthcare and Family Services Posting ID: DF39697 BPIS: 08425 Group: CL (B-H) Start Date: 07/15/24 Closing Date: 07/29/2024 Salary: Starting Salary $7,491 - $11,015 Monthly / Anticipated Non-State $7,491. 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 DF39697 Job Description: The Department of Healthcare and Family Services, Division of Finance, Bureau of Federal Finance (BFF) is seeking to hire an Information Systems Analyst. The BFF is responsible for federal financial reporting of the Medicaid Program, Children's Health Insurance Program (CHIP), and Child Support Program maximizing federal revenue of approximately $14 billion annually. This position will independently conduct complex technical research and system analysis of the Federal Financial Participation Program and federal claiming systems, run ad hoc reports using the Enterprise Data Warehouse to facilitate date management decisions, and consult with Bureau staff concerning system needs and objectives. The ideal candidate will possess the ability to analyze data logically and exercise good judgment in solving technical or operational problems with set deadlines. The preferred candidate will be able to present technical information to others with clarity and precision and determine the ideal solution for practical and timely implementation while maintaining a well-organized schedule. 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. Job Description * Under administrative direction, serves as an Information Systems Analyst for the Department of Healthcare and Family Services, Division of Finance, Bureau of Federal Finance by conducting complex and professional functions in the analysis and evaluation of the Federal Financial Participation (FFP) Review and Analysis Program * Interviews and consults with Bureau staff concerning desirable system changes and performs comprehensive studies and analysis of needs and objectives * Develops complex management and analytical ad hoc reports and files using the Enterprise Data Warehouse (EDW) to facilitate data management decisions * Conducts in-depth management studies involving substantial technical research and systems analysis on special projects relating to the federal financial participation process * Conducts special review projects related to the medical assistance claim data and federal claiming systems * Serves as Bureau liaison with DoIT for upgrades and changes * 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 (4) four years of college with course work in computer science or directly related fields, supplemented by (3) three years of professional experience in a related Information Technology field. Preferred Qualifications * Two (2) years of experience utilizing an Enterprise Data Warehouse, including composing complex queries using Teradata SQL Assistant software * Three (3) years of experience utilizing Microsoft Excel to create complex spreadsheets and information tables * Three (3) years of experience utilizing hardware and software languages and procedures to provide technical and analytical services * Three (3) years of experience presenting technical information to others * Three (3) years of experience analyzing data to evaluate and solve difficult administrative, organization, technical, or operational problems * Three (3) years of experience using statewide accounting procedures and a statewide accounting system, preferably the Department of Healthcare and Family Services Special Skills * Two (2) years of experience utilizing Enterprise Data Warehouse, including composing complex queries using Teradata SQL Assistant software * Three (3) years of experience utilizing Microsoft Excel to create complex spreadsheets and information tables 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 Work Hours: Monday - Friday 8:30am - 5:00pm Work Location: 201 South Grand Ave E Springfield, IL 62704-3803 Agency Contact: HFS.DOFApps@illinois.gov Posting Group: Science, Technology, Engineering & Mathematics 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