Senior Computer Programmer Analyst-CAGIS

General Statement of Duties

The Cincinnati Area Geographic Information Systems (CAGIS) division of Enterprise Technology Solutions is seeking to fill a Senior Computer Programmer Analyst (SCPA) position providing strong technical and user support in various enterprise programs including Geographic Information and Permitting Business software systems. The position duties encompass skills in multiple areas including technical development, maintenance and support for mission critical operations of, CAGIS GIS, Permitting Business Systems and various CAGIS applications. The individual will perform in depth research, gather information, perform analysis, tests, and evaluations and translate business process documentation into functional requirements for systems design. The individual will develop and manage their own work plan and provide status/issues/escalation reporting to their supervisor. The individual will also develop new solutions, reports, scripts, performance metrics, etc along with providing application administration and support to internal and external customers.

GENERAL STATEMENT OF DUTIES:

Employee performs a variety of professional, technical, and analytical duties in the operation of enterprise, client/server, and desktop computer systems and networks. Employee assists in the analysis of city, county, and criminal justice agencies' data processing needs; assists in the design, testing, and implementation of systems; performs network design, implementation and maintenance, data/database analysis/administration, and modifications to existing computer applications. Performs related duties as required.

Examples of Work Performed:

(Illustrative only. Any one position within this classification may not include all of the duties listed nor do the listed examples include all of the tasks which may be performed.)

Performs all essential functions of a Computer Programmer Analyst.
Installs and maintains servers and network equipment.
Troubleshoots any application or server connections.
Installs, configures, and troubleshoots office network software and operating systems.
Identifies the need for hardware and software upgrades and perform upgrade.
Under minimal supervision, develops specifications, codes, tests and documents application programs.
Under minimal supervision, develops specifications, codes, and tests interfaces and conversion programs or procedures.
Creates and maintains medium project work plans.
Creates data flow documents which detail systems or business problems.
Evaluates and tests options for backup, restoration, and recovery procedures.
Identifies software requirements.
Drafts requests for proposals to accomplish design objectives.
Evaluates and specifies hardware and software configuration and places orders with vendors.
Applies a general understanding of protocols, topology, hardware and software, and network design.
Evaluates and specifies networking equipment and application.
Applies network hardware and software troubleshooting skills.
Provides second level network problem escalation resolution.
Develops and administers end-user training programs.
Assures that appropriate IT security is considered in all tasks.
Acts 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.
Participate in team development activities.
Report status of CAGIS systems, applications and development projects on a routine basis.
Deploy, test and maintain CAGIS systems and applications according to the guidelines of the team.
Program, test and script with various computer programming languages for automating processes
Analyze, document, write and update standard business processes of CAGIS participants.
Translate business process documentation into functional requirements for systems design.
Create and maintain project work plans as well as simultaneously work on multiple projects,
Manage workload with little supervision.
Research leading and emerging trends to stay current with various technologies used by CAGIS.
Provide communication to customers concerning the status of incidents, service requests and changes.
Participate in groups to solve problems discovered during testing or in production.
Provide responsive support for problems in CAGIS applications and systems
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.

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:
Principles of computer data processing.
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.
Principles of providing 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.

Programming:
Standard programming languages.
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.)

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.
Perform hardware modifications such as chip replacement and board swaps.
Troubleshoot and resolve network hardware and software problems.
Use and maintain networking test equipment.

Ability to: (All Categories)
Read and prepare clear and concise reports and technical documents.
Work with minimal supervision.
Provide effective customer service.
Develop and recommend cost effective improvements for technical systems.
Implement systems based on design specifications and instructions.
Evaluate and recommend purchase of computer equipment, services and supplies.
Analyze, design, program, test, debug, document and maintain various systems and
applications.
Develop procedures and means of storage for archiving data.

Required Education and Experience

Each applicant must have completed 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. In addition, each applicant must have one year of professional paid work experience performing work similar to that listed under "Examples of Work Performed."

OR

Each applicant must have completed 45-quarter credit hours from an accredited college or university with 30 of the 45 credit hours being in computer science, information technology, and/or computer programming. In addition, each applicant must have two years of professional paid work experience performing work similar to that listed under "Examples of Work Performed". A certification program, such as a Novell or Windows NT engineer, may substitute for one year paid work experience (completion of other certification programs not listed will be reviewed on a case-by-case basis).

The Preferred Candidate will have knowledge and experience in the following areas:

• Technical support, maintenance and development of software systems.
• Experience with scripting languages like SQL, Python, Windows Batch programs, etc.
• Knowledge of GIS ESRI Suite of products preferred.
• Knowledge of enterprise business systems preferably local government processes like permitting.
• Business Process analysis and implementation.
• Database integration and browser-based applications.
• Database design and program construction.
• Reports development with tools like crystal reports.

The Preferred Candidate will demonstrate skills and/or abilities in the following areas:

• Excellent customer service and organizational skills.
• Great oral and written communications.
• Highly motivated and passion for customer service and solving problems.
• Strong understanding of IT Service Management.
• Ability to quickly understand and apply the concepts of IT Service Management.
• Ability to work effectively with diverse customer and colleague groups.
• Experience managing and supporting large support applications.

Familiarity with project management principles.

OTHER REQUIREMENTS
Must have a valid Driver's License 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 EVALUATIONMilitary 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 case basis 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).