Lead Data Warehouse Developer

Illinois State University; Normal (IL); Hybrid; USD 75,000 - 80,000; Full time

Job summary

Illinois State University is seeking a Lead Data Warehouse Developer to lead data analysis, database design, data modeling, and ETL development and administration (Informatica) for the Enterprise Data and Analytics team, supporting university-wide business intelligence. The role requires a bachelor's degree plus 3+ years of experience with SQL, Python, and R, and ETL tools such as Informatica PowerCenter.

It offers a hybrid arrangement with potential for 100% remote work within Illinois, based

Qualifications

• Bachelor's degree required plus 3+ years in SQL, Python, R.
• Experience in data modeling and ETL design using Informatica PowerCenter.
• Strong SQL/Python/R for data analysis and BI support.

Responsibilities

• Lead data modeling, ETL design/development, and Informatica administration for the Enterprise Data Warehouse.
• Oversee data analysis, database design, and data integration for university-wide BI

Skills

SQL

Python

R

Data modeling

ETL design

Education

Bachelor's degree

Tools

Informatica PowerCenter

Job description

Illinois State University is seeking a Lead Data Warehouse Developer to handle data analysis, database design, data modeling, and ETL development and administration (Informatica) for the Enterprise Data and Analytics team, supporting university-wide business intelligence.

Highlights

• Lead data modeling, ETL design/development, and Informatica administration for the Enterprise Data Warehouse
• Requires a bachelor's degree plus 3+ years of experience in SQL/Python/R, data modeling, and ETL tools such as Informatica PowerCenter
• Hybrid arrangement with potential for 100% remote work within Illinois, based in Normal, IL
• Compensation: $75,000 - $80,000 per year