The workflow before#
This global commercial real estate services firm manages property portfolios worth billions across multiple states. Its brokers and analysts priced acquisitions, developments and sales from listings and transaction history, with little geospatial context: how close a building sat to universities, restaurants or transit, or how a neighborhood's demographics were shifting. Pulling that together meant manual research on every deal. The firm's self-managed Airflow environment ran at about 95% capacity, so reports landed 4 to 6 hours late, and analyzing a market change took 3 to 4 days. Business units worked from separate copies of the data, and a property evaluation took about 15 days.
What we built#
We gave the firm's brokers location intelligence on every property they cover. Working in two phases, we first stabilized the data pipelines on managed Airflow, then built a spatial data warehouse on Snowflake that enriches each property with more than 50 location attributes. Brokers now open a dashboard and see a building's surroundings, not just its listing.
Every property enriched with location data
We integrated Experian location data with the firm's property records, adding more than 50 spatial attributes per property, from proximity to universities, restaurants and transit to local demographic indicators. Python pipelines normalize listings, zoning and market trend data into one spatial model covering more than 10,000 properties. We used Snowflake's native spatial types so the location math runs where the data lives, not in a separate GIS tool.
Proximity answers in seconds
Spatial indexing brought complex proximity analysis down from minutes to under 2 seconds. A broker can ask what sits within walking distance of a site, or compare two buildings' surroundings, while still on the phone with a client. The warehouse processes more than 10 million spatial data points a day, so the answers reflect current conditions.
Dashboards brokers share with clients
We built customer-facing dashboards that put the location data in front of brokers and their clients. Brokers stopped assembling research by hand for each deal, and property evaluations dropped from about 15 days to 9. We designed them for the client conversation rather than the analyst's desk, because that's where a location argument changes a decision.
Pipelines that keep up
We moved the firm's pipelines from its overloaded Airflow environment to Astronomer, a managed Airflow service, and defined every environment in Terraform. Development, staging and production now match, and deployments take 75% less time. We fixed orchestration first because a spatial warehouse fed by late pipelines would only deliver late answers faster.
How we delivered it
The work ran 16 weeks in two phases. Phase one assessed the architecture, migrated pipelines to Astronomer and set up DataOps practices. Phase two built the spatial warehouse and the broker dashboards. We ran weekly training sessions on spatial SQL with the firm's data architecture team, documented the models and governance rules, and helped set up an internal spatial analytics group to carry the work forward.
Before and after#
| Measure | Before | After |
|---|---|---|
| Analyzing a market change | 3 to 4 days | Same day |
| Complex proximity query | Minutes | Under 2 seconds |
| Property evaluation cycle | About 15 days | About 9 days |
| Pipeline deployment time | Baseline | 75% less |
| Redundant data storage | Duplicated across business units | 40% less, about $200K a year saved |
What's next#
With every property enriched and queryable, the firm can build models on the same data. The natural next steps are predictive market analysis, automated site selection recommendations for clients, and valuation models that learn from location attributes alongside the firm's own transaction history.






