IT Systems Analyst I, II, or III

***Depends on Qualifications***

REPORTS TO:IT Systems Coordinator
FLSA STATUS:Exempt Computer Employee
CLASSIFICATION:Personnel System Requires satisfactory completion of a six month probationary period
PAY GRADE:

Analyst III /122 Annual Salary $65648

Analyst II/121 Annual Salary $62522

Analyst I/ 119 Annual Salary $56710

SAFETY SENSITIVE:Subject to random drug testing per the AthensClarke County Drug and Alcohol Ordinance.

Purpose of Job
The purpose of this job is to perform systems and applications analysis development implementation support and maintenance activities. Duties and responsibilities include but are not limited to: analyzing automation needs county wide; plan design develop and launch efficient information systems and operations systems in support of core organizational functions manage hardware and software usage configure and deploy end user devices respond to service desk calls and train end users. This individual will apply proven communication analytical and problemsolving skills to help identify communicate and resolve systems issues in order to maximize the benefit of IT systems investments.

Job Related Requirements

Work Schedule:8:00 am5:00 pm MF
On call approx. 4x/year for 1 week

Nights and weekend as needed but rare

Regular and predictable attendance is required.

Must work cooperatively with others.

When requirements include vehicle operation responsible for the safety readiness and operation of the vehicle and must abide by ACCs safe driving policy.

All Levels must possess
Must possess a valid drivers license.

Criminal fingerprint background check must indicate eligibility for access to sensitive public safety information such as GCIC records and other confidential departmental data which may reasonably be accessed during execution of IT duties.

Analyst I:

Bachelors degree in computer science information systems or a related field and one year of experience in one or more of the following areas in a multiuser environment required: Database Administration Network Management Desktop Management Server Management Virtual Environment Administration Enterprise EMail Administration Application Development Security Management Storage Area Network Project Management and/or Document Management; or any equivalent combination of education training and experience which provides the requisite knowledge skills and abilities for this position.

Analyst II:

Bachelors degree in computer science information management information systems geographic information systems (GISA) mathematics business administration or a related field and three years of experience in one or more of the following areas in a multiuser environment required: Database Administration Network Management Desktop Management Server Management Virtual Environment Administration Enterprise EMail Administration Application Development Security Management Storage Area Network GIS Administration Project Management and/or Document Management; or any equivalent combination of education training and experience which provides the requisite knowledge skills and abilities for this position.

Must have one (1) or more entrylevel IT certifications in any of the following: A Network Project Security Server CYSA ArcGIS Desktop Associate Microsoft Beginner Level (any) Cisco CCST (cybersecurity or networking) or VMWare VCTADCV.

Analyst III:

Bachelors degree in computer science information management information systems geographic information systems (GISA) mathematics business administration or a related field and five years of experience in one or more of the following areas in a multiuser environment required: Database Administration Network Management Desktop Management Server Management Virtual Environment Administration Enterprise EMail Administration Application Development Security Management Storage Area Network GIS Administration Project Management and/or Document Management; or any equivalent combination of education training and experience which provides the requisite knowledge skills and abilities for this position.

Must haveone (1) or more entrylevel IT certifications in any of the following: A Network Project Security Server CYSA ArcGIS Desktop Associate Microsoft Beginner Level (any) Cisco CCST (cybersecurity or networking) or VMWare VCTADCV).

Must have one (1) or more midlevel IT certifications in any of the following: CAPM Cisco CCNA Cisco CLACCM Cisco CyberOps Associate ArcGIS Developer Foundation VMware vSphere Foundations Professional VMware vSphere or Microsoft Intermediate Level (any).

Extensive practical knowledge in importing data for use in reporting software spreadsheets graphs and flow charts.

The following duties are normal for this job. These are not to be construed as exclusive or allinclusive. Other duties may be required and assigned.

Conducts systems analysis of manual and automated systems for unified government departments and divisions; review and analyze the effectiveness and efficiency of existing systems and develop strategies for further leveraging these systems or migrating to new platforms.

Evaluates hardware and software based upon current and anticipated user needs and vendor demonstrations.

Collaborates with management staff and internal customers to determine desired technological goals priorities and resources. Analyzes operating procedures and develops related operating manuals.

Designs and implements systems; writes compiles changes and tests new programs and conversions between systems.

Performs system configurations installations and modifications.

Trains users on hardware and software; demonstrates new systems and assists users with computer related problems.

Designs intermachine program conversions.

Provides advanced technical assistance and troubleshooting for computer hardware software network and/or other related technology problems. Assists with problem and/or process identification definition and resolution.

Tests and debugs systems; writes internal online system and user program documentation.

Plans and performs disaster data recovery activities as needed.

Consults with outside technical engineers when performing troubleshooting and problem solving activities as needed.

Implements and maintains security of confidential data applications and systems.

Provides oncall support services to all departments.

Develops and maintains contacts with vendors and technicians.

Tracks and documents time usage in monthly reports and biweekly time sheets.

Tracks hardware and software assets.

When Assigned to Security and Recovery:
Implement and review backup jobs and security systems on the ACC network servers and other storage systems.

Develop business recovery documents for equipment failure and disaster recovery.

Review logs for backup and recovery to ensure backup is performing correctly and system recovery is possible and review network data packets to ensure that systems are not infected with viruses.

Test recovery plans and systems to ensure they work properly.

Consult with departments regarding critical data on local machines (PCs) to ensure it is recoverable as well as applications & system security.

Make recommendations on future backup and recovery needs virus intrusion and detection systems for budget planning.

Administer all backup systems virus intrusion and detection systems used within AthensClarke County.

Monitor and review intrusion detection equipment to ensure AthensClarke Countys network has adequate defenses in place against intrusion.

Monitor security of applications to ensure that access to databases is controlled according to policy.

When Assigned to Database Administration:
Assess and develop longterm strategic goals for production databases in conjunction with data owners.

Work with staff to upgrade database architectures standards and quality assurance policies and procedures.

Create models for new database development and/or changes to existing ones and performs database management.

Respond to and resolve database access and performance issues.

Monitor database system details within the database including stored procedures SQL queries and execution times and implement efficiency improvements as they are identified using data processing techniques entity relationships or the Unified Modeling Language (UML).

Monitor optimize and allocate physical data storage for database systems.

Plan and coordinate data migrations between systems as necessary.

Develop implement and maintain change control and testing processes for modifications to databases.

Establish appropriate enduser database access control levels.

Develop routines for endusers to facilitate best practices database use.

When Assigned to CAD System Administration (Police)
Functions as a control point for all system administration duties of the CAD application.

Supervises maintains and controls security access for the system and maintains associated documentation.

Maintains CAD system software and its associated database components in coordination with the RMS Administrator. This includes but is not limited to making changes to user displays modules and workflow.

Interfaces with clients and In Tyler/New World support to track problems and document resolutions.

Maintains a test environment for all CAD changes conducts tests on changes before implementation into production and documents changes for change control. Installs and upgrades new components of the CAD software as required.

Operates hardware specific to the CAD application so as to test and ensure integrity and durability.

Interfaces with the Local and Wide Area Network staff of IT to plan and coordinate network needs.

Cross trains with the RMS Administrator to assume those duties in times when staff in those positions are not available.

When Assigned to RMS System Administration (Police)
Functions as a control point for all system administration duties of the RMS application.

Supervises maintains and controls security access for the system and maintains associated documentation.

Maintains RMS system software and its associated database components in coordination with the Database Administrator and CAD Administrator. This includes but is not limited to making changes to user displays modules and workflow.

Interfaces with clients and Tyler/New World support to track problems and document resolutions.

Maintains a test environment for all RMS changes conducts tests on changes before implementation into production and documents changes for change control. Installs and upgrades new components of the RMS software as required.

Operates hardware specific to the I/Leads application so as to test and ensure integrity and durability.

Interfaces with the Local and Wide Area Network staff of IT to plan and coordinate network needs.

Cross trains with the CAD Administrator and Database Administrator to assume those duties in times when staff in those positions are not available.

When Assigned to GIS
Conducts system requirement analysis for new GIS applications and monitors application development using a system life cycle development methodology.

Monitors interdependent GIS map layers (map layers that more than one department depend on) for quality assurance (accuracy and timely maintenance).

Implements software and hardware standards to ensure that GIS related hardware and software is uptodate and capable of meeting department needs.

Coordinates plans and implements GIS system upgrades.

Ensures that GIS policies and standards are maintained.

Plans reviews and recommends annual GIS budget.

Operates hardware and software related to GIS applications as necessary.

When Assigned to Police GISCAD Mapping/RMS duties

Maintains and administers the GIS database for the Tyler/New World Computer Aided Dispatch (CAD) and Tyler/New World Records Management System including the acquisition of data development modification compliance and enhancement of the GIS system. This includes analysis integration systems testing documentation and system backups.

Acts as a liaison between GIS users with ACCPD and UGAPD other ACC departments planning entities systems developers and consultants in the development testing implementation and review of systems both existing and proposed.

Assists in the training of users of the GIS system and Tyler/New World CAD and RMS map.

Maintains up to date knowledge of the Tyler/New World systems and recommends enhancements.

Writes and develops specifications for the GIS database and application systems.

Troubleshoots problems and is accountable for the daytoday database and technical support.

Assists in the implementation of GIS database application on a PC based network.

Maintains an operational understanding of the source data for theTyler/New World CAD and RMS map and the procedures for implementing map data into the map.

Adds new features or layers and other attributes to the map.

Conducts analysis on existing Tyler/New World GIS database systems and performs updates or modifications as required. May provide recommendations for improvements to related policies systems processes and guidelines.

Performs other related work (including weather or extreme emergency duties) as required.

Performs other related duties as required.

When Assigned to Permitting and Plans Review:
Maintains and administers permitting and plans review software (Clariti built on Salesforce and/or associated systems preferred) including the acquisition of data development modification compliance and enhancement of this software.

Acts as a liaison between the Building Inspections Department and all other departments utilizing the software.

Assists in training users of the Permitting and Plans review software.

Provides recommendations and implementations for software improvements.

Provides technical support of the Permitting and Plans review software.

Performs other related duties as required.

Knowledge Skills and Abilities
Knowledge of the policies practices procedures and activities of the AthensClarke County Government and the operations and functions of the Information Technology Department.

Knowledge of applicable legal policies procedures and methods as required in the performance of duties.

Knowledge of computer terminology.

Knowledge of the following:

• Troubleshooting and resolving hardware software and peripheral problems
• Current Microsoft operating systems
• Mobile operating systems (Android/Apple iOS Windows).
• Midrange and mainframe (iSeries/AS400 Unix)
• Systems analysis and design methods (problem definition collection of data establishing facts drawing conclusions and making appropriate recommendations)
• Basic network knowledge: design topologies protocol usage and troubleshooting
• Business Intelligence applications (SSRS Crystal Reports Cognos)Programming languages (including scripting web client/server mainframe/midrange)
• Staying up to date with current technology trends and principles
• Project management principles
• Virtual environments (virtual desktop infrastructure virtual application delivery hypervisors)
• Database management

Knowledge of hardware and software utilized by AthensClarke County.

Ability to compile organize prepare and maintain an assortment of records reports and information in an effective manner and according to division departmental and/or other governmental regulations.

Ability to comprehend and apply the regulations and procedures of the division and the department.

Ability to communicate technical information to other personnel.

Ability to develop knowledge of the job functions and terminology used by personnel in other departments in order to understand and meet automation needs.

Ability to communicate and interact effectively with management other IT staff members vendors and all groups involved in the activities of the AthensClarke County government.

Ability to assemble information and write reports and documents in a concise clear and effective manner.

Ability to plan organize and prioritize short and long term assignments and work activities.

Ability to use independent judgment in routine and nonroutine situations.

Ability to perform mathematical calculations.

Ability to assist and instruct a wide variety of ACC government personnel in the proper and optimal use of available automation tools and systems.

Ability to acquire integrate and apply new technical knowledge.

Ability to work in a team oriented collaborative environment.

Skill in troubleshooting and problemsolving.

(ADA) MINIMUM QUALIFICATIONS OR STANDARDS REQUIRED TO PERFORM ESSENTIAL JOB FUNCTIONS

PHYSICAL REQUIREMENTS:Must be physically able to operate a variety of machinery and equipment including computer equipment and tools for electronic and mechanical repairs. Must be able to use body members to work move or carry objects or materials. This position requires: stooping kneeling crouching climbing crawling reaching standing walking pushing pulling lifting fingering grasping feeling seeing talking hearing and repetitive motions. Must be able to exert up to 50 pounds of force occasionally and/or up to 20 pounds of force frequently. Physical demand requirements are at levels of those for medium work.

DATA CONCEPTION:Requires the ability to compare and/or judge the readily observable functional structural or compositional characteristics (whether similar to or divergent from obvious standards) of data people or things.

INTERPERSONAL COMMUNICATION:Requires the ability to hear speak and/or signal people to convey or exchange information. Includes giving / receiving assignments and/or directions to coworkers or assistants / from supervisors.

LANGUAGE ABILITY:Requires the ability to read a variety of computer documents manuals diagrams reports and informational documentation directions instructions and methods and procedures. Requires the ability to prepare technical documentation flow charts system reports purchase orders correspondence and other records reports and charts using prescribed formats and conforming to all rules of punctuation grammar diction and style. Requires the ability to speak to people and groups of people with poise voice control and confidence.

INTELLIGENCE:Requires the ability to learn and understand complex principles and techniques; to acquire and be able to expound on knowledge of topics related to primary occupation; and to make independent judgment in the absence of management.

VERBAL APTITUDE:Requires the ability to record and deliver information to explain procedures and to follow oral and written instructions. Must be able to communicate effectively and efficiently in a variety of administrative technical or professional languages including computer accounting legal and personnel terminology.

NUMERICAL APTITUDE:Requires the ability to utilize mathematical formulas; add and subtract totals; multiply and divide; utilize and determine percentages; interpret graphs; perform calculations involving variables formulas square roots and polynomials.

FORM/SPATIAL APTITUDE:Requires the ability to inspect items for proper length width and shape visually with various computer equipment and tools.

MOTOR COORDINATION:Requires the ability to coordinate hands fingers and accurately eyes in using computer equipment and tools. Requires the ability to use the keyboard lift bend push and pull objects or materials using body parts as the position necessitates.

MANUAL DEXTERITY:Requires the ability to handle a variety of items such as screwdrivers crimpers strippers line testing equipment and other computer equipment and tools. Must have the ability to use one hand for twisting or turning motion while coordinating other hand with different activities. Must have minimal levels of eye/hand/foot coordination.

COLOR DISCRIMINATION:Requires the ability to differentiate between colors and shades of color.

INTERPERSONAL TEMPERAMENT:Requires the ability to deal with people beyond giving and receiving instructions. Must be adaptable to performing under considerable stress when confronted with an emergency.

PHYSICAL COMMUNICATION: Requires the ability to talk and/or hear: (Talking expressing or exchanging ideas by means of spoken words). (Hearing perceiving nature of sounds by ear). Must be able to communicate via telephone twoway radio.