Application and Data Warehouse Analyst

APPLICATION AND DATA WAREHOUSE ANALYST:

The Application and Data Warehouse Analyst develops, implements, and maintains computer programs and database-driven applications while managing system analysis, data integrity, and IT support. This role includes server administration, troubleshooting, backup management, and user training.

Duties/Responsibilities:

Systems Development and Programming:

• Perform systems analysis, design, and implementation of new computer programs.
• Execute changes, modifications, or enhancements to existing programs and perform the related analysis.
• Work with end users to develop new applications or modify existing ones, including the design and programming of end-user reports.
• Code, test, and debug programs utilizing programming languages such as COBOL, FORTRAN, SQL, SAS, ASP.NET, HTML, CSS, JavaScript, jQuery, Dreamweaver, and ColdFusion.
• Develop database-driven web applications.

Project Management and Documentation:

• Provide project management pertaining to the development of new systems and the enhancement of current systems.
• Create and maintain documentation to support computer programs and procedures.

System Administration and Maintenance:

• Use the Linux system to execute job procedures.
• Configure and troubleshoot the Linux system, streamline processes, maintain the file system, and ensure data integrity.
• Maintain and administer Exchange, Active Directory, web, and other servers.
• Develop strategy and procedures for systems backup and recovery; maintain the scripts that perform them.
• Operate in-house computer hardware.
• Install and maintain hardware and software on desktops to provide required Internet and Intranet services, including, but not limited to, browsers, e-mail, and scheduling applications.

Data Management and Reporting:

• Manage data collection from outside sources and assist staff with in-house reports.
• Provide training and assistance to ICCB staff in the use of in-house data manipulation procedures on PCs, including hardware and software training and system analysis functions using PC software packages.

IT Support and Training:

• Provide IT training and assistance to new IT staff.
• Serve as a help desk to agency staff and outside entities.
• Set up video conferencing equipment and troubleshoot as necessary.

Other Responsibilities:

• Perform other duties as assigned.

Minimum Qualifications:

• High school diploma or equivalent.
• Any one or any combination totaling two (2) years (24 months) from the following categories:
• College coursework which includes Information Technology (IT), IT Management, Programming, IT systems, or a closely related discipline, as measured by the following conversion table or its proportional equivalent:
• 30 semester hours equals one (1) year (12 months)
• Associate’s degree (60 semester hours) equals eighteen months (18 months)
• 90 semester hours equals two (2) years (24 months)
• Bachelor’s degree (120 semester hours) equals three (3) years (36 months)
• Work experience in IT-related functions, such as hardware/software support, programming, network design, network engineering, IT systems integration, or closely related field.

Additional Desirable Qualifications:

• Bachelor’s degree in a field related to computer science, information systems, data processing systems or management sciences.
• Knowledge of data processing practices, methods, principles, and techniques relative to the application and operation of a computer complex.
• Ability to plan, schedule, and coordinate chronological operations and to reason logically regarding operational aspects of data processing applications and functions of a computer complex.
• Ability to understand, develop, communicate, and express ideas.
• Ability to express or translate technical machine functions of data processing systems operations into non-technical terms and vice versa.
• Specialized training in systems analysis and computer programming.
• Experience with, or adequate knowledge of, the Illinois Community College System.
• Ability to work/interact with users.

Required Applicant Documents

• Resume
• Cover Letter
• Illinois Community College Board application ( www.iccb.org/about-us/employment-opportunities/ )

Please Note: These documents are required to be submitted via email to iccb.careers@illinois.gov to complete the application process.

Optional Applicant Documents

• Transcripts
• DD-214 - To be eligible for Veteran's Preference points on the exam, appropriate military service documentation such as a DD-214 must be submitted prior to the application deadline.

Special Instructions for Applicants

Please fully complete the entire application including, but not limited to, the education and work history portions. Be specific on your work history, including employment dates and duties for all positions held. Please do not put "see resume" in the duties and responsibilities section of the work history. This will be considered an incomplete application and incomplete applications will not be considered.

The Civil Service examination for this classification is based on your application materials and responses to the supplemental questions. No participation other than submission of applicant materials is required from applicants that qualify to take the exam. If you meet the minimum required qualifications for this position, you will receive a score calculated based on your education and experience, and your name will be placed on the active employment register by exam score. After the application deadline, the names within the top three scores will be referred to the department for interview.

Important Information for Applicants

This position requires a criminal background investigation and, if applicable, an employment history review. Any offer of employment is contingent upon successfully passing these checks. Employment may not commence until the results of the background investigation have been reviewed and approved by Human Resources.

The ICCB is an Equal Opportunity/Affirmative Action Employer. Minorities, women, veterans, and individuals with disabilities are encouraged to apply.

Job Type: Full-time

Pay: $64,625.00 - $69,625.00 per year

Benefits:

• Dental insurance
• Employee assistance program
• Health insurance
• Life insurance
• Paid time off
• Tuition reimbursement
• Vision insurance

Schedule:

• Monday to Friday

Experience:

• IT: 2 years (Required)

Ability to Commute:

• Springfield, IL 62701 (Required)

Ability to Relocate:

• Springfield, IL 62701: Relocate before starting work (Required)

Work Location: In person

Salary : $64,625 - $69,625