MK
All case studies
Case study

Real Estate Investment Manager: One Set of Numbers, and an Assistant That Can Answer From Them

Ongoing engagement, 2026 · Data platform architecture & AI engineering

Real estate investment management

A US real estate investment manager had a property management system, fund spreadsheets and a shared drive of agreements that each told a different story. I built the platform that makes them agree, and the assistant their team asks instead of waiting a week for an analyst.

Concept illustration of property, fund and finance sources flowing through bronze, silver and gold layers into a dashboard and an assistant

Concept illustration

Context

The client is a US real estate investment manager with funds, properties and investors to report to. Under NDA, so the name and anything that would identify them stay out. They had systems of record but no single place where the numbers agreed: the property management system held rent and occupancy, the fund models and covenants lived in spreadsheets owned by one person each, and the loan, lease and investor agreements sat as PDFs on a shared drive. The board wanted AI. The CFO wanted a number they could trust first.

Challenge

Three sources gave three answers to the same question, and the one that reached investors was whichever somebody typed last. Any real question cost a week of an analyst's time, so most questions were never asked. Quarter end took weeks and still shipped with corrections. The firm was being pitched two-year data programmes with a team of five, and had already seen one AI pilot that could not say where its answers came from. The ask was to prove, on their own data, that there was a shorter way: one set of numbers, questions answered the same day, and an assistant that cannot see what the person asking cannot see.

Solution

  • Picked one part of the business and wrote down what done meant

    Started with a short scoping phase instead of a platform programme. Chose the reports the finance team already trusted as the acceptance test: the platform would be done when it reproduced them, line for line, from the source systems. Listed the questions the investment team wanted answered and the sources each one needed. That paper was what the sponsor approved.

  • Built a medallion lakehouse on Microsoft Fabric

    Landed the property management system, the fund spreadsheets and the finance system into a bronze layer exactly as received, cleaned and reconciled them in a silver layer, and shaped a gold layer around the firm's own vocabulary: fund, property, lease, investor, period. Every row carries where it came from and when, so a number can be traced back to the source that produced it.

  • Made the three answers agree

    Most of the first weeks went on finding out which of the three rent numbers was right and why the others differed. Each difference became a rule in the silver layer, written down and reviewed with the finance team. Once the reports matched, the rules became the firm's definitions, not one person's memory.

  • Put the agreements inside the same system

    Loaded the leases, loan documents and investor agreements alongside the numbers, split into clauses with the document, page and section kept with every piece. Questions like which loans carry a change-of-control clause stopped being a week of reading and became a query with the source attached.

  • Built the assistant on top, read-only and cited

    Connected a large language model to the reporting layer so the investment team can ask a question in plain English and get an answer with the figures, the report it came from and the clause it rests on. The assistant reads, it never writes. It answers only from the governed layer, so it cannot invent a number that is not in the data.

  • Bound every answer to the person asking

    Access runs through the same permissions the firm already manages. A person who cannot open a fund's investor list cannot get it out of the assistant either, and the audit trail records who asked what. This was the CFO's real condition for letting anything called AI near investor data.

Trade-offs I'd defend

Reproduce the old reports before building anything new

The temptation was to start with the assistant, because that was what the board wanted to see. I held the order: trusted numbers first, then the assistant on top of them. An assistant over disputed data would have been a faster demo and a slower project.

The client's engineers own the connectors

Ingestion from the firm's own systems was built with their IT lead so it can be maintained without me. I owned the architecture, the silver rules, the definitions and the AI layer, which is where the judgement sits.

Answers with sources over answers that sound good

The assistant is tuned to say where a number came from and to say when it cannot answer from the data. A model that will always produce something is the wrong tool for a finance team. Trust came from the citations, not from the fluency.

Illustrations of the product decisions and engineering workflow, recreated for this case study.

Illustration of three source systems giving different rent totals, silver rules signed off by finance, and a portfolio report that reconciles to one figure.

From three answers to one set of numbers

The property management system, the fund spreadsheets and the finance system each gave a different answer. Every difference became a written rule in the silver layer, agreed with finance. The platform passes when it reproduces the reports finance already trusts. Figures are illustrative.

View full-size image (new tab)
Illustration of sources landing in bronze, cleaned and reconciled in silver, modelled in gold around fund, property, lease, investor and period, then reported, on a shared foundation of pipelines as code, lineage and access rules.

A medallion lakehouse on Microsoft Fabric

Bronze keeps every source exactly as received. Silver cleans and reconciles it. Gold is modelled in the firm's own vocabulary. Pipelines are set up as code, every row carries its lineage, and access rules are set once.

View full-size image (new tab)
Illustration of a person asking which loans carry a change-of-control clause, the assistant reading the gold layer and agreements, and a read-only answer with numbered citations.

Questions answered from governed data, with sources

The assistant reads the gold layer and the firm's agreements, never writes, and cites the page each answer rests on. It sees only what the person asking may see, and every question is logged.

View full-size image (new tab)

Outcomes

One set of numbers
The platform reproduces the reports the finance team already trusts, from the source systems, with every figure traceable
Same-day answers
The investment team asks the assistant directly instead of waiting on an analyst
Agreements that answer back
Clause-level questions across leases, loans and investor documents, with the page cited
Permission-bound
The assistant sees only what the person asking is allowed to see, with an audit trail
Microsoft Fabric
Medallion lakehouse (bronze, silver, gold)
Large language model, read-only with citations
What's next

A second part of the business is a second run on the same platform: the definitions, permissions and assistant are already in place, so the next domain starts with bronze, silver and gold already in place rather than at zero.

Where this goes next

Work of this shape starts with Phase Zero: three weeks, a fixed fee, and a paper written for your steering group — with a proof on your own data where there is something to prove.

Specialist engineering for larger companies
Weighing a similar problem for your team?

A build you can't evaluate, a demo that has to ship, or a certificate a contract is waiting on.

Book a 30-minute discovery call. Bring what you're building, the decision you need help with, and your timeframe. We will check fit and agree the next step before any paid work.