Data Intelligence & Analytics Analyst - ETL, SQL & BI

The University of Chicago; Chicago (IL); On-site; USD 70,000 - 110,000; Full time

Job summary

The University of Chicago seeks a Business Intelligence & Analytics Analyst to design, develop, and support ETL/ELT processes and BI solutions across academic, administrative, and clinical areas.

You will build dimensional data models, optimize SQL, and support reports and dashboards using Power BI, Tableau, and related tools. The role emphasizes data quality, security, and collaboration with stakeholders.

Qualifications

• Minimum degree in a related field and 2–5 years in data engineering, analytics, BI, or related roles.
• Preferred: BS in computer science, information systems, data science, engineering, business analytics, healthcare analytics.
• Strong SQL proficiency with optimization for large datasets.

Responsibilities

• Design, develop, test, and maintain ETL/ELT processes for enterprise reporting and analytics.
• Develop and optimize SQL queries, stored procedures, views, and data structures.
• Create and maintain technical documentation and data mappings.
• Support BI reports, dashboards, and analytic applications across units.
• Monitor data quality, security, and access controls; ensure compliant data handling.

Skills

SQL

Power BI

Tableau

ETL

Data modeling

Dimensional modeling

SSIS

SQL Server

Education

Bachelor's degree in CS

Bachelor's degree in data science

Tools

Power BI

Tableau

SSIS

SQL Server

Job description

The University of Chicago seeks a Business Intelligence & Analytics Analyst to design, develop, and support ETL/ELT processes and BI solutions across academic, administrative, and clinical areas.

You will build dimensional data models, optimize SQL, and support reports and dashboards using Power BI, Tableau, and related tools. The role emphasizes data quality, security, and collaboration with stakeholders.