Columbia County Public Works is seeking a Geographic Information System (GIS) Specialist and/or Senior Geographic Information System (GIS) Specialist. These position are responsible for maintaining Public Works related GIS data pertaining to pavement management, road inventory, and addressing; Maintain the Public Safety Answering Point (PSAP) mapping system; Work with Public Works staff and other County departments to establish and maintain the GIS system using primarily ESRI software; Responds to GIS related inquiries from internal and external customers including Emergency Management, 911, Assessor’s Office, Auditor’s Office, Planning and Building; Performs miscellaneous work in engineering and GIS related analysis, cartography, and data collection.
GIS Specialist: Maintains the Public Safety Answering Point map for the Public Safety Communications Department. Maintains the Mobility system for county road inventory. Develop and maintain a County-wide sign inventory and inspection program fulfilling, at a minimum, the requirements of the Manual of Uniform Traffic Control Devices (MUTCD). Maintain County road data and inventory including pavement management, traffic counts, accident report management, etc. Complete reporting forms as required. Coordinate the county right-of-way access and use permits, serves as the Addressing Coordinator. Conducts research and data collection; interprets plans, photos and maps. Participates in GPS surveying and mapping of public infrastructure and the transfer of electronic data to and from outside agencies and customers. Works with other departments to develop and implement GIS applications to improve workflows and decrease redundancy in data collection and storage.
Senior GIS Specialist: In addition to the GIS Specialist duties the senior position will Coordinate GIS work flow; receive requests from user departments; prioritize through the County Engineer and coordinate projects between user groups and engineering staff to assure completion of assignments. Develop and maintain systems to integrate new and existing databases; meet with user groups to determine needs and direction of projects; collect and analyze information as needed. Coordinates consultants contracted to perform various GIS related activities for County departments. Supervise full time and part time employees assigned to GIS activities by the County Engineer.
A current Washington State driver’s license and a driving record acceptable to the County’s risk manager.
Completion of two (2) years of college or a technical school program in GIS, automated mapping, geography, computer science, computer aided design, or a related field.
GIS Specialist: At least two (2) years progressively responsible experience.
Senior GIS Specialist: At least four (4) years progressively responsible experience.
The years of experience should include any or all of the following:
Two (2) years of hands-on use of the County’s selected GIS software, preferred Arc GIS Desktop, ArcGIS Online and associated modules.
Knowledge of data integration, relational databases, and the ability to work with different map projections, data formats, and foreign data.
Knowledgeable in GIS data analysis techniques, spatial data queries, and data manipulation.
Strong data maintenance and cartographic design experience.
Experience demonstrating a basic working knowledge of relational database management systems (Oracle or SQL Server preferred), relational data modeling, and relational database design.
Knowledgeable in COGO and surveying/mapping techniques.
One to two (1-2) years of experience performing application requirements analysis and/or client/server application development desirable for Senior GIS Specialist.
Any equivalent combination of education and experience will be accepted.
Additional Salary Information: Paid, vacation and sick leave.
11 paid holidays plus two floating holidays per year.
$850 per month stipend for Medical, Vision and Dental insurance.
Washington Public Employees Retirement Systems (PERS)
HRA VEBA Account
Deferred Compensation Plans available
Life Insurance and Disability Insurance available
Relocation assistance to Columbia County is available.
About Columbia County, Washington
Nestled at the base of the Blue Mountains, Columbia County is located in southeastern Washington. Dayton is the county seat and largest city in the county. Located just 30 miles northeast of Walla Walla and 60 miles east of the Tri Cities, Dayton is home to three national historic districts, including the oldest train depot and oldest working courthouse in the State of Washington and over 120 buildings on the National Historic Register.
Dayton enjoys a cost of living well below other areas of the state (40% to 60% below the Seattle and Portland/Vancouver metro areas and 10% to 20% below Spokane, Walla Walla and the Tri-Cities according to Sperling’s Best Places).
The City’s Main Street underwent a major revitalization in the early 1990’s and is now home to essential business services, unique shops, Victorian lodging, restaurants and breweries. Columbia County is bordered by the Oregon state line to the south and the Snake River to the north and enjoys nearby world class wineries, recreational trails, and local rivers allow for residents of all ages to enjoy a variety of recreational opportunities including picnicking, recreational sports, cycling, fishing, hunting, gol...f, and winter sports in the Blue Mountains. Just 30 minutes to the south, Ski Bluewood is an important source of tourism and seasonal employment for residents across the region, offering 400 skiable acres, clear skies and more than 300 inches of snow annually.
Columbia County covers an area of just under 870 square miles and is the perfect place to experience all four seasons with its warm sunny summers, crisp yet moderate winters and spectacular springs and falls that fill the area with color. The area has picturesque landscapes with rolling hills, bountiful crops, and pristine rivers, along with private and national forest lands.
Columbia County has long been known as one of the most fertile agricultural areas in the nation, producing crops including winter and spring wheat, barley, dry beans and green peas. Building on its original foundation of agriculture, Columbia County has encouraged economic diversification in order to remain vital and healthy while retaining its rural charm.
The County operates with 100 full-time equivalent employees spread over more than 13 departments, and has a 2018 operating budget of $18 million. The Columbia County Department of Public Works consists of a diverse staff of 29 crew members in operations, engineering, GIS, and administration. The Department’s overall 2019 budget is approximately $8.3 million. The Public Works Department is responsible for the planning, engineering, design, construction, operation and maintenance of approximately 540 miles of county roadways, and 63 bridges. Currently the department has 9 major projects being planned or underway during the next six years.