D&B Integration for Underwriting: How InsightUW Auto-Resolves Industry Codes from Dun & Bradstreet
How InsightUW enriches every submission with firmographic data — DUNS number, industry classification, revenue, employee count, and risk score — by matching insured names against Dun & Bradstreet in real time.
The Problem
When a broker submits an application for "Solaris Energy Holdings," the underwriter gets a company name and maybe a mailing address. That is not enough to classify the risk. What industry is the company in? How large are they? How long have they been operating? What is their financial stability?
Today, underwriters manually look up companies in D&B Direct, copy DUNS numbers into spreadsheets, cross-reference SIC codes, and paste revenue figures into rating worksheets. This takes 10-15 minutes per submission and introduces transcription errors that cascade into incorrect classifications, wrong rate factors, and mispriced policies.
The problem compounds at scale. A team processing 200 submissions per week spends 50+ hours on manual D&B lookups alone — time that should be spent on risk analysis and decision-making.
The InsightUW Approach
InsightUW integrates directly with Dun & Bradstreet to auto-resolve company information at the moment of submission intake. When a submission arrives, the platform queries D&B by company name or DUNS number, retrieves firmographic data, and enriches the submission record before the underwriter even opens it.
Exact and Fuzzy Matching
InsightUW supports two matching strategies against D&B:
| Strategy | Method | When Used | Confidence |
|---|---|---|---|
| Exact Match | DUNS number lookup or exact company name | DUNS provided or name matches 100% | 98% |
| Fuzzy Match | Levenshtein distance with 70% threshold | Name has minor variations | 75-95% |
Fuzzy matching catches common variations: "Solaris Energy Holdings Inc." vs. "Solaris Energy Holdings," "ABC Corp" vs. "ABC Corporation," and abbreviations like "Intl" for "International." The 70% threshold prevents false positives while accommodating real-world naming inconsistencies.
D&B Data Fields Retrieved
Every successful D&B match returns a standardized enrichment payload:
| Field | Description | Example |
|---|---|---|
| duns number | 9-digit DUNS identifier | 03-445-6789 |
| industry description | D&B industry classification | Energy - Renewable/Solar |
| primary sic | 4-digit SIC code | 4911 |
| primary naics | 6-digit NAICS code | 221114 |
| annual sales | Latest reported revenue | $4,500,000,000 |
| employee count | Total employees | 8,500 |
| year started | Year of incorporation | 2008 |
| risk score | D&B Composite Risk Score (1-100) | 32 |
Demo vs. Production Architecture
InsightUW ships with 13 simulated D&B company records for demonstration and testing. These cover common LOBs and industry segments:
| # | Company | Industry | DUNS | Annual Sales |
|---|---|---|---|---|
| 1 | Solaris Energy Holdings | Energy - Renewable/Solar | 03-445-6789 | $4.5B |
| 2 | NovaPay Technologies | Financial Services - Payments | 04-556-7890 | $890M |
| 3 | Ironclad Construction | Construction - Heavy/Civil | 05-667-8901 | $2.1B |
| 4 | Bluefin Dining Group | Food Service - Restaurants | 06-778-9012 | $340M |
| 5 | CedarPoint Health Systems | Healthcare - Hospital Systems | 07-889-0123 | $6.2B |
In production, InsightUW connects to the D&B Direct+ API via OAuth 2.0 client credentials. The integration supports configurable rate limiting, response caching (24-hour TTL), and automatic retry with exponential backoff.
How D&B Data Enriches the Submission
The D&B enrichment occurs before rating, before appetite evaluation, and before the underwriter opens the submission. This means:
- Industry classification is pre-populated — the underwriter does not need to guess or look it up
- Revenue and employee count feed directly into exposure calculations
- D&B risk score provides an independent financial stability signal
- Year started flags startup risks (companies < 3 years old)
- DUNS number becomes the canonical company identifier for deduplication and portfolio tracking
D&O Submission: Solaris Energy Holdings
Lockton Risk Advisors submits a D&O application for "Solaris Energy Holdings" via email. Here is what happens:
| Step | Action | Result |
|---|---|---|
| 1 | Email parsed | Insured name: "Solaris Energy Holdings" |
| 2 | D&B exact match | DUNS: 03-445-6789, Match confidence: 98% |
| 3 | Firmographic data | Energy - Renewable/Solar, $4.5B sales, 8,500 employees |
| 4 | Risk score | D&B Composite: 32 (low risk) |
| 5 | Year started | 2008 — 18 years operating history |
| 6 | Classification triggered | NAICS 221114 sent to actuarial mapping pipeline |
What the underwriter sees: When Sarah Chen opens SUB-2026-DO-0042, the D&B panel is already populated. She sees the DUNS number, industry, revenue, employee count, and risk score without leaving the submission screen. The classification chain is already running.
What this prevents: Without D&B integration, Sarah would manually search D&B Direct, copy 8 fields into 3 different systems, and spend 12 minutes before she could even begin risk analysis.
What This Means for Underwriters
- Zero manual lookup — D&B data is resolved automatically at intake, eliminating 10-15 minutes of manual research per submission
- Consistent company identification — DUNS numbers prevent the same insured from being classified differently across submissions and underwriters
- Pre-populated firmographics — Revenue, employee count, and year started flow directly into rating and exposure models without re-keying
- Risk signal at first glance — The D&B Composite Risk Score gives underwriters an independent financial stability indicator before they read the application
- Production-ready architecture — The simulated D&B dataset proves the integration pattern; switching to D&B Direct+ in production requires only an API key configuration change
What's Next
With D&B data enriching the submission, the next step is mapping external industry codes (NAICS and SIC) to internal actuarial classes. Blog 37 covers the NAICS-to-Hazard-Group mapping chain that transforms a D&B industry code into a rate-ready actuarial classification.
InsightUW is an AI-powered underwriting workstation for P&C carriers. Request a demo to see D&B integration and auto-classification in action.