This job was posted by https://idahoworks.gov : For more information,
please see: https://idahoworks.gov/jobs/2518644
The Idaho Department of Fish and Game (IDFG) Nampa Research Station
conducts monitoring of ESA-listed Snake River Chinook Salmon, steelhead,
and Sockeye Salmon at Lower Granite Dam, the first dam encountered by
adult fish returning from the ocean on the Snake River. The project
integrates data from multiple sources including daily fish trap
operations, PIT tag detection arrays, coded wire tags (CWT), genetic
stock identification, and otolith/scale-based age determination. These
data are used to estimate run abundance, productivity, and survival
through statistical models, and the results are reported annually to
state and federal fisheries management agencies. The research is
conducted in coordination with NOAA Fisheries, the Pacific States Marine
Fisheries Commission (PSMFC), and other regional partners. Data
integrity and timely management of the multiple interrelated databases
that support this program are essential to its scientific and regulatory
functions.
Main Day-to-Day Tasks and Duties andApproximate time allocations:
Database monitoring and maintenance (~30%): Monitor automated daily
append of trap data to the LGDTrapping database; troubleshoot
pipeline failures; coordinate with PSMFC, federal, and state
partners as needed.
Biosamples queue management (~20%): Monitor the age lab upload
queue; append new biosample records and age determinations to the
Biosamples database; ensure timely linkage of scale ages to trap
database records.
Quality control (~15%): Conduct monthly QC of trapping database
records; identify and resolve duplicate sample numbers and other
common errors.
Seasonal data preparation (~10%): Prepare in-season PIT tag
analysis spreadsheets for various anadromous species in coordination
with project biologists; upload juvenile fish bypass data,
temperature logger data, and trap operations records on a seasonal
schedule.
CWT coordination (~10%): Prepare collection kits for coded wire tag
sampling; coordinate snout collection and return with hatchery
partners; manage snout sample inventory; extract, read, and record
CWTs from snout samples; upload CWT recoveries to Regional Mark
Information System (RMIS).
SharePoint administration (~5%): Manage membership and content for
multiple SharePoint collaboration sites supporting the Nampa
Research program.
Data requests and miscellaneous (~10%): Respond to internal and
external data requests; maintain PTAGIS subscriptions; assist with
server backups and file server maintenance. Field survey
opportunities (e.g., redd surveys) are available on a voluntary
basis.
Lead / Supervisory Responsibilities
The DMS II does not directly supervise staff but works
semi-independently and coordinates with a broad group of internal and
external collaborators including project biologists, age lab staff,
geneticists, NOAA personnel, and PSMFC contacts. The position requires
the ability to prioritize competing tasks with minimal oversight and to
proactively communicate data pipeline issues to the supervising
biologist.
Additional Skills (Mandatory: M/Desirable: D)
Proficiency in SQL or a relational database platform (e.g., MS SQL
Server, Access) M
Proficiency in R or Python M
Ability to work independently and manage multiple concurrent deadlines
M
Strong attention to detail and commitment to data integrity M
Effective written and verbal communication with diverse technical
collaborators M
Experience with automated data pipelines or scheduled database jobs D
Experience with R Markdown or other reproducible reporting tools D
Familiarity with PTAGIS, RMIS, or other Pacific salmon data systems D
Microsoft SharePoint site administration D
Experience with fisheries or ecological field data D
Familiarity with otolith and scale-based age determination workflows D
Familiarity with federal and state anadromous fish monitoring programs,
including ESA-listed Snake River populations D
Experience with salmonid redd surveys or other anadromous fish field
monitoring methods D
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
