Hybrid Analytics Specialist - Dashboards & ETL Pro

Commonwealth of VA Careers; Richmond (VA); Hybrid; USD 80,000 - 100,000; Full time

Job summary

The Commonwealth of Virginia, Department of Environmental Quality, is seeking an Analytics Specialist to craft production-grade analytics content and maintain analytics systems. This hybrid role will build dashboards and ETL processes, respond to ad-hoc analyses, and support tool maintenance across enterprise environments.

You will collaborate with OIS Analytics Team to translate requirements into actionable analytics solutions, while maintaining documentation and incident response within agreed

Qualifications

• Experience developing production-grade analytics content in enterprise analytics environments.
• Experience building dashboards (Shiny/Dash/Tableau) and automated workflows for analytics.
• Experience ETL development using SQL, R, Python, Tableau Prep Builder, etc.
• Experience with database query design and optimization for analytics.
• Familiarity with development environments like RStudio, VS Code, Tableau Desktop/Prep Builder.
• Experience using Git to support code development and maintenance.
• Ability to translate business requirements into stable analytics solutions.
• Ability to work independently and in multidisciplinary teams.

Responsibilities

• Designs, analyzes, and develops systems and datasets meeting deadlines and release requirements.
• Develops and executes test plans for new or updated applications.
• Collaborates to deploy analytics-based ETL processes for performant reporting.
• Follows development best practices and coding standards.

Skills

R

Shiny app development

Python

Tableau

SQL

ETL design

Education

Coursework in Environmental Science, Data Science/Analytics, or a related field

Tools

Posit Connect

Tableau Server

Metabase

ArcGIS Enterprise

ArcGIS Online

Positron

VS Code

Git

Jira

Job description

The Commonwealth of Virginia, Department of Environmental Quality, is seeking an Analytics Specialist to craft production-grade analytics content and maintain analytics systems. This hybrid role will build dashboards and ETL processes, respond to ad-hoc analyses, and support tool maintenance across enterprise environments.

You will collaborate with OIS Analytics Team to translate requirements into actionable analytics solutions, while maintaining documentation and incident response within agreed