Back to projects PT
Case study

A fintech Lakehouse from scratch

Implementation of a Databricks Lakehouse integrating an entire fintech database.

Paytime · 2024–2025

Problem

The fintech lacked a unified data platform: analytics and reports were slow and data was fragmented across systems.

Architecture

flowchart LR
  SRC[Fintech sources] --> ING[Spark ingestion]
  ING --> B[Bronze]
  B --> S[Silver]
  S --> G[Gold]
  G --> REP[Reports and dashboards]
  classDef a fill:#0d1525,stroke:#3b82f6,color:#e2e8f0
  classDef g fill:#0d1525,stroke:#10b981,color:#e2e8f0
  class SRC,ING,B,S a
  class G,REP g

Solution

  • Designed and implemented the Lakehouse (Databricks, Spark, SQL, AWS) from scratch.
  • Integrated the entire database into Bronze, Silver and Gold layers.
  • Governance practices: quality testing, documentation and access control.
  • Foundation for data products and self-service analytics.

Results

  • Improved analytics performance.
  • Faster report and dashboard updates.
  • Solid foundation for the company's first data products.

Stack

Databricks Spark SQL AWS Delta Lake