The Insurance AI Operating System Stack: Building High-Performance Analytics on ClickHouse at Scale

Ujjwal Agarwal, Software Development Engineer and Avitash Purohit, Principal Software Engineer @ OutMarket.ai

This talk was delivered live at the ClickHouse Bangalore Meetup on 28 February at Awfis Bangalore by Ujjwal Agarwal, Software Development Engineer and Avitash Purohit, Principal Software Engineer @ OutMarket.ai

The full agenda can be found at https://www.meetup.com/clickhouse-bangalore-user-group/events/313325219/?eventOrigin=group_past_events

Talk Title: The Insurance AI Operating System Stack: Building High-Performance Analytics on ClickHouse at Scale

Talk Description: Outmarket is building the Insurance AI Operating System for US agencies and brokers, transforming time-consuming workflows into instant intelligence. We scaled from zero to 10 billion tokens and a million page ingestions weekly in just 9 months, now processing close to 100 million records daily through ClickHouse for analytics. This talk explores our architecture for handling extreme data volatility—including full dataset replacements at massive scale—while maintaining strict single-tenancy guarantees and sub-second query performance. Learn our battle-tested patterns for dedicated infrastructure per client, pipelines that handle complete dataset rebuilds without downtime, and query optimization for instant insights on constantly evolving data. Essential for architects building B2B SaaS platforms where isolation and performance are both non-negotiable.