Linkedin    Twitter   Facebook

Get Started
Log In

Linkedin

Articles Tagged with: DaaS

How RiskSpan Helped a Credit-Focused Investment Management Firm Transition to Snowflake

A leading investment management firm and recognized leader in structured credit, including asset-backed securities (ABS), mortgage-backed securities (MBS), and other fixed-income sectors, sought RiskSpan’s help transitioning key data processing functions from the data management platform 1010data to Snowflake.

The ability to share data with partners using the same system in which the analytics are performed made the combination of RiskSpan and Snowflake especially attractive. The shift provided significant operational and financial benefits to the client, marking another successful milestone in RiskSpan’s history of helping clients optimize their data management.

Converting Key Functionalities from 1010data to Snowflake

The company had been relying on 1010data for several critical timeseries-based calculations. However, the limitations of the platform—both in terms of speed and cost—prompted them to seek a more modern solution. RiskSpan worked closely with them to replicate and enhance key functionalities using Snowflake. Converted functionalities included:

  1. Timeseries-Based Calculations: We re-engineered these to operate efficiently within Snowflake’s cloud-native architecture, maintaining accuracy while enhancing processing speeds.
  2. fill_nearest: This function retrieves the nearest non-N/A value within a group. It was implemented seamlessly using Snowflake’s window functions, preserving data integrity while boosting performance.
  3. rolling_sum: Snowflake’s SQL capabilities were leveraged to implement the moving sum of valid (non-N/A) values within a window. This provided the company with more responsive and scalable time-series analysis capabilities.
  4. cumulative_run_length: The cumulative run length within a group was translated into Snowflake’s environment using efficient SQL queries, making the entire process faster and more robust.

Integration Capabilities

In addition to replicating 1010data’s core functionalities, the company sought to expand its data capabilities by integrating additional datasets such as Market Data and Home Price Indices (HPI). We showed them how to incorporate and analyze these datasets within Snowflake’s environment, further enhancing their decision-making capabilities.

This cross-functional integration was pivotal in showcasing Snowflake’s ability to streamline complex data workflows. By integrating third-party data directly into their ecosystem, our client can now generate more insightful reports and conduct deeper analysis across multiple datasets without leaving the Snowflake platform.

The Benefits of Transitioning to Snowflake

Our client experienced several immediate and impactful benefits by transitioning from 1010data to Snowflake were immediate and impactful. These included:

  • Complete Replacement of 1010data: With all critical functionalities successfully converted, the company now can fully discontinue their reliance on 1010data. This eliminates the need for maintaining multiple platforms and simplifies their technology stack.
  • Significant Cost Savings: Discontinuing 1010data relieved our client of the high costs associated with the platform’s licensing and maintenance fees. Snowflake’s cost-efficient pricing model has already resulted in substantial savings for the company.
  • Improved Processing Speeds: One of the most noticeable changes has been the drastic improvement in the company’s processing times. Snowflake’s optimized cloud infrastructure provides faster data processing and querying capabilities, significantly reducing time-to-insight.
  • Access to Full Snowflake Feature Set: Moving to Snowflake has enabled the company to take advantage of features such as data sharing, enhanced security, and elasticity. Snowflake’s built-in scalability ensures our client’s data infrastructure will continue to grow effortlessly as its data needs expand.
  • Speed and Cost Efficiency: The company has expressed particular satisfaction with both the speed and cost-efficiency of the Snowflake platform. The reduction in data processing time and cost per query has positively impacted its business operations.

Partnering with RiskSpan not only enabled the company to replace 1010data with a more modern and efficient platform, but it has also empowered them to take advantage of Snowflake’s newest, advanced features, including AI.

Contact us to learn how RiskSpan can help you unlock the full potential of your data by guiding you through complex transitions and helping you implement scalable, secure, and cost-effective solutions.


Enhancing a HELOC Lender’s Operations with RiskSpan’s Data as a Service (DaaS)

A leading fintech company specializing in home equity lines of credit (HELOCs), was seeking to optimize the management of its data operations. To accomplish this, the company turned to RiskSpan, a leader in data analytics and financial technology solutions. Through a tailored Data as a Service (DaaS) offering, RiskSpan helped the company improve its HELOC business operations by providing advanced data management and modeling capabilities.

Challenges

The company sought to enhance its HELOC operations in two critical areas:

  1. Data Management and Integration: The company was dealing with complex data sets from multiple sources, including credit bureaus, property data, and customer behavior insights. Integrating and managing this data effectively was crucial for making informed lending decisions.
  2. Risk Assessment and Modeling: Accurate and reliable risk assessment models were necessary for evaluating customer behavior and predicting loan performance. The company required a solution that could model draw behavior and other variables specific to HELOCs.

RiskSpan’s DaaS Solution

RiskSpan’s DaaS offering provided the company with a comprehensive solution tailored to address these challenges. The key components of the solution included:

  1. Advanced Data Integration: RiskSpan’s DaaS platform seamlessly integrated the company’s various data sources, enabling a more streamlined and efficient data management process. This integration allowed the company to better understand their borrowers and make more informed lending decisions.
  2. Enhanced Loan-Level HELOC Pricing and Projections: The client successfully loaded its historical loan performance data onto RiskSpan’s DaaS platform and established a monthly process within the platform’s flexible data warehouse. Using the embedded historical performance tool, the client analyzed loan-level behavior across its portfolio. This enabled the client to generate detailed collateral performance reports for investors and rating agencies, as well as leverage these insights to enhance future projections and loan-level pricing for new loans.
  3. Cost-Effective Data Services: RiskSpan also identified an opportunity to replace the client’s existing data services provider at a significantly reduced cost. By offering a more competitive pricing structure while maintaining high-quality data services, RiskSpan positioned the client to achieve substantial cost savings, making them more competitive in the HELOC market.

Outcomes and Benefits

Implementing RiskSpan’s DaaS solution brought several key benefits:

  • Improved Decision-Making: With better-integrated data and more accurate modeling of HELOC draw behavior, the client could make more informed lending decisions, ultimately reducing risk and enhancing profitability.
  • Operational Efficiency: The streamlined data management process allowed the client to operate more efficiently, freeing up resources to focus on core business activities.
  • Cost Savings: RiskSpan’s competitive pricing enabled the client to cut costs significantly, improving their bottom line and allowing them to reinvest in other areas of the business.

RiskSpan’s Data as a Service solution provided the clients with the tools it needed to optimize its HELOC business. By addressing its data integration challenges, improving risk assessment through advanced modeling, and offering a cost-effective alternative to existing data services, RiskSpan helped the client strengthen its market position and enhance overall business performance.


How RiskSpan and Snowflake Helped a Large Insurance Company Revolutionize Its Data Management

Background

Asset managers are increasingly turning to Snowflake’s cloud infrastructure to address the limitations of outdated databases. Migrating to Snowflake grants them access to a sustainable and secure platform that enables efficient data storage, processing, and analytics. This transition empowers asset managers to streamline operations, improve data accessibility, and reduce costs associated with maintaining on-premises infrastructure.

Client Challenge

A large insurance company’s asset management team was seeking to improve its approach to data management in response to its increasingly complex investment portfolio. The company recognized that transitioning to Snowflake would serve as a foundation for sustainable data analysis for years to come.

Desiring a partner to assist with the transition, the life insurer turned to RiskSpan – a preferred Snowflake partner with substantial experience in database architecture and management.

Specifically, the insurance company sought to achieve the following:

Systems Consolidation: Data stored across multiple transactional systems had contributed to data fragmentation and inefficiencies in data retrieval and analysis. The client sought to establish and maintain a consistent source of asset data for enterprise consumption and reporting.

Improved Reporting Capabilities: Quantifying full risk exposures in fast-moving situations proved challenging, leaving the institution vulnerable to unforeseen market fluctuations. Consequently, the client sought to improve its asset evaluation and risk assessment process by incorporating comprehensive look-through data and classification information. The need for various hierarchical classifications further complicated data access and reporting processes which required streamlining the process of producing ad-hoc exposure reports, which often required several weeks and involved teams of people.

Reduction of Manual Processes: The client needed more automated data extraction processes in order to create exposure reports across different asset classes in a more time-efficient manner with less risk of human error. 

Reduction of Infrastructure Constraints: On-premise infrastructure had defined capacity limitations, hindering scalability and agility in data processing and analysis.

RiskSpan’s Approach and Solutions Implemented

Collaborative Partnership: RiskSpan worked closely with the client’s IT, risk management, and analytics teams throughout the project lifecycle, fostering collaboration and ensuring alignment with organizational goals and objectives.

Comprehensive Assessment: Together, we conducted a thorough assessment of the client’s existing data infrastructure, analytics capabilities, and business requirements to identify pain points and opportunities for improvement.

Strategic Planning: Based on the assessment findings, the collective team developed a strategic roadmap outlining the migration plan to the unified data platform, encompassing asset data consolidation, portfolio analytics enhancement, and reporting automation.

Unified Data Platform: Leveraging modern technologies, including cloud-based solutions and advanced analytics tools, RiskSpan orchestrated the integration of various data sources and analytics capabilities. Together, we consolidated asset data from various transactional systems into a unified data platform, providing a single source of truth for comprehensive asset evaluation and risk assessment.

Data Lineage Tracking: The team employed dbt Labs tools to build, validate, and deploy flexible reporting solutions from the Snowflake cloud infrastructure.  This enabled the tracking of data lineage, adjustments, and ownership.

Daily Exposure Reporting: Leveraging automated analytic pipelines, we enabled real-time generation of exposure reports across different asset classes, enhancing the client’s ability to make timely and informed decisions.

Automated Data Extraction: We automated the data extraction processes, reducing manual intervention and streamlining data retrieval, cleansing, and transformation workflows.

Hierarchical Classification Framework: We implemented a hierarchical classification framework, providing standardized and consistent data hierarchies for improved data access and reporting capabilities.

Transformative Outcomes

Enhanced Decision-making: Implementing advanced analytics capabilities and exposure reporting empowered our client to make informed decisions more quickly, mitigating risks and capitalizing on market opportunities.

Operational Efficiency: Automation of data extraction, analytics modeling, and reporting processes resulted in significant operational efficiencies, reducing time-to-insight and enabling resource reallocation to strategic initiatives.

Scalability and Agility: The migration to a cloud-based infrastructure provides scalability and agility, allowing our client to adapt quickly to changing business needs and accommodate future growth without infrastructure constraints.

Data Governance and Compliance: The implementation of standardized hierarchical classifications strengthened data governance and compliance, ensuring data consistency, integrity, and regulatory adherence. By leveraging Snowflake’s scalable architecture and advanced features, this large asset manager is now positioned to maneuver both its current and future data landscapes. The implementation of Snowflake not only streamlined data management processes but also empowered the organization to extract valuable insights with unprecedented efficiency. As a result, the asset manager can make data-driven decisions confidently, enhance operational agility, and drive sustainable growth in a rapidly evolving market landscape.


RiskSpan Launches MBS Loan Level Historical Data on Snowflake Marketplace

ARLINGTON, Va., June 18, 2024 – RiskSpan, a leading provider of data analytics and risk management solutions for the mortgage industry, announced today that it has launched MBS Loan Level Historical Data on Snowflake Marketplace. RiskSpan’s MBS Loan Level Historical Data on Snowflake Marketplace enables joint customers to access RiskSpan’s normalized and enriched loan-level data for Fannie Mae, Freddie Mac, and Ginnie Mae mortgage-backed securities.

“We are thrilled to join the Snowflake Marketplace and offer our loan-level MBS data to a wider audience of Snowflake users,” said Janet Jozwik, Senior Managing Director at RiskSpan. “This is a first step in what we believe will ultimately become a cloud-based analytical hub for MBS investors everywhere.”

RiskSpan and Snowflake, the AI Data Cloud company, are working together to help joint customers inform business decisions and drive innovations by enabling them to query the data using SQL, join it with other data sources, and scale up or down as needed. RiskSpan also provides sample code and calculations to help users get started with common metrics such as CPR, aging curves, and S-curves.

“RiskSpan’s launch of a unique blend of enriched data onto Snowflake Marketplace represents a major opportunity for Snowflake customers to unlock new value through data on their business journey,” said Kieran Kennedy, Head of Marketplace at Snowflake. “We welcome RiskSpan to the ecosystem and look forward to exploring how we can support our customers as they look to leverage the breadth of the Snowflake platform more effectively.”

Joint customers can now leverage Loan-Level MBS Data on Snowflake Marketplace, allowing them to access RiskSpan data enhancements, including servicer normalization, refinements, mark-to-market LTV calculations, current coupon. These and other enhancements make it easier and faster for users to perform analysis and modeling.

Snowflake Marketplace is powered by Snowflake’s ground-breaking cross-cloud technology, Snowgrid, allowing companies direct access to raw data products and the ability to leverage data, data services, and applications quickly, securely, and cost-effectively. Snowflake Marketplace simplifies discovery, access, and the commercialization of data products, enabling companies to unlock entirely new revenue streams and extended insights across the AI Data Cloud. To learn more about Snowflake Marketplace and how to find, try and buy the data, data services, and applications needed for innovative business solutions, click here.

About RiskSpan, Inc. 

RiskSpan delivers a single analytics solution for structured finance and private credit investors of any size to confidently make faster, more precise trading and portfolio risk decisions and meet reporting requirements with fewer resources, and less time spent managing multiple vendors and internal solutions. Learn more at www.riskspan.com.


The newest, fastest and easiest way to access and analyze Agency MBS data

TL;DR Summary of Benefits

  • Data normalization and enhancement: RiskSpan’s MBS data on Snowflake normalizes Fannie, Freddie, and Ginnie loan-level data, consolidating everything into one set of field names. It also offers enhanced loan level-data fields, including current coupon, spec pool category, and mark-to-market LTV, which are not available in the raw data from the agencies. The data also includes pool-level factors like pool prefix and pool age, as well as full loan histories not available from the GSEs directly.
  • Data access and querying: Users access the data in Snowflake using SQL or Python connectors. Snowflake functions essentially as a cloud SQL server that allows for instantaneous data sharing across entities. In just a few clicks, users can start analyzing MBS data using their preferred coding language—no data, ETL, or IT Teams required.
  • Data merging and analytics: Users can merge the data in Snowflake with other available loan level or macroeconomic data, including interest rates, home prices, and unemployment, for advanced analytics. Users can also project performance, monitor portfolios, and create spec pools, among other features.

The Problem

Even though Fannie, Freddie and Ginnie have been making MBS performance data publicly available for years, working with the raw data can be challenging for traders and back-office analysts.

Traders and analysts already have many of the tools they need to write powerful queries that can reveal hidden patterns and insights across different markets – patterns that can reveal lucrative trading opportunities based on prepayment analysis. But one big obstacle often stands in the way of getting the most out of these tools: the data from the agencies is large and unwieldy and is not formatted in a consistent way, making it hard to compare and combine.

What’s more, the Agencies do not maintain full history of published data on the websites for download. Only recent history is available.

The Solution: RiskSpan’s new MBS loan-level historical offering on Snowflake Marketplace

Using RiskSpan’s new MBS Loan-Level Historical Data Offering, MBS traders and analysts can now leverage the power of Snowflake, the leading cloud data platform, to perform complex queries and merge data from multiple sources like never before.

This comprehensive data offering provides a fully normalized view of the entire history of loan-level performance data across Agencies – allowing users to interact with the full $9T Agency MBS market in unprecedented ways.

A list of normalized Fannie and Freddie fields can be found at the end of this post.

In addition to being able to easily compare different segments of the market using a single set of standardized data fields, MBS traders and analysts also benefit from derived and enhanced data, such as current coupon, refinance incentive, current loan-to-value ratio, original specified pool designation, and normalized seller and servicer names.

The use cases are practically limitless.

MBS traders and analystscan track historical prepayment speeds, find trading opportunities that offer relative value, and build, improve, or calibrate prepayment models. They can see how prepayment rates vary by loan size, credit score, geographic location, or other factors. They can also identify pools that have faster or slower prepayments than expected and exploit the differences in price.

Loan originators can see how their loans perform compared to similar loans issued by other originators, servicers, or agencies, allowing them to showcase their ability to originate high-quality loans that command premium pricing.

Enhanced fields provide users with more comprehensive insights and analysis capabilities. They include a range of derived and enhanced data attributes beyond the standard dataset: derived fields useful for calculations, additional macroeconomic data, and normalized field names and enumerations. These fields give users the flexibility to customize their analyses by incorporating additional data elements tailored to their specific needs or research objectives.

Enhanced loan-level fields include:

  • Refi Incentive: The extent to which a borrower’s interest rate exceeds current prevailing market rates
  • Spread at Origination (SATO): a representation of the total opportunities for refinancing within a mortgage servicing portfolio. SATO encompasses all potential refinance candidates based on prevailing market conditions, borrower eligibility, and loan characteristics
  • Servicer Normalization: A standardization of servicer names to ensure consistency and accuracy in reporting and analysis
  • Scheduled Balance: A helper field necessary to easily calculate CPR and other performance metrics
  • Spec Pool Type: A designation of the type of spec story on the loan’s pool at origination
  • Current LTV: a walked forward LTV based on FHFA’s HPI and the current balance of the loan

Not available in the raw data from the agencies, these fields allow MBS traders and analysts to seamlessly project loan and pool performance, monitor portfolios, create and evaluate spec pools, and more.

Access the Data on Your Terms

Traders and analysts can access the data in Snowflake using SQL or Python connectors. Alternatively, they can also access the data through the Edge UI, our well-established product for ad hoc querying and visualization. RiskSpan’s Snowflake listing provides sample queries and a data dictionary for reference. Data can be merged with macroeconomic data from other sources – rates, HPI data, unemployment – for deeper insights and analytics.

The listing is available for a 15-day free trial and can be purchased on a monthly or annual basis. Users don’t need to have a Snowflake account to try it out. Learn more and get started at the Snowflake Marketplace or contact us to schedule a demo or discussion.

Fannie/Freddie Normalized Fields

NAMETYPEDESCRIPTION
AGENumberLoan Age in Months
AGENCYVarcharFN [Fannie Mae], FH [Freddie Mac]
ALTDQRESOLUTIONVarcharPayment deferral type: CovidPaymentDeferral,DisasterPaymentDeferral,PaymentDeferral,Other/NA
BORROWERASSISTPLANVarcharType of Assistance: Forbearance, Repayment, TrialPeriod, OtherWorkOut, NoWorkOut, NotApplicable, NotAvailable
BUSINESSDAYSNumberBusiness Day in Factor Period
COMBINEDLTVFloatOriginal Combined LTV
CONTRIBUTIONFloatContribution of Loan to the Pool, to be used to correctly attribution Freddie Mirror Pools
COUPONFloatNet Coupon or NWAC in %
CURRBALANCEFloatCurrent Balance Amount
CURRENTCOUPONFloatPrimary rate in the market (PMMS)
CURRENTLTVFloatCurrent Loan to Value Ratio based on rolled-forward home value calculated by RiskSpan based on FHFA All-Transaction data
CURTAILAMOUNTFloatDollar amount curtailed in the period
DEFERRALAMOUNTFloatDollar amount deferred
DQSTRINGVarcharDelinquency History String, left most field in the current period
DTIFloatDebt to Income Ratio %
FACTORDATEDatePerformance Period
FICONumberBorrower FICO Score [300,850]
FIRSTTIMEBUYERVarcharFirst time home buyer flag Y,N,NA
ISSUEDATEDateLoan Origination Date
LOANPURPOSEVarcharLoan Purpose: REFI,PURCHASE,NA
LTVFloatOriginal Loan to Value Ratio in %
MATURITYDATEDateLoan Maturity Date
MICOVERAGEFloatMortgage Insurance Coverage %
MOSDELINQVarcharDelinquency Status: Current, DQ_30_Day, DQ_60_Day, DQ_90_Day, DQ_120_Day, DQ_150_Day, DQ_180_Day, DQ_210_Day, DQ_240_Day, DQ_270_Day, DQ_300_Day, DQ_330_Day, DQ_360_Day, DQ_390_Day, DQ_420_Day, DQ_450_Day, DQ_480_Day, DQ_510_Day, DQ_540_Day, DQ_570_Day, DQ_600_Day, DQ_630_Day, DQ_660_Day, DQ_690_Day, DQ_720pls_Day
MSAVarcharMetropolitian Statistical Area
NUMBEROFBORROWERSNumberNumber of Borrowers
NUMBEROFUNITSVarcharNumber of Units
OCCUPANCYTYPEVarcharOccupancy Type: NA,INVESTOR,OWNER,SECOND
ORIGBALANCEFloatOriginal Loan Balance
ORIGSPECPOOLTYPEVarcharSpec Story of the pool that the loan is a part of. Please see Spec Pool Logic in our linked documentation
PERCENTDEFERRALFloatPercentage of the loan balance that is deferred
PIWVarcharProperty Inspection Waiver Type: Appraisal,Waiver,OnsiteDataCollection, GSETargetedRefi, Other,NotAvailable
POOLAGENumberAge of the Pool
POOLIDVarcharPool ID


Transforming Loan Data Management Using Snowflake Secure Data Sharing

Presenters

Paul Gross

Senior Quantitative Analyst, Rithm Capital

Michael Cowley

Principal, Data Cloud Products, Snowflake

Bernadette Kogler

CEO, RiskSpan

Suhrud Dagli

CTO, RiskSpan

Wednesday, May 29th, 2024

1:00 ET

Hear from a distinguished panel including RiskSpan and Snowflake customers as they describe how Data Share has transformed their approach to mortgage investment. Specific topics to include:

  • High-speed data processing using Snowflake for easy delivery of risk analytics and diligence data
  • How Snowflake’s Data Sharing facilitates data access across and between organizations while maximizing computational performance and flexibility 
  • How Snowflake protects client data
  • The unique value of a central hub for all mortgage industry data and never having to FTP a file again

watch recording


Snowflake and the Future of Data Sharing Across Financial Institutions

The digitization of the financial services industry has opened countless doors to streamlining operations, building customer bases, and more accurately modeling risk. Capitalizing on these opportunities, however, requires financial institutions to address the immense data storage and sharing requirements that digitization requires.  

Recognizing this need, Snowflake has emerged as an industry-leading provider of cloud-computing services for the financial industry. According to estimates, some 57 percent of financial service companies in the Fortune 500 have partnered with Snowflake to address their data needs.1 In this article, we highlight some of Snowflake’s revolutionary data sharing capabilities that have contributed to this trend and RiskSpan’s decision to become a Snowflake partner.     

Financial institutions contemplating migration to the cloud are beset by some common concerns. Chief among these are data sharing capabilities and storage costs. Fortunately, Snowflake is well equipped to address both. 

Data Sharing Between Snowflake Customers

Ordinarily, sharing information across institutions inflates storage costs and imposes security and data integrity concerns.  

Snowflake’s Secure Data Sharing eliminates these concerns because no physical data transfer occurs between accounts. When one Snowflake customer desires to share data with another Snowflake customer, a services layer and metadata store facilitate all sharing activities. As a result, shared data does not occupy any storage in the institution consuming the data, nor does it impact that institution’s monthly data storage expenses. Data consumers are only charged for the compute resources, such as virtual warehouses, they use to query the shared data.  

The setup for Secure Data Sharing is streamlined and straightforward for data providers, while consuming institutions can access shared data almost instantaneously.   

Organizations can easily: 

  • Establish a share from a database within their account, granting access to specified objects within that database.  
  • Share data across multiple databases, provided all databases are under the same account.  
  • Add, remove, and edit access for all users. 

Data Sharing with Non-Snowflake Customers

For institutions desiring to share data with non-Snowflake customers, Snowflake offers an alternative secure data sharing method, known as a “reader account.” Reader accounts offer an efficient and cost-effective solution for data sharing without requiring consumers to register for Snowflake. They are associated exclusively with the provider’s account that established them. Data providers share databases with reader accounts, but each reader account can only access data from its originating provider account. Individuals using a reader account can perform queries on shared data but are restricted from carrying out DML operations, such as data loading, insertions, updates, and other data manipulations. These accounts serve as cost-effective solutions for organizations seeking to limit the number of more expensive user profiles. 

Secure Sharing with Data Clean Rooms

Clean room managed accounts are another way for Snowflake customers to share data with non-Snowflake customers. Data clean rooms are created by data providers to avoid privacy concerns when sharing their data. This is accomplished by allowing data consumers to compile aggregated results and analysis without permitting access to query the original raw data. Data providers can granularly control how their data is accessed and the types of analysis that can be run using their data. The data is encrypted and uses differential privacy techniques for further protection.   

How Can RiskSpan Help?

Knowing that you want to be on Snowflake isn’t always enough. Getting there can be the hardest part, and many organizations face challenges migrating from legacy systems and lack the expertise to fully utilize new technology after implementation. RiskSpan has partnered with numerous companies to help guide them towards a sustainable framework that holistically addresses all their data needs. No matter where the organization is within their data journey, RiskSpan has the expertise to help overcome the challenges associated with the new technology.    

RiskSpan is equipped to help institutions with the following as they embark on their Snowflake migration journey: 

  • End-to-end migration services, including architecture design, setting up the Snowflake environment, and properly validating the new platform.   
  • Adaptive project management. 
  • Data governance including the creation of a data catalog, tracing data lineage, and compliance and security requirements. 
  • Establishing data warehouses and data pipelines to facilitate collaboration and analysis. 
  • Creating security protocols including role-based access controls, disaster recovery solutions, and ensuring the utmost protection of personally identifiable information.   
  • Optimizing extract, transform and load solutions   

Snowflake’s data sharing capabilities offer an innovative solution for businesses looking to leverage real-time data without the hassle of traditional data transfer methods. These features not only enhance operational efficiency but also provide the scalability and security necessary for handling extensive datasets in a cloud environment.

Contact us with any questions or to discuss how Snowflake can be tailored to your specific needs.


Case Study: How a leading loan and MSR investor reduced costs with a loan-level approach

Learn more about how one whole loan and MSR investor (a large mortgage REIT) successfully overhauled its analytics computational processing with RiskSpan. The investor migrated from a daily pricing and risk process that relied on tens of thousands of rep lines to one capable of evaluating each of the portfolio’s more than three-and-a-half million loans individually (and how they actually saved money in the process). 

The Situation 

One of the industry’s largest mortgage REITs sought a more forward-thinking way of managing its extensive investment portfolio of mortgage servicing rights (MSR) assets, residential loans and securities. The REIT runs a battery of sophisticated risk management analytics that rely on stochastic modeling. Option-adjusted spread, duration, convexity, and key rate durations are calculated based on more than 200 interest rate simulations.

The investor used rep lines for one main reason: it needed a way to manage computational loads on the server and improve calculation speeds. Secondarily, organizing the loans in this way simplified the reporting and accounting requirements to a degree (loans financed by the same facility were grouped into the same rep line).  

This approach had some significant downsides. Pooling loans by finance facility was sometimes causing loans with different balances, LTVs, credit scores, etc., to get grouped into the same rep line. This resulted in prepayment and default assumptions getting applied to every loan in a rep line that differed from the assumptions that likely would have been applied if the loans were being evaluated individually. 

The Challenge 

The main challenge was the investor’s MSR portfolio—specifically, the volume of loans needing to be run. Having close to 4 million loans spread across nine different servicers presented two related but separate sets of challenges. 

The first set of challenges stemmed from needing to consume data from different servicers whose file formats not only differed from one another but also often lacked internal consistency. Even the file formats from a single given servicer tended to change from time to time. This required RiskSpan to continuously update its data mappings and (because the servicer reporting data is not always clean) modify QC rules to keep up with evolving file formats.  

The second challenge related to the sheer volume of compute power necessary to run stochastic paths of Monte Carlo rate simulations on 4 million individual loans and then discount the resulting cash flows based on option adjusted yield across multiple scenarios. 

And so there were 4 million loans times multiple paths times one basic cash flow, one basic option-adjusted case, one up case, and one down case—it’s evident how quickly the workload adds up. And all this needed to happen on a daily basis. 

To help minimize the computing workload, the innovative REIT had devised a way of running all these daily analytics at a rep-line level—stratifying and condensing everything down to between 70,000 and 75,000 rep lines. This alleviated the computing burden but at the cost of decreased accuracy because they could not look at the loans individually.

The Solution 

The analytics computational processing RiskSpan implemented ignores the rep line concept entirely and just runs the loans. The scalability of our cloud-native infrastructure enables us to take the nearly four million loans and bucket them equally for computation purposes. We run a hundred loans on each processor and get back loan-level cash flows and then generate the output separately, which brings the processing time down considerably. 

For each individual servicer, RiskSpan leveraged its Smart Mapper technology and Configurable QC feature in its Edge Platform to create a set of optimized loan files that can be read and rendered “analytics-ready” very quickly. This enables the loan-level data to be quickly consumed and immediately used for analytics without having to read all the loan tapes and convert them into a format that an analytics engine can understand. Because RiskSpan has “pre-processed” all this loan information, it is immediately available in a format that the engine can easily digest and run analytics on. 

What this means for you

An investor in any mortgage asset benefits from the ability to look at and evaluate loan characteristics individually. The results may need to be rolled up and grouped for reporting purposes. But being able to run the cash flows at the loan level ultimately makes the aggregated results vastly more meaningful and reliable. A loan-level framework also affords whole-loan and securities investors the ability to be sure they are capturing the most important loan characteristics and are staying on top of how the composition of the portfolio evolves with each day’s payoffs. 


It’s time to move to DaaS — Why it matters for loan and MSR investors

Data as a service, or DaaS, for loans and MSR investors is fast becoming the difference between profitable trades and near misses.

Granularity of data is creating differentiation among investors. To win at investing in loans and mortgage servicing rights requires effectively managing a veritable ocean of loan-level data. Buried within every detailed tape of borrower, property, loan and performance characteristics lies the key to identifying hidden exposures and camouflaged investment opportunities. Understanding these exposures and opportunities is essential to proper bidding during the acquisition process and effective risk management once the portfolio is onboarded.

Investors know this. But knowing that loan data conceals important answers is not enough. Even knowing which specific fields and relationships are most important is not enough. Investors also must be able to get at that data. And because mortgage data is inherently messy, investors often run into trouble extracting the answers they need from it.

For investors, it boils down to two options. They can compel analysts to spend 75 percent of their time wrangling unwieldy data – plugging holes, fixing outliers, making sure everything is mapped right. Or they can just let somebody else worry about all that so they can focus on more analytical matters.

Don’t get left behind — DaaS for loan and MSR investors

It should go without saying that the “let somebody else worry about all that” approach only works if “somebody else” possesses the requisite expertise with mortgage data. Self-proclaimed data experts abound. But handing the process over to an outside data team lacking the right domain experience risks creating more problems than it solves.

Ideally, DaaS for loan and MSR investors consists of a data owner handing off these responsibilities to a third party that can deliver value in ways that go beyond simply maintaining, aggregating, storing and quality controlling loan data. All these functions are critically important. But a truly comprehensive DaaS provider is one whose data expertise is complemented by an ability to help loan and MSR investors understand whether portfolios are well conceived. A comprehensive DaaS provider helps investors ensure that they are not taking on hidden risks (for which they are not being adequately compensated in pricing or servicing fee structure).

True DaaS frees up loan and MSR investors to spend more time on higher-level tasks consistent with their expertise. The more “blocking and tackling” aspects of data management that every institution that owns these assets needs to deal with can be handled in a more scalable and organized way. Cloud-native DaaS platforms are what make this scalability possible.

Scalability — stop reinventing the wheel with each new servicer

One of the most challenging aspects of managing a portfolio of loans or MSRs is the need to manage different types of investor reporting data pipelines from different servicers. What if, instead of having to “reinvent the wheel” to figure out data intake every time a new servicer comes on board, “somebody else” could take care of that for you?

An effective DaaS provider is one not only that is well versed in building and maintain loan data pipes from servicers to investors but also has already established a library of existing servicer linkages. An ideal provider is one already set-up to onboard servicer data directly onto its own DaaS platform. Investors achieve enormous economies of scale by having to integrate with a single platform as opposed to a dozen or more individual servicer integrations. Ultimately, as more investors adopt DaaS, the number of centralized servicer integrations will increase, and greater economies will be realized across the industry.

Connectivity is only half the benefit. The DaaS provider not only intakes, translates, maps, and hosts the loan-level static and dynamic data coming over from servicers. The DaaS provider also takes care of QC, cleaning, and managing it. DaaS providers see more loan data than any one investor or servicer. Consequently, the AI tools an experienced DaaS provider uses to map and clean incoming loan data have had more opportunities to learn. Loan data that has been run through a DaaS provider’s algorithms will almost always be more analytically valuable than the same loan data processed by the investor alone.  

Investors seeking to increase their footprint in the loan and MSR space obviously do not wish to see their data management costs rise in proportion to the size of their portfolios. Outsourcing to a DaaS provider that specializes in mortgages, like RiskSpan, helps investors build their book while keeping data costs contained.

Save time and money – Make better bids

For all these reasons, DaaS is unquestionably the future (and, increasingly, the present) of loan and MSR data management. Investors are finding that a decision to delay DaaS migration comes with very real costs, particularly as data science labor becomes increasingly (and often prohibitively) expensive.

The sooner an investor opts to outsource these functions to a DaaS provider, the sooner that investor will begin to reap the benefits of an optimally cost-effective portfolio structure. One RiskSpan DaaS client reported a 50 percent reduction in data management costs alone.

Investors continuing to make do with in-house data management solutions will quickly find themselves at a distinct bidding disadvantage. DaaS-aided bidders have the advantage of being able to bid more competitively based on their more profitable cost structure. Not only that, but they are able to confidently hone and refine their bids based on having a better, cleaner view of the portfolio itself.

Rethink your mortgage data. Contact RiskSpan to talk about how DaaS can simultaneously boost your profitability and make your life easier.

REQUEST A DEMO


Get Started
Log in

Linkedin   

risktech2024