Job: Aquatic Data Manager, GeoSearch, Inc., Lakewood, CO
This is a Full-time, 24 months with an option to extend 12 additional months.
We are seeking an Aquatic Data Manager to work directly with its federal government client at the Federal Center in Lakewood, Colorado. The successful candidate will apply their knowledge of natural resource management and GIS expertise to give input to the design of, update, and maintenance of multiple databases and related tools for aquatic inventory management. The successful candidate will also assist and coordinate the development, configuration and maintenance of databases and related tools developed by other contractors and federal employees. The Aquatic Data Manager will work in many different software environments such as ArcSDE, Access, Microsolf SQL, R, and Survey 123.
- 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 aquatic management initiatives
- Maintain proprietary data collection applications 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 aquatic monitoring program
- Develop and maintain a Sample Design database which is used to capture feature level metadata related to the development of individual aquatic management 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 monitoring 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 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 spatial data updates and maintenance activities to determine conformance with established policies, plans, standards and procedures of the aquatic management 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
- Conducts landscape level geospatial assessments to support specific ecological and natural resource questions
- Supports the integration of remote sensing into natural resource management and monitoring programs.
- Experience of more than 4 years with ESRI’s ArcGIS Desktop software. Preference will be given to the candidate(s) demonstrating at least 1 year experience using ArcGIS Desktop 10.4 or higher.
- 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. Demonstrating in narrative form an 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
- 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