Case Study

Data Infrastructure for Financial Account, Asset and Performance Reports

“(Insert customer quote here)”

A hand drawing of computer code, data pipelines and graphs and charts.

Customer Intro

StratorSoft’s customer is a full service fund administrator within the financial services space.

Customer Needs

The customer's Client Services and Fund Accounting groups needed to package and distribute account, asset and performance data reports for fund managers. The required report data was coming from multiple third party financial services organizations. They needed help building data pipelines that would aggregate and transform the data and store it in a data warehouse where it was prepared for reporting.

Solution

StratorSoft worked with multiple API endpoints coming from multiple hedge fund accounting systems to create ETL pipelines. Each pipeline was custom built using Python and would extract the relevant data from the respective accounting system, transform the data and load the data into an existing data warehouse. Stratorsoft also updated a legacy report packaging system to use a modern data stack and data lifecycle architecture. The modern stack employs a data pipeline to a data warehouse with PowerBI integration for data consumption.

Outcome

The customer now uses a modern data stack for ETL pipelines and product/packaging and distribution.

Let's work together
Our team is ready to answer your questions and guide you through the best technical solutions.
Contact Us