Last month, the Kiski team was tasked with solving a challenge for a new client who initially provided data for one of their portfolios. Within a week, we delivered a suite of twelve detailed reports, covering various aspects of portfolio inspection. These covered performance details, detailed exposure, return contribution drill downs and more, impressing the client and leading them to request similar analyses for eighteen additional portfolios. This case study highlights Kiski’s ability to handle complex data needs in a time-sensitive and efficient manner.
The initial request was for reports on a small portfolio with limited data. Our rapid delivery of comprehensive reports demonstrated our capabilities and prompted the client to expand the scope significantly. They now wanted analyses for portfolios with over 5000 positions in total, encompassing various asset classes, including bonds, equities, options, ETFs, and warrants. This required us to handle significant data volume and handle acquiring and checking data from markets across the globe.
The success of the task hinged on efficiently finding, processing, and presenting the data. Our engineering team set up a new Snowflake data sink with a connection to the client’s own systems. This solution gave the client seamless access to data and analytics we provide, matching their data pipelines for transparency and availability. With the data groundwork in place, our analysts stepped up to find and gather data, as well as process it and look for any anomalies to ensure data precision.
Our team of quantitative analysts produced various analyses from this data. Detailed performance and exposure reports with drill downs and groups by markets, geography and industries, provide a magnifying glass to examine large number of portfolios. Return contribution analysis provided insight into drivers of performance and can show where a particular manager is strong. We also introduced an index look-through option for each month, showing overlap in exposures to individual companies due to owning index ETFs. While not directly requested, this proactive initiative provided crucial insights for large portfolios, demonstrating our commitment to adding value beyond the client's initial requirements.
This case study underscores our dedication and capability in managing complex data analytics projects. Our swift adaptation to client needs and proactive approach highlight our commitment to providing exceptional service. The successful handling of this project not only strengthened our relationship with the client but also showcased our potential to prospective clients seeking advanced investment technology solutions.
