2 min read
Deploying advanced engineering to drive process improvement
Fred McDonnell 24 August, 2023
In the fast-paced world of financial services, timely and reliable data can make all the difference in gaining a competitive edge on investment opportunities.
Executive summary
An asset management firm used automation to accelerate the validation and sharing of data used in investment decision making.
QuantSpark defined an engineering solution that decreased the end to end processing time by 70%, whilst shortening technical runs to a matter of minutes.
Working with a leading asset management firm, QuantSpark was able to optimise the collection & validation of data from a key 3rd party provider, reducing the end-to-end processing time from 5 days to 1.5 days, a 70% reduction in time.
The challenge: A data bottleneck
The asset management firm had relied on manual processes to collect, clean, and validate data from a prominent fast-moving consumer goods (FMCG) market intelligence provider.
This information was used to provide a snapshot of the market with key insights on consumer spending from credit card purchase data. However the data would typically reach portfolio managers several days after its release. Where managers rely on hundreds of data points to make quantitative assessments of their position, having ready access what they need, when they need it, can make a real difference.
The solution: A data engineering transformation
To solve this problem, QuantSpark approached the project in three key steps, each designed to exhaustively cover the nuances of the complex data process flows involved.
-
Data audit - Laying the foundation for efficiency
The first step was a comprehensive analysis of the existing data processes, built using a no-code data management tool. By thoroughly examining the workflows, the team identified areas where optimisation was necessary. This laid the groundwork for creating more efficient data flows. -
Data engineering - Leveraging the power of automation
At the heart of the solution was advanced data engineering, seamlessly combining Python, AWS cloud infrastructure and automated pipelines. These pipelines allowed for the direct integration of data from the data providers to interactive dashboards, whilst implementing the solution within the clients' cloud infrastructure to meet their security requirements. -
Quality assurance and optimisation - Providing reliability and confidence
Given the nature of the investment decisions, it was imperative that there is absolute reliability and assurance in the numbers. The team recognised and implemented a set of rigorous quality checks using Great Expectations, with automated alerts where source data does not been the expected thresholds.
The impact: Powering towards success
-
Faster data processing with rapid time enhancements
Within the end to end process, the technical run itself was cut down from a few hours to under 30 minutes, providing a secondary benefit to engineering teams. -
Productivity gains through efficient data validation
By streamlining the data validation process valuable resources could be redirected towards more strategic endeavours, delivering against the bottom line. -
Accelerated decision-making
The value in improving data pipelines always lies with the decisions that can be made faster as a result. Making incremental improvements to how quickly portfolio managers can access useful data will assist them to make smart decisions quickly.
Embrace the automated future of financial services
In the realm of financial services, data is the cornerstone of success.
By leveraging the power of data engineering, this leading asset management firm optimised their data processes and driving efficiency.
Through modern data engineering solutions providing faster data, clear efficiency gains, and accelerated decision-making, automation has become the new normal. Contact QuantSpark today to learn how your firm can use technology and engineering to make better decisions, faster.
Get in touch
Are you looking for a team with deep expertise in advanced analytics and modelling techniques to drive value in your business? We can support you.
Posts by Tag
- CASE STUDY (18)
- RETAIL (10)
- PRIVATE EQUITY (7)
- SAAS (7)
- FINANCIAL SERVICES (6)
- DATA ENGINEERING (4)
- ANALYTICS ROADMAP (3)
- AUTOMATION (3)
- LLMS (3)
- STRATEGY (3)
- ANALYTICS SUITE (2)
- ASSET MANAGEMENT (2)
- BI (2)
- CLIENT RETENTION (2)
- DATA PIPELINE (2)
- EMAIL OPTIMISATION (2)
- GROCERY (2)
- MARKETING (2)
- PREDICTIVE CHURN (2)
- BUSINESS INTELLIGENCE (1)
- BUSINESS PERFORMANCE (1)
- CHURN (1)
- CLTV (1)
- CPA (1)
- CUSTOMER CONVERSION (1)
- CUSTOMER SEGMENTATION (1)
- DATA CUBES (1)
- DATAFLOW (1)
- DIAGNOSTIC (1)
- EXCEL AUTOMATION (1)
- FORECASTING (1)
- HR (1)
- LEAD SCORING (1)
- LOCATION INTELLIGENCE (1)
- PROFESSIONAL SERVICES (1)
- RECURRING REVENUE ANALYTICS (1)
- REVENUE RECOGNITION (1)
- SUPPLY CHAIN (1)
- TALENT (1)