Sigma Computing Consulting for Insurance Companies and Agencies
Give underwriting and finance back the days spent building the monthly loss ratio pack. We build Sigma workbooks on Snowflake that refresh on their own and still feel like a spreadsheet.
The short answer
Where the Hours Go Today
- The monthly loss ratio pack takes days of copying policy and claims exports between workbooks.
- Written, earned and in-force premium each come from a different report.
- Producer and agency commission reports are built by hand for each partner.
- Claims development triangles live in a spreadsheet only one actuary maintains.
Sigma Workbooks We Build
- Premium and Policy Count
- Written, earned and in-force premium by line, state, product and month, read from dated tables so any past month can be reopened.
- Loss Ratio and Claims
- Paid, reserved and incurred losses next to earned premium, with drill paths from the line of business down to the claim.
- Producer and Agency Performance
- Premium, retention and loss ratio by producer or agency, with each partner able to see only their own book.
- Carrier and Board Reporting
- Monthly bordereaux, carrier reports and board packs built from the same tables as the daily views, sent on a schedule.
Why Sigma Fits
- Actuaries and analysts live in Excel
- Sigma works as a spreadsheet grid with over 200 functions on live warehouse data, so analysts can rebuild their models on governed tables without learning SQL.
- Each partner sees only their book
- Row-level security by user, team or user attribute means one workbook can serve every producer or agency, including through secure embeds.
- Reports that send themselves
- Scheduled exports send PDFs or files by email, Slack, Teams or cloud storage, so carrier and partner reports stop being built by hand.
Data We Connect
- Policy administration system
- Claims system
- Billing system
- Agency management system
- Rating engine
- General ledger
- Snowflake
Common questions
Is Sigma good for insurance reporting?
Sigma fits insurers, MGAs and agencies whose analysts work in spreadsheets and whose policy and claims data are in, or moving to, a cloud warehouse such as Snowflake.
Can Sigma show loss ratio by line of business?
Yes, once earned premium and incurred losses are loaded at matching dates and levels of detail. We agree the earned premium and incurred loss rules with your team before building the view.
Can Sigma build claims triangles?
Yes. With claims history stored by valuation date in Snowflake, a Sigma pivot table can show development by accident period and age, and analysts can still add their own calculations.
Can agencies or producers log in to see their own numbers?
Yes. Row-level security limits each user to their own book, and Sigma secure embeds can show the same workbook inside a partner portal.
How long does a Sigma build take?
It depends on your policy and claims systems, how much history you need and how clean it is. We scope it on a short call, starting with one report.
Bring the report that eats your week
We'll look at it with you and say what Sigma would save. No pitch deck.