Business Intelligence & Analytics Specialist
About The Position
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.
Requirements
- Minimum requirements include a college or university degree in related field.
- Minimum requirements include knowledge and skills developed through 5-7 years of work experience in a related job discipline.
Nice To Haves
- 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.
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.
Benefits
- health
- retirement
- paid time off
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
Associate degree
