Skip to content
Work with us
Home/Case studies
Case studies

Case studies

A selection of our data platform, AI and software projects for banks, insurers, energy suppliers, retailers and manufacturers.

The case descriptions are sample texts for this concept site. On the final site they will be replaced with real projects approved by our clients.

Data & AI Engineering

Data warehouse migration to a Databricks lakehouse

Challenge

  • 10+ year-old on-premise data warehouse with rising licence and operating costs
  • Management and regulatory reports that could not be disrupted during the move
  • Long daily load windows; new data requests waiting for months

Solution

  • Mapping of report and pipeline dependencies; migration plan by business domain
  • Databricks lakehouse build; ETL rewritten in Spark
  • Parallel runs with automated reconciliation in every domain
  • Legacy warehouse decommissioned; platform handed over to the bank's data team
Data & AI Engineering

Unified data model and Snowflake cost optimisation

Challenge

  • Different calculation logic for the same metrics (margin, active customer, stock turnover)
  • Snowflake costs rising every quarter with no clear breakdown

Solution

  • Single, documented definitions of key metrics agreed with business teams
  • Shared dbt data model under management reporting
  • Automated quality checks on critical tables
  • Query and resource optimisation; cost tracking per team
AI Applications & Integration

RAG-based knowledge search for claims handlers

Challenge

  • Product terms, internal instructions and past decisions spread across several systems
  • Earlier AI pilot: inaccurate on the full document estate, no access control

Solution

  • Continuous document ingestion with versioning and access rights
  • RAG-based answers with source references, filtered by user permissions
  • Test question set built with domain experts; accuracy measured before rollout
  • Integration into the existing claims-handling application
AI Applications & Integration

AI-based impact analysis for data warehouse changes

Challenge

  • Hundreds of reports, interfaces and processes on the same data warehouse
  • Manual impact analysis taking days before every change

Solution

  • Automated processing of database schemas, load and report code, and documentation
  • Knowledge graph of relationships between tables, fields, reports and processes
  • Natural-language interface for impact analysis
Product Engineering & Modernization

Gradual replacement of a monolithic transport management system

Challenge

  • 20-year-old monolith known by a small group of experts
  • Growing demand for API-based partner integrations
  • Requirement for a cut-over with no downtime

Solution

  • API layer in front of the legacy system
  • Module-by-module replacement: partner integrations, quoting, transport planning
  • Parallel runs with automated comparison
  • Knowledge transfer to the internal development team
Product Engineering & Modernization

Web-based production planning app built on the data platform

Challenge

  • Production planning for three plants in linked Excel files
  • Manual data transfer from inventory and order systems

Solution

  • Workflow discovery with planners
  • Web planning application with a direct data platform connection
  • Write-back to the manufacturing execution system
  • Automated tests, monthly release cycle
The first step

Bring a specific data or AI problem.

In 30 minutes, one of our experienced engineers talks through the situation with you and what it would take to solve it. Not a sales pitch.

Data platform and AI feasibility assessment

For one selected business need, we look at which data and integrations are needed, what is missing, and in what steps it makes sense to deliver it.

Enterprise knowledge search or impact analysis

We deliver one well-defined use case, with data sources, access rights and quality expectations agreed in advance.

Work with us