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 DocumentsHiring Range$49.00 - $57.75 Per Hour
The salary of the finalist(s) selected for this role will be set based on a variety of factors, including but not limited to, internal equity, experience, education, specialty and training.
As one of the largest employers in Pasadena, CA, Caltech is committed to providing comprehensive benefits to eligible employees and their eligible dependents. Our benefits package includes competitive compensation, health, dental, and vision insurance, retirement savings plans, generous paid time off (vacation, holidays, sick time, parental leave, bereavement, etc.), tuition reimbursement, and more. Non-benefit eligible employees will have access to some benefits such as onsite counseling and sick time. Learn more about our benefits and staff perks.
