Zurich needed to navigate policies across regions with individualized premiums, claims, exposures, and differentiated reporting requirements. This meant that data accuracy was critical. Getting it wrong could result in compliance breaches, exposure of confidential information and reputational damage.
- 01
The challenge
Zurick aimed to address report ingestion challenges and had evaluated the best options for a scalable solution to meet their complex bordereaux requirements. Challenges including addressing file complexities, ensuring regulatory compliance and providing flexibility, scalability and observability across operations.
The solution needed to:
- Close gaps in financial visibility and management.
- Connect data sources, formats and tools to improve efficiency and consistency.
- Remove manual interventions to reduce costs, delays and financial discrepancies.
- Increase confidence in data integrity and compliance monitoring.
- 02
The approach
Kubrick implemented a solution with flexibility, scalability and advanced observability.
- Provided a Streamlit user-friendly interface: Allows business users to configure validation and transformation rules, upload files, and easily manage ingestion logic. This minimized reliance on IT teams for day-to-day operations.
- Built metadata-driven Snowflake pipelines: Using Snowpark, we employed a fully metadata-driven pipeline to process, transform, and load data according to predefined rules. This architecture allowed for seamless adjustments to ingestion logic as data standards evolved.
- Integrated monitoring and auditing: We implemented comprehensive logging and traceability using Snowflake Event Tables, enabling end-to-end monitoring of ingestion progress, error handling, and data transformation activities. An intuitive Streamlit UI was provided to track file progress and review logs for quick issue resolution.
- Minimized error handling and resilience: Erroneous records were captured in a rejected records table for easy review and reprocessing. The solution’s dynamic schema handling allowed it to adapt to new or altered data structures without requiring extensive rework.
- Provided Streamlit-based file upload UI: An additional tactical interface for manual file uploads, ensuring flexibility and continuity even during process exceptions.
- Ensured robust testing and CI/CD: Delivered with unit tests and a CI/CD pipeline, enabling continuous integration, automated testing, and rapid deployment.
- 03
The impact
In just three weeks, our solution provided a scalable ingestion platform that met all core requirements with the flexibility to handle diverse bordereaux schemes across the business.
The standardized ingestion process delivered:
- improved financial oversight and compliance,
- accurate and timely reporting
- reduced manual effort, operational overheads and manual interventions through automated rule-based processing and real-time monitoring
- faster turnaround times, and
- enhanced productivity.
The client noted that the solution met their needs more closely than any SaaS products they had considered.
Turn proven outcomes into business impact
Explore how this solution could be adapted to your organisation to drive performance, resilience, and growth.
