Description

The City of Anaheim Public Utilities Department seeks a dynamic Business Information Systems Analyst I/II to join its Technology team. The Business Information Systems (BIS) Analyst should have good business and systems analysis, communication, and technical skills necessary to implement, administer and support Public Utilities information systems and processes.

The BIS Analyst will support and troubleshoot issues with existing systems as well as work on new projects and be involved with planning, requirements analysis, systems design, implementation, integration, reports development, testing, documentation, training, and go-live activities.

Most of the software the Analyst will work with will be commercial-off-the-shelf (COTS), not custom developed. However, the BIS Analyst will be expected to develop SQL database queries, be a critical thinker, and have an understanding of web service APIs and system integration concepts.

The BIS Analyst may support and work on the following types of systems and projects.

• Enterprise Asset Management (EAM)
• Computerized Maintenance Management (CMMS)
• Enterprise Resource Planning (ERP) / Financial System
• Systems Integration, Middleware, Extract, Transform, Load (ETL) Tools
• Data Queries, Report Writing, Analytics, Data Conversions

The BIS Analyst may play an operational role with some systems, such as running jobs, loading data, etc.

Experience with any of the following software applications is a plus: Oracle WAM or other EAM/CMMS systems (e.g.: IBM Maximo, Infor EAM, SAP), CGI Advantage or other ERP systems, and Spatial Wave. Experience with Utilities business processes are also a plus.

It is the City's sole discretion to fill this position at either level I or II based on qualifications.

DISTINGUISHING CHARACTERISTICS:
Business Information Systems Analyst I: This is the entry level class in the Business Information Systems Analyst series. This class is distinguished from the Business Information Systems Analyst II by the performance of the more routine tasks and duties assigned to employees within the series.

Business Information Systems Analyst II: This is the full journey level class in the Business Information Systems Analyst series. Employees within this class are distinguished from the Business Information Systems Analyst I by the performance of the full range of duties as assigned. Employees at this level receive only occasional instruction or assistance as new or unusual situations arise, and are fully aware of the operating procedures and policies of the work unit.

Essential Functions

The following functions are typical for this classification. Incumbents may not perform all of the listed functions and/or may be required to perform additional or different functions from those set forth below to address business needs and changing business practices.

• 
  Provide technical and administrative support for a variety of automated systems; provide user support on vendor supported systems including application updates, technical troubleshooting and development and maintenance of system documentation.
• Participate in the implementation, coordination, testing, and problem resolution and procedure development associated with department technology.
• Participate in negotiating acceptable issue resolution and required delivery schedules with vendors.
• Review new technology to determine feasibility and technical coordination with existing systems; prepare data flow diagrams and process flow analysis for current and new automation to ensure maximum system utilization and tasks assigned to correct work unit.
• Develop detailed specification documentation for complex system modifications and interfaces; coordinate developments with multiple vendors or other outside vendor until issue is resolved.
• Coordinate the development of documentation and implementation of training and procedures for new systems and programs; coordinate with vendors, internal technical staff, management, and system users.
• Support contracted vendor technical staff on hardware and software projects and issues resolution.
• Implement desktop and web-based applications. Verify and test that programs are debugged and provide desire results.
• Design and develop complex data base models and templates; write and edit programs for accessing, maintaining, linking and populating databases. Verify database integrity.
• Develop custom reports and queries based on user's needs and specifications; perform file extracts and queries; determine report specifications including layout.
• Administer servers and workstations by installing and troubleshooting system software and programs; administer system access and security.
• Generate standard and custom products such as reports, diagrams, exhibits, maps, and displays.
• Attend professional meetings and conferences to represent the department's needs and interests associated with modification requirements and future direction of current systems.
• Provide assistance with the development, preparation and evaluation of Requests for Proposal and contracts associated with computerized system acquisitions; gather all vendor and technical information and needs requirements; coordinate the review and approval of requests for proposals; assist with the evaluation of proposals and selection of vendor; assist with the preparation and approval of contracts; monitor contract compliance and maintenance agreements as assigned.
• Provide project management for modifications, interface programs, new systems, information systems, databases and annual updates; develop project plans, timelines, and test scripts; prepare test data and lead and conduct testing; evaluate and approve for implementation into a production environment.
• Develop technical specification documents including data mapping, field and file requirements; identify and coordinate resolution of issues and required modifications on proposed solutions; make recommendations to ensure technical success; design documentation and workflow of new and existing system specifications for integration; coordinate requirements, priorities and work between multiple vendors.
• Participate in the research, development, and preparation of technical services and related capital project budgets; monitor assigned budgets for technology capital projects.
• Perform and review daily, monthly and annual jobs and reports associates with departmental applications.
• Provide on-call support as required; research, analyze and resolve reported system issues.
• Provide escalation support and guidance during and after hours. Ensure all incidents are managed properly with the proper documentation and follow through.
• Perform related duties as required.

Qualifications

Business Information Systems Analyst I:

• One year of experience in systems administration, implementation, support and/or project management related to automated systems supplemented by a Bachelor's degree from an accredited college or university with major course work in computer science, business information systems, or a related field. An equivalent combination of experience and education sufficient to perform the essential job functions and provide the required knowledge and abilities is qualifying.

Business Information Systems Analyst II:

• Two years of experience in systems administration, implementation, support and/or project management related to automated systems supplemented by a Bachelor's degree from an accredited college or university with major course work in computer science, business information systems, or a related field. An equivalent combination of experience and education sufficient to perform the essential job functions and provide the required knowledge and abilities is qualifying.

Either level must demonstrate:

• Candidates must have knowledge of operations, services, and activities of a business information system program; application system software design, system application purposes, database configurations and process workflows; systems analysis, system operations, diagnosing, troubleshooting and general maintenance and repair standards; traditional business systems such as payroll, accounting, work management, customer billing, productivity software, and query software tools; utility billing rates and calculation methodology; public utility and customer service operations and procedures, database configurations; system modification; programming logic, computer operating systems and networks; computer system architecture, client/server and web-based protocols, local area network systems; specification development theory; analytical research techniques; technical writing, report generation and automation theories; training and procedure development; basic accounting and budgeting principles; record keeping methodology; best practices for tracking and evaluating system performance; software testing methodologies; documentation and organization of research findings and test results for efficient follow-up and record retention; principles, practices and techniques of automated system project management; principles of business letter writing and basic report preparation; office procedures, methods, and equipment including computers and applicable software applications such as word processing, spreadsheets, and databases; pertinent federal, state, and local laws, codes and regulations.
  
• Candidates must have the ability to manage phases and assignments of a system upgrade or installation project; effectively apply technical knowledge of automated systems hardware and software in the assistance and support of users; understand users needs and recommend system modifications compatible with environment, prepare documents for complex system modifications; potentially develop web pages and applications; understand and apply programming logic; understand Relational Database management Systems (RDBMS) such as Oracle and SQL Server and utilize RDBMS tools to create, install and maintain custom database applications; install, debug and resolve software and application problems; logically process technical information and effectively communicate with technical and non-technical personnel; perform system tests and evaluate data; gather, document and evaluate research; prepare comprehensive technical and informational reports; work independently; prioritize assignments; work well under pressure and with multiple deadlines; effectively solve problems and manage incident using the proper methodology and documentation; oversee and coordinate vendor technical staff on hardware and software projects and issues resolution; coordinate and provide user training; develop complex project plans and timelines; develop operational procedures and training documentation; make sound recommendations; communicate clearly and concisely, both orally and in writing; and establish and maintain effective working relationships with those contacted in the course of work.
  
• Possession of a valid California Class C driver's license.

Supplemental Information