Facilities AI & Data Solutions Consultant

University of California; Pasadena (CA); On-site; USD 140,404,992 - 165,477,312; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Retirement plans

Paid time off

Tuition reimbursement

Job summary

Caltech in Pasadena seeks an Associate Business Systems Consultant reporting to the Facilities Information Systems Manager. You will design, implement, and maintain solutions for facilities applications including IWMS AiM, ArcGIS, and Power BI models to support campus operations.

Responsibilities include gathering requirements, data modeling, testing, deployment, and user training; collaborating with technology partners to advance AI-enabled workflows and digital twin tools like SkySpark; and

Qualifications

• Bachelor’s degree or equivalent experience with 4+ years in information systems or business analytics.
• Proficiency in Power BI, SQL, DAX, R and Power Query with dashboard/data model development.
• Experience implementing and maintaining business applications and BI solutions.
• Strong problem solving, communication, and collaborative work style.

Responsibilities

• Design, implement, enhance and maintain facilities business apps (IWMS AiM, ArcGIS, Power BI models).
• Gather requirements, evaluate software and define solutions for Facilities and Campus.
• Develop systems and processes that are cost effective and meet user needs.
• Troubleshoot issues and coordinate with support teams.
• Create training materials and provide end-user training and data validation.
• Assist with data validation, UAT, testing and deployment across modules.

Skills

Power BI

SQL

DAX

R

Power Query

Office suite

Dashboard development

Education

Bachelor's degree or equivalent experience

Master's degree (preferred)

Tools

IWMS AiM

ArcGIS

SkySpark

Job description

Caltech in Pasadena seeks an Associate Business Systems Consultant reporting to the Facilities Information Systems Manager. You will design, implement, and maintain solutions for facilities applications including IWMS AiM, ArcGIS, and Power BI models to support campus operations.

Responsibilities include gathering requirements, data modeling, testing, deployment, and user training; collaborating with technology partners to advance AI-enabled workflows and digital twin tools like SkySpark; and