Title: Data Management Specialist 2- Aquatic Monitoring Data Scientist (21-1151)
Location: Corvallis, OR (97333)
Anticipated Start Date: October 1, 2021
Position Type: Full Year (20-29 hrs/week), Hourly/Non-Exempt
Benefits Eligible: No | www.psmfc.org/benefits
Salary Target: $22.41/hour
Job Number: 21-1151
How to Apply: Online at www.psmfc.org/careers
Closing Date: September 20, 2021 at Midnight PT
This is a data management position with the Pacific States Marine Fisheries Commission. The primary role of this position is assisting U.S. Geological Survey (USGS)-Pacific Northwest Aquatic Monitoring Partnership (PNAMP), with building novel integrated data sets that link each data collection location to other USGS and non-USGS resources.
The primary task of this position will be working with PNAMP to support integration, documentation and publication of novel integrated aquatic monitoring datasets. Specifically, the Data Specialist will assist with the PNAMP Habitat Metric Data Integration Project. This PNAMP project, initiated in 2019, has been developing methods for integrating and sharing stream data from multiple sources to decrease the time spent finding and organizing data to provide accurate and timely information for building indicators, completing analysis, and making decisions. The project has made considerable progress to review the response design metrics from four federal stream habitat monitoring programs: BLM AIM, EPA NRSA, USFS AREMP, and PIBO programs. The project adapted Darwin Core and other observation and measurement standards to exchange and combine stream habitat metrics and metadata. Darwin Core recommends using standard vocabulary for fields to create homogeneity in the data. The project recently facilitated a process to outline the controlled vocabulary and the field methods crosswalk from these programs. Based on the data exchange specifications, the controlled vocabulary and cross walk, data tables were built integrating data from three habitat monitoring programs. The project goal is to build a novel integrated data set and link each data collection location to other USGS and non-USGS resources to provide context to the data collection locations.
Applicants should be able to think and work independently, be self-motivated to complete tasks with little direct supervision.
1. Publishing novel integrated dataset via ScienceBase following USGS FSP process for data release, including appropriate metadata and code documentation. This may include reviewing ScienceBase documentation and reviewing GitHub documentation.
2. Assisting with drafting of summary report of methods used to create the novel integrated dataset, following USGS FSP requirements for publishing via a USGS series (either Methods and Techniques Series or Open File Report Series).
3. Compile data into standardized data formats. This includes accessing filed information and verifying accuracy and completeness, performing data entry, electronic data transfer, editing, and error checking.
4. Acquire disparate data sets and integrating these into a share file or database.
5. Serve as liaison with USGS staff working with PNAMP and with the USGS-Forest and Rangeland Ecosystem Science Center.
DESIRED EXPERIENCE (course work or job-related):
Five years of experience is preferred, but not required, in working with natural resources datasets; data management and database operations; and with Excel and Access.
Experience in environmental science, environmental management, fisheries management, or another related field. Experience with database design is a plus.
The Data Management Specialist must be detail oriented and work independently to identify and resolve data problems.
***This position requires a valid driver's license and all offers of employment will be contingent upon passing a driving records check.***
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:
• 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:
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. This knowledge allows the employee to assess the results and relate that to the overall objective of the assignment.
Additional Mandatory Skills:
• specific databases
• MS Access
• MS Excel
• MS Word
• oral communication skills
• writing technical documentation
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.
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.
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 (503) 595-3100 between the hours of 8 a.m. and 5 p.m. PST, Monday-Friday. Reasonable accommodations for interviews will be provided upon request to individuals with disabilities.
We maintain a drug-free workplace.
Minimum Qualification Requirements:
A range of experience 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.
**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.