Healthcare BI & Analytics Specialist

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 data integration, modeling, and enterprise reporting solutions. You will build ETL processes, maintain data structures, ensure data quality and security, and support BI applications across academic, administrative, and clinical areas.

Responsibilities include designing ETL processes, dimensional models, and optimized SQL; translating requirements into technical solutions; and documenting

Qualifications

• 2–5 years of experience in data engineering, analytics engineering, BI, or related roles.
• Demonstrated experience writing optimized SQL queries, stored procedures, and data transformation logic.
• Experience working with large and complex datasets across multiple enterprise systems.
• Experience supporting analytics reporting, automated workflows, or ETL/data integration processes.

Responsibilities

• Design, develop, test, and maintain ETL/ELT processes for enterprise reporting and analytics.
• Design and support dimensional data models, database objects, and reporting data structures.
• Develop and optimize SQL queries, stored procedures, views, and related database components.
• Gather and translate business and reporting requirements into technical solutions.
• Create and maintain technical documentation, metadata, data definitions, and source-to-target mappings.
• Support BI reports, dashboards, and analytic applications.
• Monitor and troubleshoot ETL jobs, data issues, and BI application problems.

Skills

SQL Queries

Power BI

Tableau

ETL

Data Modeling

Data Warehousing

Education

Bachelor’s degree in CS/IS/DS/Engineering/Business analytics

Tools

Microsoft Integration Services

Job description

The University of Chicago seeks a Business Intelligence & Analytics Analyst to design, develop, and support data integration, modeling, and enterprise reporting solutions. You will build ETL processes, maintain data structures, ensure data quality and security, and support BI applications across academic, administrative, and clinical areas.

Responsibilities include designing ETL processes, dimensional models, and optimized SQL; translating requirements into technical solutions; and documenting