Business Systems Analyst (7583U), Facilities Services - #71438

$74,880 - $94,994/Yr

University of California - Berkeley, CA

Full-time - Entry Level

Berkeley, CA

251-500 employees

Educational Services

About the position

The Business Systems Analyst position at the University of California, Berkeley, is a vital role within the Facilities Services department, focusing on the IBM Maximo computer maintenance management system (CMMS). This position is responsible for supporting the system through regular financial reporting activities, planning, performing, and implementing system improvements and initiatives. The analyst will ensure that the system operates as intended and will evaluate areas where modifications may be necessary. The role encompasses various functions, including requirements data gathering, best practice research, process mapping and design, testing, and support. Additionally, the analyst will be tasked with developing effective reports to aid in decision-making and operational efficiency. The Facilities Services department is dedicated to enhancing the campus environment in collaboration with all university community members. With over 500 staff members, the department manages a wide range of services, including asset management, custodial services, maintenance operations, and environmental services. The Business Systems Analyst will play a crucial role in ensuring that the systems in place support the university's mission of teaching, learning, and research. This position requires a proactive approach to problem-solving and a commitment to continuous improvement, as the analyst will work closely with various stakeholders to gather and analyze functional business requirements, validate end-user needs, and assist in the implementation of system changes. In this role, the analyst will also be responsible for processing and developing SQL scripts or queries to update and evaluate backend database information, applying programming best practices, and assisting with project plan development and end-user documentation. The position requires a thorough understanding of relational database concepts and the ability to communicate technical information effectively to both technical and non-technical personnel. The analyst will also analyze existing and potential software integrations, providing support for effective data processing between different software systems, including financial software and reporting tools like Tableau. Overall, this position is integral to the success of Facilities Services and the broader mission of UC Berkeley.

Responsibilities

• Evaluates existing configuration of IBM Maximo computer maintenance management system (CMMS) to resolve issues and/or implement improvements.
• Analyze business processes and problems to understand and validate functional business requirements to meet end-user needs.
• Gathers, analyzes and documents functional business requirements.
• Communicates and coordinates with other workgroups to regularly balance financial information from the CMMS to process external client charges.
• Evaluate and validate incoming improvement or troubleshooting requests.
• Assist with planning, developing and testing any changes to IBM Maximo system considering the units existing business processes, needs and system integrations.
• Conduct and verify end-user need and acceptance.
• Process and develop SQL scripts and or queries to update and/or evaluate backend database information.
• Apply programming best practices with proper documentation.
• Assists with project plan development and end user documentation.
• Gathers and analyzes data to prepare business process and procedural documentation.
• Assists with implementation of changes in development, maintenance, system standards and in the creation of specifications.
• Analyze existing and potential software integrations and provides support for defining effective data processing between different software.
• Assist with maintaining web and mobile solutions to provide accessible information to clients.

Requirements

• Demonstrated ability to work with others from diverse backgrounds.
• Thorough understanding of relational database concepts.
• Self-motivated and works independently and as part of a team.
• Able to learn effectively and meet deadlines.
• Demonstrates problem-solving skills.
• Knowledge related to software design, planning, testing, and user acceptance processes.
• Knowledge of a variety of software programs that might include CMMS, Tableau, BIRT or Cognos reporting, FME, GIS.
• Skills associated with analysis of business processes and issues of moderate scope, information flow and architecture.
• Demonstrated effective communication and interpersonal skills.
• Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization.
• Interpersonal and communications skills to work with both technical and non-technical personnel at various levels in the organization.
• Knowledge of other related areas of IT; server infrastructure, backup and recovery planning and implementation, and security configurations.
• Bachelor's degree in related area and/or equivalent experience/training.

Benefits

• Comprehensive benefits package offered by the University of California.
• At least 80 hours (10 days) of paid time per year for professional development activities.