CLACKAMAS COUNTY

CLASSIFICATION NO. 690
Established: 09/00
FLSA: Non-Exempt
EEO: 3

MICROCOMPUTER ANALYST

CLASS CHARACTERISTICS

Under direction, to update and maintain departmental databases; to create and interpret reports; to verify, audit and maintain automated records and data; to coordinate the routine operation and maintenance of a computer system; and to do other work as required.

DISTINGUISHING CHARACTERISTICS

The Microcomputer Analyst and Microcomputer Programmer/Analyst series is used for application/database design, and development and implementation at the department level. Incumbents assist departments and staff in processing and organizing large volumes of data into useful formats. Incumbents also assist in planning, monitoring, and evaluating department operations, finances, billing processes, and application systems.

The Microcomputer Analyst is responsible for updating and implementation of microcomputer database projects in accordance with user specifications and needs. Incumbents work closely with users to define problems, evaluate microcomputer database requirements, and coordinate the maintenance of existing microcomputer application systems.

The Microcomputer Analyst is distinguished from the Microcomputer Programmer/Analyst which is responsible for microcomputer programming, analysis, and data base projects and from the Microcomputer Specialist series which installs and maintains microcomputers, operating software, and related equipment. It also differs from the Information Services Software Specialist series that creates and modifies programming solutions, web applications, and performs system analysis within the Information Services department only.

TYPICAL TASKS

Duties may include but are not limited to the following:

  1. Updates and supports microcomputer databases to meet users needs; tests and develops application/data base programs to ensure operational accuracy; monitors the daily performance of data bases and related software; develops and implements data base security guidelines and procedures; establishes database backup and recovery procedures; assists in the upload and download of data elements between software applications.
  2. Requests, audits, and interprets computer-generated reports; investigates and corrects problems causing incorrect input or output; creates, processes, and distributes reports requested by users.
  3. Researches, reviews, and prepares source documents for data entry; assigns job codes, project numbers, and account numbers; examines documents for accuracy and completeness; corrects coding and mathematical errors; oversees or performs data entry and data control activities.
  4. Confers with user departments in analyzing microcomputer processing needs, resources, and system performance to plan new or modified applications; recommends the most cost-effective approach to meet user requirements; develops estimates of time and costs to complete projects.
  5. Performs computer software maintenance activities; recovers lost files, reorganizes and backs up files, and transfers files between computer systems; creates program information, display screens or report templates; maintains and stores computer discs and tapes.
  6. Trains user department personnel in the use, operation and maintenance of office automation systems such as word processing and spreadsheet services; instructs users in backup procedures and diagnosis of minor software problems; develops formal training agendas and arranges materials and equipment for training sessions.

REQUIRED KNOWLEDGE AND SKILLS

Working knowledge of: Principles and practices of microcomputer data base management systems; applicable data base language generator and job control languages; operation and capabilities of microcomputer equipment; configuration for terminals, printers, modems and data interface units; applicable software, release levels and compatibility with existing hardware and software; repair and maintenance procedures for various types of microcomputers and related equipment; data entry and retrieval techniques; principles and techniques of recordkeeping, bookkeeping and cost accounting; modern office procedures and practices; basic math; English grammar and composition.

Some knowledge of: Data communication equipment, hardware, software, network design, operation, and installation; theory and fundamentals of microcomputer operations and related equipment; training techniques.

Skill to: Communicate effectively, both orally and in writing; reason and think logically; write job control and data base tables and structure in appropriate language; design, test, debug, and document microcomputer program applications; maintain accurate and detailed records; convey technical information to persons at all levels of ability; read, understand and interpret source documents; work under extreme deadlines; establish and maintain effective working relationships with vendors, system users and County employees.

OTHER REQUIREMENTS

Some positions require evening and/or weekend overtime hours and availability on an on-call basis.

Positions within the County's Criminal Justice agencies must successfully pass an extensive background investigation which may include national fingerprint records check; Some positions within Non-Criminal Justice agencies must successfully pass a criminal history check which may include national or state fingerprint records check.

All positions within the County's Criminal Justice agencies must pass a pre-employment drug test.

Driving may be necessary for County business. For position(s) with occasional/incidental driving, incumbents must possess a valid driver's license. Accommodation requests for an acceptable alternative method of transportation will be reviewed on an individual basis in compliance with State and Federal legislation. For position(s) with regular driving, incumbent(s) must also possess and maintain an acceptable driving record throughout the course of employment.

MINIMUM RECRUITING STANDARDS

Any satisfactory combination of experience and training that demonstrates possession of the required knowledge and skills.