Title: Data Warehouse Developer
Division Name: Finance and Planning
Department: Enterprise Data and Analytics
The Data Warehouse Developer will be involved in all aspects of data analysis, data acquisition, profiling, database design, source-to-target maps, testing, and all technical meta data documentation related to data modeling for new solutions and the ongoing maintenance of existing ones. S/he will also be involved in all aspects of the analysis, design, development, testing, and all technical meta data documentation related to ETL for new solutions and the ongoing maintenance of existing ones. The Data Warehouse Developer will also be responsible for contributing to and upholding departmental data modeling and ETL standards in practice and in appropriate documentation.
In addition the Data Warehouse Developer will have responsibilities related to ETL deployments as well as the ongoing administration of Informatica or any future ETL tools.
The individual(s) in this role work as a member of the Office of Decision Support-EDA team as well as university staff in support of business intelligence to support and promote data usage within the University community.
There is the potential for 100% remote work in this position, within the State of Illinois. Eligibility is based upon employee performance, appropriate remote working environment, and business needs.
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 Enterprise Data Warehouse and provides data access and training.
https://data.illinoisstate.edu/
Salary Rate / Pay Rate
$65,000 - $70,000 annual
1. High school diploma or equivalent.
2. Any one or any combination totaling two (2) years (24 months) of full time (or part time equivalent) from the following categories:
a. 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)
b. Work experience in IT-related functions, such as hardware/software support, programming, network design, network engineering, IT systems integration, or closely related field.
3. One (1) year (12 months) of full time (or part time equivalent) experience performing the following:
a. Authoring SQL, Python, or R
b. Data discovery, data profiling/analysis, or data modeling
c. Modifying, creating, or analyzing relational and dimensional data structures
d. Software testing including creating test plans, creating test cases, test execution, and documenting defects
e. Collecting technical requirements
f. Integrating data between systems using API technology
g. Working with relational database concepts, queries (SQL), and ability to use 1 or more common query/reporting tools (SQL Developer, TOAD, Cognos, SSRS, Crystal Reports)
h. Developing and debugging Software
i. Programming and/or authoring complex data integration scripts
4. Basic knowledge of ETL mappings and workflows
5. Basic knowledge of Business Intelligence and data warehousing
6. Strong customer service skills along with a desire for achieving excellence in customer satisfaction, process, and product quality and reliability.
7. Strong problem-solving ability
8. Excellent interpersonal and communication skills, ability to conduct internal and external meetings
Preferred Qualifications
1. Experience designing/developing enterprise ETL mappings and workflows with a tool such as Informatica PowerCenter, AWS Glue, Microsoft SSIS, Oracle ODI, or similar
2. Experience in development and support of a Business Intelligence or data warehousing initiative
Core work hours: Monday - Friday 8:00 a.m. - 4:30 p.m.
Must be able to complete the following with or without a reasonable accommodation:
1. Remain at a workstation for extended periods.
2. Distinguish colors on a monitor.
3. Effectively communicate on a daily basis.
August 2026
Resume
Cover Letter
Reference List (include three (3) references including a current or former supervisor)
Please Note These documents are required to be submitted online in order to complete the application process. Please have these documents ready prior to clicking on "Apply"
Transcripts - See Special Instructions section for additional options
Certification of Retirement Annuity
Please Note These documents may be submitted online in order to complete the application process. Please have these documents ready prior to clicking on "Apply"
Sponsorship Applicants for this position must be currently legally authorized to work for Illinois State University in the United States. Illinois State University will not sponsor or take over the sponsorship of an employment visa for this opportunity. Illinois State University is not a qualifying employer for the STEM OPT benefit: only the 12-month OPT may be used to work at Illinois State University.
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 (if part-time you must list the number of work hours) and duties for all positions held. Applicable part-time work experience will be considered toward qualifying for this position; however, it will be converted to a full-time equivalency to determine combined length of experience. 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.
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, appropriate military service documentation, such as a DD214, 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: Colette Homan
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 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. The active register for this classification will be voided when the position is filled.
Illinois State University is authorized to do business within the State of Illinois. All work under this appointment is required to be performed from within the State of Illinois. If hired, out-of-state candidates must establish Illinois residency within 180 calendar days from the start date for this position. Illinois residency requires proof of a valid Illinois driver’s license or a valid State of Illinois ID card. Failure to produce the required documentation within 180 calendar days will result in immediate termination of employment.
University Benefit Highlights:
- Insurance benefits, including health, dental, vision, and life
- Retirement and supplemental retirement planning options
- Tuition waiver benefits available to staff as well as their eligible dependents
- Paid holidayadministrative closures during Thanksgiving and Winter Breaks
- Paid benefit time
Additional University Benefit information, including information regarding eligibility to participate in the State Universities Retirement System and the State of Illinois Group Insurance program, can be reviewed here: https://hr.illinoisstate.edu/benefits/
Colette Homan
Human Resources
309-438-8848
cshoman@ilstu.edu
This position is subject to a criminal background investigation and if applicable, an employment history review, based on University Policy 3.1.30 and any offer of employment is contingent upon you passing a satisfactory criminal background investigation and/or an employment history review. You may not begin work until the criminal background investigation results have been received and cleared by Human Resources.
Illinois State University is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
If you are an individual with a disability and need a reasonable accommodation under the Americans with Disabilities Act (ADA) or other state or federal law you may request an accommodation by contacting the Office of Equal Opportunity and Access at (309) 438-3383 The Office of Equal Opportunity and Access will hold any confidential information you provide in confidence.
If you are having difficulty accessing the system, please call Human Resources at (309) 438-8311
