Associate Business Systems Consultant

Caltech is a world-renowned science and engineering institute that marshals some of the world''s brightest minds and most innovative tools to address fundamental scientific questions. We thrive on finding and cultivating talented people who are passionate about what they do. Join us and be a part of the diverse Caltech community.

Job Summary

Reporting to the Facilities Information Systems Manager, the Associate Business Systems Consultant will be part of a small team responsible for the following:

• Design, implement, enhance and maintain solutions for Facilities business applications (IWMS AiM, ArcGIS, Power BI models, and other applications.
• Utilize best business practices, perform tasks such as gathering requirements, identifying/evaluating software and solutions that meet the needs of Facilities and the Campus community.
• Coordinate, analyze, and develop systems and/or processes, which are cost effective and meet user requirements.
• Troubleshooting issues within Facilities business applications and working with the Support teams to resolve issues.
• Working with key technology partners, develop and sustain Caltech's digital twin model and associated management tools, SkySpark, etc.

Essential Job Duties

• Provides a full range of Information Systems Services including implementation of new applications/modules, Power BI/SQL programming, user support, data management, and training.
• Participates in the entire lifecycle of a system which includes but is not limited to gathering requirements, analyzing, planning, design, configuration, testing, deployment, roll out and maintenance.
• Works with the customer to facilitate negotiating, and capture requirements for enterprise and/or standalone applications.
• Creates and modifies software training documentation and works with users to understand Facilities software systems.
• Independently perform data validation and module testing.
• Provides consultation to system users on technical and/or functional issues.
• Analysis of situations or data requires identification, review and interpretation of policies, procedures and practices.
• Troubleshoots and resolves customer inquiries effectively.
• Exercises judgment and discretion in applying applicable policies and procedures to situations and significant problems.

Basic Qualifications

• Bachelor's degree or equivalent experience with at least four years of related experience
• Proficient with Microsoft Office Suite of applications.
• Working knowledge of Power BI, SQL, DAX, R, and Power Query (M) with experience developing reports, dashboards, data models, and business intelligence solutions.
• Experience developing Power BI dashboards and data models to support business reporting and operational decision-making.
• Experience in creating and maintaining business process documentation, training materials, and reporting solutions to support system users and continuous improvement initiatives.
• Must have implementation experience.
• Demonstrated problem-solving skills, and supportive and team-oriented.
• Effective verbal and written communication skills.
• Collaborative work style and ability to adapt to changes in priorities, assignments, and more.
• Proven ability to adapt vendor-provided documentation and train customers in the use of software
• Ability to take personal initiative and leverage problem-solving skills to figure out how business software functions and how it interfaces with other applications.
• Must be able to support the evaluation, implementation, testing, and adoption of business applications and AI-enabled solutions to improve operational efficiency, data accessibility, and decision-making.
• Demonstrated ability to utilize AI and automation to reduce manual processes, improve data quality, and enhance decision support capabilities.
• Experience assisting with system configuration, user acceptance testing (UAT), data validation, troubleshooting, and end-user training to support successful application deployments.

Preferred Qualifications

• Master's degree in Business Analytics.
• Experience in higher education.
• Experience supporting initiatives for a large, complex facility.
• Experience conducting software quality assurance testing.

Required Documents

• Resume.