YAKIMA COUNTY, WASHINGTON

CLASS SPECIFICATION

CLASS TITLE: Systems Programmer

BAND:

C

GRADE:

4

SUBGRADE:

1

CLASS CODE:

3341

DEPARTMENT:

Varies†

ACCOUNTABLE TO:

Varies

 

Overtime Status:

Non-Exempt

JOB SUMMARY:†

Incumbents are responsible for analyzing, planning, organizing and managing a network of databases; for writing and maintaining application programs; for the creation of maps, graphs, charts, and/or web based applications and interfaces used in meeting the business and technological needs of the County.† Assists the general public in accessing information and assists other technical staff and customer project teams in project development, planning and analysis.

DISTINGUISHING CHARACTERISTICS:

The Systems Programmer classification is the first level of a three-level classification series.† It is distinguished from other classifications by primary assignment to writing and maintaining computer applications programs.

DUTY

NO.

ESSENTIAL DUTIES: (These duties are a representative sample; position assignments may vary.)

BAND/

GRADE

1.

Plans, analyzes, develops, creates and manages applications.† Writes application code using the most up-to-date technology to produce computer system products such as maps, graphics, web based applications and web pages.

C4

2.

Plans, builds and tests computer applications for County departments and other outside agencies and individuals; translates database design goals to projects; and evaluates project requirements.†

C4

3.

Works with end users and staff, providing support, technical assistance and trouble-shooting of applications; advises owners and users on the design and implementation of projects using County technology services; identifies appropriate database requirements; and verifies the quality of data.

C4

4.

Uses computer system information and technology to manipulate and model data for purposes such as creating spatial overlays and composing plots and maps in support of GIS projects.

B2

5.

Performs maintenance and administration of computer systems to include: recommending the purchase of equipment; installing software and hardware; solving computer and printer errors; updating and maintaining databases and mapping layers; and ordering supplies.† Conducts or assists in demonstrations and presentations of application technology.

B2

6.

Designs, creates and maintains internet and desktop applications.† Creates reports which present and summarize data to effectively meet project objectives.† Writes programs to perform analyses.† Creates models and uses specific programming language such as: Avenue, AML, Visual Basic, ESRIís desktop development tools, and web authoring tools, for production of maps, desktop applications, and/or Microsoft back office solutions.† May perform statistical analysis functions.

C4

7.

Participates in team project design and development efforts including: MDI process, database design, hardware evaluation and report design.† May serve as project coordinator.

C4

8.

Represents the department at meetings, seminars and conferences with process decision making responsibility.

C4

9.

Performs other duties as required.

 

Knowledge of: (position requirements at entry):

Knowledge of:

∑         Computer technology and database design concepts, principles, practices, and techniques such as: geoprocessing functions, spatial data conversion, relational database and modeling concepts, Mutual Design and Implementation concepts, open database connectivity; object oriented programming,

∑         Programming languages and techniques and composition data conversion methods;

∑         Microsoft Office applications and other applications specific to the position;

∑         Techniques of analysis and presentation;

∑         Basic companion disciplines specific to assignment such as, urban planning, transportation, engineering, and resource management;

∑         Mathematics pertinent to area of assignment; and

∑         Customer service techniques.

Skills (position requirements at entry):

Skill in:

∑         Using computers, e-mail, internet, related software applications and the specific assignment systems;

∑         Using office equipment such as: printers, plotters, calculators, fax machines, telephones and scanners;

∑         Creating and maintaining applications using system development tools and† programming languages;

∑         Using and administering UNIX and Windows operating systems and installing/maintaining hardware and software; and creating spreadsheets and databases;

∑         Creating and maintaining applications using system development tools;

∑         Managing projects and prioritizing time and tasks; summarizing and presenting data;

∑         Designing, creating and maintaining web sites;

∑         Establishing and maintaining effective interpersonal relationships with County and other officials, at all organizational levels and with the public; and

∑         Communications, oral and written, sufficient to exchange or convey information and to receive work direction.†

Training and Experience (position requirements at entry):

Bachelorís Degree in Computer Science or a field related to assignment plus two years computer application programming experience, including desktop or web application programming experience; or an equivalent combination of education and experience which provides knowledge, skills and abilities sufficient to successfully perform the essential duties of the job.

Note:† ArcInfo Experience is required for GIS Department assignments.

Licensing Requirements (position requirements at entry):

None required.†

Physical Requirements:†

Positions in this class typically require: stooping, reaching, fingering, mobility, grasping, feeling, talking, hearing, seeing and repetitive motions.† Incumbents may be subject to travel.

Sedentary Work: Exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body.† Sedentary work involves sitting most of the time.† Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.

Classification History:

Revised 1/4/01 (Retitled and Revised from GIS Analyst)