Skip to main content
Duspat

Service

Cloud Data Platforms

Lakehouse and warehouse platforms designed for the workloads you actually have — and for the people who will run it after we leave.

Who it is for

  • A data team standing up its first serious platform and wanting to get the foundations right
  • An organisation migrating off a legacy warehouse that has become the bottleneck
  • A platform team whose lakehouse works but cannot be governed, operated or afforded

Problems we solve

What tends to be going wrong.

Sized for a demo, not for quarter-end
The platform performs beautifully until the month that matters, when concurrency, volume and a reporting deadline arrive together.
A medallion architecture in name only
Bronze, silver and gold as folder names rather than contracts. Nothing is guaranteed at any layer, so consumers reach past them into raw data anyway.
A cost curve nobody modelled
Spend that grows faster than usage, with no one able to attribute it to a workload, a team or a decision — so the only lever left is a blunt one.

How we help

What Duspat delivers.

01
Lakehouse and warehouse architecture
Platform design grounded in your real workloads — query patterns, concurrency, latency and volume — rather than a reference architecture from a vendor deck.
02
Warehouse modernisation and migration
Migration design and execution off legacy platforms, including very large production tables with live dependencies and no acceptable downtime window.
03
Data modelling and platform patterns
Dimensional and domain modelling, medallion layers with actual contracts, and reusable patterns your team can apply without us.
04
Cost, security and operational design
A cost model with attribution, RBAC and least privilege, observability, and the runbooks that make the platform operable on a Tuesday afternoon.

Typical deliverables

Things you can hold, review and hand to a team.

Architecture and design over four to eight weeks, or a design-and-build engagement delivered alongside your team.

  • Platform architecture and design (lakehouse, warehouse, medallion)
  • Dimensional and domain data models
  • Migration design and execution, including very large production tables
  • Cost model, attribution and FinOps guardrails
  • Access control and RBAC design
  • Observability, data quality checks and a remediation path
  • Standards, runbooks and documented handover

Technology fit

What we build this on.

We are independent: no reseller agreements and no partner quotas. If your estate points a different way, we will say so.

Data platforms
  • Databricks
  • Snowflake
  • Redshift
  • BigQuery
Storage & formats
  • Delta Lake
  • Apache Iceberg
  • S3
  • PostgreSQL
Cloud
  • AWS
  • Azure
  • GCP
Modelling & transformation
  • DBT
  • PySpark
  • AWS Glue

Governance & production readiness

Designed in, not added later.

A platform without governance is a liability with good query performance. Access, lineage and quality are designed alongside the architecture, not bolted on after go-live.

How we run an engagement

  • RBAC and least-privilege access modelled at design time
  • Metadata cataloguing and end-to-end lineage
  • Data quality checks with named owners and a remediation path
  • Retention, GDPR-related controls and auditability
  • Cost attribution, so spend is a decision rather than a surprise

Example outcomes

Evidence, not testimonials.

Anonymised and sector-level. Client names are withheld by design — the constraint and the architecture are the parts that carry any information.

  • Enterprise

    Large-scale migration off a legacy warehouse

    The constraint. Very large production tables with live dependencies, and no acceptable downtime window.

    Migration designed and executed into Redshift, Snowflake and PostgreSQL using change-data-capture and a phased cutover, so the business kept reading from a consistent view throughout. The estate ended on a platform the in-house team could actually operate.

    • AWS
    • Redshift
    • Snowflake
    • PostgreSQL
    • CDC
  • Regulated data

    Data governance in production, not on paper

    The constraint. Governance that had been written down but never enforced, across an estate holding personal data.

    Metadata cataloguing, lineage, RBAC, retention and automated data quality checks with named owners and a remediation path — so that a governance claim became something a regulator could be shown rather than told.

    • Data quality
    • Lineage
    • RBAC
    • GDPR controls
    • Monitoring

Questions

Common questions about cloud data platforms.

What is a lakehouse, and do we actually need one?

A lakehouse puts warehouse-style tables and transactions on top of cheap object storage, so one platform serves both analytics and engineering workloads. You need one if you have significant unstructured or semi-structured data, or ML workloads alongside BI. If you have neither, a well-modelled warehouse is simpler and we will say so.

How do you migrate a legacy data warehouse without downtime?

With change-data-capture and a phased cutover, so the old and new platforms run in parallel and the business keeps reading from a consistent view throughout. The hard part is never the small tables; it is the very large production ones with live dependencies, and those are planned first rather than last.

How do you control cloud data platform costs?

By modelling the cost at design time and attributing it afterwards. Warehouse sizing, storage layout, partitioning and job scheduling all move the bill more than most teams expect. Without attribution you cannot tie spend to a workload, and the only lever left is a blunt one.

What is medallion architecture?

A layering convention — raw, cleaned, and business-ready — that makes data quality and lineage explicit. It only works if each layer is a genuine contract rather than a folder name. Where it is only a naming scheme, consumers reach past it into raw data and you have the complexity without the benefit.

Talk through your platform architecture.

A first call is technical, not a sales call. Bring a problem, an architecture, or a stalled initiative.

30 minutes, no pitch deck.