Job Postings:

PSMFC Database Engineer/Database Management Specialist

Salary: $28.64/hour or higher (DOE)

Location: McCall, Idaho

Closing Date: June 12th, 2026

Position Overview:

Pacific States Marine Fisheries Commission (PSMFC) is recruiting candidates to fill the role of a mid-level Data Engineer / Database Specialist, working closely with USGS researchers at the Klamath Falls Field Station. The incumbent will support long-term research on endangered Lost River and Shortnose suckers, helping translate decades of biological, telemetry, and environmental data into insights that guide species recovery and water management in the Klamath Basin. 

This role meaningful responsibility and real-world impact. The incumbent will design and build modern, cloud-enabled data systems, improve legacy workflows, and collaborate directly with scientists to advance critical research. 

The position is based in Portland, Oregon and includes regular travel to Klamath Falls (approximately one week per month) to work on-site with the USGS researchers, with a potential option to relocate to Klamath Falls, Oregon. 

Group Definition: Database Management Specialists develop and administer large-scale, multi-agency database systems. They have responsibility for maintenance, tuning, running backup and recovery, growing the system, administering permissions and security, and assuring continuous system availability.

Our Team

The incumbent will join a small, highly collaborative team working closely with USGS scientists to turn research needs into technical solutions. The incumbent will perform query and analyze data, support modeling and system performance, and help modernize workflows. In this role, the incumbent will also collaborate with IT on security and access, contribute to data governance practices, and support GIS and field data collection systems, while helping teammates grow through knowledge sharing and collaboration. 

Project Specifics 

Contribute to the design and modernization data systems that support fisheries research and real-world decision making in the Klamath Basin. Build reliable, scalable data platforms, improve legacy systems, and collaborate closely with scientists to turn complex data into actionable insights. We don’t expect candidates to bring experience in every listed technology—strength in core data skills and a willingness to learn are what matter most. 

Essential Functions 

The data professional should have 3+ years of experience and can design, build, and improve scientific data systems. The ideal candidate brings strong data engineering and database skills, along with the ability to collaborate effectively with scientists and IT partners. 

Data & Platform Management 

• Design, build, and maintain relational databases (e.g., SQL Server, SQLite) 
• Perform data modeling, schema design, and performance optimization 
• Implement reliability practices (backup/recovery, access controls, availability) 
• Maintain documentation and support data stewardship practices 
• Troubleshoot and resolve database performance and integrity issues 

Data Engineering & Integration 

• Build and support automated data pipelines (ETL/ELT) 
• Use SQL and scripting tools (Python, R, or similar) for data processing 
• Integrate diverse datasets into centralized systems 
• Refactor legacy scripts and workflows into scalable, automated pipelines 

Analytics & Data Products 

• Develop queries and reporting solutions (e.g., Power BI) 
• Build reproducible analytical workflows in Python or R 

Collaboration  

• Partner with scientists, engineers, and IT staff 
• Communicate technical concepts to non-technical audiences 

Support Modernization 

• Support migration of legacy systems into modern, cloud-enabled environments 
• Contribute to ongoing system and workflow improvements 

Additional Mandatory Skills: 

Databases and Data Engineering 

• 3+ years of experience in data engineering and/or database administration 

Programming languages: 

• Strong SQL proficiency and at least one scripting language (Python or R) 

Additional Desirable Skills: 

Data & Data Architecture  

• Experience with data architecture and system design 

Cloud and Modern Platforms 

• Knowledge of cloud platforms (Azure preferred; AWS/GCP acceptable) 
• Familiarity with workflow automation or orchestration tools 

Analytics & Visualization 

• Knowledge of dashboards, Power BI or similar data visualization tools 
• Familiarity AI assisted tools 

GIS Technology and Field Data Systems 

• Exposure to GIS systems (ArcGIS, QGIS) or spatial data is a plus 
• Support ingestion workflows for field/mobile data collection systems (e.g., data from ESRI Survey123). 

Data Governance & Lifecycle Management 

• Contribute to improving data governance or metadata practices 
• Familiarity with data lifecycle management and long-term data stewardship concepts 

Operating Systems and Legacy Support 

• Support migrating legacy systems or applications (C#, VB) 
• Familiarity with Windows Server and/or Linux environments 

Domain Experience 

• Familiarity working with scientific, environmental, or ecological datasets 
• Familiarity with fisheries data, telemetry, tagging, or movement data 

Collaboration and Leadership Skills 

• Interact with contractors and with IT on security, permissions, and cloud migration (e.g., Azure) 
• Help team members grow by sharing knowledge and providing guidance 

Knowledge Required by the Position: 

• Database management concepts, principles, and methods including database logical and physical design, normalization, storage capacity management, and back-up and recovery. 
• Data flow design and business process design. 
• Sources, characteristics, and uses of the organization’s data assets. 
• Database management systems, query languages, table relationships, and views.  
• Data mining and data warehousing principles  
• The characteristics of physical and virtual data storage media. 
• Data administration and data standardization policies and standards in developing and managing large-scale, multi-agency databases. 

Physical Demands: 

The work is sedentary with moderate walking between workstations and carrying folders, reports, and similar light loads. 

Work Environment: 

The work is performed in an office setting with adequate lighting, heating and ventilation. There are the normal risks of an office environment. 

Qualifications

Minimum Qualification Requirements: 

Candidates must present one year of Specialized Experience which demonstrates: 

• Knowledge of customary approaches, techniques, and requirements appropriate to database management; 
• Knowledge of planning sequences necessary to accomplish assignments where this entailed coordination with others outside the organizational unit and development of project controls; and 
• Adaptation of guidelines or precedents to the needs of the assignment. 

The Specialized Experience must equip the candidate with the particular knowledge, skills, and abilities to perform successfully the duties of the position and is typically in or related to the work of the position to be filled. To be creditable, the Specialized Experience must have been equivalent to at least the next lower level in the normal line of progression position. 

To work with USGS Data Systems, the Candidate must also meet the below minimum requirements: 

• Federal System Access: Must meet federal eligibility requirements to access and utilize federal data systems. 
• Citizenship & Residency: Due to federal security mandates, this position requires U.S. citizenship or lawful permanent residency (Green Card holder) maintained for a minimum of three consecutive years. 

• Background Investigation: Position is contingent upon the successful completion of a comprehensive federal agency background investigation. 
• Driving Clearance: Offers of employment for positions located in Oregon are contingent upon supplying and clearing an MVR check. The selected candidate must provide PSMFC with a copy of their 3-Year Oregon Motor Vehicle Record (MVR) and are are responsible for all associated DMV fees. 

---

Posted 5/22/2026

NPT Watershed Restoration Specialist II

Salary: $28.64/hour or higher (DOE)

Location: McCall, Idaho

Closing Date: June 12th, 2026

Posted 6/4/2026

Position Overview:

The Nez Perce Tribe is seeking a motivated and qualified professional to fill a full-time Watershed Restoration Specialist II position. This role offers the opportunity to work with a highly experienced team dedicated to restoring and protecting aquatic ecosystems critical to Endangered Species Act listed fish (Chinook salmon, steelhead and bull trout) recovery.

This position blends office-based technical work during the winter with hands-on field work and project oversite during the snow free months. 

Office Responsibilities:

• Analyze and summarize watershed data
• Prepare reports and technical documents
• Utilize GIS tools (ArcGIS)
• Develop restoration plans
• Secure environmental compliance for projects
• Monitor and report on project implementation
• Assist with grant writing and project development
• Coordinate with project leadership and partner agencies

Field Responsibilities:

• Supervise field crews
• Conduct fisheries and stream habitat surveys
• Perform culvert and road assessments
• Oversee restoration projects such as culvert replacement, road removal, riparian planting, water quality and quantity monitoring. 

Minimum Qualifications

• Bachelor’s degree in a related field (Master’s preferred)
• Three (3) years of related professional experience
  • OR one (1) year of professional experience with a Master’s degree
• At least one (1) year of supervisory experience
• Strong written and verbal communication skills

Note: Experience cannot be substituted for education.

Application Requirements

Applicants must submit:

• A Nez Perce Tribe Employment Application
• Cover letter
• Resume
• Three (3) letters of reference
• Unofficial college transcripts

Applications can be emailed to: teamhr@nezperce.org

In the subject line make sure to note: Watershed Specialist II (HR-26-141)

Or mailed to: Nez Perce Tribe Human Resources Office

                       Attn: Watershed Specialist II (HR-26-141)

                        PO Box 365

                        Lapwai, Idaho 83540

Additional Requirements

• Valid driver’s license and insurable under Tribal policy
• Current Driver’s License Record (DLR) from any state licensed within the past three (3) years
• Pre-employment drug testing required (drug-free workplace)

A full job description is available on the Tribes Employment Webpage.

Federal Jobs
Nez Perce Tribal Employment
State of Idaho
Idaho Department of Fish and Game Temporary Employment
State of Montana
State of Nevada
State of Oregon
State of Utah
State of Washington
State of Wyoming