Location: PSMFC Sellwood
Project Length: 12 months or more
Position Type: Full-Year
Travel Requirements: Up to 10%
Water Vessel Operation: No
Driving: None
Salary Target: $29.45-31.00/hr
Closing Date: May 8, 2023

Position/Project Specifics
The Data Management Specialist (GIS) serves as a core member of the PSMFC GIS Team. The position reports to the GIS Manager and collaborates with project-funded members of the Team (GIS Specialist & Senior GIS Analyst) to provide systems technical support, assist with data management and development efforts, and broadly support the use of GIS technology. The position requires excellent in-person, telephone, virtual meeting, email communication skills, and a customer service mindset. The position will use GIS and database management software to create, document, synthesize and share data products and will provide GIS technical support services to colleagues, project partners, and end-users of PSMFC’s spatial data products.

The position will be full-time (40 hours/week) for one year with the possibility of an extension, and pay will be commensurate with experience.

Specifically, this position will carry out the following tasks:

  • Assist the GIS Manager with systems administrative tasks related to PSMFC’s ArcGIS Enterprise instances and ArcGIS Online platform.
  • Provide helpdesk-type functions to assist users of centralized GIS resources commission-wide.
  • Assist GIS Manager with ESRI GIS software license management and account administration on the ArcGIS platform and curate content on the platform (documenting, cataloging, highlighting, and maintaining core items).
  • Perform a variety of tasks related to Geographic Information Systems (GIS) that may include geo-referencing biological or habitat data, maintaining location information tables, and maintaining GIS data layers.
  • Create queries, summaries, maps, and graphs in response to custom information requests.
  • Support ESRI Field data collection workflows and applications (Field Maps, Survey 123, Collector…) and provide guidance and backup technical support for PSMFC projects that are leveraging these workflows through PSMFC’s ArcGIS Online platform.
  • Support maintenance of project websites and `groups’ on ArcGIS Online and coordinate with project staff to standardize and verify the collection and reporting of website and application usage metrics. Support high-level reporting of resource usage, particularly for projects that are leveraging PSMFC’s Enterprise GIS.
  • Stay informed on the latest trends and developments related to natural resources applications of GIS technology, and provide training and technical advice to project staff and partners.
  • Create and update core framework datasets for consistent georeferencing of data across PSFMC projects. Actively encourage and facilitate the use of these framework data layers (e.g., fish data collection facilities, ports, harbors, marine managed areas…).
  • Maintain and update data catalogs or repositories designed to facilitate the sharing of well-documented data among project partners.
  • Assist projects with designing and hosting interactive web applications including map viewers, story maps, and dashboard applications. Assist with developing and printing cartographic products and large-format posters.
  • Attend weekly GIS Team meetings, and monthly IT meetings and, occasionally, join project staff meetings for projects that are leveraging the GIS or have short-term support needs related to spatially enabling their project data.

Essential Functions
(The functions listed below are characteristic of the type and level of work associated with this group and pay band. They are not all-inclusive. Individual positions may perform some or all, as well as other similar work.)

At the lower end of the range, Data Management Specialists (Natural Sciences):

  • Compile project data into standardized electronic data formats. This includes accessing filed information and verifying its accuracy and completeness, performing data entry, electronic data transfer, editing, and error checking.
  • Extract relevant data which may be presented in many different text and numeric formats, reports, tables, graphics, or figures.
  • Maintain local versions of datasets in accordance with established regional database exchange formats and standards.
  • Maintain a local archive of current and historical reports and Coordinate the regular transfer of reference materials to archives and libraries.
  • Perform a variety of tasks related to Geographic Information Systems (GIS) using ArcGIS Pro. Tasks may include map preparation, geo-referencing biological and habitat data, maintaining location information tables, editing and updating hydrography GIS coverages, and maintaining metadata for data sets and GIS coverages.
  • Train technical and general users in the use of GIS and database applications through individual instruction and/or group presentations.
  • Create queries, summaries, and/or maps in response to requests for customized data.
  • Prepare and manipulate various data and graphic outputs for use in reports, presentations, and internet applications using standardized retrieval scripts.

At the upper end of the range, employees:

  • Develop and implement databases and libraries. Includes acquiring new data as well as taking previously created or historical databases or spreadsheets and integrating them. Data sources vary in a format including database, spreadsheet, and survey data sets. Custom interfaces may be required.
  • Produce written research and statistical reports (including graphs, tables, maps, and text), data sets, and data summaries using a variety of analytical techniques and software tools. This involves the master-level use of database retrieval scripts.
  • Document data handling and reporting to ensure consistency and validity of data between and within sites. Files may come from sources that use different computer hardware, software systems/protocols, and different communication packages.
  • Maintain and update data catalogs, data catalog directories, and metadata.
  • Perform system maintenance and backups. This includes routine database checkpoints, checkpoint verification, tuning, data-process merges, and user account management. Restore files when required.
  • Perform Help Desk functions, responding to online user inquiries about access to the spatial data resources and data retrievals, the execution of query scripts, and standard report programs

Knowledge Required by the Position
The employee must have knowledge of:

  • natural sciences
  • computers and software packages and applications for databases, spreadsheets, and word processing
  • data management concepts, principles, and methods
  • quality assurance principles
  • technical documentation methods and procedures
  • analytical methods and common query languages
  • the organization’s data sets sufficient to: input data; structure information retrievals; edit, combine and manipulate data; and/or provide reports for users.

Additional Desirable Knowledge and Skills:

  • Excellent communication, organizational, and customer service
  • Experience with data collection interviews or field data collection.
  • Knowledge of West Coast marine, estuarine and inland fisheries
  • Experience working with fisheries data and information related to natural resources management.
  • Coursework or working knowledge of data management concepts and GIS
  • Experience with ArcGIS Pro workflows including the use of python scripting and model builder.
  • Experience using and editing relational databases and documenting technical procedures.
  • Experience using online data repositories and project management/collaboration tools.
  • Experience and interest in working with the ArcGIS platform, including systems administration tasks.
  • Experience curating content in ArcGIS Enterprise and/or ArcGIS Online.

Physical Demands:

  • The work is generally sedentary, although there may be some nominal walking or standing for short periods of time, or carrying of light loads of papers, books, reports, etc. that require only moderate physical ability and physical stress.

Work Environment:

  • The works area is adequately lighted, heated, and ventilated. The work involves the common risks or discomforts typical of offices, meeting rooms, libraries, and the like.

Qualifications and Education Requirements
A range of experiences and education may be presented. Candidates must present one year of Specialized Experience** AND four years of successfully completed education above high school in the natural sciences (biology, fishery biology, environmental science, aquatic science, geology, chemistry, physics, mathematics). An equivalent combination of experience and education is also qualifying.

  • Bachelor’s Degree or Master’s Degree in Biological, Environmental, Natural Resources Sciences or Geographic Information Systems.
  • Proficiency with data entry, office productivity, GIS, and relational database management software, including Microsoft Excel, Access, and SQL Server.
  • A solid understanding of and experience working with spatially explicit environmental and natural resources data.

**Specialized Experience is an experience that equips the applicant with the knowledge, skills, and abilities to perform successfully the duties of the position and is typically in or related to the work of the position being filled. To be creditable, Specialized Experience must have been equivalent to at least the next lower level in the normal line of progression for the position being filled.

For more information and to apply: https://recruiting.adp.com/srccar/public/nghome.guid?c=1161651&d=External&prc=RMPOD3&r=5000942795306#/