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

Home / Companies / Mercer Spokane LLC

Mercer Spokane 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.

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
Mercer Spokane LLC211FY2024 to FY2024
Latest decision 2023-12-11
0Senior SAP Architect
2 filings
dol_oflc_lcaProfile

Activity summary

LCA filings2
Certified LCAs2
Denied LCAs0
Role titles1
Worksites1
Latest decision2023-12-11
USCIS approvals0
USCIS denials0

Aliases and source names

AliasesSource NamesSources
-Mercer Spokane LLCdol_oflc_lca

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
Senior SAP Architect15-1299.08
Computer Systems Engineers/Architects
2$150,000$225,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
Spokane ValleyWA9902721150,000225,0002,0242,024

Full company payload

Company IDcompany:mercer spokane
NameMercer Spokane LLC
Normalized Namemercer spokane
Source Company Idscompany_dol_oflc_lca_mercer_spokane_llc
Source NamesMercer Spokane LLC
Aliases-
Identifiers-
Sourcesdol_oflc_lca
Names
{
  "source_names": [
    "Mercer Spokane LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "Mercer Spokane LLC",
      "filing_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}
LCA Activity
{
  "lca_count": 2,
  "case_count": 2,
  "role_title_count": 1,
  "worksite_count": 1,
  "total_workers": 2,
  "first_fiscal_year": 2024,
  "first_received_date": "2023-10-13",
  "latest_fiscal_year": 2024,
  "latest_decision_date": "2023-12-11",
  "certified_count": 2,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 0,
  "total_denial": 0,
  "fiscal_years": [],
  "year_metrics": []
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "SPOKANE VALLEY WA 99027",
      "city": "Spokane Valley",
      "state": "WA",
      "postal_code": "99027",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2023-12-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "SPOKANE VALLEY WA 99027",
      "city": "Spokane Valley",
      "county": "Spokane",
      "state": "WA",
      "postal_code": "99027",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2023-12-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 1,
    "worksite_address_count": 1,
    "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": [
    "WA"
  ],
  "cities": [
    "Spokane Valley"
  ],
  "postal_codes": [
    "99027"
  ],
  "top_markets": [
    {
      "city": "Spokane Valley",
      "state": "WA",
      "postal_code": "99027",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 150000,
      "wage_high_max": 225000,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024
    }
  ]
}
Industry
{
  "naics_codes": [
    "423990"
  ],
  "naics_breakdown": [
    {
      "value": "423990",
      "filing_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 150000,
  "annualized_high_max": 225000,
  "annualized_low_avg": 150000
}
Trend
[
  {
    "fiscal_year": 2024,
    "quarter": "Q1",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 150000,
    "wage_high_max": 225000,
    "wage_low_avg": 150000
  }
]
Links
{
  "roles": "/v1/roles?company=Mercer%20Spokane%20LLC",
  "wages": "/v1/wages?company=Mercer%20Spokane%20LLC",
  "trends": "/v1/trends?company=Mercer%20Spokane%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=mercer+spokane+llc&limit=5JSON