Environmental Data Analyst

GSI Environmental Inc.; Olympia (WA); Hybrid; USD 76,000 - 110,000; Full time

Benefits offered by this job

Competitive salary

Bonuses

Remote work potential

Mentorship

Conferences participation

Collaborative environment

Base salary varies

Job summary

GSI Environmental Inc. seeks an Environmental Data Analyst to strengthen our data management, analysis, and visualization team.

You will build and maintain relational databases, develop ETL pipelines in SQL, Python, and R, and provide query, reporting, and visualization support across projects. The role involves collaborating with engineers and scientists, performing QA on datasets, and creating dashboards and reports aligned with project goals.

Qualifications

• BS/BA or higher in data science, computer science, statistics, environmental science, or related field.
• 2–5 years in data management or analysis with strong relational DB skills.
• Advanced SQL for data cleaning, transformation, and structuring.
• Familiarity with data modeling, normalization, and backups.
• Experience with Python and/or R for analysis, visualization, and dashboards.
• Shell scripting (Bash) and Linux command-line comfort.
• Excellent communication and ability to manage multiple tasks.

Responsibilities

• Maintain relational databases of environmental chemistry data from multiple sources.
• Build ETL and analysis workflows in SQL, Python, and/or R.
• Support statistical and spatial analyses with multidisciplinary teams.
• Create dashboards and formatted visuals for technical reports.
• Organize data to support automation and downstream analysis.
• Perform QA on analytical databases to ensure data integrity.
• Support projects from litigation to research data mining.
• Communicate findings to clients clearly.
• Complete tasks on schedule and within budget while meeting quality standards.

Skills

SQL

Python

R

Data visualization

ETL

Linux

Bash

Git

Dashboarding

Django/Flask

Education

BS/BA or higher in data science, CS, statistics, environmental science, or related field

Tools

PostgreSQL

Microsoft SQL Server

Microsoft Access

SQLite/DuckDB

Job description

Overview

GSI is seeking an Environmental Data Analyst who combines technical ability, analytical creativity, and business acumen to strengthen our data management, analysis, and visualization team. The ideal candidate is comfortable across the full data lifecycle—building and maintaining relational databases, developing analysis and automation pipelines in SQL, Python, and/or R, and providing query, reporting, and visualization support in a collaborative organization working closely with technical staff. Familiarity with environmental chemistry data generated from field investigations of water, soil, sediment, air, and biological matrices is valued. The candidate should know how to analyze system requirements and be familiar with relational databases, statistical analysis, and modern data visualization techniques using relevant and current tools.

GSI provides high-quality technical and regulatory expertise to industry and government to address a broad range of environmental issues. We specialize in solving complex environmental problems by leveraging our extensive knowledge of environmental regulations, stressing accurate data collection and analysis, and applying new technologies to our clients' most difficult challenges.

Responsibilities

• Support environmental investigation projects by maintaining relational databases of environmental chemistry data from historical reports, laboratory test results, web sources, and third‑party databases.
• Build and maintain ETL (extract, transform, load) and analysis workflows in SQL, Python, and/or R to clean, transform, validate, and analyze environmental datasets.
• Work with multi‑disciplinary teams of engineers and scientists to support statistical and spatial analyses.
• Build dashboards and visualizations, and format tables, charts, and graphs to style guidelines for technical reports and presentations.
• Organize data in structures that support automation and downstream analysis.
• Perform quality assurance on analytical databases to ensure data integrity, and identify and correct data gaps, errors, and relational table issues.
• Support a wide variety of projects ranging from litigation support and site investigation to data mining for research and development.
• Effectively communicate findings to internal and external clients.
• Complete assigned tasks on schedule and within budget while meeting quality standards on deliverables.

Qualifications

• BS/BA or higher degree in data science, computer science, statistics, environmental science, or a related field.
• 2‑5 years of work experience in data management or analysis, with strong relational database skills using PostgreSQL, Microsoft SQL Server, Microsoft Access, or other database management systems.
• Comfortable writing advanced SQL for data management (beyond basic create, read, update, delete), to clean, transform, and structure data in relational databases.
• Familiarity with relational database design, data modeling, and normalization.
• Awareness of data compilation, migration, and backup/retention considerations.
• Shell scripting (Bash) and comfort working in Linux and command‑line environments.
• Experience using Python and/or R (Tidyverse, Shiny) for data analysis, visualization, dashboards, and web applications, including hands‑on project work.
• Self‑motivated and eager to learn, with a drive to adopt new data and analysis techniques, AI, and emerging technologies to improve workflows.
• Excellent written and verbal communication, and the ability to manage multiple tasks and meet deadlines with limited supervision.
• Strong problem‑solving skills and attention to detail.
• Additional preferred skillsets and qualifications include:
  • Familiarity with chemistry data, laboratory information management systems (LIMS), data validation, and extraction of data from online sources.
  • Version control (Git) and reproducible, scripted analysis workflows.
  • Application development and deployment, including web frameworks for data tools (e.g., Django, Flask/FastAPI, Dash, Streamlit, R Shiny). Familiarity with containerization (Docker) is a plus.
  • Experience with embedded and analytical database engines (e.g., SQLite, DuckDB) for local analysis, prototyping, and data interchange.

Job Perks

• Competitive salary and benefits
• Quarterly and year‑end bonuses
• Flexible work environment with potential for remote work
• On‑the‑job training, mentorship, and professional development
• Participation in conferences, technical presentations, and papers
• Collaborative atmosphere
• Base salary will vary depending on qualifications and experience.

The anticipated salary range for this position is $76,000–$110,000. This range represents GSI's good‑faith estimate of the base salary for the position and is provided in accordance with applicable pay transparency laws. Starting salary will be determined based on several job‑related factors, including relevant experience, education, professional licensure, certifications, technical expertise, geographic location, internal equity, and overall qualifications.