Senior Geospatial Data Engineer – Building a Proprietary Hail-Lead Pipeline

Senior Geospatial Engineer – Proprietary Hail-Lead Pipeline & Self-Service Portal

Project Overview:

Ajinyx is building a proprietary "Weather-to-Revenue" engine.

We are moving away from third-party data subscriptions to build a custom, owned pipeline that identifies high-probability hail-damaged residential leads using raw NOAA weather data.

This is a "Large" initiative involving complex data sets (GRIB2), geospatial intersections (PostGIS), and predictive measurement (Google Solar API).

Detailed Project Scope & Deliverables:

• Outbound "Storm Hunter" Module

Ingestion:

Automate retrieval of MRMS MESH GRIB2 files from NOAA AWS buckets.

Spatial Processing:

Convert raw rasters to vector polygons; implement sieving to remove noise.

Property Harvesting:

Intersect storm footprints with Microsoft Building Footprints to extract residential addresses only.

• Inbound "Instant Quote" Website Widget

Frontend/

API:

A lightweight widget for our client's website where homeowners enter an address.

Logic:

The system must instantly trigger the measurement engine (Module 3) and return a $USD estimate.

• The Measurement & Quote Engine

Google Solar Integration:

Pass addresses to the buildingInsights endpoint.

Math Logic:

Programmatically calculate Roof Squares and Pitch-Adjusted Estimates based on custom pricing variables.

• CRM & Automation Sync

GHL & JobNimbus:

Seamlessly push leads, roof measurements, and PDF summaries to both platforms via Webhooks/REST API.

Required Experience & Expertise:

Proven Geospatial Track Record:

Experience with GDAL, PostGIS, and handling NOAA MRMS/NEXRAD data.

Python Specialist:

Deep knowledge of cfgrib, xarray, geopandas, and FastAPI.

API Architect:

Experience with Google Maps Platform (Solar/Places) and building scalable webhook architectures.

Problem Solver:

Must be able to handle "Ground Truth" verification logic (e.g., verifying a storm hit a specific roof via spatial data).

Project Dynamics:

Collaboration:

You will work independently but in close communication with the Agency Founder.

You will be the technical lead on this build; we provide the business logic and API access, you provide the engineering.

Guidance Needed:

We need your expertise in Database Architecture—specifically how to store spatial data efficiently to minimize API latency for the website widget.

We also look for guidance on the most cost-effective way to host this (Serverless vs. Containerized).

Deadline Expectations:

Total Project Duration: 5–6 Weeks.

Milestone 1 (Week 1): Successful NOAA data ingestion and polygonization.

Milestone 2 (Week 3): Residential harvesting and Google Solar integration.

Milestone 3 (Week 5): CRM sync and Website Widget deployment.

Final Week:

Debugging, optimization, and "Backtesting" using June 6, 2024 (Pampa, TX) storm data.

Budget & Application:

Fixed Price:

$7,500 (Milestone-based).

To Apply:

Please do not send a generic template. Tell us about a complex geospatial project you have built. If you have worked with GRIB2 files or the Google Solar API, you are our top candidate.

Contract duration of 1 to 3 months.

Mandatory skills:

Python, API, cfgrib, xarray, geopandas, Flask, FastAPI