CO - P4676 - Analytics Specialist

The Analytics Specialist will serve as a core developer and maintainer of production-grade analytics content at DEQ. The Analytics Specialist will create and maintain solutions that support agency-wide operations and public data accessibility as well as respond to ad-hoc requests for analyses and visualizations. This role will also help support the development and maintenance of extract transform and load (ETL) processes to support analytical tools. The Analytics Specialist will coordinate closely with staff in the Office of Information Services (OIS) Analytics Team and throughout DEQ to define requirements and develop and maintain solutions. The Analytics Specialist will also help support the Analytics Systems Administrator with the maintenance of DEQ’s enterprise analytics environments and tools as needed. This position will need to have experience in a combination of the following: R, Shiny app development, Python, Tableau, or analogous BI tools or programming languages, database query design, and experience with SQL programming. Please note this position follows a hybrid work schedule to include both in-office and telework. Candidates must be able to work from the assigned work location in Virginia.

- Experience developing and maintaining production-grade content hosted in enterprise analytics environments (e.g., Posit Connect, Tableau Server, Metabase, etc.)
- Experience building dashboards (e.g., Shiny or Dash applications, Tableau dashboards, etc.), infographics, and automated data management or process support workflows.
- Experience with ETL development and maintenance using any of the following: SQL, R, Python, Tableau Prep Builder, etc.
- Experience with database query design and optimization to support analytics content development.
- Capable of using a combination of the following development environments: RStudio, Positron, VS Code, Tableau Desktop, Tableau Prep Builder, etc.
- Experience using git to support code development and maintenance.
- Demonstrated ability to gather and translate business requirements into stable and maintainable analytics solutions.
- Ability to work independently and collaboratively in multidisciplinary teams.
- Familiarity with work management tools (e.g., Jira or similar) to track work intake, priorities, delivery, and service performance.

Additional Considerations
- Experience integrating analytics content across data science platforms (e.g., Posit Connect, Tableau, ESRI etc.).
- Experience administering analytical tools (Posit Connect, Tableau Server, etc.).
- Experience developing and maintaining production-grade content hosted in ArcGIS Enterprise and, or, ArcGIS Online.
- Relevant technical certifications or training.
- Coursework in Environmental Science, Data Science/Analytics, or a related field.
- Recommended: 3-4 years of experience developing analytics content in production environments.
- Equivalent education and experience may be considered.