Systems Analyst

JOB SUMMARY STATEMENT: Monitors administers and troubleshoots commercial off the shelf information systems. Assists with configuration tasks as assigned by supervisor or manager of applications and development. Primarily supports one or more systems used by the various City departments (Parks and Recreation Planning Public Works Human Resources Court Services etc.). Coordinates and manages project tasks as assigned. Assists in the development of requirements and specifications for configuration changes to off the shelf information systems. Writes tests and maintains custom reports using standard business intelligence and report writing tools. Assists in the development of training materials and trains users in the use of off the shelf information systems. Writes tests and maintains database queries procedures and views to support data analysis and data migration functions. Answers Help Desk phone calls as required.

DUTIES AND RESPONSIBILITIES:

Monitors administers and troubleshoots commercial off the shelf information systems. Coordinates network and other computer related work with other staff members.

Assists with configuration tasks for information systems.

Evaluates gathers requirements documents designs implements and refines systems to meet city goals. Diagnoses troubleshoots and documents related problems. Maintains timelines assists stakeholders and monitors ongoing progress.

Assists in the development of project plans time and cost estimates implementation schedules and project timelines.

Participates in the design and implementation (with developers) of integrations between city information systems.

Writes tests and maintains custom reports using standard business intelligence and report writing tools and methods.

Conducts research; evaluates software applications tools and hardware; and develops recommendations relating to software hardware applications tools and systems. Assists with the preparation and presentation of staff recommendations as required.

Writes tests and maintains database queries procedures and views (e.g. SQL) to support data analysis and data migration functions.

Assists in the development of training materials and trains users in use of application software.

May work closely with outside agencies in the support of hosted applications and systems.

Completes scripting and minor customization assignments as necessary to support enduser needs of assigned systems.

Answers and responds to Help Desk phone calls as required. Troubleshoots and handles hardware and software issues.

Participates in oncall rotation and responsible for receiving afterhours calls.

Performs other duties as assigned.

The employee must work the days and hours necessary to perform all assigned responsibilities and tasks. Must be available (especially during regular business hours or shifts) to communicate with peers subordinates supervisors customers vendors and any other persons or organization with whom interaction is required to accomplish work and employer goals.

The employee must be punctual and timely in meeting all requirements of performance including but not limited to attendance standards and work deadlines; beginning and ending assignments on time; and scheduled work breaks where applicable.

GENERAL QUALIFICATIONS

EDUCATION & SPECIAL LICENSE(S)/CERTIFICATIONS:

Bachelors degree in computer science a related field or an equivalent combination of formal education and work experience.

Access to the Kansas Criminal Justice Information System (KCJIS) may be required so the following KCJIS requirements apply: must be at least 18 years of age; must not have been convicted of a felony; must not have been convicted of a serious misdemeanor; and must not have an arrest history the nature and severity of which warrant disqualification.

EXPERIENCE:

One to two years of experience in commercial off the shelf information system administration and support.

Must also have a working knowledge of computer and network systems and office productivity software used by the City or an equivalent level of experience.

SKILLS:

Basic administration and troubleshooting knowledge of specifically assigned information systems or identical experience with different systems in the same domain.

Basic domain knowledge in the business goals and objectives of the departments and systems assigned to support e.g. basic knowledge of Public Safety domain if assigned to systems supporting Police Department.

Basic understanding of relational database management system (RDBMS) concepts and usage as well as a working knowledge in writing SQL. Experience with one or more of the following: Microsoft SQL Server Oracle or MySQL.

Experience supporting and configuring a CRM ticket or work management system.

Writes tests and maintains custom reports using standard business intelligence and report writing tools and methods. Proficient in one or more of the following: Crystal Reports (BI) SQL Server Reporting Services (SSRS) PowerBI or Tableau.

Basic knowledge of coding constructs (if else loop) with a programming language such as JavaScript PHP or Python.

Ability to actively participate in business process/workflow mapping exercises.

Computer hardware network and software skills.

Strong analytical and research skills.

Problem solving.

Basic math concepts.

Good oral and written communication skills and the ability to communicate and work effectively with managers supervisors vendors and the various users supported by Information Technology.

Reading.

Good listening and organizational skills.

Good human relations/interpersonal skills and the ability to work effectively with persons from other disciplines and departments.

Attention to detail.

Project management skills.

Time management skills.

MENTAL REQUIREMENTS:

Ability to work both independently and as a part of a team.

Ability to prioritize work and multiple tasks.

Ability to analyze basic and complex problems and recommend possible solutions and alternatives.

Ability to meet deadlines.

Ability to carry out assignments from written and oral instructions.

Ability to train and guide others.

Abstract and logical thinking and reasoning.

Decision making ability.

Ability to adapt to a changing environment and priorities.

PHYSICAL REQUIREMENTS:

Ability to make and receive phone calls.

Hand and eye coordination adequate for data entry.