Description
Discover how Novacomp transformed the analytical management of a Fintech company through the design and implementation of a high-performance data ecosystem. By integrating modern storage, transformation, and real-time visualization technologies, this solution enabled the consolidation of a reliable Data Warehouse to maximize loan portfolio performance and foster a data-driven organizational culture.
What will you discover in this document?
By reading this case study, you will learn:
- The challenge of data ingestion and governance: The need to extract and integrate information from Apache Fineract and transactional APIs, properly orchestrate the semantic transformation layer, and ensure data quality, documentation, and lineage.
- The technical approach and dimensional modeling: The deployment of an expert data architecture team to structure dimensional models in Snowflake and dbt, establishing business health KPIs and implementing Reverse ETL techniques to synchronize data with operational tools.
- The analytics platform tech stack: The combination of Snowflake as a Data Warehouse, dbt for transformations, Anomalo for data quality monitoring, Sigma Computing for visualization, Apache Pulsar, GitLab Runner, Amazon S3, MySQL, and Java APIs.
- The impact on decision-making results: The creation of near real-time interactive dashboards to optimize credit performance, increased organizational trust in data, the enablement of a self-service program for ad-hoc analysis, and the leverage of data for marketing campaigns and accounting reports.