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

Home / Companies / EXCELLUS BLUECROSS BLUESHIELD

EXCELLUS BLUECROSS BLUESHIELD 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
EXCELLUS BLUECROSS BLUESHIELD
EXCELLUS BLUECROSS BLUESHIELD
1192FY2016 to FY2018
Latest decision 2017-11-09
14INFORMATION DESIGN TEST ENGINEER
2 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings11
Certified LCAs11
Denied LCAs0
Role titles9
Worksites2
Latest decision2017-11-09
USCIS approvals14
USCIS denials1

Aliases and source names

AliasesSource NamesSources
EXCELLUS BLUECROSS BLUESHIELDEXCELLUS BLUECROSS BLUESHIELDdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
INFORMATION DESIGN TEST ENGINEER15-11212$82,500$0
ACTUARIAL ANALYST IV15-20111$95,000$0
GOVERNMENT PROGRAMS TECHNICAL BUSINESS ANALYST II15-11211$73,000$0
INFORMATION DESIGN TEST ENGINEER15-11991$82,500$0
RISK ADJUSTMENT ANALYST13-20511$63,172$0
SOFTWARE ENGINEER15-11991$52,000$0
SOFTWARE ENGINEER I15-11321$65,000$0
SOFTWARE ENGINEER II15-11321$60,000$0
SOFTWARE ENGINEER V15-11321$98,000$0
USER INTERFACE DEVELOPER15-11321$65,000$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
RochesterNY146479752,00002,0162,018
East RochesterNY144452260,00002,0172,017

Full company payload

Company IDcompany:excellus bluecross blueshield
NameEXCELLUS BLUECROSS BLUESHIELD
Normalized Nameexcellus bluecross blueshield
Source Company Idscompany_dol_oflc_lca_excellus_bluecross_blueshield, company_uscis_h1b_datahub_excellus_bluecross_blueshield_tax_9043
Source NamesEXCELLUS BLUECROSS BLUESHIELD
AliasesEXCELLUS BLUECROSS BLUESHIELD
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "EXCELLUS BLUECROSS BLUESHIELD"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "EXCELLUS BLUECROSS BLUESHIELD",
      "filing_count": 10,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "EXCELLUS BLUECROSS BLUESHIELD",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "9043",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 11,
  "case_count": 11,
  "role_title_count": 9,
  "worksite_count": 2,
  "total_workers": 11,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-03-08",
  "latest_fiscal_year": 2018,
  "latest_decision_date": "2017-11-09",
  "certified_count": 11,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 11,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 11,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 8,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 14,
  "total_denial": 1,
  "fiscal_years": [
    "2016",
    "2017",
    "2018"
  ],
  "year_metrics": [
    {
      "cities": [
        "Rochester"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "14647"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_excellus_bluecross_blueshield_tax_9043_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_006390"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Rochester"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "14647"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_excellus_bluecross_blueshield_tax_9043_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_005705"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Rochester"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "14647"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 10,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_excellus_bluecross_blueshield_tax_9043_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_006038"
      ],
      "continuing_approval": 7
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "ROCHESTER NY 14647",
      "city": "Rochester",
      "state": "NY",
      "postal_code": "14647",
      "filing_count": 11,
      "case_count": 11,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2017-11-09",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "ROCHESTER NY 14647",
      "city": "Rochester",
      "county": "Monroe",
      "state": "NY",
      "postal_code": "14647",
      "filing_count": 9,
      "case_count": 9,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2017-11-09",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "EAST ROCHESTER NY 14445",
      "city": "East Rochester",
      "county": "Monroe",
      "state": "NY",
      "postal_code": "14445",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-09-18",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 1,
    "worksite_address_count": 2,
    "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": [
    "NY"
  ],
  "cities": [
    "Rochester",
    "East Rochester"
  ],
  "postal_codes": [
    "14647",
    "14445"
  ],
  "top_markets": [
    {
      "city": "Rochester",
      "state": "NY",
      "postal_code": "14647",
      "lca_count": 9,
      "role_title_count": 7,
      "wage_low_min": 52000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018
    },
    {
      "city": "East Rochester",
      "state": "NY",
      "postal_code": "14445",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 60000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    }
  ]
}
Industry
{
  "naics_codes": [
    "524114",
    "52"
  ],
  "naics_breakdown": [
    {
      "value": "524114",
      "filing_count": 8,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 52000,
  "annualized_high_max": 0,
  "annualized_low_avg": 75106.5454545455
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 1,
    "wage_low_min": 52000,
    "wage_high_max": 0,
    "wage_low_avg": 70057.3333333333
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 7,
    "case_count": 7,
    "role_title_count": 5,
    "worksite_count": 2,
    "wage_low_min": 60000,
    "wage_high_max": 0,
    "wage_low_avg": 77571.4285714286
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 73000,
    "wage_high_max": 0,
    "wage_low_avg": 73000
  }
]
Links
{
  "roles": "/v1/roles?company=EXCELLUS%20BLUECROSS%20BLUESHIELD",
  "wages": "/v1/wages?company=EXCELLUS%20BLUECROSS%20BLUESHIELD",
  "trends": "/v1/trends?company=EXCELLUS%20BLUECROSS%20BLUESHIELD"
}
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=excellus+bluecross+blueshield&limit=5JSON