City of Cincinnati COMPUTER SYSTEMS ANALYST (NON-COMPETITIVE) in Cincinnati, Ohio

COMPUTER SYSTEMS ANALYST (NON-COMPETITIVE)

Print

Apply

COMPUTER SYSTEMS ANALYST (NON-COMPETITIVE)

Salary

$74,423.27 - $100,018.64 Annually

Location

Ohio 45202, OH

Job Type

Full-time Classified

Department

Metropolitan Sewer District

Job Number

18-00242 (N)

Closing

5/15/2018 11:59 PM Eastern

  • Description

  • Benefits

  • Questions

General Statement of Duties

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).

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

Required Education and Experience

Transcripts must be attached to your application or your application will be rejected.

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 case basis based on the American Council on Education (ACE) Military Guide recommendations.

ADDITIONAL INFORMATION

Background Investigation: A criminal background investigation will be conducted for this position (according to Civil Service Commission Rule 15 – Sensitive Classifications/Positions and the Critical Infrastructure Protection Act of 2001 and the Patriot Act). The purpose is to detect security risks and prevent security threats posed by potential employees.

U.S. Citizenship: All positions with the City of Cincinnati require that each applicant be a citizen of the United States or have a valid permanent resident card at the time of appointment (date of hire).

HR Contact: Amy.Luthanen@cincinnati-oh.gov

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).

The below information is solely intended as a summary of the benefits available and is subject to change. Not all benefits listed are available for every position. Benefits can vary depending on appllicable labor agreements and/or salary plan. For specific questions, contact the HR Contact indicated on the Job Posting.

The City of Cincinnati offers its employees competitive salaries and a comprehensive benefit package designed to actively attract and retain quality employees' to add additional value to the City of Cincinnati's workforce. A summary of these benefits for full-time employment is listed below. This is a general listing of benefits for all employees and is not intended to be a comprehensive listing for all bargaining units.

The City offers a variety of training programs, ranging from job-specific skills such as computer and equipment instruction, to helping supervisors improve their management techniques.

Equal Employment Opportunity

The City of Cincinnati is dedicated to providing equal employment without regard to race, gender, age, color, religion, disability status, marital status, sexual orientation or transgendered status, or ethnic, national or Appalachian origin, or on the basis of any other category protected under federal, state and local laws.

Holidays

The City of Cincinnati has 10 paid holidays annually that include:

New Year's Day

Martin Luther King Day

President's Day

Memorial Day

Independence Day

Labor Day

Veterans' Day

Thanksgiving Day

Day after Thanksgiving

Christmas

Health Insurance

The Cincinnati 80/20 Plan is offered to all City of Cincinnati employees and eligible dependents. The 80/20 medical plan is administered by Anthem and prescription drug coverage is administered by OptumRx.

Eligible dependents include:

Legal Spouse or Equal Partner

Child (natural child, adopted child, and/or child who the group has determined is covered under a "Qualified Medical Child Support Order")

Step-child

Child for whom the employee or employee's spouse/equal partner is a legal guardian

Group Life Insurance

City employees that are in the non-protective services can participate in a flex term life insurance and long term disability plan. Premiums are determined by age, amount of coverage, and tobacco use.

Flexible Benefits Plans

Healthcare Flex Spending Account

City employees can participate in the Healthcare Flex Spending Account that can be used to pay out-of-pocket medical, prescription, dental, and vision care expenses for employees and family member. Participants can set aside up to $2,500/year in pre-tax payroll deductions.

Dependent Care Flex Spending Account

City employees can participate in a Dependent Care Flex Spending Account that can be used to pay work-related dependent care expenses. Participants can set aside up to$2,500/year for a single person or married person filing separately and up to $5,000 for a married couple or single person filing head of household in pre-tax payroll deductions.

Transportation Expense Reimbursement Account

City employees can participate in a Transportation Expense Reimbursement Account (TERA) that can be used to reimburse expenses related to traveling to and from work. Participants can set-up a pre-tax payroll deduction up to $230/month.

Healthy Lifestyles Program

City employees can voluntarily participate in a wellness incentive program that encourages and rewards employees and their spouses/equal partners for making positive choices for better health. The City of Cincinnati will contribute up to$500/year to a Health Reimbursement Account for each the employee and their spouse/equal partner for meeting specified program goals. These dollars can be used to offset qualified out-of-pocket medical expenses.

Integrated Health Reimbursement Arrangement (HRA)

This is a voluntary program that serves as an alternative healthcare option to the traditional medical plan. If you have alternate group health coverage available to you through a spouse, equal partner, another job, or a non-city retirement plan, you may qualify for an annual reimbursement of up to $10,000 to offset the cost of enrolling in the other plan and your out of pocket expenses associated with that plan.

Retirement Plan

The City provides a defined benefit pension plan for part-time and full-time employees. New hires and re-hired employees are required to participate in the City of Cincinnati's Retirement System (CRS), regardless of previous participation in an Ohio State pension system or any another state or federal pension system. CRS is funded by employer and employee contributions, and investment returns from plan assets. CRS provides retirement and health care benefits subject to eligibility requirements. The following groups are excluded from participation in CRS: Mayor and Members of City Council; Sworn Police & Fire; Police Recruits; and Rehired Ohio Police & Fire Retirees.

Deferred Compensation

The City offers employees a choice of two tax-deferred retirement savings programs, Ohio Public Employees Deferred Compensation (OPEDC) program and ICMA Retirement Corporation (ICMA-RC). Both programs allow employees to build a retirement nest egg through voluntary, pre-tax payroll deductions. A broad range of investment options are available to select from.

01

By completing this supplemental evaluation you are attesting that the information you have provided is accurate. Any information you provide may be reviewed by the Human Resources staff and hiring department(s). Any misstatements or falsification of information may eliminate you from consideration or may result in dismissal. "See resume" is not an acceptable answer to the questions.

The Human Resources staff will verify that you meet the minimum qualifications as outlined in the job posting, based on the information provided in your application and in these answers.

Please indicate you have read and agree with this information.

  • Yes, I understand and agree

02

Have you attached your transcripts to your application? This is required or your application will be rejected.

  • Yes

  • No

03

If you are a current employee of the City of Cincinnati, what is your CHRIS ID #?

04

The candidate selected for this position may be involved in one or more of several IT areas. In order to help us determine your experience in these areas, please answer the questions below. Please note that it is not necessary for you to have experience in all areas listed.

Enterprise Resource Planning (ERP) Systems

• List and describe your administration, development, and support experience directly involving PeopleSoft FMS or comparable ERP/financial management systems in an enterprise environment.

05

Field Service Management Systems (FSM)

• List and describe your experience building, maintaining, developing, and supporting FlowFinity or comparable mobile business process automation application.

06

Collaboration Software Tools

• List and describe your experience installing, configuring, maintaining, and supporting SharePoint or comparable Collaboration Software.

07

Development & Programming

• List and describe your experience developing, testing, and supporting applications. Please specify programming languages, web technologies, and development environments you have used in the workplace.

08

Development & Programming

• List and describe your experience developing, configuring and supporting databases using Oracle, Microsoft SQL Server, or comparable RDBMS platforms.

09

I understand I am responsible for maintaining the accuracy of my contact information, including my street address, email address, and telephone numbers. My failure to maintain accurate contact information may result in me not receiving information regarding this job announcement and/or may result in me not receiving further consideration for this employment opportunity. To update this information, visit www.governmentjobs.com, click on the "career seekers" link, and follow the prompts. For technical difficulties, contact NEOGOV support at 855-524-5627.

  • Yes, I understand and agree

    Required Question

Agency

City of Cincinnati

Address

805 Central Avenue Suite 200

Cincinnati, Ohio, 45202

Phone

513-352-2400

Website

http://agency.governmentjobs.com/cincinnati/default.cfm