Mission & needs

The mission of the buy-side data analyst is to collect a variety of data, organize them intelligently for ease of use, manipulate them to create augmented data and business insight, and make them easily accessible to other teams—portfolio managers, in particular.

Their first need is to be able to intelligently collect and organize large and extremely varied data in terms of:

checkbox
Their nature:

market prices, corporate accounting and consensus data, ESG indicators, macro or sectoral data

checkbox
Their coverage:

geographic and by asset class

checkbox
Their format:

the datasets can be structured or unstructured

checkbox
Their frequency,

which can go up to intraday

It is also essential that data be timestamped and that their date of availability be stored to prevent any look-ahead bias in backtests.

The typical use case is that of an ESG analyst who:

    1. (1) collects company responses to ESG questionnaires over time
    1. (2) uses ESG scores provided by third parties
    1. (3) wishes to enrich his/her analysis with unstructured data, e.g., global temperatures

All this information is then used to construct proprietary ESG scores for a large universe of companies.

What StarQube offers

  • checkbox
    A NoSQL database optimized for the management of huge volumes of data
  • checkbox
    The organization of data into a single repository
  • checkbox
    A simplified language for manipulating data, transforming it in order to develop augmented data (e.g., proprietary ESG scores)
  • checkbox
    Database connection to all external sources for real-time data updates
  • checkbox
    Timestamping of all data to avoid “look-ahead” bias in backtests and provide an audit trail
  • checkbox
    The ability to collect data directly from the internet through web scraping

Recommended package