Allan GaigherData engineering & infrastructure
Hi, I'm Allan.

I build and fix data infrastructure, mostly in finance.

If you're dealing with pipelines that need to be reliable, audit-friendly, or just less painful to maintain — that's the kind of thing I work on.

Find a time to chat →
£87BAUM across platforms I've worked on
Tier-1financial institutions
Zerodowntime migrations

A bit about me

I've spent most of my career in data, mainly in finance.

I've worked on enterprise platforms at Rothschild & Co, First Rate (Forex), McLaren Group, Alliela AI, and OpenData.London — so I'm used to environments where data has to be right, traceable, and compliant, not just fast.

What I like doing is the unglamorous stuff that actually matters: lineage, governance, migrations that don't blow up, and reporting that stands up to audit.

What I do

The kind of work I take on.

01

Regulatory & compliance pipelines

Lineage, access control, and governance (GDPR, MiFID II, SOC2) built into the pipeline so reporting is traceable from ingestion to dashboard. Boring but essential.

02

Legacy modernisation & cloud migration

Moving off on-prem SQL or spreadsheets is risky. I've run migrations to AWS, Azure, Databricks, Snowflake with zero downtime and no data loss — it's doable if you plan it right.

03

Analytics & BI that actually gets used

Power BI, Tableau, or similar — set up with proper RLS, sensible latency, and KPIs that tie to the business rather than vanity metrics.

04

Enterprise AI & automation

LLMs and automation inside your perimeter: reconciliation, reporting, internal tools that don't send sensitive data to public APIs.

How I work

Roughly how things go.

I work with a small number of clients — retainer or project. No hard sell.

01

Discovery

We figure out what you're working with — regulatory constraints, tech stack, and what's actually broken.

02

Design

I propose an approach that fits your security, scale, and budget. No over-engineering.

03

Build

I build and document as I go, so your team can follow and maintain it.

04

Handover

You get something your team can run — not a black box.

Background

Where I've worked and what I use.

I've built and run data platforms at:

Rothschild & CoFirst Rate (Forex)McLaren GroupAlliela AIOpenData.London

Same kind of standards everywhere — traceable, compliant, built to last.

Allan GaigherLead Data Engineer

Tech I'm comfortable in

PythonSQLAzureAWSDatabricksSnowflakePower BIAirflowdbt