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

Home / Companies / Hagerty Insurance Agency, LLC

Hagerty Insurance Agency, LLC H-1B company data

Summary

Hagerty Insurance Agency, LLC filed 13 H-1B labor condition applications (LCAs) with the U.S. Department of Labor between FY2017-FY2023.

Of those, 13 were certified (a 100% certification rate among adjudicated filings).

The filings span 10 distinct role titles across 4 worksites.

The most-sponsored role was Business Intelligence Analyst (2 filings), with offered wages from $120,000 to $120,000.

Separately, USCIS H-1B Employer Data Hub records show 7 approved and 2 denied H-1B petitions for this employer.

LCA filings are labor-condition applications certified by the U.S. Department of Labor, not active job postings or approved USCIS H-1B petitions.

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
Hagerty Insurance Agency, LLC
Hagerty Insurance Agency, HAGERTY INSURANCE AGENCY LLC
13104FY2017 to FY2023
Latest decision 2023-01-27
7Business Intelligence Analyst
2 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings13
Certified LCAs13
Denied LCAs0
Role titles10
Worksites4
Latest decision2023-01-27
USCIS approvals7
USCIS denials2

Aliases and source names

AliasesSource NamesSources
Hagerty Insurance Agency, HAGERTY INSURANCE AGENCY LLCHagerty Insurance Agency, LLC, Hagerty Insurance Agency, HAGERTY INSURANCE AGENCY LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
Business Intelligence Analyst15-2051.01
Business Intelligence Analysts
2$120,000$120,000
Product Data Analyst15-2051.01
Business Intelligence Analysts
2$120,000$120,000
Database Administrator15-1141.00
Database Administrators
1$116,000$116,000
FINANCIAL ANALYST13-20511$51,565$0
Senior Software developer15-1132.00
Software Developers, Applications
1$107,000$107,000
Senior Software Developer15-1252.00
Software Developers
1$116,844$116,844
Software Developer15-1252.00
Software Developers
1$90,000$90,000
Software Engineer15-1132.00
Software Developers, Applications
1$121,956$121,956
APPLICATIONS INTEGRATION ENGINEER17-2071
ELECTRICAL ENGINEERS
1$94,827$110,000
Software Developer15-1132.00
Software Developers, Applications
1$79,000$90,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
LittletonCO8012342120,000120,0002,0232,023
Traverse CityMI496844451,565121,9562,0172,022
Traverse CityMI496843379,000110,0002,0192,020
Traverse CityMI4968521107,000116,8442,0202,023

Full company payload

Company IDcompany:hagerty insurance agency
NameHagerty Insurance Agency, LLC
Normalized Namehagerty insurance agency
Source Company Idscompany_dol_oflc_lca_hagerty_insurance_agency_llc, company_dol_oflc_lca_hagerty_insurance_agency, company_uscis_h1b_datahub_hagerty_insurance_agency_llc_tax_8247
Source NamesHagerty Insurance Agency, LLC, Hagerty Insurance Agency, HAGERTY INSURANCE AGENCY LLC
AliasesHagerty Insurance Agency, HAGERTY INSURANCE AGENCY LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Hagerty Insurance Agency, LLC",
    "Hagerty Insurance Agency",
    "HAGERTY INSURANCE AGENCY LLC"
  ],
  "dba_names": [
    "Hagerty Insurance Agency"
  ],
  "name_variants": [
    {
      "value": "Hagerty Insurance Agency, LLC",
      "filing_count": 7,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Hagerty Insurance Agency",
      "filing_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "HAGERTY INSURANCE AGENCY",
      "filing_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Hagerty Insurance Agency",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "HAGERTY INSURANCE AGENCY, LLC",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "HAGERTY INSURANCE AGENCY LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "8247",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 13,
  "case_count": 13,
  "role_title_count": 10,
  "worksite_count": 4,
  "total_workers": 13,
  "first_fiscal_year": 2017,
  "first_received_date": "2017-03-16",
  "latest_fiscal_year": 2023,
  "latest_decision_date": "2023-01-27",
  "certified_count": 13,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 9,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 10,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "H-1B",
      "filing_count": 3,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 10,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Y",
      "filing_count": 3,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 7,
  "total_denial": 2,
  "fiscal_years": [
    "2018",
    "2019",
    "2020",
    "2022",
    "2023"
  ],
  "year_metrics": [
    {
      "cities": [
        "Traverse City"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "49684"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_hagerty_insurance_agency_llc_tax_8247_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_051668"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Traverse City"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "49684"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_hagerty_insurance_agency_llc_tax_8247_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_055099"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Traverse City"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "49684",
        "49685"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_hagerty_insurance_agency_llc_tax_8247_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_021136",
        "sr_uscis_h1b_datahub_2020_row_021137"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Traverse City"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "49684"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_hagerty_insurance_agency_llc_tax_8247_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_023054"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Traverse City"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2023,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "49684"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_hagerty_insurance_agency_llc_tax_8247_2023",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2023_row_012725"
      ],
      "continuing_approval": 3
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "TRAVERSE CITY MI 49684",
      "city": "Traverse City",
      "state": "MI",
      "postal_code": "49684",
      "filing_count": 9,
      "case_count": 9,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-01-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "TRAVERSE CITY MI 49684",
      "city": "Traverse City",
      "state": "MI",
      "postal_code": "49684",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-03-05",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "TRAVERSE CITY MI 49685",
      "city": "Traverse City",
      "state": "MI",
      "postal_code": "49685",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-05-29",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "LITTLETON CO 80123",
      "city": "Littleton",
      "county": "Jefferson",
      "state": "CO",
      "postal_code": "80123",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2022-10-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "TRAVERSE CITY MI 49685",
      "city": "Traverse City",
      "county": "Grand Traverse",
      "state": "MI",
      "postal_code": "49685",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-01-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "TRAVERSE CITY MI 49684",
      "city": "Traverse City",
      "county": "Grand Traverse",
      "state": "MI",
      "postal_code": "49684",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-09-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "TRAVERSE CITY MI 49684",
      "city": "Traverse City",
      "county": "Grand Traverse",
      "state": "MI",
      "postal_code": "49684",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-03-05",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 3,
    "worksite_address_count": 4,
    "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": [
    "CO",
    "MI"
  ],
  "cities": [
    "Littleton",
    "Traverse City"
  ],
  "postal_codes": [
    "80123",
    "49684",
    "49685"
  ],
  "top_markets": [
    {
      "city": "Littleton",
      "state": "CO",
      "postal_code": "80123",
      "lca_count": 4,
      "role_title_count": 2,
      "wage_low_min": 120000,
      "wage_high_max": 120000,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023
    },
    {
      "city": "Traverse City",
      "state": "MI",
      "postal_code": "49684",
      "lca_count": 4,
      "role_title_count": 4,
      "wage_low_min": 51565,
      "wage_high_max": 121956,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2022
    },
    {
      "city": "Traverse City",
      "state": "MI",
      "postal_code": "49684",
      "lca_count": 3,
      "role_title_count": 3,
      "wage_low_min": 79000,
      "wage_high_max": 110000,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020
    },
    {
      "city": "Traverse City",
      "state": "MI",
      "postal_code": "49685",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 107000,
      "wage_high_max": 116844,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2023
    }
  ]
}
Industry
{
  "naics_codes": [
    "524128",
    "5241",
    "52"
  ],
  "naics_breakdown": [
    {
      "value": "5241",
      "filing_count": 7,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "5241",
      "filing_count": 3,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "52412",
      "filing_count": 2,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "524128",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 51565,
  "annualized_high_max": 121956,
  "annualized_low_avg": 98101.58333333334
}
Trend
[
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 51565,
    "wage_high_max": 0,
    "wage_low_avg": 51565
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 89773,
    "wage_high_max": 110000,
    "wage_low_avg": 92300
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 79000,
    "wage_high_max": 90000,
    "wage_low_avg": 79000
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 107000,
    "wage_high_max": 107000,
    "wage_low_avg": 107000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 116000,
    "wage_high_max": 116000,
    "wage_low_avg": 116000
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 121956,
    "wage_high_max": 121956,
    "wage_low_avg": 121956
  },
  {
    "fiscal_year": 2022,
    "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": 2023,
    "quarter": "Q1",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 120000,
    "wage_high_max": 120000,
    "wage_low_avg": 120000
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 2,
    "wage_low_min": 116844,
    "wage_high_max": 120000,
    "wage_low_avg": 118948
  }
]
Links
{
  "roles": "/v1/roles?company=Hagerty%20Insurance%20Agency%2C%20LLC",
  "wages": "/v1/wages?company=Hagerty%20Insurance%20Agency%2C%20LLC",
  "trends": "/v1/trends?company=Hagerty%20Insurance%20Agency%2C%20LLC"
}

Frequently asked questions

Does Hagerty Insurance Agency, LLC sponsor H-1B visas?
Yes. Hagerty Insurance Agency, LLC filed 13 H-1B labor condition applications with the U.S. Department of Labor (FY2017-FY2023), of which 13 were certified. LCA filings are labor-condition applications certified by the U.S. Department of Labor, not active job postings or approved USCIS H-1B petitions.
How many H-1B applications has Hagerty Insurance Agency, LLC filed?
Hagerty Insurance Agency, LLC has 13 H-1B LCA filings on record spanning FY2017-FY2023 across 10 role titles and 4 worksites.
What roles does Hagerty Insurance Agency, LLC sponsor for H-1B?
The most common H-1B role at Hagerty Insurance Agency, LLC is Business Intelligence Analyst (2 filings). Other frequent roles include Product Data Analyst, Database Administrator, Financial Analyst, Senior Software Developer.
What wages does Hagerty Insurance Agency, LLC offer H-1B workers?
For its most-sponsored role (Business Intelligence Analyst), Hagerty Insurance Agency, LLC reported offered wages ranging from $120,000 to $120,000 in DOL LCA filings.
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=hagerty+insurance+agency&limit=5JSON