GIS / Spatial Data Integration Specialist @ Richmond, VA (Hybrid)

Location: Richmond, VA (Hybrid)

Duration: Long Term - Contract - Parttime

Department: Virginia Department of Environmental Quality

Experience: 6+ years in GIS; experience with web, API, and database integration

Key Responsibilities: Review existing spatial datasets/services, coordinate systems, locality/FIPS/HUC12/VAHU6 reference data, and DEQ GIS patterns relevant to BMP Warehouse. Design spatial-validation logic for latitude/longitude validity, Virginia boundary checks, locality/HUC12 consistency, and automatic derivation of locality/HUC12 from coordinates. Define and validate spatial determination of Chesapeake Bay versus non-Bay drainage and partial-locality cases used to assign implementation qualifier codes. Support ingestion and storage of CGP footprint polygons, centroids, drainage/impervious acreage and jurisdictional/spatial attributes. Recommend appropriate spatial data storage/indexing/query patterns in SQL Server and integration approaches to DEQ GIS services/data sources. Work with the Lead BA and Data Lead to define precedence when supplied textual geography conflicts with derived spatial geography and to document exception handling. Develop/review GIS service calls, spatial SQL, geometry transformations, overlays/point-in-polygon operations, and performance-sensitive spatial queries as needed. Create test datasets covering valid/invalid coordinates, border cases, partial localities, mismatched HUC/locality values, missing coordinates, and polygon/centroid anomalies. Support integration/performance troubleshooting and verify spatial outcomes during UAT and production readiness. Document spatial data sources, assumptions, coordinate systems, derivation rules, dependencies, and operational support procedures. Minimum / Required Profile for Sourcing 6+ years of GIS/spatial systems experience with production web or enterprise applications. Strong experience with ArcGIS/Esri technologies or comparable enterprise GIS platforms and spatial web services/APIs. Experience with point-in-polygon, spatial joins, coordinate/reference systems, geometry/polygon/centroid processing, and boundary-derived attributes. Experience using spatial capabilities in SQL Server or comparable relational databases. Ability to integrate GIS logic with APIs, .NET applications, and data-validation workflows. Strong data-quality mindset and ability to explain spatial precedence/edge cases to non-GIS stakeholders.

Preferred Skills: Experience with watershed/HUC datasets, environmental/water-quality systems, Chesapeake Bay geography, locality/FIPS relationships, or similar regulatory spatial data. Experience with ArcGIS REST services and performance optimization of spatial queries. Experience testing/validating spatial derivations used in regulatory submissions.