Geographer

Position: Geographer 3
ASSIGNMENT RESPONSIBILITIES

Note:

All official drafts, documents and recommendations, as listed below, must be reviewed, finalized and approved / accepted by appropriate BPA manager or other federal personnel with the authority to do so.

Provides SDE enterprise GIS cultural geodatabase administration and maintenance functions within scope and authority of non-IT GIS personnel to validate optimal database integrity and performance. This includes the development and maintenance of documents related to data management and multi-user version editing workflow processes, procedures, and tools to provide training and guidance for cultural staff.

Maintains technically complex GIS projects in support of cultural resource legal compliance for BPA transmission construction projects, fiber optic projects, communication system projects, land management and environmental projects, Fish and Wildlife Program projects and operation and maintenance of the Federal Columbia River Power System (FCRPS). Support includes project specific spatial analysis, design, and preparation of publication-quality cartographic and tabular report products.

Promotes multiple long-range GIS/database priorities for cultural resource programs. Coordinates and tracks projects, workload forecasting, and work assignments for FCRPS operations and maintenance work, and for Area of Potential Effects and public notification maps related to a wide variety of Transmission, Fish and Wildlife, and FCRPS Cultural Resources Program projects.

Assists with the creation and maintenance of an enterprise-wide set of standard ArcGIS feature classes specific to the cultural resources group, that include standard schemas, projection, symbology, database query statements and current metadata.

Develops, configures and administers ArcGIS Online cloud-based web mapping portal environment using industry standard web and software development tools and scripting languages.

Maintains and updates an enterprise mobile data collection workflow using off-network Android tablets, Trimble R1 Global Navigation Satellite System (GNSS), Global Positions Systems (GPS) receivers and ArcGIS Online (AGOL) off-premises hosted services.

Performs geographic analyses, including but not limited to viewsheds, spatial joins, proximity analysis, buffer creation, optimal path and resource allocation, and point and linear event processing with dynamic segmentation.

Maintains geospatial databases and schemas and validates data quality and integrity using automated and manual techniques to enter, edit, and process data sets.

Creates advanced geoprocessing models and/or scripts to assist in data collection, storage, integration, visualization, and retrieval and analyses using automated techniques.

Develops custom web mapping applications using industry standard software development tools (HTML) and scripting languages such as JavaScript, Visual Basic, Perl, etc. to support project specific visualization and status reporting portals. May also include the use of version control systems to manage and document code revisions.

Prepares and maintains metadata of newly created data sets to track the source, scale, currency and other pertinent geographic information, as well as any modifications to the data set.

Publishes map services of spatially enabled datasets to facilitate program level planning, estimating, and reporting in ArcGIS Server for on premise data hosting.

Serves as liaison to BPA's Geographic Information Systems (GIS) department for integration of cultural resource program's GIS/GPS data with GIS department data. Also serves as technical point of contact for cultural resource GIS and database contracts.

Develops, tests, and maintains MS Access relational databases.

Designs logical/physical data models using MS Visio.

Drafts and maintains schema and metadata standards for cultural resource GIS contract deliverables. Reviews draft contract statements of work and resulting deliverables for consistency with established standards. Alerts BPA manager (or designee) of any inconsistencies or potential issues.

Prepares and maintains BPA GIS datasets for external data sharing agreements and requests.

Provides demonstrations, presentations, and related documentation to BPA staff and partners across the region. Also provides technical guidance and user training to external partners and BPA staff as requested.

Supports the timely delivery of data between Geospatial Services and other organizational units used in the design, acquisition, and construction of BPA's Transmission facilities, Fish and Wildlife mitigation projects, and operation and maintenance of the FCRPS.

Trains staff on web mapping applications (eGIS and AGOL), SAS applications (Collector for ArcGIS) as well as desktop ESRI clients (Arc Map, Arc Catalog).

Provides support for EH staff in the field when requested, which could involve travel and overnight stays.

Marks documents and maintains filing system(s), files, emails and records in accordance with compliance…