Computer Systems Analyst (Non-Competitive)

General Statement of Duties

Greater Cincinnati Water Works is seeking to fill a Computer Systems Analyst position with a candidate who possesses experience developing applications and integrations that support and enhance meter to cash operations. The person filling this position will be required to provide excellent customer service to internal and external customers, participate in project teams, and communicate effectively to all levels of the organization.

This employee performs a variety of complex technical duties related to the analysis of city, county, and criminal justice agencies' data processing needs. Employee designs, tests, and implements systems and performs modifications to existing computer applications. Performs related duties as required.

Minimum Qualifications (KSAs)

(Illustrative only. Any one position may not require all of the listed KSAs nor do the listed examples include all the KSAs which may be required.)

Knowledge of:(One or more of the following categories may be required.)

All Categories:

Data processing applications such as geographical information systems, financial systems, human resources, court management, and other management information systems.

Standard programming languages.

Design, installation, and maintenance of enterprise distributed client server and desktop computer systems.

Principles and practices of computer network systems analysis and design.

Current trends and new technologies in data processing.

Desktop software packages and operating systems.

Principles of effective documentation.

Effective customer service.

Operating Systems:

Methods and practices of installation for upgrading of client servers and desktop computer hardware and software.

Computer system configurations.

Operating system structures.

Networking:

Principles of computer network systems analysis and design.

Local area network hardware and transmission protocols.

Data communication concepts and principles.

Internet and intranet architecture.

Network security policies, techniques, and procedures.

Network configuration, maintenance, and diagnostic procedures and techniques.

Licensing Agreement enforcement.

Analyze network communication requirements

Troubleshoot and resolve network hardware and software problems.

Use and maintain networking test equipment.

Lead a technical team in developing network infrastructure.

Programming:

Computer operating systems/hardware.

Program design and analysis.

Principles and techniques of programming.

Programming languages (Java, C, C++, Visual Basic, etc.) and utilities.

Database Administration:

Database management systems.

Database design.

Database tools.

Data/file management tools.

Database utilities.

Data warehouse and multi dimensions.

File and data recovery.

Database security methods and techniques.

Physical control standards and procedures.

Database software (Oracle, SQL, etc.)

Manage a multiple data base environment.

Develop procedures and means of storage for archiving data.

Web:

In-depth graphic design.

User interface design.

Advertising and marketing.

Information architecture.

Management of e-commerce.

Front-end web code such as HTML and JavaScript.

Business:

Business systems analysis.

Business software packages.

GIS:

Desktop GIS software for analysis, query, and visualization (e.g., ESRI's ArcView).

WEB-based GIS application interfaces and data presentation.

Desktop or Workstation GIS advanced software for data creation, geo processing, and conversion (e.g., ESRI's Arc Info).

Geo-locational and Geo-relational dataset concepts and database structures.

Engineering/surveying principles and practices as related to GIS and GPS (global positioning systems) applications.

Interface and integration of GIS database systems with other public enterprise systems such as permitting, licensing, and financial systems.

Skill to: (All Categories)

Install, configure, upgrade, and maintain hardware and software, including that related to local and wide area networks.

Troubleshoot and resolve network hardware and software problems.

Use and maintain networking test equipment.

Ability to: (All Categories)

Prepare clear and concise reports and technical documents.

Develop and recommend cost effective improvements for technical systems.

Implement systems based on design specifications and instructions.

Recommend purchase of computer equipment, services, and supplies.

Plan, analyze, design, program, test, debug, document, and maintain various systems and applications.

Design and develop software to facilitate inter-operability of software programs and data sharing.

Analyze network communication requirements.

Manage a multiple data base environment.

Develop procedures and means of storage for archiving data.

Lead a technical team in developing network infrastructure.

Design a client workflow using multiple software to accomplish a group of tasks.

Coordinate, prepare, and review requests for proposals to accomplish design objectives.

Develop and apply various criteria to evaluate contract bids and recommend selections (as assigned).

Required Education and Experience

PROMOTIONAL:

Each applicant must have three years of experience as a Senior Computer Programmer Analyst with the City of Cincinnati plus a Bachelor's Degree from an accredited college or university with a major in computer science, information technology, computer programming, criminal justice, geography, or a related field.

OR

Each applicant must have five years of experience as a Senior Computer Programmer Analyst with the City of Cincinnati plus an Associate's Degree from an accredited college or university with a major in computer science, information technology, computer programming, criminal justice, geography, or a related field.

OPEN:

Each applicant must have four years of senior-level paid professional experience in information technology or information systems, plus a Bachelor's Degree from an accredited college or university with major course work in GIS, geography, planning, information technology, computer science or a related field.

OR

Each applicant must have six years of senior-level paid professional experience in information technology or information systems, plus an Associate's Degree from an accredited college or university with major course work in GIS, geography, planning, information technology, computer science or a related field.

OTHER REQUIREMENTS

A valid Driver's License is required for some positions.

Some positions may require a criminal background investigation and fingerprinting due to the sensitive nature of the work.

May be required to work irregular hours and be on-call.

MILITARY EDUCATION & EXPERIENCE EVALUATION

Military education and experience may be substituted for college level course work at the lower and upper division baccalaureate and graduate levels and apprenticeship training at the vocational certificate level on a case-by-casebasis based on the American Council on Education (ACE) Military Guide recommendations.

Working and Physical Conditions

Environmental Conditions: Office environment, exposure to computer screens; travel to sites within the City/Hamilton County may be required.

Physical Conditions: Duties require maintaining physical condition necessary for sitting and standing for prolonged periods of time; general manual dexterity; must be able to operate assigned vehicle (as required).