Skip to content
Book a call

Work / Knight Frank

One data and integration platform, three products

I led the design and delivery of a multi-source Azure platform that gives Knight Frank’s products a shared data, integration and mapping foundation. Three products were built on it.

Client
Knight Frank
Role
Technical Lead & Architect
Period
Nov 2024 - Jul 2026
Sector
Property

In numbers

3

products on one platform

4

pipeline layers to a canonical model

8GB+

sanctions data integrated

Context

Instead of each product carrying its own pipelines, database, search and map stack, the platform provides them once: ingestion, a canonical data model, search, APIs and geospatial serving, deployed the same way across every environment.

The platform

  1. Bruin and Python ETL pipelines that take every dataset through raw, staging, intermediate and canonical layers.
  2. Liquibase-managed schema migrations on PostgreSQL with PostGIS.
  3. A geospatial serving stack: PostGIS, the Martin vector-tile server and MapLibre GL.
  4. Containerised infrastructure in Bicep: Azure Container Apps, Hasura GraphQL, OpenSearch and API Management, deployed across multiple environments.

Architecture

Knight Frank data and integration platform2024 - 2026
  1. SourcesHM Land Registry, sanctions lists, EPC and VOA
  2. Bruin + Python ETLraw › staging › intermediate › canonical
  3. PostgreSQL / PostGIScanonical model, Liquibase migrations
    • Martinvector tiles
    • HasuraGraphQL API
    • OpenSearchentity search
  5. Productslease expiry, sanctions screening, scheme management3 products, one platform

Built on the platform

Each product reuses the platform’s pipelines, canonical model, search and mapping components rather than building its own.

Lease expiry

Ingests the full HM Land Registry leasehold dataset (~5.8M live leases, ~2GB monthly snapshots) and visualises lease-expiry exposure across England and Wales through a 5-tier level-of-detail pipeline. SCD2 history tracking, EPC and VOA enrichment through a UPRN, postcode and fuzzy-address matching cascade, and ArchiMate architecture packs approved at the Architecture Review Board.

  • PostGIS
  • Martin
  • MapLibre
  • ArchiMate

Sanctions screening

Integrates the OFAC, EU, UK and UN sanctions lists (8GB+ of data) into a canonical entity model, built on the platform’s ETL and search components, for compliance screening across the business.

  • OpenSanctions
  • OpenSearch
  • Python

Development scheme management

A Next.js 15, React 19, TypeScript and Hasura GraphQL application for living-sectors teams tracking Build-to-Rent, Student and Seniors Housing schemes, with interactive maps, 30+ column data grids, embedded Dynamics 365 CRM and Azure AD (MSAL) role-based access.

  • Next.js
  • Hasura
  • Dynamics 365
  • MSAL

Technology

  • Azure Container Apps
  • Bicep
  • API Management
  • PostgreSQL / PostGIS
  • Liquibase
  • Bruin
  • Python
  • Hasura GraphQL
  • OpenSearch
  • Martin
  • MapLibre
  • Next.js
  • OpenSanctions
  • Claude Code

Have a platform decision coming up?

Tell me where the programme is and what needs deciding. I will tell you plainly whether I can help.

Available for new engagements

Book a callgareth.williams@gdwuk.com