Business Information Systems Analyst I - Public Utilities

City of Anaheim; Anaheim (CA); Presencial; USD 65.000 - 90.000; Jornada completa

Descripción de la vacante

The City of Anaheim Public Utilities Department is seeking two dynamic Business Information Systems Analysts I for the CIS and Technology Development teams. You will analyze business needs, design system solutions, develop queries, and support public utilities information systems.

You will work on planning, requirements analysis, design, implementation, testing, documentation, training, and go-live activities with COTS software and various data systems.

Formación

• One year of experience in systems administration and project management related to automated systems.
• Bachelor's degree from an accredited college or university in computer science, BIS, or related field.
• Proficiency in operational and analytical aspects of business information systems; software knowledge and documentation.

Responsabilidades

• Provide technical and administrative support for automated systems and vendor-supported applications.
• Participate in implementation, testing, problem resolution and procedure development for department technology.
• Coordinate with vendors and internal staff for training and procedures on new systems.
• Develop data flow diagrams and process flow analyses for current and new automation.
• Develop specifications for system modifications and interfaces; coordinate with multiple vendors.
• Coordinate documentation and training for new systems; ensure proper vendor interaction and project delivery.
• Support vendor technical staff on hardware and software projects and issue resolution.
• Develop test plans, data, and scripts; supervise testing and production readiness.
• Create custom reports and queries; manage data extracts and reporting templates.
• Administer servers/workstations and manage system security and access.
• Generate standard/custom outputs like reports, diagrams, exhibits, maps.

Conocimientos

Business analysis

Systems analysis

Communication

SQL queries

COTS integration

Vendor coordination

Educación

Bachelor's degree in computer science or related field

Herramientas

SQL

C#

VB.NET

Java

Python

HTML/JavaScript

Oracle

SQL Server

Descripción del empleo

The City of Anaheim Public Utilities Departmentseeks two dynamic Business Information Systems Analyst I professionals, one for the Customer Information Systems (CIS) team and one for the Technology Development team. These Business Information Systems (BIS) Analysts 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.

The BIS Analyst will work with commercial-off-the-shelf (COTS) software, database, and systems integration tools. The BIS Analyst should be detail-oriented and able to develop SQL database queries and reports.

The BIS Analyst may work with the following types of systems. Experience with these are preferred but not required.

• Utility Billing and Customer Information System (CIS)
• Customer Web Portals
• Meter Data Management System (MDMS) and Advanced Meter Infrastructure (AMI)
• Field Service / Work Order System
• Cashiering and Payment Systems
• Contact Center Solution and Interactive Voice Response (IVR)
• Enterprise Asset Management (EAM)
• Computerized Maintenance Management (CMMS)
• Enterprise Resource Planning (ERP) / Financial System
• Middleware, Enterprise Service Bus, and / or Systems Integration Platform / Tools

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, 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 specification documentation for 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.

• Develop requirements for test, and support software applications. Verify that programs are debugged and provide desired results. Design and develop 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.

Experience and Education

Experience and Education: One year of experience in systems administration and 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. 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. 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; write complex custom applications using languages such as C#, VB.NET, Java, and Python; develop web pages and applications using HTML and JavaScript; understand and apply programming logic and interpret programming code; 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.

License/Certification Required

License/Certification Required: Possession of a valid driver's license.

Equal Opportunity Employer