Client type
Large data vendor
Key stakeholders
Head of Mortgages
Location
United States
Project outline
- The 2008 financial market downturn led to a heightened need for clarity and insights among mortgage issuers in the US RMBS landscape
- Our client, a notable data provider, identified this need and aimed to create analytic tools to enable mortgage issuers to compare their offerings with similar issuers and servicers
- The goal was to bring transparency to this market, which consists of millions of loans across various pools from diverse sources with different formats
The Challenge
Post-2008 market dynamics posed several challenges:
- Mortgage issuers sought to make informed decisions by comparing their offerings with those of similar issuers and servicers, amidst evolving market conditions
- Handling vast volumes of loan data across various pools from diverse sources, each with different formats, made data analysis a complex task
- There was a necessity for analytics tools to unveil transparency in this multifaceted market
How StructureIt helped
StructureIt stepped in with a comprehensive solution designed to empower mortgage issuers:
- Cloud-Based ETL Process: StructureIt designed and deployed a cloud-based Extract, Transform, Load (ETL) process to ingest and standardize the extensive Agency RMBS Pool and Loan data, easing the data management burden
- Data Platform: The consolidated data was hosted on a platform that allowed rapid pre-canned aggregations, enabling mortgage issuers to quickly compare loans based on various attributes such as issuers, servicers, government agencies, and product types
- Effective Visualization: An intuitive application was developed to harness the data’s potential. Through straightforward graphs and visualizations, issuers could identify trends and make informed decisions
The Results
The collaboration yielded impressive outcomes:
- Up and running in 5 months: The first iteration of the platform was operational within five months of project initiation, delivering timely insights to mortgage issuers.
- Robust data aggregation: The platform, aggregating data from over 80 million active loans across thousands of attributes, facilitated quick data aggregation and comparison within seconds, enhancing decision-making capabilities.
- Industry Adoption: With over 80% engagement from the RMBS issuer community, the platform established itself as a valuable industry resource for data analysis and market insight.
StructureIt’s partnership with the data provider ushered in a transformative solution that navigated the complexities of the post-2008 mortgage landscape. By offering clarity through data-driven insights, the solution enabled mortgage issuers to remain competitive and well-informed.
Collaboration, on your terms
We collaborate with you to develop personalized software solutions that contribute to your business growth in the capital markets