Client type
Leading data provider
Key stakeholders
Multiple business lines
Location
Global
Project outline
- Our client wanted to harness a decade’s worth of diverse historical residential mortgage-backed security (RMBS) data for monetization
- The goal was to create a configurable platform to process, clean, and transform complex data sets and allow users to manage these data sets into the future with reduced vendor dependency
- After several in-house attempts had proven unsuccessful, StructureIt was engaged to bring a new perspective to the technical solution
The Challenge
Our client, a global leader in the Commercial Mortgage-Backed Security industry, reached a critical stage in their data management journey. Specifically, they needed to extend their reporting and portfolio monitoring processes to meet growing SEC requirements. They required complete monthly IRP data for all deals within days of payment dates in their data store.
Moreover, this included historical data dating back to the issuance of their active deals. Internal technical bandwidth challenges further complicated this data timeliness requirement.
Unfortunately, existing market data options fell short of their overall vision. These solutions could not provide a consistent replica of IRP data crucial for their financial and monitoring excellence. Furthermore, they managed a large and growing portfolio of over 70 deals. They added 2 deals each month. Therefore, they required a robust and scalable data solution.
How StructureIt helped
StructureIt was asked to build a solution that could rapidly deliver a clear, quick return on investment. StructureIt delivered a cloud-based data ingestion platform that:
- Centralizes data collection from multiple disparate upstream data sources
- Automatically ingests, validates, and extracts data into a cleansed layer, consolidated into a single common normalised format with additional fields derived for analytic purposes
- Provides a generic configuration-driven solution that allows complete control and versioning of historical schemas within a database, enabling the extraction process to adapt to changing data structures over time
Through the solution’s configurable design, users can now validate new schemas and data independently, streamlining adaptation to new and evolving data sets.
The Results
The platform is now a monetized asset for our customers. By providing a centralized repository for cleansed, consolidated, and normalized RMBS data, our customer has been able to deliver analytical insights via Snowflake, Databricks, and other data distribution layers, offering new data products to market and strategically increasing revenue numbers.
Alongside this, the analytics teams and domain experts are enabled to independently onboard and analyze new data sets within days, rather than weeks. This has also significantly reduced the business dependency on IT resources, and the platform’s ability to validate and adapt to new data significantly shortens analytics production cycles.
With this foundation in place, our customer is now expanding the platform to cater to additional data sources, which is crucial for future growth and adaptability in the evolving data landscape.
Collaboration, on your terms
We collaborate with you to develop personalized software solutions that contribute to your business growth in the capital markets
