EP 11: Growing Technology Footprints in Insurance Sector

Summary

This Data Science With Sam episode has Sam interview Nick Blamer of Coherent about Insurance Technology Modernization, Excel-based workflows, cloud infrastructure, APIs, and generative AI in insurance. The episode’s main argument is that insurance technology repeatedly moves computation closer to business users: mainframes gave way to desktop tools, cloud made workloads faster and more scalable, and business-logic APIs can now make spreadsheet calculations reusable, auditable, and production-ready. It extends the wiki’s actuarial and insurance AI branch by tying Spreadsheet to API Governance, Insurance Technical Literacy, Insurance Model Regulatory Constraint, and AI Model Bias Governance to practical work by actuaries, underwriters, risk managers, and IT teams.

Key Claims

• Nick Blamer describes a long shift in insurance technology from mainframe processes that could take weeks, to desktop calculations that could run in hours, to cloud systems that improve speed, cost, and scalability.
• The episode frames the current wave as wider use of APIs, but emphasizes that APIs still require people, tools, and governance to turn business logic into reliable interfaces.
• Coherent Spark is described as taking an Excel spreadsheet, identifying inputs and outputs, and generating version-controlled, auditable APIs that can run faster and scale in the cloud.
• The speakers treat Excel as a persistent insurance work surface rather than a legacy tool to discard. In this framing, Spreadsheet to API Governance upgrades familiar business logic instead of forcing every user into a new platform.
• Business units can own logic while IT connects the API plumbing and promotion path into production, creating a division of labor close to Actuary Data Scientist Partnership.
• APIs are presented as reusable blocks for valuation, projections, underwriting, sales, and other repeated insurance calculations.
• The episode recommends Insurance Technical Literacy for actuaries, underwriters, and risk managers, especially comfort with R, Python, SQL, and basic programming concepts even when low-code or no-code tools are available.
• Generative AI is treated as already embedded in everyday software and useful for chatbots, reports, formulas, BI exploration, and productivity support, but not as a reason to skip legal, statistical, or operational controls.
• The speakers warn that AI-generated risk scoring can violate insurance law or fairness requirements when prohibited factors, such as gender in California P&C rates, are reintroduced through proxy variables.
• The episode’s AI section reinforces AI Governance And Compliance: insurance firms need privacy, security, compliance, model-bias review, and human judgment before using AI in production decisions.

Key Quotes

“world’s largest development platform” - Nick’s description of Excel as a business-user technology base.

“Lego blocks” - Nick’s analogy for reusable APIs.

“correlation does not necessarily mean causation” - Nick’s warning about AI pattern discovery.

Connections

• Data Science With Sam, Sam (Data Science With Sam), Nick Blamer, Coherent, and Coherent Spark - show, host, guest, company, and product context.
• Insurance Technology Modernization, Spreadsheet to API Governance, Business Logic APIs, Microsoft Excel, and API Product Design - enterprise technology and API branch.
• Actuarial Science, Actuary Data Scientist Partnership, Actuarial Self-Study Career Path, Insurance Technical Literacy, and Society of Actuaries - actuarial workforce and professional-development context.
• Insurance Model Regulatory Constraint, AI Model Bias Governance, AI Governance And Compliance, Human Judgment Under AI, and Actuarial AI Augmentation - AI governance, bias, validation, and professional judgment branch.

Contradictions

• No direct contradiction found.
• The source extends Data, Risk, and Actuarial Science in Insurance and EP 10: A thought-provoking chat with an actuary and TEDx speaker: those episodes emphasize actuarial data quality, regulatory model constraints, workforce formation, and AI augmentation, while EP11 adds the infrastructure layer around Excel, cloud, APIs, and governed business logic reuse.