State Universities Civil Service System

Employment Opportunities
Job Details


Business Intelligence Analyst

University/Agency Illinois State University
Civil Service Classification Information Technology Technical Associate
View Class Spec Details
Posting Duration 6/9/2021 - 6/22/2021
Probationary Period 12 months

Job Description

General Summary
The BI Analyst is responsible for creation and maintenance of both BI and operational reports for the University community. This includes IBM Cognos and Microsoft Power BI development, as well as analyzing transactional source systems to develop, manage, and assist in build of the data warehouse environment. Additionally, this position will be responsible for generating SQL queries to pull data directly from multiple source systems, including the enterprise data warehouse.

Additional Information
Technology Solutions provides information technology products and services for the administrative and business functions of Illinois State University. Through our Technology Support Center and our highly trained staff, Technology Solutions looks to improve the campus experience for all students, faculty, staff, and the rest of the campus community.

The Enterprise Data and Analytics (EDA) team provides a strong business intelligence environment that helps the University make informed and strategic decisions. This groups manages the Institutional Data Warehouse and provides data access and training.


Qualifications

Bachelors or equivalent degree in Business Intelligence, Computer Science, Information Systems, Information Technology, Technology, Business Administration, Marketing Analytics, Economics, Mathematics, Statistics, or similar field.
Three (3) or more years of experience developing and supporting business intelligence solutions, preferably in IBM Cognos, Microsoft Power BI, or similar BI tool.
Three (3) or more years of experience developing complex SQL queries
Three (3) or more years of experience utilizing multiple database types, including but not limited to a relational-style database such as Oracle or SQL
Three (3) or more years of experience interacting with end-users and key stakeholders on business intelligence or data warehousing initiatives
Three (3) or more years of experience using and/or analyzing data structures in a transactional source system, such as an ERP
Three (3) or more years of experience using operational and analytical database concepts


Salary

$60,000 - $80,000 annual


Links

ISU Jobs Website


Contact Information


University/Agency Illinois State University
Department/College Human Resources
Contact Kira Shelton
Phone Number (309) 438-8311
Address
Comments Please fully complete the entire application including, but not limited to, the education and work experience portions. Please list all education and all jobs you have had. Do not leave gaps in employment. You must list all duties you performed in the job duties section (Phrases such as "See Resume" are not acceptable). Failure to follow any of these instructions may constitute an incomplete application. Incomplete applications will not be considered.

College or university transcripts (may be unofficial) must be submitted prior to the application deadline in order to receive full consideration. Transcripts can either be uploaded with your application or submitted via the options listed below.

In order to be eligible for Veteran's Preference points on the exam, a copy of your DD-214 must be submitted prior to the application deadline.

Transcripts and/or DD-214 paperwork may be faxed or mailed to Human Resources by the application deadline:

Fax: 309.438.0011, Attn: Kira Shelton
Address: Illinois State University
Human Resources
Campus Box 1300
Normal, IL 61790-1300

The Civil Service examination for this classification is based on your application materials. 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. The active register for this classification will be voided when the position is filled.