Design & build of a new data platform on Azure for a Swiss bank
Context
The IT team's objective was to design and implement a new cloud-based data platform, interconnected with internal and external systems such as Bloomberg and custodian banks. The new data would enable the company to provide data warehousing services as well as more advanced analytics. In this context, our mission was to co-define a future state beyond the technology architecture, consistent with the company's strategy, design a pragmatic and progressive implementation plan, and ensure adoption by the business.
Issues
The challenges of this project were manifold. It involved developing a data platform based almost entirely on the various layers of Microsoft Cloud AZURE, ranging from IaaS to SaaS services. The platform had to process positions and transactions on a daily basis, including intraday, as well as other data critical to asset management. The major challenge was to achieve significant productivity gains and open up new prospects for the development of the services offered by the company to its customers.
Solution and method
The solution adopted was to develop a data platform using Microsoft Cloud Azure services, including SQL DATAWAREHOUSE, LOGIC/FUNCTION APP, DATA FACTORY, POLYBASE, SSAS/IS, and others. The implementation plan was designed to be pragmatic and progressive, ensuring smooth adoption by the company. The methods employed included co-definition of the future state, in-depth design, and progressive implementation of the platform.
Benefits
The benefits obtained from this project have been significant. The data platform developed has enabled significant productivity gains, while opening up new prospects for the development of services offered by the company to its customers. The use of Microsoft Cloud Azure and the various associated services has helped to boost the company's operational efficiency, positioning the organization favorably in an evolving technological environment.