Home / Companies / Herspiegel Consulting LLC

Herspiegel Consulting LLC 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.

Role rows Wage rows Trends

Employer	LCA filings	Role titles	Worksites	Coverage	USCIS approvals	Top role	Sources	Open
Herspiegel Consulting LLC HERSPIEGEL CONSULTING LLC	9	4	4	FY2016 to FY2026 Latest decision 2025-11-21	1	ASSOCIATE CONSULTANT 5 filings	dol_oflc_lca, uscis_h1b_employer_data_hub	Profile

Activity summary

LCA filings	9
Certified LCAs	9
Denied LCAs	0
Role titles	4
Worksites	4
Latest decision	2025-11-21
USCIS approvals	1
USCIS denials	1

Aliases and source names

Aliases	Source Names	Sources
HERSPIEGEL CONSULTING LLC	Herspiegel Consulting LLC, HERSPIEGEL CONSULTING LLC	dol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

Title	SOC	LCA filings	Low wage min	High wage max
ASSOCIATE CONSULTANT	13-1161 MARKET RESEARCH ANALYSTS AND MARKETING SPECIALISTS	5	$80,000	$110,000
Consultant	13-1111.00 Management Analysts	2	$66,123	$86,445
Director, Patient Services	13-1111.00 Management Analysts	1	$150,000	$200,000
Principal	13-1111.00 Management Analysts	1	$172,453	$210,000

Top markets

City	State	Postal Code	LCA Count	Role Title Count	Wage Low Min	Wage High Max	First Fiscal Year	Latest Fiscal Year
Yardley	PA	19067	6	2	80,000	200,000	2,016	2,024
San Francisco	CA	94104	1	1	172,453	210,000	2,026	2,026
Cary	NC	27513	1	1	66,123	86,445	2,025	2,025
Cary	NC	27518	1	1	66,123	86,445	2,025	2,025

Full company payload

Company ID	company:herspiegel consulting
Name	Herspiegel Consulting LLC
Normalized Name	herspiegel consulting
Source Company Ids	company_dol_oflc_lca_herspiegel_consulting_llc, company_uscis_h1b_datahub_herspiegel_consulting_llc_tax_7241
Source Names	Herspiegel Consulting LLC, HERSPIEGEL CONSULTING LLC
Aliases	HERSPIEGEL CONSULTING LLC
Sources	dol_oflc_lca, uscis_h1b_employer_data_hub

Names

{
  "source_names": [
    "Herspiegel Consulting LLC",
    "HERSPIEGEL CONSULTING LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "HERSPIEGEL CONSULTING LLC",
      "filing_count": 5,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Herspiegel Consulting LLC",
      "filing_count": 4,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "HERSPIEGEL CONSULTING LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}

Identifiers

[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "7241",
    "source": "uscis_h1b_employer_data_hub"
  }
]

LCA Activity

{
  "lca_count": 9,
  "case_count": 9,
  "role_title_count": 4,
  "worksite_count": 4,
  "total_workers": 9,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-03-07",
  "latest_fiscal_year": 2026,
  "latest_decision_date": "2025-11-21",
  "certified_count": 9,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 4,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED-WITHDRAWN",
      "filing_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 7,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "E-3 Australian",
      "filing_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 8,
      "first_fiscal_year": 2017,
      "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": 1,
  "fiscal_years": [
    "2016",
    "2019"
  ],
  "year_metrics": [
    {
      "cities": [
        "Morrisville"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "19067"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_herspiegel_consulting_llc_tax_7241_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_015084"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Morrisville"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "19067"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_herspiegel_consulting_llc_tax_7241_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_014338"
      ],
      "continuing_approval": 0
    }
  ]
}

Addresses

{
  "office_addresses": [
    {
      "address_kind": "office",
      "address_line_1": "1020 Stony Hill Rd",
      "address_line_2": "Suite 200",
      "raw_address": "1020 Stony Hill Rd Suite 200 YARDLEY PA 19067",
      "city": "Yardley",
      "state": "PA",
      "postal_code": "19067",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2025-11-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "YARDLEY PA 19067",
      "city": "Yardley",
      "state": "PA",
      "postal_code": "19067",
      "filing_count": 7,
      "case_count": 7,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-06-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "YARDLEY PA 79067",
      "city": "Yardley",
      "state": "PA",
      "postal_code": "79067",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-07-31",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "address_line_1": "44 Montgomery Street",
      "address_line_2": "# 4050",
      "raw_address": "44 Montgomery Street # 4050 SAN FRANCISCO CA 94104",
      "city": "San Francisco",
      "state": "CA",
      "postal_code": "94104",
      "filing_count": 1,
      "case_count": 1,
      "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 27513",
      "city": "Cary",
      "county": "Wake",
      "state": "NC",
      "postal_code": "27513",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-06-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CARY NC 27518",
      "city": "Cary",
      "county": "Wake",
      "state": "NC",
      "postal_code": "27518",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-05-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "YARDLEY PA 19067",
      "city": "Yardley",
      "county": "Bucks",
      "state": "PA",
      "postal_code": "19067",
      "filing_count": 6,
      "case_count": 6,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-06-06",
      "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": [
    "PA",
    "CA",
    "NC"
  ],
  "cities": [
    "Yardley",
    "San Francisco",
    "Cary",
    "Morrisville"
  ],
  "postal_codes": [
    "19067",
    "94104",
    "27513",
    "27518"
  ],
  "top_markets": [
    {
      "city": "Yardley",
      "state": "PA",
      "postal_code": "19067",
      "lca_count": 6,
      "role_title_count": 2,
      "wage_low_min": 80000,
      "wage_high_max": 200000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024
    },
    {
      "city": "San Francisco",
      "state": "CA",
      "postal_code": "94104",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 172453,
      "wage_high_max": 210000,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026
    },
    {
      "city": "Cary",
      "state": "NC",
      "postal_code": "27513",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 66123,
      "wage_high_max": 86445,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025
    },
    {
      "city": "Cary",
      "state": "NC",
      "postal_code": "27518",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 66123,
      "wage_high_max": 86445,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025
    }
  ]
}

Industry

{
  "naics_codes": [
    "541690",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541690",
      "filing_count": 4,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "54161",
      "filing_count": 3,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "541613",
      "filing_count": 1,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}

Wage Summary

{
  "annualized_low_min": 66123,
  "annualized_high_max": 210000,
  "annualized_low_avg": 99966.5555555556
}

Trend

[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 80000,
    "wage_high_max": 92000,
    "wage_low_avg": 80000
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 80000,
    "wage_high_max": 100000,
    "wage_low_avg": 85000
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 105000,
    "wage_high_max": 110000,
    "wage_low_avg": 105000
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 90000,
    "wage_high_max": 100000,
    "wage_low_avg": 90000
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 150000,
    "wage_high_max": 200000,
    "wage_low_avg": 150000
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q3",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 2,
    "wage_low_min": 66123,
    "wage_high_max": 86445,
    "wage_low_avg": 66123
  },
  {
    "fiscal_year": 2026,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 172453,
    "wage_high_max": 210000,
    "wage_low_avg": 172453
  }
]

Links

{
  "roles": "/v1/roles?company=Herspiegel%20Consulting%20LLC",
  "wages": "/v1/wages?company=Herspiegel%20Consulting%20LLC",
  "trends": "/v1/trends?company=Herspiegel%20Consulting%20LLC"
}

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=herspiegel+consulting+llc&limit=5JSON

Docs · Get an API key