Building the first comprehensive database and AI-powered platform that aggregates climate resilience insights from various planning documents across all US states. The platform will enable investment professionals to quickly research climate adaptation efforts for due diligence.<ul><li>Trial: 1-3 weeks, 20 hrs/week starting immediately</li><li>$40-62.5/hr based on experience</li><li>Remote or hybrid SF Bay Area</li><li>Potential founding team role based on performance</li></ul><h2>What You'll Build</h2>Transform our scrappy prototype into a scalable system that processes tens of thousands of municipal documents nationwide, extracts structured project data using AI, and provides fast location-based search for climate adaptation projects.<h2>Key Responsibilities</h2>Scale the Architecture<ul><li>Migrate prototype to production cloud infrastructure (AWS/GCP)</li><li>Build distributed systems for parallel document processing and web scraping</li><li>Design scalable databases (relational + vector) with cost/performance optimization</li></ul>Production Data Pipeline<ul><li>Create robust ETL with error handling, monitoring, and automated retries</li><li>Implement accurate geocoding across inconsistent municipal address formats</li><li>Standardize data validation across diverse state/municipal document types</li><li>Build RESTful APIs and efficient search functionality</li></ul>AI-Powered Extraction<ul><li>Scale LLM-based PDF processing while managing API costs</li><li>Implement semantic search across infrastructure project databases</li><li>Enhance AI extraction accuracy from unstructured municipal documents</li></ul>Technical Requirements<ul><li>Languages: Python, TypeScript, SQL</li><li>Cloud Platforms: AWS, GCP, or Azure with distributed systems experience</li><li>Databases: PostgreSQL, vector databases (Pinecone, Supabase)</li><li>AI/ML: LangChain, vector embeddings, RAG, conversational agents</li><li>Data Pipeline Tools: Apache Airflow (or similar tools)</li><li>Web Scraping: Scrapy, Selenium, Google Custom Search API&nbsp;</li><li>Geocoding: Google Maps API, OpenStreetMap, PostGIS</li><li>PDF Processing: Text extraction and document parsing libraries</li></ul> <h2>Nice to have</h2>Technical Mindset<ul><li>Thinks in systems and can architect for scale from day one</li><li>Comfortable making technical decisions with limited guidance</li><li>Experience debugging production issues and optimizing performance</li><li>Wants to shape engineering culture and hiring as the team grows</li></ul>Enjoy working in start-up environment<ul><li>Takes ownership and drives projects to completion</li><li>Adapts quickly to changing requirements and priorities</li><li>Direct communication style with both technical and non-technical stakeholders</li></ul>Passionate about urban climate adaptation and resilience<ul><li>Background in municipal/government document analysis</li><li>Familiarity with infrastructure planning or environmental data</li><li>Interest in climate risk assessment or sustainability tech</li><li>Previous work with public sector or policy-related datasets</li></ul>

In 2024 alone, the U.S. experienced 27 billion-dollar extreme weather disasters, resulting in $182 billion in damages. Events like the LA wildfires and Kerr County floods highlight not only the escalating climate risks, but also the growing demand for transparency around how communities are planning and preparing for them.Over the past several years, billions of public dollars have been invested in resilience — through local plans, capital projects, and budgets. But this data is fragmented, hidden in PDFs, spreadsheets, and siloed systems. We’re building an AI platform to unlock and aggregate that latent value — making municipal climate resilience data accessible and actionable.Our mission is to help municipal finance officials, insurers, governments, and other stakeholders make smarter, faster, climate-informed decisions. We’re backed by the TomKat Center for Sustainable Energy, High Impact Technology Fund, Stanford Professionals in Real Estate, and Stanford Ecopreneurship. If you're passionate about building tech that supports climate solutions and community resilience at scale, we’d love to talk.

Founding Data Engineer

About the Job

About the Company

Airys