← All case studiesFinancial Services · Data & Analytics consulting

Case study

Scattered Research Data Unified for a Multinational Investment Bank

How SquareShift built an Investment Management Data Lake on Azure, using Databricks and H2O Driverless AI, so analysts could stop pulling scattered financial and research data one request at a time.

Book a session →
5market data providers merged into one governed store
2teams now working from the same data: analysts and scientists

Client

An American multinational investment bank and financial-services holding company that needed a single data lake to unify financial, economic, and research data across every asset class it covers.

Industry

Financial Services

Services

DaData & Analytics

Stack

Azure · Databricks · H2O Driverless AI · Bloomberg · Reuters · FactSet

How SquareShift delivered it.

01

The challenge

The client is an American multinational investment bank and financial-services holding company. Financial, economic, and research data for every asset class it covers lived in scattered systems, with no single, scalable home, so analysts and data scientists pulled from fragmented sources one request at a time.

02

What we delivered

SquareShift built an Investment Management Data Lake on Azure, using Databricks and H2O Driverless AI. Data from Bloomberg, Reuters, FactSet, S&P, and Sustainalytics was ingested and cleansed into one centrally managed store, governed so both analysts and data scientists could trust and build on it directly.

See the data engineering services behind projects like this.

03

The outcome

Analysts and data scientists now work from the same governed data lake instead of pulling from fragmented sources one request at a time. The bank runs on a single, centrally managed store for its financial, economic, and research data instead of scattered feeds across every asset class it covers.

“
A data lake only earns the name once analysts stop emailing someone for access. Self-serve, governed data beats another dashboard sitting on top of the same fragmented sources.

Data & Analytics Practice Lead, SquareShift

Related reading: migrating a 70TB analytics workload to BigQuery and cutting analytics costs for a global learning and talent software provider.

Related work