Job Detail

Organization: The Sanborn Map Company, Inc.
Title: Geospatial Aquatic Database Admin / Programmer Intermediate
Location: Lakewood, CO

Posted: 2019-08-22
Application Deadline:

Position Description:

Join Sanborn’s award-winning team! Sanborn is looking for a Geospatial Aquatic Database Administrator/ Programmer Intermediate to work onsite with our federal government client where the primary responsibilities will be to provide geospatial database support for aquatic data. This position will be responsible for serving as a liaison between both subject matter experts and data technical staff to ensure that database design, implementation, and maintenance meet the needs of the users and to ensure that databases are developed and maintained according to best practices for database management.

This position is located in Lakewood, CO. It is anticipated that the candidate may be required to travel up to 3 times per year.

The candidate will provide assistance in supporting the full range of database activities.
Primary responsibilities of the Geospatial Aquatic Database Administrator/ Programmer Intermediate will be to give input to the design of, update, and maintain multiple databases and related tools for aquatic AIM. This position will also assist and coordinate the development, configuration and maintenance of databases and related tools developed by other employees. The candidate will work in many different software environments such as ArcSDE, Access, Microsolf SQL, R, and Survey 123.

High emphasis is on the following;
•Requires a strong understanding of applied ecology and field natural resources data collection.
•Writing scripts and macros to perform specific operations (such as watershed delineation and geospatial statistics) within existing software packages; specifically, ArcSDE, FME checks, Python, R, Microsoft SQL server and Microsoft Access, as well as ArcGIS SDE versioning, data replication, and other database applications.
•Candidates who can demonstrate experience with aquatic resource management.
•Candidates that have direct range management, riparian, and vegetation data collection experience.
•Candidates with R scripting experience.
•Candidates with Survey 123 use or design experience.

REQUIREMENTS:
• Demonstrate expertise of greater than 6 years with of ESRI’s suite of desktop GIS software primarily focused on ArcGIS Desktop and extensions.
• Demonstrate experience of greater than 2 years working in a multi-user, enterprise Geodatabase environment using ESRI’s ArcSDE software connected to an enterprise instance of SQL Server.
• Demonstrate working understanding of publishing geospatial data using ArcGIS Server. Candidate should highlight in narrative their understanding of the utility and limitations of publishing data through ArcGIS Server. Preference will be given to candidates that understand MXD and Geodata optimization practices.
• Demonstrate professional knowledge of concepts and principles of geospatial data management by providing a minimum of 2 specific work examples.
• Demonstrate professional knowledge in applying geospatial technologies to address natural resource and/or land management business requirements by providing a minimum of 2 specific work examples. Preference will be given to candidates that have direct range management, riparian, and vegetation data collection experience.
• Demonstrate ability to communicate technical information effectively to lay persons and geospatial technical experts alike.
• Demonstrate knowledge working with variety of geospatial datasets from sources within and external to the federal government. Candidate should highlight in narrative the range of data sources they have worked with in the past.
• Preference will be shown to candidates who can demonstrate experience with aquatic resource management.
• Preference will be shown to candidates with R scripting experience.
• Preference will be shown to candidates with Survey 123 use or design experience.

TASKS
• Update and maintain multiple databases (including ArcSDE, Access, and Microsoft SQL Server) with versioning and replication, maintaining and creating data applications for field data recorders, and building database calculation code to manipulate data.
• Support data collection, processing, summarizing and/or analyzing of natural resource data and implementation of AIM and other initiatives.
• Maintain the SARAH data collection application and assist in design and maintenance of a new replacement application (likely Survey 123).
• Gather spatial data of aquatic and terrestrial survey information for compilation into national geodatabases and link complex databases to spatial data layers.
• Develop editing processes, standard operating procedures, and software interfaces to facilitate spatial data capture and editing associated with multiple enterprise-level databases associated with the AIM program. These databases are named AquADat and TerrADat.
• Develop and maintain a Sample Design database which is used to capture feature level metadata related to the development of individual AIM projects in order to appropriately apply statistical calculations across multiple scales.
• Develop and implement quality assurance and quality control (QAQC) procedures to routinely ensure data quality and integrity during multiple phases of data capture. This includes determining and setting data requirements/standards to support state and national AIM leads. This will also include creating and maintaining all metadata and documentation for data bases and layers, as well as summary analysis.
• Serve as a consultant/liaison to personnel preforming survey data capture and spatial data manipulation for applications. This includes advocating the user’s needs/requirements with management and with those responsible for computer applications/operations and resolving problems with user requirements and the identification and definition of data elements. Effective implementation of this role requires a strong understanding of applied ecology and field natural resources data collection.
• Use, test and create workflows to compile, edit, migrate, build and maintain the official AIM data repository for agency and public access.
• Write scripts and macros to perform specific operations (such as watershed delineation and geospatial statistics) within existing software packages; specifically, ArcSDE, FME checks, Python, R, Microsoft SQL server and Microsoft Access, as well as ArcGIS SDE versioning, data replication, and other database applications.
• Make periodic inspections of AIM spatial data updates and maintenance activities to determine conformance with established policies, plans, standards and procedures of the AIM protocols and instructing personnel in new procedural requirements for proper implementation of stream and terrestrial survey activities.
• Serve as contact for data access questions
• Assist with analysis of biological and physical components of ecosystems at a variety of temporal and spatial scales.
• Work as part of a team to build additional analysis and data visualization tools
• Conduct landscape level geospatial assessments to support specific ecological and natural resource questions.
• Support the integration of remote sensing into natural resource management and monitoring programs

CANDIDATE PERSONNEL SECURITY AND SUITABILITY REQUIREMENTS
The following forms and inquiries, or their equivalent, will be used to initiate the credentialing process:
•OPM Standard Form 85 or 85P
•OF306
•National Criminal History Check (NCHC)
•Release to Obtain Credit Information
•PIV card application

If selected to fill the position, a candidate would be required to pass a drug screen and satisfy the requirements of a National Criminal History Check (NCHC) to verify the identity of the individual applying for clearance and to determine the individual’s suitability for the position.

Applicant must be a U.S. citizen.

Sanborn offers a comprehensive health and wellness program which includes medical, dental, vision, 401k, holiday, PTO, EAP, disability and life insurance benefits.

TO APPLY: Visit our website: www.Sanborn.com to apply for this position. Sanborn is an Equal Opportunity Employer.

All Contents © 1999-2019. The GIS Jobs Clearinghouse