bluedoor data·H-1B Jobs API·bluedoor.sh ->

Home / Companies / Constellation Insurance, Inc.

Constellation Insurance, Inc. H-1B company data

Employer profile assembled from DOL OFLC LCA rows and USCIS H-1B Employer Data Hub petition summaries. Rows below include aliases, source IDs, filing coverage, petition counts, role coverage, worksite coverage, and wage summary fields when present.

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
Constellation Insurance, Inc.
Constellation Insurance, CONSTELLATION INSURANCE INC
1175FY2023 to FY2026
Latest decision 2025-11-21
1AVP, Annuity Valuation AXIS Modeler
4 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings11
Certified LCAs11
Denied LCAs0
Role titles7
Worksites5
Latest decision2025-11-21
USCIS approvals1
USCIS denials0

Aliases and source names

AliasesSource NamesSources
Constellation Insurance, CONSTELLATION INSURANCE INCConstellation Insurance, Inc., CONSTELLATION INSURANCE INCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
AVP, Annuity Valuation AXIS Modeler15-2011.00
Actuaries
4$180,000$180,000
Software Engineer III15-1252.00
Software Developers
2$126,800$142,140
Quantitative Analyst13-2099.01
Financial Quantitative Analysts
1$81,000$81,000
Quantitative Investment Analyst13-2099.01
Financial Quantitative Analysts
1$135,000$135,000
Software Engineer II15-1252.00
Software Developers
1$90,000$90,000
Software Engineer IV15-1252.00
Software Developers
1$142,140$142,140
Software Engineer V15-1252.00
Software Developers
1$115,678$115,678

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
CincinnatiOH452425490,000142,1402,0232,026
BaltimoreMD2121021180,000180,0002,0242,025
CaryNC2751921180,000180,0002,0252,025
New YorkNY1001911135,000135,0002,0252,025
MontgomeryOH452421181,00081,0002,0232,023

Full company payload

Company IDcompany:constellation insurance
NameConstellation Insurance, Inc.
Normalized Nameconstellation insurance
Source Company Idscompany_dol_oflc_lca_constellation_insurance_inc, company_uscis_h1b_datahub_constellation_insurance_inc_tax_4097
Source NamesConstellation Insurance, Inc., CONSTELLATION INSURANCE INC
AliasesConstellation Insurance, CONSTELLATION INSURANCE INC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Constellation Insurance, Inc.",
    "CONSTELLATION INSURANCE INC"
  ],
  "dba_names": [
    "Constellation Insurance"
  ],
  "name_variants": [
    {
      "value": "Constellation Insurance, Inc.",
      "filing_count": 8,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Constellation Insurance",
      "filing_count": 3,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CONSTELLATION INSURANCE INC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "4097",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 11,
  "case_count": 11,
  "role_title_count": 7,
  "worksite_count": 5,
  "total_workers": 11,
  "first_fiscal_year": 2023,
  "first_received_date": "2023-01-26",
  "latest_fiscal_year": 2026,
  "latest_decision_date": "2025-11-21",
  "certified_count": 11,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 10,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified - Withdrawn",
      "filing_count": 1,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 9,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "H-1B1 Singapore",
      "filing_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 11,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 1,
  "total_denial": 0,
  "fiscal_years": [
    "2023"
  ],
  "year_metrics": [
    {
      "cities": [
        "Cincinnati"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2023,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "45242"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_constellation_insurance_inc_tax_4097_2023",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2023_row_007063"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "address_line_1": "1 Financial Way",
      "raw_address": "1 Financial Way  CINCINNATI OH 45242",
      "city": "Cincinnati",
      "state": "OH",
      "postal_code": "45242",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2025-11-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "CINCINNATI OH 45242",
      "city": "Cincinnati",
      "state": "OH",
      "postal_code": "45242",
      "filing_count": 8,
      "case_count": 8,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-09-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "MONTGOMERY OH 45242-5800",
      "city": "Montgomery",
      "state": "OH",
      "postal_code": "45242-5800",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-05-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "address_line_1": "1 Financial Way",
      "raw_address": "1 Financial Way  CINCINNATI OH 45242",
      "city": "Cincinnati",
      "state": "OH",
      "postal_code": "45242",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2025-11-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CARY NC 27519",
      "city": "Cary",
      "state": "NC",
      "postal_code": "27519",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-09-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BALTIMORE MD 21210",
      "city": "Baltimore",
      "county": "Baltimore City",
      "state": "MD",
      "postal_code": "21210",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-04-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10019",
      "city": "New York",
      "county": "New York",
      "state": "NY",
      "postal_code": "10019",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-05-15",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CINCINNATI OH 45242",
      "city": "Cincinnati",
      "county": "Hamilton",
      "state": "OH",
      "postal_code": "45242",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-02-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "MONTGOMERY OH 45242",
      "city": "Montgomery",
      "county": "Hamilton",
      "state": "OH",
      "postal_code": "45242",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-05-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 3,
    "worksite_address_count": 6,
    "has_street_address_evidence": true,
    "caveat": "LCA employer/worksite addresses are capped filing evidence scoped to matched source company names and should not be treated as verified headquarters without external validation."
  }
}
Geography
{
  "states": [
    "OH",
    "MD",
    "NC",
    "NY"
  ],
  "cities": [
    "Cincinnati",
    "Baltimore",
    "Cary",
    "New York",
    "Montgomery"
  ],
  "postal_codes": [
    "45242",
    "21210",
    "27519",
    "10019"
  ],
  "top_markets": [
    {
      "city": "Cincinnati",
      "state": "OH",
      "postal_code": "45242",
      "lca_count": 5,
      "role_title_count": 4,
      "wage_low_min": 90000,
      "wage_high_max": 142140,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2026
    },
    {
      "city": "Baltimore",
      "state": "MD",
      "postal_code": "21210",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 180000,
      "wage_high_max": 180000,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2025
    },
    {
      "city": "Cary",
      "state": "NC",
      "postal_code": "27519",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 180000,
      "wage_high_max": 180000,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025
    },
    {
      "city": "New York",
      "state": "NY",
      "postal_code": "10019",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 135000,
      "wage_high_max": 135000,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025
    },
    {
      "city": "Montgomery",
      "state": "OH",
      "postal_code": "45242",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 81000,
      "wage_high_max": 81000,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023
    }
  ]
}
Industry
{
  "naics_codes": [
    "524113",
    "52"
  ],
  "naics_breakdown": [
    {
      "value": "524113",
      "filing_count": 11,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 81000,
  "annualized_high_max": 180000,
  "annualized_low_avg": 141159.818181818
}
Trend
[
  {
    "fiscal_year": 2023,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 126800,
    "wage_high_max": 126800,
    "wage_low_avg": 126800
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 81000,
    "wage_high_max": 81000,
    "wage_low_avg": 81000
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 90000,
    "wage_high_max": 90000,
    "wage_low_avg": 90000
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 115678,
    "wage_high_max": 115678,
    "wage_low_avg": 115678
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 180000,
    "wage_high_max": 180000,
    "wage_low_avg": 180000
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q3",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 135000,
    "wage_high_max": 180000,
    "wage_low_avg": 157500
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q4",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 180000,
    "wage_high_max": 180000,
    "wage_low_avg": 180000
  },
  {
    "fiscal_year": 2026,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 142140,
    "wage_high_max": 142140,
    "wage_low_avg": 142140
  }
]
Links
{
  "roles": "/v1/roles?company=Constellation%20Insurance%2C%20Inc.",
  "wages": "/v1/wages?company=Constellation%20Insurance%2C%20Inc.",
  "trends": "/v1/trends?company=Constellation%20Insurance%2C%20Inc."
}
Get this page with API

Rendered from the bluedoor H-1B Jobs API. Reproduce it:

GET https://api.bluedoor.sh/h1b-jobs/v1/companies?q=constellation+insurance+inc&limit=5JSON