GIS Analyst Programmer

Day to Day responsibilities:

Tasks under this project shall include:

  • Develop complex SQL queries in consultation with national applications coordinator as well as other resource users. Outputs from these queries include complex spatial and tabular information presented and displayed for resource specialists
  • Create scripts to identify data discrepancies in current application databases, using information provided by regional data stewards and National Applications coordinator, then provide end users with discrepancy reports and correction direction
  • Perform landscape level project analysis in support of National Environmental Policy Act (NEPA) using existing applications, and apply these project principles across multiple business areas
  • Using MS Access software to create and develop custom output reports from National Application data
  • Create final reports, PowerPoint presentations, and AGOL story maps
  • Manipulate legacy electronic tabular and spatial information provided by regional sources into current data formats and for migrating it into corporate databases
  • Obtain necessary information from those that collected the data to understand and correct errors that are found
  • Work in concert with Mobile/Web GIS staff to ensure NRM standards and protocols are used
  • Develop business specific User Guides to assist program managers (PMs), users and other personnel in bulk data retrieval and display and uploading of geospatial information from corporate databases by creating custom maps, scripts and/or tools
  • Tasks also include slope, volume, area, and hill-shade analysis, and various spatial modeling including surface modeling, demographic modeling, travel time and cost analysis, dynamic segmentation and route analysis. Basic statistics for tabular analysis from various data sources. All final products must include complete FGDC compliant or other comprehensive metadata


  • Attend project meetings as technical expert
  • Participate in field trips to forests as needed
  • Participate in meetings with resource PMs and National Applications coordinator
  • Maintain relationships with National, Forest, and District personnel as well as other technical experts as necessary
  • Perform ArcGIS tasks assigned by National Applications coordinator
  • Perform ArcGIS data analysis tasks as necessary
  • If required, create a knowledge transfer plan to coordinate ongoing work with government employees or other designated parties. This includes identifying and documenting:
  • Project management processes
  • Points of contact
  • Location of technical and project management documentation
  • Status of ongoing technical initiatives
  • Identify pending actions required of the Government
  • Establish status meetings for effective communication with the appropriate Contractor/Government personnel for the period of transition

Knowledge and Experience required:

  • Bachelor's degree in GIS, Forestry, Ecology, Wildlife Biology, Soils, Geology, Hydrology, Geography or Earth Science. Master's degree from an accredited college or university in GIS is highly desired.
  • Experience Requirement: Five years of intensive and progressive experience in a field requiring extensive use of GIS and related tools
  • 15 years of intensive and progressive experience in a field requiring extensive use of GIS and related tools accompanied by a High School degree or equivalent.

Expert in application of following software:

  • ESRI GIS products including ArcGIS, ArcGIS Server, ArcSDE, ArcGIS Online (AGOL),
  • Oracle PL/SQL Developer and Access (Microsoft) databases

Desirable skills Nice to Have Skills and Requirements in Order of Priority:

  • Background knowledge of hydrology, botany, wildfire, geology, soils, vegetation and infrastructure
  • Knowledge of NEPA processes within a Natural Resource agency
  • Familiar with mobile technology and application development for mobile devices

Please email your resume to to apply.

posted: 13 June 2018     Please mention EARTHWORKS when responding to this advertisement.