## Jubilee Insurance

Project Overview: In 2024, I spearheaded a team of skilled data engineers at Jubilee Insurance, where we developed advanced data pipelines on Azure Synapse. This project aimed to streamline the data flow and drastically reduce operational costs, while also ensuring smooth integration across multiple systems.

### Project Goals

- Optimize data pipeline performance to reduce processing time and costs.
- Design a scalable, reusable ETL framework to improve data processing efficiency.
- Enhance the data warehouse by integrating multiple data sources from different countries.
- Ensure high availability and performance of reporting systems using Power BI.
- Maintain documentation for long-term scalability and future integration needs.

### Technologies Used

- Microsoft Azure: Utilized Azure Synapse for cloud data warehousing and analytics.
- Synapse Analytics: For building high-performance data pipelines and integrating data sources.
- Power BI: To deliver comprehensive, real-time reporting dashboards across multiple teams.
- ETL Framework: Designed a reusable framework to automate data extraction, transformation, and loading processes.

### Achievements & Impact

Through the successful implementation of these solutions, we achieved significant improvements:

- A 60% reduction in costs through optimized data processing pipelines.
- A more efficient and scalable data architecture that could handle the increasing volume of data.
- Improved reporting capabilities, providing real-time insights to teams across three countries: Kenya, Uganda, and Tanzania.

### Challenges & Solutions

During the course of the project, we encountered several challenges, such as managing large data volumes and ensuring seamless integration between disparate systems. To address these:

- We optimized our Synapse pipelines by using partitioning and incremental loads to handle large datasets.
- We developed custom solutions to address system downtime, ensuring minimal impact on reporting operations.
- We employed a robust ETL error-handling mechanism, reducing the number of operational disruptions.

### Project Results

This project not only saved costs but also ensured high data integrity and quality across the reporting ecosystem. It provided Jubilee Insurance with the ability to make data-driven decisions and enhanced collaboration between teams spread across multiple regions.