Business Intelligence & Analytics Specialist

About the department

The University of Chicago biomedical enterprise comprises three entities: the Biological Sciences Division (BSD), the University of Chicago Medicine (UCM), and the Pritzker School of Medicine. Collectively known as UCM, we are a leading academic medical institution founded in 1927. Located 20 minutes south of downtown Chicago, our Hyde Park main campus offers a unique environment for learning, research, and clinical care. The BSD is the largest academic unit within the University, comprising ten basic science departments, thirteen clinical departments, and several centers and institutes. With approximately 1,300 faculty and 3,000 staff members, the BSD collaborates across the organization to achieve its mission, vision, and values.

Job Summary

This role develops and implements analytic programs and supports the use of analytic platforms and administrative data across the University. The position reviews administrative data for joint analyses across multiple domains, partners with functional stewards, business units, and user partners to develop reporting and analytic solutions with appropriate data governance and secure access, and serves as the primary data analytics and business intelligence resource supporting BSD Facilities Services. The role manages enterprise space management systems, produces operational dashboards and reports, and maintains critical data infrastructure that drives space planning decisions and supports $255M+ in annual research expenditures. The position bridges facilities operations and IT, requiring both technical depth and an understanding of academic research facility management.

Responsibilities

• Designs, creates, and supports dimensional data models for academic, administrative, and clinical functions.
• Gathers and vets data definitions for new solution implementation.
• Ensures security and compliance.
• Implements changes that lead to continuous improvement in customer service.
• Administers user roles, permissions, and vendor relationships.
• Generates themed PDF reports and space utilization outputs.
• Compiles Modified Total Direct Cost (MTDC) data for space performance metrics (MTDC/SF).
• In coordination with others, produces annual PowerPoint decks for executive summaries.
• Extracts and transforms data from ServiceNow, eBuilder, OpenSensor APIs, and Oracle databases.
• Manages automation scripts for nightly data pulls and file synchronization.
• Collaborates on institutional survey responses (AAMC, NSF HERD, LCME).
• Serves as ServiceNow point-person for BSD Facilities Services.
• Maintains software licenses (AutoCAD, Archibus).
• Maintains service accounts and automation infrastructure.
• Coordinates SSO/SAML integrations (OpenSensor, Booking Software).
• Manages BSDFS website user access.
• Supports internal communications and administrative resource delivery.
• Works with users to ensure deliverables are meeting or exceeding expectations.
• Provides support and communicates issues to users as defined by IT standards.
• Guides requirements analysis, translates requirements into a scope document and develops reporting deliverables based on the design.
• Performs other related work as needed.

Education

• Minimum requirements include a college or university degree in a related field.
• Minimum requirements include 5-7 years of work experience in a related job discipline.
• Preferred qualifications include 5+ years experience with business intelligence tools, experience with enterprise space/facilities management systems (Archibus helpful), proficiency in SQL database programming, proficiency in ETL processes and concepts, proficiency in scripting languages (such as Python, R, etc.), experience with Apache Airflow, DAGs (Directed acyclic graphs), strong analytical and problem-solving skills, experience in academic or healthcare facilities environment, experience with LLM tools (such as ChatGPT, Claude, Gemini, etc.), experience with ServiceNow, eBuilder, or similar project management platforms, API integration experience.