Computer Systems Analyst

City of Cincinnati•Ohio 45202, OH

23h•Onsite

About The Position

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.

Requirements

Knowledge of data processing applications such as geographical information systems, financial systems, human resources, court management, and other management information systems.
Knowledge of standard programming languages.
Knowledge of design, installation, and maintenance of enterprise distributed client server and desktop computer systems.
Knowledge of principles and practices of computer network systems analysis and design.
Knowledge of current trends and new technologies in data processing.
Knowledge of desktop software packages and operating systems.
Knowledge of principles of effective documentation.
Knowledge of effective customer service.
Knowledge of methods and practices of installation for upgrading of client servers and desktop computer hardware and software.
Knowledge of computer system configurations.
Knowledge of operating system structures.
Knowledge of principles of computer network systems analysis and design.
Knowledge of local area network hardware and transmission protocols.
Knowledge of data communication concepts and principles.
Knowledge of Internet and intranet architecture.
Knowledge of network security policies, techniques, and procedures.
Knowledge of network configuration, maintenance, and diagnostic procedures and techniques.
Knowledge of Licensing Agreement enforcement.
Ability to analyze network communication requirements.
Ability to troubleshoot and resolve network hardware and software problems.
Ability to use and maintain networking test equipment.
Ability to lead a technical team in developing network infrastructure.
Knowledge of computer operating systems/hardware.
Knowledge of program design and analysis.
Knowledge of principles and techniques of programming.
Knowledge of programming languages (Java, C, C++, Visual Basic, etc.) and utilities.
Knowledge of database management systems.
Knowledge of database design.
Knowledge of database tools.
Knowledge of data/file management tools.
Knowledge of database utilities.
Knowledge of data warehouse and multi dimensions.
Knowledge of file and data recovery.
Knowledge of database security methods and techniques.
Knowledge of physical control standards and procedures.
Knowledge of database software (Oracle, SQL, etc.)
Ability to manage a multiple data base environment.
Ability to develop procedures and means of storage for archiving data.
Knowledge of in-depth graphic design.
Knowledge of user interface design.
Knowledge of advertising and marketing.
Knowledge of information architecture.
Knowledge of management of e-commerce.
Knowledge of front-end web code such as HTML and JavaScript.
Knowledge of business systems analysis.
Knowledge of business software packages.
Knowledge of desktop GIS software for analysis, query, and visualization (e.g., ESRI's ArcView).
Knowledge of WEB-based GIS application interfaces and data presentation.
Knowledge of desktop or workstation GIS advanced software for data creation, geo processing, and conversion (e.g., ESRI's Arc Info).
Knowledge of geo-locational and geo-relational dataset concepts and database structures.
Knowledge of engineering/surveying principles and practices as related to GIS and GPS (global positioning systems) applications.
Knowledge of interface and integration of GIS database systems with other public enterprise systems such as permitting, licensing, and financial systems.
Ability to install, configure, upgrade, and maintain hardware and software, including that related to local and wide area networks.
Ability to prepare clear and concise reports and technical documents.
Ability to develop and recommend cost effective improvements for technical systems.
Ability to implement systems based on design specifications and instructions.
Ability to recommend purchase of computer equipment, services, and supplies.
Ability to plan, analyze, design, program, test, debug, document, and maintain various systems and applications.
Ability to design and develop software to facilitate inter-operability of software programs and data sharing.
Ability to coordinate, prepare, and review requests for proposals to accomplish design objectives.
Ability to develop and apply various criteria to evaluate contract bids and recommend selections (as assigned).
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.

Nice To Haves

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.
PROMOTIONAL: 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.

Responsibilities

Performs all the essential functions of Computer Programmer Analyst and Senior Computer Programmer Analyst.
Installs and maintains workstations and servers using various operating systems such as Novell, UNIX, and Windows NT.
Establishes connectivity between the different systems located on the network.
Applies hardware and protocol knowledge for addressing connectivity problems such as TCP/IP, IP, IPX, router, hubs, etc.
Applies in-depth understanding of protocols, topography, hardware, and software.
Applies tools to monitor server activity; determines the extent of a problem such as desktop, multiple desktop, multiple servers, etc.
Troubleshoots operating systems such as Novell, Windows NT, UNIX, or AS 400 using server diagnostic tools.
Installs and configures major applications (such as: Cincinnati Financial System, Human Resource Information System, Cincinnati Area Geographic Information System, Court Management System, Jail Management System, and Automated Fingerprint Identification System).
Coordinates and performs hardware and/or software upgrades.
Designs and develops software to facilitate inter-operability of applications and data sharing on a distributed, centralized, or decentralized platform.
On a high level, identifies and develops specifications for interface and conversion programs and procedures.
On a high level, develops procedures for backup, restoration, and disaster recovery.
Designs a client workflow using multiple software to accomplish a group of tasks.
Consolidates and integrates various workflows to constitute major applications such as Cincinnati Financial System, Cincinnati Area Geographic Information System, Banner (Water Works/Sewers billing system), Total Enterprise Asset Management (TEAM), Jail Management System, Court Management System, etc.
Evaluates and specifies hardware configuration.
Creates and maintains major project work plans.
Develops a budget and work plan to facilitate completion of the application design.
Provides training and mentoring to lower-level employees.
Identifies end-user training requirements; oversees the development of end-user training materials and programs.
Administers training program for major applications.
Assures that appropriate IT security is considered in all tasks.
Act in compliance with the City of Cincinnati's Information Security Policy, Administrative Regulations, and related standards and procedures in the City's Human Resources Policies and Procedures.