Streamline pipeline integrity data management for financial services

How to create outlook signature

[Music] hi everyone I'm Brian lenker and I'm the financial services industry CTO at Snowflake today I'll be demonstrating how hypothetical investment manager can seamlessly incorporate ESG data into their investment planning workflow using snowflake the momentum to adopt and incorporate ESG into Financial Services workflows has never been higher with factors such as the covid pandemic continued climate change and heightened social unrest investors and Regulators are now expecting Financial professionals to identify and properly evaluate investment opportunities and risk against ESG measures fortunately the financial services industry is well positioned to be a leader in this space for this demo I will show how to discover and Source new sets of third-party ESG data how to integrate and apply these new data sets into an existing database of In-House ESG metrics how to compare proprietary ESG scores with third-party ESG data and then apply this data to our portfolios by the end of this workflow we will be able to help investment managers identify any Holdings with deteriorating ESG scores screen for alternative investment opportunities and quickly rebalance their portfolio to meet the needs of their clients as you can see here we have a set of Json files sitting on object storage for our clients this could be something like S3 Azure blob or Google Cloud Storage for this demo we have an internal object storage stage that I have loaded to still and as you can see we have these compressed files that include our daily portfolio data by just clearing the data as it lies on the internal stage before we've even loaded it into a proper table in Snowflake we see our Json data showing our portfolio the Holdings the shares as well as the in-house ESG score later in this demo we will show how our portfolio ranks against this proprietary score that our analysts have derived and how it compares the ESG scores from the snowflake Marketplace so diving in and showing some snowflake feature functions here you can create a table containing a special variant column to load that Json into now let's load the data we'll go ahead and scale our warehouse up load that data using a Json file format grabbing it from the stage putting it in our new table and then immediately scale that warehouse back down with those Json files loaded we can go ahead and just take a look at that raw table next using snowflakes dot notation you can click into our portfolio see our Holdings the thicker symbols the name of the Securities any trades that have been made in the previous day and our in-house ESG scores I can turn this into a view so it looks more like a normal table and will be easier for us to refer to later on in the demo as an example I quickly return this View and look at all of our positions for Tesla across our various portfolios now I'm going to show you how to bring in factset's ESG data what you're seeing here is snowflake's data Marketplace we're going to pull from factset's True Value Labs sasb scores data feed which you can see more info on here including things like coverage history and documentation we'd normally click on this request data button but we've already handled the agreements for the purpose of this demo we've received this data from factset to rishair and harmonized it with our in-house ESG scores we will focus on materiality as well as their all categories insights and ranking scores all of which you can see here in the results pane promoting this as a view you get to your analytics layer where bi users and tools will actually report out of and we can begin to query this view looking at our internal ESG score as well as fat sets all categories ESG score for this next query we'll look at anything newer than March of last year and we're looking at the average internal score by day compared to the average factset True Value score here you can see on our result pane that our average internal score is a little higher than what factset is providing we can make this a little easier to see by visualizing the results quickly with a simple line chart comparing the two metrics over time this scoring differential is something that may trigger a portfolio manager to examine and re-evaluate something that our internal ESG data lacks is scoring around benchmarks by utilizing the marketplace again we can access this data from fax app here you can see the results of this query returning ESG scores at The Benchmark level by bringing this data in our portfolio managers can now Benchmark their portfolios against these different indices Now using the snow site functionality we can visualize this in a bar graph you can see that we have been able to quickly go from tabular data to some visuals to grab insights from and then specifically our portfolio seems to be performing on an aggregate ESG scoring higher than the S P 500 but lower than the s p total US Stock Market with factset's ESG data merged with our in-house ESG scores we can also see any constituents that have dropped in their ESG scores month over month as this query is showing us this Insight will help us determine and influence how we construct and rebalance our portfolios [Music] we can even dig further into specific Holdings as the next query shows and understand more about why specific attributes might be declining and maybe in this instance removing a holding completely from our portfolio finally we have a dashboard to pull all this information together we can see our Market values from our portfolios our internal ESG scores plus the scores we brought in from factset through the marketplace as well as the Benchmark values and finally our top decliners and advancers in our portfolio based on those combined scores wrapping up we were able to highlight a number of topics reduce time and data Discovery and data acquisition by leveraging the snowflake data Marketplace lower overall total cost of data ownership with reduced or no ETL with data onboarding from on-prem or S3 storage ease of data management fast query times within snowflake a more efficient and secure way to share data across internal teams and external counterparties using snowflake data sharing capabilities and an effective dashboard to highlight the effectiveness of all the kpis this overview of incorporating ESG into an investment manager's portfolio construction rebalancing workflow is just a quick example of one of many different use cases that can be enabled by Snowflake and the financial services data cloud whether you're an asset management banking or Insurance snowflake Powers business critical workflows by enabling and streamlining data access collaboration and security and with near and limited scalability and multi-cluster compute different teams across different lines of business can run workloads across the front middle and back office without contention thank you for joining us today please subscribe to our Channel and follow us on LinkedIn and Twitter