INFORMATION SYSTEMS ANALYST II

We continually strive for a workforce that reflects the growing diversity within the State of Illinois. A variety of employee backgrounds, perspectives, ideas and experiences are crucial to our ability to most effectively serve the public. Bilingual skills welcome

Reasonable Accommodation Statement

Persons with disabilities are provided reasonable accommodations throughout the hiring process and during performance of all job duties. Please email the Central Management Services Disability Resource Center at CMS.DisabilityResCen@illinois.gov or call (217) 524 - 7514 for further information and to request an accommodation.

Sponsorship for Employment

The State of Illinois does not provide sponsorship for employment visa status (e.g. H-1B visa status). To be considered for permanent employment with the State of Illinois, applicants must be currently authorized to work in the United States on a full-time basis.

Disclosure of Salary Information

In compliance with the Illinois Equal Pay Act, 820 ILCS 112/1 et seq., the State does not seek, request, or require a job applicant’s wage or salary history. Employment decisions are not made based on an applicant’s wage or salary history. To that end, please do not include wage or salary information in your resume or other profile or application materials.

Date: May 13, 2022

Location:

Springfield, IL, US, 62701-1323

Job Requisition ID: 15477

Agency:  Department of Children and Family Services
Closing Date/Time:  05/27/2022
Salary:  $6,294 - $9,558/mo. (anticipated starting salary $7,920/ mo.)
Job Type:  Salaried Full Time
County:  Sangamon
Number of Vacancies:  2
Plan/BU:  RC063

Collective Bargaining Agreement language applies to this requisition:
We are currently transitioning away from a paper application process to an electronic application process. This position has not been transitioned. Please follow the directions below when applying to this position.

DO NOT APPLY ONLINE

**DO NOT CLICK THE APPLY BUTTON**

CMS100/B Employment Application and all applicable documentation should be submitted to the Agency contact listed below.

Posting Identification # 2239001

Position Overview

Under administrative direction of the Data Analytics Supervisor, as a Database Engineer II, develops, tests, and implements the more technically complex data warehouse structures, data collections, reports, visualizations, SQL Server Integration Services (SSIS) packages, and systems for the Data Analytics Team, as well as other related systems. Performs advanced analysis, evaluation, problem solving, maintenance, testing, and implementation of trouble tickets and engineering service requests as assigned. Prepares and maintains technical documentation in support of data warehouse structures and usage and analysis functions. Attends advanced continuing data processing training covering new technologies, new techniques, enterprise standards, and best practices from internal department staff, enterprise state data practice, and external training classes and seminars. Travels in performance of duties.

Job Responsibilities

Develops, tests, and implements the more technically complex data warehouse structures, data collections, data modeling, reports, visualizations, SQL Server Integration Services (SSIS) packages, and systems for the Data Analytics Team.
Prepares and maintains technical documentation in support of data warehouse structures and usage and analysis functions.
Performs advanced analysis, evaluation, problem solving, maintenance, testing, and implementation of trouble tickets and engineering service requests.
Attends advanced continuing data processing training covering new technologies, new techniques, enterprise standards, and best practices from internal department staff, enterprise state data practice, and external training classes and seminars.
Attends meetings and creates meeting notes and status reports.
Performs other duties as required or assigned which are reasonably within the scope of the duties enumerated above.

Minimum Qualifications

1. Requires knowledge, skill, and mental development equivalent to four years of college, with coursework in computer science or directly related fields;

2. Requires three years experience working as a software developer or database administrator in a data warehouse or related development area; preferred one or more years of professional experience with the design, development and implementation of data warehouse structures, collections, and cubes; preferred experience with Crystal Reports, IBM DB2, Microsoft Team Foundation Server.

Specialized Skills: Of the previously noted experience, requires 3 years of professional experience working with Microsoft SQL Server 2012 or above, ETL using Microsoft SQL Server Integration and Analysis Services, SQL Server Reporting Services (SSRS) building and report subscription creation; and a minimum of 1 year of experience with Power BI, Tableau or other data visualization software

Conditions of Employment

Requires the ability to pass a background check.
Requires a valid driver’s license and the ability to travel..

Work Hours: Mon-Fri 8:30AM to 5:00PM
Work Location: 1 N Old State Capitol Plz Springfield, IL 62701-1323

Supervsor: Brian Rhodes

Agency Contact:

Tiffany Hatfield

Phone # 217-558-8261

Fax # 217-588-5069

Email: Tiffany.Hatfield@Illinois.gov

1 N. Old State Capital Plaza, Springdield Illinois 62701

Job Function: Technology

CANDIDATES MUST SUBMIT A SEPARATE BID FORM (as applicable) AND CMS-100/B FOR EACH POSTED VACANCY APPLIED FOR.

APPLICATION INSTRUCTIONS

DO NOT APPLY ONLINE.

Please submit application via email to: cmsapplications@fakeaddress.com (explain how you would like to receive the paper application/bid forms)

Current State Employees:

Seeking a Promotion – Submit an Official Position Vacancy Bid Form and CMS-100B Employment Application (version dated 9/2020 or after) to the Agency Contact address listed above.
- Older versions of the CMS-100B will not be graded or returned to applicants.
- Failure to complete and submit the new CMS-100B (version dated 9/2020 or after) will result in your application being rejected.

Seeking a Transfer – Submit an Official Position Vacancy Bid Form, Transfer Request, and CMS-100 Employment Application (version dated 9/2020 or after) to the Agency Contact address listed above.
- A separate Bid form and Application is required for each Posting Identification#/Job Requisition ID # or your bid will be rejected.
- Failure to complete and submit the new CMS-100 version (dated 9/2020 or after) will result in your application being rejected.

Seeking a Reduction - Submit an Official Position Vacancy Bid Form and CMS-100 Employment Application (version dated 9/2020 or after) to the Agency Contact address listed above.
- A separate Bid form and Application is required for each Posting Identification#/Job Requisition ID # or your bid will be rejected.
- Failure to complete and submit the new CMS-100 (version dated 9/2020 or after) will result in your application being rejected.

Former State Employees:

Submit an Official Position Vacancy Bid Form and CMS-100 Employment Application (version dated 9/2020 or after) to the Agency Contact address listed above.
- A separate Bid form and Application is required for each Posting Identification#/Job Requisition ID # or your bid will be rejected.
- Failure to complete and submit the new CMS-100 (version dated 9/2020 or after) will result in your application being rejected.

Non-State Employees:

Submit a CMS-100 Employment Application (version dated 9/2020 or after) and official college transcripts (where applicable) to the Agency Contact address listed above.
- Documentation is required for each Posting/Bid ID or your application(s) will be rejected.
- Failure to complete and submit the new CMS-100 version (dated 9/2020 or after) will result in your application being rejected.

Apply »