FactSet, Snowflake Take Aim at Financial Data Mapping Challenges
FactSet’s mapping service, Concordance, can be used on its own or with Snowflake’s cloud, enabling users to apply the offering to other datasets in Snowflake’s ecosystem.
FactSet will this week unveil Concordance, a new service for performing outsourced data mapping of traditional, alternative, and clients’ proprietary data. It leverages its existing operations and technology, as well as its relationship with cloud provider Snowflake to provide mapping of data stored in mutual clients’ cloud environments.
The Concordance service aims to link standard reference data to alternative data and a firm’s own internal datasets—in the same way that FactSet already links identifiers and other metadata to “traditional” market data—so that all relevant information can be mapped to the companies and securities it relates to.
For any data—such as new “alternative” or proprietary client data—that does not immediately match the reference data in FactSet’s security master file, clients can submit the unmatched data via the vendor’s Concordance API, and the vendor will accurately link it to reference data using AI algorithms, then send it back to clients with the metadata required to link all of a client’s data with minimal effort. The data matches are checked and validated by FactSet’s data teams, who also manually link any data that does not match automatically.
Once data is mapped and linked, it can be used to power clients’ security masters, data lakes in the cloud, as well as creating new usage opportunities, such as an input to customer-relationship management (CRM) systems, Jonathan Reeve, global head of content and technology solutions at FactSet, tells WatersTechnology.
The big challenge to achieving this is that many firms have assembled proprietary datasets which have value but do not conform to FactSet’s reference data. Previously, to use its own data in conjunction with FactSet’s market data, a firm would have needed to link the content manually, which—at a conservative estimate—could take one minute per company, whereas the new service aims to match up to 80% of data instantaneously, with the remainder matched manually by FactSet’s operations staff.
“Think of the service as concentric circles of capabilities: At the center of the circle is a service we call Data Management Solutions—a reference data file that allows you to connect securities with all standard identifiers and reference data, full descriptions, our FactSet ID, other vendor identifiers, and entity/issuer identifiers, so that you have the relationship between a company and the securities it has issued,” Reeve says.
Having accurate reference data allows users to connect and search for companies across different industries and sectors, he says. “The next ring of the circle is our Open:FactSet platform, where we bring in ‘alternative’ content… and link it all. That allows people to navigate not just ‘traditional’ datasets, but also new data types,” he adds.
For example, one company already using the service is an alternative data vendor that participates in the Open:FactSet Marketplace of alternative data. This vendor scrapes content from the web, and in the past needed to source and link reference data to its content by hand to make the data usable. Now, the vendor can achieve that almost immediately using the Concordance service, Reeve says.
FactSet will offer Concordance as a standalone service, but Reeve believes it offers even greater value when applied to data being stored and shared in Snowflake’s cloud. “When you put that in Snowflake, you have the ultimate data-linking capability in the ultimate data-sharing platform,” he says.
“This mapping problem—whether internal or between different providers—plagues every industry, but in particular financial services,” says Matt Glickman, VP of customer product strategy at Snowflake, who spent almost 25 years at Goldman Sachs prior to joining Snowflake in 2015. Addressing the data mapping challenge is as “strategic” to Snowflake as expanding its ecosystem of data and services, because it will help clients not just integrate but also search for and identify potential services on its cloud.
“I could take a dataset that uses natural-language extraction to generate sentiment, and tie it to classification data in FactSet, and then I have a classified dataset that I can join with other data I have from FactSet within minutes or hours, without having to undertake a big project,” Glickman says. This enables firms to use the data not just to support trading and investment decisions, but also to support new business development.
For example, another potential—and non-traditional—use-case for Concordance is that of an unnamed European financial firm that uses it to augment client data in its CRM system with reference data and other information, so that the firm can link FactSet’s market and fundamental data to its database of customer data.
“Everyone has client data in a CRM system,” Glickman says. “What if you could enrich your CRM system to identify which clients are ESG (environmental, social, and governance)-friendly, or which companies in a client’s supply chain have experienced Covid-related earnings disruptions?”
“It transforms the client’s CRM platform from being a call-tracking system to a lead-generation system,” Reeve adds.
Further reading
Only users who have a paid subscription or are part of a corporate subscription are able to print or copy content.
To access these options, along with all other subscription benefits, please contact info@waterstechnology.com or view our subscription options here: http://subscriptions.waterstechnology.com/subscribe
You are currently unable to print this content. Please contact info@waterstechnology.com to find out more.
You are currently unable to copy this content. Please contact info@waterstechnology.com to find out more.
Copyright Infopro Digital Limited. All rights reserved.
You may share this content using our article tools. Printing this content is for the sole use of the Authorised User (named subscriber), as outlined in our terms and conditions - https://www.infopro-insight.com/terms-conditions/insight-subscriptions/
If you would like to purchase additional rights please email info@waterstechnology.com
Copyright Infopro Digital Limited. All rights reserved.
You may share this content using our article tools. Copying this content is for the sole use of the Authorised User (named subscriber), as outlined in our terms and conditions - https://www.infopro-insight.com/terms-conditions/insight-subscriptions/
If you would like to purchase additional rights please email info@waterstechnology.com
More on Data Management
The IMD Wrap: Talkin’ ’bout my generation
As a Gen-Xer, Max tells GenAI to get off his lawn—after it's mowed it, watered it and trimmed the shrubs so he can sit back and enjoy it.
Waters Wavelength Podcast: The issue with corporate actions
Yogita Mehta from SIX joins to discuss the biggest challenges firms face when dealing with corporate actions.
Data catalog competition heats up as spending cools
Data catalogs represent a big step toward a shopping experience in the style of Amazon.com or iTunes for market data management and procurement. Here, we take a look at the key players in this space, old and new.
This Week: JP Morgan, Broadridge, Lloyds, JSE, Schroders, and more
A summary of the latest financial technology news.
What firms should know ahead of the DSB’s UPI launch
Six jurisdictions have set deadlines for firms to implement the derivatives identifier, with more expected to follow.
Has cloud cracked the multicast ‘holy grail’ for exchanges?
An examination of how exchanges—already migrating to the cloud—are working to solve the problem of multicasting in a new environment.
Waters Wrap: Market data spend and nice-to-have vs. need-to-have decisions
Cost is not the top factor driving the decision to switch data providers. Anthony looks at what’s behind the evolution of spending priorities.
The consolidated tapes are taking shape—but what shape exactly?
With political appetite established on both sides of the Channel, attention is turning to the technical details.