GIS Data Engineer: PostGIS, ETL & Parcel Data

Resilience Partners; Houston, Northern (TX, KY); Hybrid; USD 110,000 - 140,000; Full time

Job summary

Resilience Partners is building a resilient analytics platform for infrastructure data. You will stand up and harden a PostGIS environment, own the schema, and manage migrations for an initial study area.

Your work includes ETL for parcel data, provenance logging, and robust entity resolution across parcels to streamline data quality and trust. We seek a GIS data engineer with 4+ years of spatial data experience, strong PostGIS SQL, Python ETL, and GDAL/OGR expertise.

Qualifications

• 4+ years professional experience with spatial data engineering.
• Strong PostGIS spatial SQL skills (buffers/intersections/overlays/GiST).
• Python ETL fluency: geopandas, psycopg2 or SQLAlchemy, requests.
• GDAL/OGR for shapefile, geodatabase, and raster wrangling.
• REST API integration and authentication (vendor parcel-data pulls).
• Cloud DB operations: production Postgres with RLS, backups, security.
• Data-modeling rigor: composite keys, append-only history, idempotent loads.
• pgRouting or graph/network analysis in production; entity-resolution skills.
• Experience with parcel/land/real estate data; familiarity with NWI, FEMA NFHL, 3DEP, PAD-US.
• Supabase experience; HubSpot or Make integration awareness; data-license terms.

Responsibilities

• Build and harden the PostGIS environment (Supabase-hosted PostgreSQL 17).
• Apply and own the reviewed schema; manage migrations.
• ETL for parcel ownership data with validation, logging, provenance.
• Entity resolution: owner and party matching across parcels.
• Operate data pipelines end-to-end; ensure idempotent, auditable loads.

Skills

GIS data engineering

PostGIS

Python ETL

geopandas

SQLAlchemy

psycopg2

REST API integration

data modeling

entity resolution

pgRouting

parcel/land data

NWI/FEMA data

Tools

PostgreSQL

PostGIS

Supabase

GDAL/OGR

geopandas

psycopg2

SQLAlchemy

pgRouting

Job description

Resilience Partners is building a resilient analytics platform for infrastructure data. You will stand up and harden a PostGIS environment, own the schema, and manage migrations for an initial study area.

Your work includes ETL for parcel data, provenance logging, and robust entity resolution across parcels to streamline data quality and trust. We seek a GIS data engineer with 4+ years of spatial data experience, strong PostGIS SQL, Python ETL, and GDAL/OGR expertise.