Data infrastructure modernisation — automated ETL, Apache Iceberg, and unified QuickSight analytics.
Manual data processing eliminated, unified analytics platform delivered, serverless pay-as-you-go model adopted.
Challenge
Yellow Africa is a leading provider of digital financial services in Sub-Saharan Africa, specialising in offering financial solutions to underbanked populations. With a focus on innovation, the company relies heavily on data to drive strategic decisions and improve service delivery.
Yellow Africa sought to modernise its data infrastructure to enhance its ability to collect, process, and analyse data from Zoho, ensuring real-time insights and improved operational efficiency. As the business scaled, manual data processing and fragmented analytics tools were creating bottlenecks for financial reporting and data-driven decision-making.
Solution
CloudZA partnered with Yellow Africa to design and implement a modernised, automated ETL pipeline to streamline data collection, processing, and analysis. Leveraging AWS services, the solution integrated Zoho's API with a scalable and serverless architecture, ensuring seamless data ingestion and transformation.
AWS Lambda was utilised to automate API data retrieval from Zoho, eliminating manual processes and ensuring timely data updates. Amazon S3 was implemented for cost-effective, scalable data storage. AWS Glue provided data cataloguing and transformation capabilities, improving data discoverability and governance. Apache Iceberg tables enhanced data lake functionality, supporting efficient querying and large-scale analytics. Amazon EventBridge automated ETL scheduling, Amazon QuickSight served as the BI layer, and Amazon Athena enabled ad-hoc SQL queries directly against the S3 data lake.
Result
The automated ETL pipeline significantly improved Yellow Africa's data operations by eliminating manual data processing tasks and streamlining reporting workflows — integrating analytics from different sources into a single platform in QuickSight. The serverless architecture reduced infrastructure costs through its pay-as-you-go model, while scheduled data updates enabled more timely insights for decision-making.
The modernised data infrastructure enabled Yellow Africa to make data-driven decisions more effectively, leading to improved customer service and operational efficiency across their financial services operations.