Group Definition:  Data Management Specialists (Natural Sciences) use a background in the natural sciences as they assist in the population, maintenance, enhancement and distribution of databases.  They locate, obtain, standardize, enter, verify, and correct various data sets related to project goals and work plans.

Position/Project Specifics:

The Pacific States Marine Fisheries Commission (PSMFC) is seeking a self-motivated and high performing Data Management Specialist 2 (Natural Sciences) - Collaborative Processes and Product focused. The Specialist will be assisting primarily with the collaborative Klamath Basin Monitoring Plan project and the Klamath Basin Fisheries Collaborative (www.kbfishc.org). This position is anticipated to last 2-years, with the potential to be extended depending on funding.

The position requires working at the PSMFC office in Portland, Oregon. The individual will work within a PSMFC team and will engage with tribal, federal, state agency partners, watershed councils, and others that are involved with these projects by supporting collaborative meetings and other tasks.

The Specialist will work closely within a team environment on a diversity of tasks that range from compiling information from multiple sources, updating program websites, developing draft products (e.g., documents, presentations, spreadsheets) for use in existing processes, and supporting a diversity of collaborative processes.

The main duties of this position include:

1. Assisting with the compilation and synthesis of information to support the development of collaborative products informing a post-dam removal Klamath Basin monitoring plan and selection criteria for proposed projects
2. Assisting with content management and updates to the WordPress project websites and related tools, including  https://www.kbfishc.org/and https://www.ifrmp.org/

3. Collaboratively working with the PSMFC Project lead in writing and formatting outreach materials, such as brief newsletters to members.
4.Providing technical support to KBFC members submitting data in and/or accessing data from the KBFC data system, and to others using Klamath Basin tools supported by the PSMFC team, such as the IFRMP.org website tools
5. Participate in organization and implementation of collaborative meetings by taking meeting notes, assisting with preparation of meeting material and presentations. Including assisting with the Klamath Basin Collaborative Plan meetings and work-sessions, and a proposed 2026/2027 Klamath Basin Science Summit.
6. Contribute as a team member to identify options for addressing needs and assist with development of material to implement solutions
7. Communicate with other PSMFC staff, as needed, for information sharing and problem resolution on issues.
8. Effectively communicate (written and verbal) with a variety of partners (data consumers, data providers, biologists, fisheries managers and data stewards) about data needs
9. Collaboratively work on teams with PSMFC staff and external partners, including state, tribal and federal fish and wildlife management agencies that engage in these collaborative processes.
10. Supporting other PSMFC collaborative data projects with similar tasks.

The selected individual will plan and carry out assignments independently under the general guidance of senior team members and the Senior Program Manager.

The candidate must be comfortable working on multiple tasks, able to re-prioritize their work, be a proven team player, and understand the criteria for respectful collaboration. The position requires developing and maintaining working relationships with a wide range of colleagues and partners that have a diversity of expertise related to natural resources, data systems, and facilitation. Applicants should be able to think and work independently, self-learn, and be self-motivated to complete tasks with little direct supervision. Applicants should have experience with, or demonstrate ability to learn WordPress, Elementor (Website Builder), Trello, MS Teams, SharePoint, Microsoft Excel, PowerPoint, and Word.

Background Project Information

The Klamath Basin Monitoring Plan project focuses on developing a post-dams Klamath Basin Monitoring Basin with Klamath Basin stakeholders and existing collaborative groups such as Klamath MOU Signatory parties, Klamath Basin Monitoring Program (KBMP), Klamath Basin Fisheries Collaborative (KBFC), and watershed initiative groups throughout the Klamath Basin. This project will support open meetings to engage monitoring practitioners and other experts and stakeholders and assist with the development of a post-dam removal monitoring strategy, including funding strategies to ensure monitoring is prioritized and funded. The project will maintain and improve the existing IFRMP.org website and add new webpages to provide access to the Collaborative Process as well as the 2026-2027 Klamath Basin Post-Dam Removal Science Summit.

The Klamath Basin Fisheries Collaborative (KBFC) project is a Klamath Basin wide effort, integrating work across what historically has been termed the “lower” and “upper” basin regions. This Project purpose supports a collaborative effort to monitor and evaluate using fish tracking infrastructure (e.g. PIT tags) and associated fisheries historic river restoration opportunities and effects on imperiled fish species including Lost River suckers (Chasmistes brevirostris), shortnose suckers (Deltistes luxatus), coho salmon (Oncorhynchus kisutch), Chinook salmon (Oncorhynchus tshawytscha), and other native fish. The KBFC's work is strongly dedicated to improving the quality and quantity of data that are needed to inform decisions and to assess progress towards the Klamath Basin Integrated Fisheries Restoration and Monitoring Plan's (IFRMP)'s Fish Core Performance Indicators. The KBFC members are continuing to improve existing fish monitoring efforts by documenting and coordinating monitoring activities, investing in tagging and tag detection supplies, and advancing data exchange by refining the data system and providing technical support to data providers.

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 documents. Coordinate the regular transfer of reference materials to archives and libraries.
• Perform a variety of tasks related to Geographic Information Systems (GIS) that 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 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 must:

• 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 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 on-line user inquiries about access to the database and data retrievals, the execution of query scripts, and standard report programs.                                                                                 

Knowledge Required by the Position:

• 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.  This knowledge allows the employee to assess the results and relate that to the overall objective of the assignment. 

Additional Mandatory Knowledge and Skills: 

• MS Excel                                            
• MS Word                                
• MS PowerPoint                                                   
• MS SharePoint or equivalent
• Additional Desirable Knowledge and Skills:
• MS Access
• MS SQL or equivalent                                 
• ARC GIS or ESRI Online
• ESRI Survey 123
• WordPress or equivalent
• Elementor or equivalent
• Trello

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 office, meeting rooms, libraries, and the like.   

PSMFC is an EEO/AAP Employer. We maintain a drug free workplace.