GIS Data Engineer

Resilience Partners offers various predictive-analytics product lines for infrastructure development. As a GIS data engineer in our projects delivery group, you will be a key player in helping tobuild our initial product line.

• The build: stand up and harden the PostGIS environment (Supabase-hosted PostgreSQL 17), apply and own the reviewed schema, and manage migrations from there.
• Data engineering: ETL for licensed parcel and ownership data and free federal constraint layers (NWI wetlands, FEMA floodplains, USGS 3
  
  DEP slope, PAD-US, HIFLD, GNIS) — staged, validated, logged, with row-level provenance.
• Entity resolution: owner and party matching across parcels.

An operational database for our initial study area. Week-by-week phasing exists; you'll refine it with us in week one. Potential to transition to full-time employment at end of consulting period and associated workflow.

• 4+ years professional experience with spatial data engineering, including strong PostGIS spatial SQL (buffers, intersections, overlays, GiST indexing) on PostgreSQL.
• Python ETL fluency: geopandas, psycopg2 or SQL Alchemy, requests; comfortable building staged, validated, logged pipelines, not one-off scripts.
• GDAL/ogr2ogr for shapefile, geodatabase, and raster wrangling.
• REST API integration and authentication (vendor parcel-data pulls).
• Cloud database operations: standing up, securing, and managing a production managed-Postgres instance (RLS, roles, backups).
• Data-modeling rigor: composite keys, append-only history, idempotent loads — and the judgment to push back on the spec where it's wrong.
• pg Routing or other graph/network analysis in production; entity-resolution / record-linkage experience.
• Parcel, land, energy, utility, or real-estate data experience; familiarity with NWI, FEMA NFHL, 3
  
  DEP, PAD-US.
• Supabase specifically;
  Hub Spot or Make integration awareness; sensitivity to data-license terms and PII handling.

Resilience Partners is an equal-opportunity company. We evaluate candidates on capability, judgment, ethics, and commitment to Resilience's mission
-nothing else.