Business Intelligence & Analytics Specialist

Job Summary

The role develops and implements analytic programs and supports the use of analytic platforms and administrative data across the University. It reviews administrative data for joint analyses across multiple domains and partners with functional stewards, business units, and user partners to develop reporting and analytic solutions with appropriate data governance and secure access.

This role serves as the primary data analytics and business intelligence resource supporting BSD Facilities Services; overseeing a 4.5 M GSF portfolio across 50 buildings. The position 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 role bridges facilities operations and IT, requiring both technical depth and an understanding of academic research facility management.

• Designs, creates, and supports dimensional data models for academic, administrative, and clinical functions.
• Gather and vet data definitions for new solution implementation.
• Ensures security and compliance.
• Implement changes that lead to continuous improvement in customer service.
• Administer user roles, permissions, and vendor relationships.
• Generate themed PDF reports and space utilization outputs.
• Support system upgrades, testing, and post-upgrade enhancements.
• Develop, maintain and manage access to Tableau dashboards and reports.
• Compile Modified Total Direct Cost (MTDC) data for space performance metrics (MTDC/SF).
• In coordination with others, produce annual PowerPoint decks for executive summaries.
• Extract and transform data from Service Now, eBuilder, Open Sensor APIs, and Oracle databases.
• Manage automation scripts for nightly data pulls and file synchronization.
• Coordinate institutional survey responses (AAMC, NSF HERD, LCME).
• Support Workday integration and building data management.
• Serve as Service Now point-person for BSD Facilities Services.
• Manage software licenses (AutoCAD, Archibus).
• Maintain service accounts and automation infrastructure.
• Coordinate SSO/SAML integrations (Open Sensor, Booking Software).
• Manage BSDFS website user access.
• Support 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, translating requirements into a scope document and developing reporting deliverables based on the design.
• Performs other related work as needed.

Minimum Qualifications: Minimum requirements include a college or university degree in a related field.

Work Experience: Minimum requirements include knowledge and skills developed through 5–7 years of work experience in a related job discipline.

• 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 Service Now, eBuilder, or similar project management platforms.
• API integration experience.

• Office environment (hybrid schedule).

• Resume/CV (required)
• Cover Letter (preferred)

Information Technology

Individual Contributor

37.5

No

No

No

Salary

Exempt

$90,000.00 – $

Yes

The University of Chicago offers a wide range of benefits programs and resources for eligible employees, including health, retirement, and paid time off. Information about the benefit offerings can be found in the Benefits Guidebook.

The University of Chicago is an equal…