Unlocking a 40× Increase in Underwriting Coverage Through Automated Renewal Analysis
A global insurance broker transformed its underwriting renewal process by automating the ingestion, standardization, and analysis of carrier data across thousands of clients. By replacing a manual, resource-intensive workflow with an Alteryx-based automation, the underwriting team moved from covering just 2.5% of their client programs each quarter to analysing their entire client base with greater accuracy and consistency.
The Challenge
The underwriting team faced a fundamental capacity constraint.
Each year, they needed to brief thousands of client programs on their underwriting position ahead of renewals. However, claims data arrived from six major carriers in entirely different formats, mixing spreadsheets, PDFs, and inconsistent schemas, requiring extensive manual effort to reconcile.
The existing process was slow, resource-intensive, and not designed for scale. Producing a single renewal analysis deck required a team of three analysts working over several days. As a result, output was constrained to ~50 renewal analysis decks per quarter, forcing the team to prioritize only their largest client programs and leaving much of the portfolio without consistent analytical coverage.
Beyond scale, the process introduced risk. Inconsistent calculations and overly simplified financial assumptions reduced confidence in the analysis's accuracy. Identifying data gaps or anomalous claims often happened late in the process, forcing our client to rely on estimates under time pressure.
Our Approach
We designed and delivered an end-to-end automation solution built on Alteryx, structured to separate complex data engineering from analyst-friendly execution.
Standardizing carrier data at the source
We built modular ingestion workflows to handle each carrier’s unique data format, automatically discovering files, extracting data (including PDF scraping where required), and mapping it to a common, standardized data model. Automated quality checks flagged missing data, anomalies, and delivery issues early — before analysis began.
Encoding underwriting intelligence into repeatable logic
The core underwriting calculations were fully automated, including loss ratios across multiple coverage types, experience-period alignment, reserve treatment with time-value-of-money considerations, and consistent application of multiple premium-rate methodologies. Built-in controls identified shock claims and outliers, while integrated benchmarking contextualized results against industry norms.
Scaling insight delivery, not just analysis
We implemented a user-facing application that allowed analysts to select client programs and run analyses on demand. The Alteryx solution automatically generated client-ready PowerPoint decks, populating templated presentations at scale — transforming what had been days of manual effort into a repeatable, minutes-long process.
Designed for adoption and longevity
The engagement followed an iterative delivery model with close collaboration from underwriting leadership and analysts. The workflows were modular, documented, and structured for long-term ownership, enabling new carriers and programs to be added without re-engineering the solution.
Results
The end-to-end underwriting process — from carrier file ingestion through to client-ready PowerPoint output — was fully automated. What previously required 3–6 person-days per renewal analysis deck, with multiple analysts working over a week, now takes minutes. This reduction in runtime eliminated the primary operational bottleneck, allowing the underwriting team to shift focus from data preparation to review, judgment, and client engagement.
.png)
By removing the runtime constraint, the underwriting team increased production from approximately 50 renewal analysis decks per quarter to processing 2,000+ client program combinations across their portfolio. This represents a shift from covering roughly 2.5% of client programs to having the capacity to support the entire portfolio, fundamentally changing how renewal analysis is delivered and prioritized.
Automation enabled the consistent application of complex underwriting logic across thousands of client programs. Rate calculations, experience-period alignment, reserve treatment using the time value of money, and shock-claim detection are now executed uniformly, reducing analyst-to-analyst variability and improving confidence in renewal positions. What was previously dependent on individual judgment and manual spreadsheets is now repeatable, auditable, and scalable.
Automated quality checks now surface missing data, anomalies, and carrier delivery issues before analysis begins, rather than being discovered late in the renewal cycle. This early visibility reduces downstream rework, limits reliance on estimates, and enables underwriting teams to proactively address data issues, improving both the speed and quality of renewal discussions.
Key Takeaways
By replacing a manual, fragmented renewal analysis process with an end-to-end automated solution in Alteryx, the underwriting team removed a structural capacity constraint that had limited coverage to just 2.5% of the portfolio each quarter. Reducing runtime from multiple person-days to minutes unlocked a 40× increase in capacity, enabling scalable, consistent analysis across 2,000+ client programs.
Beyond efficiency, the solution strengthened financial precision and governance. Complex underwriting logic is now applied uniformly and auditable at scale, while automated data quality controls surface issues earlier in the renewal cycle.
By unifying six disparate carrier datasources into a single framework, the organization also established a reusable underwriting data foundation, enabling portfolio trending, carrier benchmarking, and broader actuarial insight that wasn’t previously achievable.
Let's talk AI & data. We'll architect what's next.
Whether you need advanced AI solutions, strategic data expertise, or tailored insights, our team is here to help.