Business Intelligence & Analytics Specialist

University of Chicago; Chicago (IL); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Health benefits

Retirement plans

Paid time off

Job summary

The University of Chicago is looking for a skilled data analytics professional to join their Facilities Services team. The role involves developing and implementing analytic programs for a significant portfolio, managing systems like Archibus and Tableau, and supporting space planning decisions. Candidates should have 5-7 years of experience in a related field, strong skills in business intelligence tools, SQL, and scripting languages. This is a hybrid office position with a competitive salary range of $90,000 to $130,000.

Qualifications

• Minimum of 5–7 years of work experience in a related job discipline.
• Experience in academic or healthcare facilities environment is preferred.

Responsibilities

• Design and support dimensional data models for various functions.
• Generate themed reports and ensure compliance.
• Manage software licenses and maintain critical data infrastructure.

Skills

Business intelligence tools

SQL database programming

ETL processes

Scripting languages (Python, R)

Analytical and problem-solving skills

API integration

Education

College or university degree in a related field

Tools

Archibus

ServiceNow

eBuilder

Tableau

Apache Airflow

Job description

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.

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 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 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.

Qualifications

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.

Preferred Qualifications

• 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).

Application Documents

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

Job Family

Information Technology

Role Impact

Individual Contributor

Weekly Hours

37.5

Drug Test Required

No

Health Screen Required

No

Motor Vehicle Record Inquiry Required

No

Pay Rate Type

Salary

FLSA Status

Exempt

Pay Range

$90,000.00 – $130,000.00

Benefits Eligible

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.

EEO Statement

The University of Chicago is an equal opportunity employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender, gender identity, or expression, national or ethnic origin, shared ancestry, age, status as an individual with a disability, military or veteran status, genetic information, or other protected classes under the law. For additional information please see the University's Notice of Nondiscrimination.

Job seekers in need of a reasonable accommodation to complete the application process should call 773‑702‑5800 or submit a request via Applicant Inquiry Form.

Background Check

All offers of employment are contingent upon a background check that includes a review of conviction history. A conviction does not automatically preclude University employment. Rather, the University considers conviction information on a case‑by‑case basis and assesses the nature of the offense, the circumstances surrounding it, the proximity in time of the conviction, and its relevance to the position.