Financial cloud analytics platform for academic researchers
Challenge
A 1997 portal, no longer maintainable
SIRCA operated an on-premise data portal for its university clients focused on PhD-level capital markets research, offering downloads of Australian and New Zealand historical tick data, company announcements, and property data.
In production since 1997, the platform had become unmaintainable, and SIRCA wanted to expand its data offering and migrate to a modern cloud analytics solution.
Solution
A managed cloud analytics environment
RoZetta worked with SIRCA and Morningstar to expand the offering with new geographies and datasets, including company fundamentals, corporate actions, announcements, and expanded tick data.
The platform was deployed on a Databricks managed cloud environment on AWS, with normalization, conforming, and enrichment across the datasets.
What DataHex delivered
- Expanded data offering New geographies and datasets: company fundamentals, corporate actions, announcements and expanded tick data.
- Databricks managed cloud on AWS The platform migrated off an on-premise portal in production since 1997.
- Normalization, conforming and enrichment Applied consistently across the datasets.
Results
Seconds, not hours
- Significant data requests retrieved in seconds and minutes rather than hours
- No need to download data locally, with interactive code in the cloud
- A one-stop shop of more than 100 data assets across 15 years of history
- Highly scalable Spark compute
- A choice of R, Scala, Python, and SQL
- Strong security with full collaboration control
Languages supported
Related stories
More on data analytics
Talk to us
Ready to build your own data marketplace?
We will walk your team through what a launch looks like, from catalog and licensing to delivery and managed service.