A readout to a client's leadership team
Case study

BlackRock went from 50 to 1,000+ automated external data sources

Analysts spent 30 to 40% of their time collecting filings, news and company data by hand, and still covered only 50 sources.

BlackRock

BlackRock · Deal teams · L2

20xmore external data sources covered for research teams

The workflow before

Research analysts and portfolio teams gathered external data themselves: regulatory filings, company investor relations pages, news and alternative data. Collection was manual, so coverage stopped at about 50 sources and reached roughly 20% of what teams needed. Analysts spent 30 to 40% of their week gathering and cleaning data instead of analyzing it, and information arrived daily or weekly rather than when it was published.

What we built

We built an automated collection system on AWS that crawls more than 1,000 sources: SEC EDGAR and international filings, company sites, news and alternative data. Scrapy handles standard pages, Selenium renders JavaScript-heavy sites, and API clients pull from providers that offer them. Everything streams through Kafka.

NLP models extract companies, people, transactions and events from each document, classify it and score its relevance. Entity resolution matches every mention to BlackRock's security master by ISIN, CUSIP and ticker, with low-confidence matches sent to a human reviewer.

Clean data lands in an S3 data lake and Snowflake, where analysts, data scientists and the Aladdin team query it. Change detection spots when a source site changes structure, so crawlers are fixed before data goes missing.

Before and after

MeasureBeforeAfter
Sources covered50, collected by hand1,000+, automated
Analyst time on data collection30 to 40%Under 5%
Coverage of needed sourcesAbout 20%95%
Data freshnessDaily or weeklyNear real time

What's next

With 1,000+ sources resolved to the security master, the next step is L3: agents that monitor holdings for material events, draft the summary, and route only the items that need an analyst's judgment.

ShareLinkedInEmail

Scrapy spiders and headless Selenium run on EC2 and EKS (Kubernetes), with rate limiting, retries with exponential backoff and source change detection. Raw content is published to Kafka topics split by source type (regulatory, company, news, alternative), which allows replay and independent consumers.

Consumers run PDF, HTML and table parsing, OCR for embedded text, and NLP (spaCy and deep learning language models) for named entity recognition, event detection and classification. Entity resolution with fuzzy matching links records to the security master and keeps a confidence score per match, with a human review queue for low scores.

Data moves through bronze, silver and gold layers in S3 and into Snowflake for analytics. CloudWatch tracks freshness, completeness, success rate by source and processing latency, with alerts on source failures and quality anomalies.

Next step

Let's build the case study we tell next.