We’re an urban planning consultancy building the CommunityScale Housing Forecast, tools and maps that help cities plan housing and growth. Small, focused team; real-world impact.
You’ll work on: - APIs & performance: Extend FastAPI endpoints (forecast overrides, analytics), tune queries/caching, containerize heavy jobs on Cloud Run. - Data engineering: Ingest ACS/FRED/Zillow; refactor transforms to SQL/dbt; manage schema migrations; keep tilesets fresh. - Geospatial UX: Improve PostGIS/GeoAlchemy2 pipelines and map rendering (e.g., overlapping township/municipality z-index issues).
Stack: Python 3.13+, FastAPI, SQLAlchemy 2, Pydantic, Pandas; Postgres 16 + PostGIS, DuckDB; dbt; HTMX, Tailwind, Jinja2, Mapbox GL JS; Docker, GCP (Cloud Run), GitHub Actions, uv, pytest, Ruff, Pyright. Nice-to-have: Prefect, BigQuery, dlt; familiarity with US Census data.
Requirements: 2+ yrs building Python web apps; strong SQL & schema design; ETL/ELT experience; collaborative Git workflow; geospatial familiarity (nice-to-have).
Benefits: Competitive base + 401(k) match, paid vacation, health insurance stipend. Remote-first with limited travel.