Integrated Data Architecture — Commercial Property Underwriting
Consolidated data pipeline from disparate sources into Snowflake with structured & unstructured data classification, feeding Single Version of Truth
Data Sources
Broker Submission
ACORD / Email / Portal
Federato PolicyCenter
Policy Management System
Guidewire ClaimCenter
Claims Management
Loss Control System
Inspection Platform / Zywave
Verisk (ISO / Prometrix)
Risk & Analytics API
Moody's RMS
Climate & Catastrophe API
CoreLogic
Hazard Risk Models & Scores
HazardHub (Guidewire)
Property Hazard Data API
JBA Risk (Flood)
Flood Data & Models
Geospatial Analytics
CAPE / Zesty / Nearmap / EagleView / Vexcel
Risk Engineering
Inspection Reports / SharePoint
Snowflake
Cloud Data Platform
📦 STRUCTURED DATA SCHEMAS
12 schemas · 84 tables
Broker SUBMISSION_RAW
Broker SOV_LOCATIONS
Broker LOSS_RUN_HISTORY
Federato POLICY_MASTER
Federato POLICY_COVERAGE
Federato POLICY_ENDORSEMENTS
Guidewire CLAIMS_HEADER
Guidewire CLAIMS_RESERVES
Verisk VERISK_ISO_SCORES
Verisk VERISK_360VALUE
Moody's MOODYS_CLIMATE_SCORES
CoreLogic CORELOGIC_HAZARD
HazardHub HAZARDHUB_PROPERTY
JBA JBA_FLOOD_ZONES
JBA JBA_FLOOD_DEPTH
LossCtrl LOSS_CONTROL_INSPECTIONS
Geospatial GEO_PROPERTY_ATTRIBUTES
Geospatial GEO_ROOF_CONDITION
🗂️ UNSTRUCTURED DATA STAGE
6 stages · ~2.4TB
Broker SUBMISSION_DOCS
Broker SOV_SPREADSHEETS
RiskEng INSPECTION_REPORTS
RiskEng INSPECTION_PHOTOS
Geospatial AERIAL_IMAGERY
Geospatial SATELLITE_TILES
Guidewire CLAIMS_ATTACHMENTS
Broker LOSS_RUN_PDFS
RiskEng ENGINEERING_REPORTS
⚡ REAL-TIME PROCESSING
Snowpipe: ● Active
Streams: 14
Tasks: 28
Cortex AI: ● Enabled
Single Version of Truth
Cleansed · Normalized · Taxonomy-aligned
📍 Location & Property
CP.LOC.GEO.001
Location Geocode
CoreLogic · HazardHub
CP.LOC.ADDR.001
Standardized Address
Broker · Verisk
CP.PROP.CONST.001
Construction Class (ISO)
Verisk · Broker
CP.PROP.YR.001
Year Built / Renovated
CoreLogic · Broker
CP.PROP.SQFT.001
Square Footage
EagleView · Broker
💰 Valuation
CP.VAL.TIV.001
Total Insured Value (TIV)
Broker · Verisk 360Value
CP.VAL.RC.001
Replacement Cost
Verisk 360Value · Moody's
⚠️ Hazard & Catastrophe
CP.HAZ.FLOOD.001
Flood Zone / Depth
JBA Risk · CoreLogic
CP.HAZ.WIND.001
Wind / Hurricane Score
Moody's RMS · CoreLogic
CP.HAZ.EQ.001
Earthquake PML
Moody's RMS · CoreLogic
CP.HAZ.FIRE.001
Wildfire Risk Score
HazardHub · CoreLogic
📜 Policy & Claims
CP.POL.EXP.001
Policy Expiry / Renewal
Federato PolicyCenter
CP.CLM.LKR.001
Loss-to-Kearned Ratio
Guidewire ClaimCenter
CP.CLM.FREQ.001
Claim Frequency 5-Yr
Guidewire · Loss Runs
🛰️ Geospatial Intelligence
CP.GEO.ROOF.001
Roof Condition Score
CAPE / Zesty / Nearmap
CP.GEO.PERI.001
Property Perimeter Change
EagleView · Vexcel/GIC
CP.GEO.VEG.001
Vegetation / NDVI Proximity
Nearmap · Betterview
Audit Trail
AI Insights
Taxonomy
Select a Risk
🏢
Select a risk from the portfolio to begin actuarial modelling
💡
Next Best Actions & Recommendations will appear here