
Development of IM Data Lake for a top American bank



Client
The client is an American multinational investment bank
and financial services holding company.
Project Context
The client wanted to design and develop Investment Management Data Lake for financial, economical and research data (historical and incremental) for all asset classes.
Challenges
The firm needed real-time analytics to improve investment decisions using a centralized and scalable data lake.
Solution
Designed and implemented a data lake on Azure using Databricks and H2O Driverless AI
Ingested, cleansed, and transformed data from Bloomberg, Reuters, FactSet, S&P, Sustainalytics
Enabled analysts to build new use cases with real-time access
Project Objectives
Create an Investment Management Data Lake with historical and incremental financial, economic, and research data for all asset classes.
Solution Delivery
SquareShift implemented a centrally managed Azure-based data lake using Databricks and H2O Driverless AI.
Data was ingested from multiple financial data providers, prepared for analysis, and shared with analysts and data scientists for decision-making.
Testimonial
SquareShift’s Data Lake setup gave us a huge boost in analytics speed and quality. We now make smarter investment decisions