Business Intelligence & Analytics Specialist

The job develops and implements analytic programs and supports the use of analytic platforms and administrative data across the University. 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.

This role serves as the primary data analytics and business intelligence resource supporting BSD Facilities Services; 4.5M 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.

Responsibilities

• 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 mange 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 ServiceNow, eBuilder, OpenSensor 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 ServiceNow point-person for BSD Facilities Services.
• Manage software licenses (AutoCAD, Archibus).
• Maintain service accounts and automation infrastructure.
• Coordinate SSO/SAML integrations (OpenSensor, 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 requirements include a college or university degree in 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 ServiceNow, eBuilder, or similar project management platforms.
• API integration experience.

Working Conditions

• Office environment (hybrid schedule).

The University of Chicago biomedical enterprise houses three entities: the Biological Sciences Division (BSD), the University of Chicago Medicine (UCM), and the Pritzker School of Medicine. Collectively called UCM, we are one of the nation’s leading academic medical institutions and have been at the forefront of discovery, education, and clinical care since 1927. Located 20 minutes south of downtown Chicago, our Hyde Park main campus provides a single environment for learning, world-renowned basic science and clinical research, and outstanding clinical care. The BSD is the largest academic unit within the University.

The BSD is comprised of faculty from ten basic science departments, 13 clinical departments, and several Centers and Institutes. The approximately 1,300 faculty and 3,000 staff members working in the BSD collaborate across the organization to achieve our Mission, Vision, and Values (MVV):

MISSION: As part of the University of Chicago, we pursue globally impactful solutions to seemingly unsolvable challenges. Through our rigorous research, innovative education, and comprehensive care and healing, we collaborate on life-changing advancements that create meaningful results for our community and the world, including a greater, more equitable future for all.

VISION: Together, we elevate the human experience with knowledge and health care.

VALUES:

• Commit to Excellence: We contribute our exceptional talents to all we do and empower the same spirit of excellence in others .* Embrace Curiosity: We stay open to new ideas, champion diverse perspectives, and drive a culture of thoughtful risk-taking to deliver transformative innovation.

• Embody Equity: We identify systemic issues and then foster change to drive a more equitable environment inclusive of diverse people, ideas, and fields of science.

• Grow Together: We meaningfully collaborate with one another to create something bigger than we could ever achieve alone .* Make a Difference: We lead with heart and compassion in all our interactions. We create positive change in our areas of influence, whether expanding scientific inquiry, developing the next generation of leaders, or healing our community.

• Take Ownership: We accomplish what we say we will and hold ourselves and one another accountable for our actions.

The MVV serves as our True North, charting our strategic plan for the next ten years and beyond. It is an exciting time to be a part of the University of Chicago and the BSD. Our team is helping to shape the future for our learners, staff, faculty, patients, and community.