Strategic BI & Analytics Analyst

uchicago; Chicago (IL); On-site; USD 70,000 - 110,000; Full time

Job summary

The University of Chicago is seeking a Business Intelligence & Analytics Analyst to design, develop, and support data integration, modeling, and BI solutions across academic, administrative, and clinical areas.

Responsibilities include ETL development, data modeling, SQL optimization, and ensuring data quality and security. Candidates should have 2–5 years in BI/analytics and a strong SQL/ETL background.

Qualifications

• Bachelor’s degree in computer science, information systems, data science, engineering, business analytics, healthcare analytics, or a related analytical or STEM field strongly preferred.
• 2-5 years of professional experience in data engineering, analytics engineering, business intelligence, healthcare analytics, or related technical roles strongly preferred.
• Demonstrated experience writing optimized SQL queries, stored procedures, and data transformation logic strongly preferred.
• Demonstrated experience working with large and complex datasets across multiple enterprise systems strongly preferred.
• Experience supporting analytics reporting, automated workflows, or ETL/data integration processes strongly preferred.
• Proficient in Microsoft SQL, Power BI and Tableau; SSIS in ETL workflows.

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.
• Ensure data quality, integrity, security, access control, and compliance.
• Support software upgrades, testing, deployment activities, and continuous improvement efforts.
• Plans and executes requirements analysis, translating requirements into a scope document and developing reporting deliverables based on the design.
• Works with users to ensure deliverables are meeting or exceeding expectations. Provides support and communicates issues to users as defined by IT standards.
• Performs other related work as needed.

Skills

Analytical thinking

Communication skills

Problem solving

Education

Bachelor’s degree in Computer Science, Information Systems, Data Science, Engineering, Business Analytics, Healthcare Analytics, or related STEM field

Tools

Power BI

Tableau

Microsoft Integration Services

SQL

Data warehousing concepts

Job description

The University of Chicago is seeking a Business Intelligence & Analytics Analyst to design, develop, and support data integration, modeling, and BI solutions across academic, administrative, and clinical areas.

Responsibilities include ETL development, data modeling, SQL optimization, and ensuring data quality and security. Candidates should have 2–5 years in BI/analytics and a strong SQL/ETL background.