Data Management Specialist 2- Natural Coordinated Assessments and StreamNet

PSMFC; Boise, Northern (ID, KY); Hybrid; USD 33,000 - 54,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Life insurance

Disability insurance

Retirement plan

Paid vacation

Flexible spending

Job summary

Pacific States Marine Fisheries Commission is seeking a Data Management Specialist 2 for the Natural Coordinated Assessments and StreamNet projects in Boise, Idaho. The role focuses on ETL into DES for natural origin fishes, validating data, and supporting regional data sharing for ESA/non-ESA species.

Responsibilities include developing data workflows, assisting biologists, and handling data requests from internal and external customers, with occasional travel to regional offices.

Qualifications

• Requires 2+ years Specialized Experience or a bachelor's in natural sciences; or 3+ years Specialized Experience or a master's in natural sciences or CS with NR background.
• Experience with ETL, data management concepts, QA/QC, and data sharing
• Ability to communicate goals to biologists and research staff; travel up to 10% may be required.

Responsibilities

• ETL data into established data exchange structures (DES) for natural origin fishes.
• Validate and upload data to regional database; document workflows for redundancy.
• Develop workflows; assist with data requests from internal and external customers.
• Collaborate with state, federal, and tribal partners in a regional environment.
• Mentor and support a Data Management Specialist I on Hatchery Coordinated Assessments project.

Skills

Analytical skills

Data interpretation

Communication

Education

Bachelor's degree in natural sciences

Master's degree in natural sciences or CS with NR background

Tools

MS SQL

MS Access

MS Excel

MS Word

ArcGIS Pro

R

Python

Job description

Data Management Specialist 2- Natural Coordinated Assessments and StreamNet

#26-1164

Boise, Idaho, United States

Job Description

Pacific States Marine Fisheries Commission is recruiting candidates to fill the role of the Data Management Specialist 2 - Natural Coordinated Assessments and StreamNet. This is a full-time, full-year benefits eligible position located in Boise, Idaho. The anticipated start date is January 2027.

Position/Project Specifics

The Coordinated Assessments Partnership (CAP) and StreamNet (SN) are collaborative efforts among federal, state, and tribal organizations creating access to standardized anadromous fish high level indicators (HLI) and fish monitoring metrics for informing regional assessments and reporting needs. The CAP has a hatchery origin component (HCA) and a natural component (NCA).

The data sharing achieved through the Pacific Northwest CAP and StreamNet projects inform decisions and reporting requirements that relate to both ESA-listed and non-listed salmon and steelhead, as well as other associated species.

This position will be primarily focused upon data extraction, transformation, and loading (ETL) into established data exchange structures (DES) for natural origin fishes. Additionally, they will aid in the development and testing of new data exchange structures both for natural and hatchery origin fishes.

The tasks related to achieving the objectives above will include communicating goals and needs of the project to biologists and research staff, collaborating with those personnel to locate appropriate data sources, and then developing workflows to ETL those data into the regional DES. The data will then be validated and uploaded to a shared, regional database. The workflows will be documented and shared with project personnel in order to build redundancy.

This position will also aid with meeting data and technical assistance requests for these data from internal and external customers. Some travel to regional offices may also be needed.

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, employees:

• Compile natural resource 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.
• Assist biologists with analyses and interpretation of data.
• Keep records on methods and parameters of data collection.
• Extract relevant data and present it in a variety of text and numeric formats, reports, tables, graphics, or figures.
• Maintain local versions of datasets in accordance with established regional database exchange formats and standards.
• Create queries, summaries, and/or maps for recurring reports.
• Ensure annual submittals for datasets are competed according to schedule

At the upper end of the range, employees:

• Standardize and automate workflows using SQL, ArcGIS Pro, R, and other software to streamline dataflow and provide quality assurance and quality control (QA/QC).
• Develop documentation and protocols using technical and non-technical formats.
• Work with internal and external collaborators, including state, federal, and tribal partners in a regional, consensus-driven environment.
• Attend technical and upper-level meetings for project direction and feedback. Take lead role on presenting information from biologist to technical committees for implementation into workflows.
• Supervising, mentoring and fostering the growth of a Data Management Specialist I working on Hatchery Coordinated Assessments Project.

Knowledge Required by the Position

The employee must have knowledge and experience in:

• natural sciences
• personal computers and software packages and applications for databases, spreadsheets, and word processing
• data management concepts, principles, and methods
• quality assurance principles
• common query languages
• Supervising or mentoring
• MS SQL
• MS Access
• MS Excel
• MS Word
• ArcGIS Pro
• 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 or interpret the significance of the results and relate that to the overall objective of the assignment.

Additional Desirable Knowledge and Skills

• R (including Shiny Apps and Markdown)
• Python (within a GIS environment)
• oral communication skills
• writing technical documentation
• Application Programming Interface (API) creation, management

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. Significant amounts of time may be spent on the phone.

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.

Qualifications

Minimum Qualification Requirements: A range of experience and education may be presented. At the lower end of the range, candidates must present at least two years of Specialized Experience** OR a bachelor's degree in the natural sciences (biology, fishery biology, environmental science, aquatic science, geology, chemistry, physics, mathematics, statistics), or any other field that provides the same knowledge. An equivalent combination of experience and education is also qualifying. At the upper end of the range, candidates must present at least three years of Specialized Experience** OR a master's degree in the natural sciences (biology, fishery biology, environmental science, aquatic science, geology, chemistry, physics, mathematics, statistics) OR a master's degree in computer science with a natural resources background. An equivalent combination of experience and education is also qualifying. **Specialized Experience is 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.

Location

12 months or more

Position Type

Full-Year

Travel Requirements

Up to 10%

Full-Year Employees working at least 30 hours a week are covered by the Company's Life, LTD and AD&D plan. They are eligible to enroll in medical, dental and vision insurance, as well as short term disability, voluntary Life, LTD and AD&D insurance, flexible spending and deferred compensation. An employee receives up to 120 hours of vacation during their first three years of service. After that, the amount of vacation increases every three years of service up to a maximum of 192 hours per year.

Driving

State Vehicle - Valid driver's license required. Offers of employment contingent upon passing driving records check.

Salary Target

$24.26-38.58/hour

Closing Date

undefined

PSMFC participates in E-Verify. We consider all qualified candidates legally authorized to work in the United States and able to provide proof of eligibility. PSMFC is unable to support visa sponsorships or extensions.

Pacific States Marine Fisheries Commission is an affirmative action (AA) and equal employment opportunity (EEO) employer, and welcomes all qualified applicants. Applicants will receive fair and impartial consideration without regard to race, sex, color, religion, national origin, gender identity, age, mental or physical disability, sexual orientation, veteran status, genetic data, or other legally protected status.

If you have a disability and need assistance completing the application form, you may call the PSMFC Human Resources office at [phone] between the hours of 8 a.m. and 5:00 p.m. PT, Monday-Friday. Reasonable accommodations for interviews will be provided upon request to individuals with disabilities.

We maintain a drug-free workplace.