Business Information Systems Analyst I - Public Utilities

City of Anaheim•Anaheim, CA

About The Position

The City of Anaheim Public Utilities Department is hiring two Business Information Systems Analyst I professionals: one for the Customer Information Systems (CIS) team and one for the Technology Development team. The role calls for business and systems analysis, communication, and technical skills to implement, administer, and support department information systems and processes. Analysts support and troubleshoot existing systems and contribute to new projects throughout planning, requirements analysis, systems design, implementation, integration, report development, testing, documentation, training, and go-live activities. Work includes commercial-off-the-shelf software, databases, and systems integration tools, including developing SQL queries and reports. Experience with the listed utility and enterprise systems is preferred but not required. The analyst provides technical and administrative support for automated systems, participates in system implementations and vendor coordination, develops database models, queries, reports, specifications, and test materials, and administers system access, security, servers, and workstations. The role may include project management, budgets, training, procurement support, and on-call and after-hours escalation support. Applicants must have one year of systems administration and project management experience related to automated systems, supplemented by a relevant bachelor's degree, or an equivalent combination of education and experience. A valid driver's license is required.

Requirements

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 coursework in computer science, business information systems, or a related field; an equivalent combination of education and experience sufficient to perform the essential functions is qualifying.
Possession of a valid driver's license.
Knowledge of business information systems, application software design and purposes, database configurations, and process workflows.
Knowledge of systems analysis, system operations, troubleshooting, and maintenance and repair standards.
Knowledge of traditional business systems, including payroll, accounting, work management, customer billing, productivity software, and query tools.
Knowledge of utility billing rates and calculation methodology and public utility and customer service operations and procedures.
Knowledge of system modification, programming logic, operating systems, networks, computer architecture, client/server and web protocols, and local area networks.
Knowledge of specification development, analytical research, technical writing, report generation, automation, training and procedure development, basic accounting and budgeting, record keeping, and system performance evaluation.
Knowledge of software testing methodologies, research and test-result documentation, and automated-system project management.
Knowledge of business letter writing, report preparation, office procedures, computers, word processing, spreadsheets, databases, and pertinent federal, state, and local laws, codes, and regulations.
Ability to manage phases and assignments of system upgrade or installation projects and apply technical knowledge to support system users.
Ability to understand user needs, recommend compatible system modifications, and prepare documentation for complex modifications.
Ability to write complex custom applications using languages such as C#, VB.NET, Java, and Python, and develop web pages and applications using HTML and JavaScript.
Ability to understand programming logic and interpret code; use relational database management systems such as Oracle and SQL Server and their tools to create, install, and maintain custom database applications.
Ability to install, debug, and resolve software and application problems; perform system tests and evaluate data.
Ability to process technical information and communicate effectively with technical and non-technical personnel.
Ability to gather, document, and evaluate research; prepare comprehensive technical and informational reports; work independently; prioritize assignments; and work under pressure with multiple deadlines.
Ability to solve problems and manage incidents using appropriate methodology and documentation; oversee and coordinate vendor technical staff; and coordinate and provide user training.
Ability to develop complex project plans, timelines, operational procedures, and training documentation; make sound recommendations; communicate clearly orally and in writing; and establish and maintain effective working relationships.

Nice To Haves

Experience with utility billing and customer information systems (CIS).
Experience with customer web portals.
Experience with meter data management systems (MDMS) and advanced meter infrastructure (AMI).
Experience with field service or work order systems.
Experience with cashiering and payment systems.
Experience with contact center solutions and interactive voice response (IVR).
Experience with enterprise asset management (EAM) or computerized maintenance management systems (CMMS).
Experience with enterprise resource planning (ERP) or financial systems.
Experience with middleware, enterprise service buses, or systems integration platforms and tools.

Responsibilities

Provide technical and administrative support for automated systems, including user support, vendor-system updates, troubleshooting, and system documentation.
Participate in technology implementation, coordination, testing, problem resolution, and procedure development.
Coordinate vendor issue resolution, delivery schedules, system modifications, interfaces, and technical work across vendors and internal stakeholders.
Evaluate new technology for feasibility and compatibility; prepare data-flow diagrams and process-flow analyses.
Develop requirements, specifications, data mappings, field and file requirements, and integration and workflow documentation.
Coordinate development of training, procedures, and documentation for new systems and programs.
Support vendor technical staff on hardware and software projects and resolve related issues.
Develop software testing requirements, verify and debug programs, and evaluate results before implementation.
Design and develop database models and templates; write and edit programs for database access, maintenance, linking, and population; verify database integrity.
Develop custom reports and queries, perform file extracts, and define report specifications and layouts.
Administer servers and workstations, install and troubleshoot system software and programs, and administer system access and security.
Generate standard and custom reports, diagrams, exhibits, maps, and displays.
Represent department needs at professional meetings and conferences concerning system modifications and future direction.
Assist with requests for proposals and contracts for computerized systems, including gathering requirements, coordinating reviews, evaluating proposals, supporting vendor selection, and monitoring contract compliance and maintenance agreements.
Manage projects for system modifications, interfaces, new systems, and databases by developing plans, schedules, timelines, test scripts, and test data; lead testing and evaluate and approve production implementation.
Coordinate requirements, priorities, work, and issue resolution among vendors and other stakeholders; make recommendations to ensure technical success.
Participate in research and preparation of technical services and capital project budgets and monitor assigned technology budgets.
Perform and review daily, monthly, and annual application jobs and reports.
Provide on-call and after-hours escalation support as required; research, analyze, and resolve reported system issues and ensure incidents are documented and followed through.
Perform related duties as required.