← All work

EU pharmaceutical market-intelligence client · 2026

Procurement intelligence

Public pharma tenders from three national portals, normalised into one 59-field dataset for price benchmarking and biosimilar tracking.

572,676Portuguese public contracts scanned

The problem

Hospitals across Europe publish what they buy and what they pay, but each country does it in its own portal, format and language. That turns cross-country price benchmarking and biosimilar tracking into slow manual work.

Tender intelligenceAdalimumab · L04AB04PTUKCY2026
572,676PT contracts scanned
4UK sources merged
€26.1MCY awards tracked

Awarded unit price, 40 mg Illustrative

Portugal€182
United Kingdom€158
Cyprus€214

Median across markets €182

Latest awards

DateMktBuyerUnit
12 OctPTHospital group€182.40
09 OctUKNHS framework€158.10
03 OctCYState health serviceNot stated

Multi-molecule lots: price left blank, never guessed.

My role

Architect and lead engineer

Results

4
UK procurement sources merged
€26.1M
in awarded Cypriot contracts tracked
472
automated tests

Stack

  • Python
  • Parquet
  • Open Contracting (OCDS)
  • PDF and XLSX parsing
  • ATC/DDD

What changes

Coverage

WithoutCategory codes miss pharma contracts filed under the wrong code.

With Procurement intelligenceEvery contract matched by molecule name, so none is dropped.

Sources

WithoutThree countries, three portals, three formats, with key data buried in PDFs, spreadsheets and archives.

With Procurement intelligenceOne clean dataset with a fixed 59-field schema.

Prices

WithoutUnit prices guessed for contracts that cover several molecules.

With Procurement intelligencePrices shown only where they can be defended. An honest blank beats a wrong number.

New countries

WithoutEach new country is a new system.

With Procurement intelligenceEach new country is one adapter on a shared protocol.

How it works

At a high level. A detailed walkthrough is available on a call.

  1. 01Portals
  2. 02Country pipelines
  3. 03Molecule matcher
  4. 04Document parsing
  5. 05Enrichment
  6. 06Output
  1. Decision 01

    Matched molecules by name across every contract, with no category-code pre-filter.

    No real contract gets dropped because a tender was filed under the wrong code.

  2. Decision 02

    One pipeline protocol for every country.

    Adding a country means writing one adapter, not a new system.

  3. Decision 03

    Unit price left empty for contracts that cover several molecules.

    An honest blank is more useful to an analyst than a wrong number.