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. 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 View phone number on click.appcast.io 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. #J-18808-Ljbffr Biological Sciences Division at the University of Chicago