Apply »

IES Database Support Analyst I (INFORMATION SYSTEMS ANALYST I OPT A)

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

The State of Illinois is committed to working with and providing reasonable accommodations to people with disabilities. Further, federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job, interview for a job, or for any other activity related to the hiring process. Examples of reasonable accommodation include, but are not limited to, making a change to the application process (if possible), providing documents in an alternate format, using a sign language interpreter, or using specialized equipment.

To be provided a Reasonable Accommodation during the hiring process, you will need to provide a certification of disability from a physician, psychiatrist, school official or an Illinois Department of Human Services (DHS) Division of Rehabilitation Services (DRS) Vocational Rehabilitation (VR) Counselor. Supporting documentation should be uploaded under My Documents → Additional Documents section for each application.

Any questions on Reasonable Accommodations can be directed to Central Management Services Disability Resource Center at CMS.DisabilityResCen@illinois.gov or call (217) 524-7514 for further information and to request or discuss 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:  Oct 21, 2024
Location: 

Springfield, IL, US, 62762

Job Requisition ID:  42176

Agency: Department of Innovation and Technology
Class Title: INFORMATION SYSTEMS ANALYST I - 21165 
Skill Option: Application Services - Information Technology 
Bilingual Option: None 
Posting Date: 10/22/2024

Closing Date/Time: 11/04/2024
Salary: Anticipated Starting Salary $6,688.00/month. Full Range $6,688 - $9,745/month
Job Type: Salaried
Category: Full Time 
County: Sangamon; Cook
Number of Vacancies: 3
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.

 

PROOF OF EDUCATIONAL COURSEWORK IS REQUIRED. ACCEPTABLE PROOF OF COURSEWORK INCLUDES UNOFFICIAL TRANSCRIPTS, COPIES OF OFFICIAL TRANSCRIPTS, ACCOUNT RECORDS (INCLUDING SCREENSHOTS) OF ACADEMIC COURSEWORK, AND ANY SIMILAR DOCUMENTS CREATED BY AN ACADEMIC INSTITUTION.  Answer all questions thoroughly- Do not state ‘See Resume’ on application questions.

 

Posting Identification Number  42176 

 


Are you looking for a rewarding career with an organization that values their staff? The Department of Innovation & Technology (DoIT) is seeking to hire qualified candidates with the opportunity to work in a dynamic, creative thinking, problem solving environment. This position serves as an IES Database Support Analyst I, supporting the Illinois Department of Health & Human Services (IDHS), reviewing and analyzing functional system requirements and comparing to end user needs/requests for modifications.  In this role, you will utilize appropriate tools to create queries from TANF, SNAP and Medical Eligibility Systems sources. In addition, you will conduct large complex database/systems software implementation duties as a team member on both enterprise and individual program applications. This position provides technical expertise for the production of detailed database designs and design documentation, including data modules, and data flow diagrams. If you possess these knowledges, skills, abilities, and experience, we invite you to apply for this position to join the DoIT Team!

 

As a State of Illinois employee, you receive a comprehensive benefits package including:

  • Competitive Group Insurance benefits including health, life, dental and vision plans.
  • Flexible work schedules (when available and dependent upon position)
  • 10 -25 days of paid vacation time annually (10 days for first year of state employment)
  • 12 days of paid sick time annually which carryover year to year
  • 3 paid personal business days per year
  • 13-14 paid holidays per year dependent on election years
  • 12 weeks of paid parental leave
  • Pension plan through the State Employees Retirement System
  • Deferred Compensation Program – voluntary supplemental retirement plan
  • Optional pre-tax programs -Medical Care Assistance Plan (MCAP) & Dependent Care Assistant Plan (DCAP)
  • Tuition Reimbursement Program and Federal Public Service Loan Forgiveness Program eligibility

 
For more information regarding State of Illinois Benefits follow this link: https://www2.illinois.gov/cms/benefits/Pages/default.aspx

 

 

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.

Essential Functions

  • Under general direction, serves as an IES Database Support Analyst I for the Department of Innovation & Technology (DoIT), supporting the Illinois Department of Health & Human Services (IDHS), performing difficult and specialized professional work, reviewing and analyzing functional system requirements and comparing to end user needs/requests for modifications.
  • Conducts large complex database/systems software implementation duties as a team member on both enterprise and individual program applications.
  • Provides technical expertise in the production of detailed database designs and design documentation, including data modules, and data flow diagrams.
  • Completes maintenance and performance tuning of system databases to ensure optimum efficiency using software products such as DB2 and AIX.
  • Determines solutions to problems and prepares recommendations and impact statements for project management.
  • Prepares written and graphical reports depicting development progress for management.
  • Keeps abreast of new developments in the Information Technology field by continuing education through meetings, training sessions, seminars, and conferences to increase familiarity with and remain current on products, vendors, techniques, and procedures.
  • Performs other duties as assigned or required which are reasonably within the scope of duties enumerated above.

Minimum Qualifications

  • Requires knowledge, skill, and mental development equivalent to four (4) years of college with course work in computer science or directly related fields.
  • Requires one (1) year of professional experience in Application Services or a related Information Technology field.

Specialized Skills

  • Requires one (1) year of professional experience creating queries using Windows Operating Systems, DB2, IBM Clear Quest, IBM Content Manager, Rational Application Developer, SQL Server, SQL scripts or Microsoft Office products. 
  • Requires one (1) year of professional experience maintaining and performance tuning system databases using software products such as DB2 or AIX.
  • Requires one (1) year of professional experience producing technical documentation, including database designs and data flow diagrams.

Preferred Qualifications

  • One (1) year of professional experience creating queries using Windows Operating Systems, DB2, IBM Clear Quest, IBM Content Manager, Rational Application Developer, SQL Server, SQL scripts or Microsoft Office products. 
  • One (1) year of professional experience maintaining and performance tuning system databases using software products such as DB2 or AIX.
  • One (1) year of professional experience producing technical documentation, including database designs and data flow diagrams.
  • Working knowledge of relational database design, object-oriented analysis and design and query analysis and optimization.
  • Working knowledge of TANF, SNAP and Medical eligibility systems. 
  • Ability to analyze and diagnose system issues and coordinate efforts to resolve.
  • Ability to maintain satisfactory working relationships with others.
  • Developed verbal and written communication skills to present information to others with clarity and precision.

Employment Conditions

Applicants must possess the ability to meet ALL of the following conditions of employment, with or without reasonable accommodation, to be considered for this position.

  • Requires the ability to verify identity.
  • Requires employment authorization to accept permanent full-time position with the State of Illinois.
  • Requires the ability to pass a position specific, agency required background check.
  • Requires self-disclosure of criminal history. 
  • Requires the ability to use agency supplied equipment such as laptop, personal computer, work cell phone and any other required equipment or devices.
  • Requires the ability to attend seminars, conferences, and training to remain current on methods, tools, ideologies or other industry related topics relevant to job duties.
  • Requires the ability to lift and carry objects or equipment weighing up to 20 pounds. This is considered light work as defined by the U.S. Department of Labor (20 CFR 404.1567(b)). Light work involves lifting no more than 20 pounds at a time with frequent lifting or carrying of objects weighing up to 10 pounds.
  • Requires the ability to travel in performance of duties.
  • Requires the ability to serve in an on-call capacity.
  • Requires the ability to work overtime including scheduled, unscheduled, short notice, evenings, weekends and holidays.
  •  

The conditions of employment listed are incorporated and/or related to any duties included in the position description.

Work Hours: Monday - Friday 8:30am - 5:00pm  


Work Location: 100 South Grand Ave E, Springfield, Illinois, 62762  or 401 S. Clinton St., Chicago, IL  60607


Agency Contact: Lois Green
Email: lois.d.green@illinois.gov
Posting Group: Science, Technology, Engineering & Mathematics

 

This position DOES contain “Specialized Skills” (as that term is used in CBAs).

 

The Department of Innovation & Technology (DolT) is the state's IT agency delivering an enterprise approach to statewide technology, innovation, and telecommunication services, as well as policy and standards development, lifecycle investment planning, and cybersecurity services. With over 1,500 employees, DolT delivers IT services and innovative solutions to customer agencies to improve services provided to Illinois residents, DolT offers employees the opportunity to advance their careers, develop new skills and reach their potential, both personally and professionally. DoIT is committed to promoting and preserving a workplace culture that embraces diversity 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.

 

 

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

Apply »