As part of a wider program to increase data asset transparency, a major US banking institution partnered with Keyrus to incorporate ESG and Climate Risk as part of its Investment Risk exposure analysis offering. Developing analysis and reports that would meet ESG compliance monitoring obligations faster than an in-house 12 month estimate.
This was a completely new initiative for the bank with strict, aggressive deadlines placed by the regulators. Challenges included consolidating data from multiple complexed sources such as Excel Spreadsheets, HR Operational Systems and internal APIs that included information on Market Values, County Codes, Asset Names and Tree Structures such as Assets and Liabilities.
Down to an initial manual approach by the bank using traditional BI processes for consolidation and reporting, the Bank required a new approach that could accelerate the process allowing them to meet their critical deadlines. Keyrus would support this project using Alteryx to consolidate and shape the data so that reports could show for instance: ● Countries per client ● Historical scenarios ● Assets & Liabilities per client ● Bespoke chart dimensions (incorporating different levels of client tree’s and multi page tables using Alteryx reporting tools. ● Climate Risk Metrics aligned to TCFD Framework ● ESG metrics aligned to the 3 pillars ● Overviews of top 10 and bottom 10 asset level exposures ● Automating this process for the future.
By consolidating the data assets and applying ESG specific logic, the application provided: ● Evidence of individual Portfolio ESG scores and exposures ● Supported ESG Regulatory requirements ● Insights into climate risks and opportunities including detailed emissions insights and forward looking scenario pathway analysis