Data Engineering and Business Intelligence
A Python-based ETL pipeline replacing manual carrier data processing across more than 25 sources.
Client
A mid-sized Excess and Surplus Lines insurer
Lines
Commercial auto
What We Solved
Submission intake and underwriting workflow
ENGAGEMENT
Custom build
Being easy for brokers to work with was central to how this company won business. It leveraged a broad appetite and a willingness to write high-risk policies to hold strong market share, and brokers rewarded that flexibility with volume.
The volume arrived by email. Most quote submissions came as attachments in whatever format the broker happened to use, frequently including handwritten elements. Each one had to be read, interpreted, and keyed into the underwriting system by hand. The result was slow turnaround, inconsistent data quality, and a large share of the underwriting team’s time spent on data entry rather than on risk.
An end-to-end automated intake pipeline. Optical Character Recognition and a custom AI model parse the emailed attachments, then extract, validate, and inject structured data into the company’s proprietary underwriting system, where submissions can be scored and prioritized for review by the underwriting team.
reduction in manual data entry
straight-through processing rate within the first 90 days, up from zero
average field-level accuracy, and 85% on handwritten content
faster initial underwriting review
The change wasn’t only speed. Because submissions arrive structured and scored, underwriters see the risks worth their attention first rather than working through the queue in the order it happened to arrive. Data quality improved as a side effect of automation rather than as a separate initiative.
Submission intake is the most common first project we take on for organizations placing high volumes of business through brokers. The details differ, wholesalers, MGAs, and E&S carriers each have their own version, but the pattern is nearly always the same: submissions arriving in formats nobody controls, and people absorbing the difference.
Twenty minutes, a candid conversation. If we’re not the right fit, we’ll say so.