Data-Driven BI & Analytics Analyst

Biological Sciences Division at the University of Chicago; Chicago (IL); On-site; USD 70,000 - 110,000; Full time

Benefits offered by this job

Health insurance

Retirement plan

Job summary

The University of Chicago is seeking a Business Intelligence & Analytics Analyst to design, develop, and support data integration, data modeling, and BI solutions across academic, administrative, and clinical areas. You will build ETL processes, maintain data quality and security, optimize SQL, and support reports and dashboards using Power BI and Tableau.

A Bachelor's degree and 2–5 years in data engineering or analytics are preferred; salary is competitive and includes a comprehensive benefits

Qualifications

• Bachelor's degree in a related analytical or STEM field required.
• 2-5 years of professional experience in data engineering, analytics engineering, BI, healthcare analytics, or related roles.
• 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.
• 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 meet expectations; monitors access control and troubleshoots BI applications.

Skills

Microsoft SQL

Power BI

Tableau

ETL/ELT

SQL optimization

Data warehousing

Education

Bachelor's degree in CS/IS/Data Science/Engineering/Business Analytics

Tools

Microsoft Integration Services

Job description

The University of Chicago is seeking a Business Intelligence & Analytics Analyst to design, develop, and support data integration, data modeling, and BI solutions across academic, administrative, and clinical areas. You will build ETL processes, maintain data quality and security, optimize SQL, and support reports and dashboards using Power BI and Tableau.

A Bachelor's degree and 2–5 years in data engineering or analytics are preferred; salary is competitive and includes a comprehensive benefits