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

Home / Companies / Alstom Grid LLC

Alstom Grid 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
Alstom Grid LLC
ALSTOM GRID LLC
2279126FY2016 to FY2020
Latest decision 2020-09-01
148SOFTWARE ENGINEER - ELECTRICAL POWER SYSTEMS
19 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings227
Certified LCAs226
Denied LCAs1
Role titles91
Worksites26
Latest decision2020-09-01
USCIS approvals148
USCIS denials4

Aliases and source names

AliasesSource NamesSources
ALSTOM GRID LLCAlstom Grid LLC, ALSTOM GRID LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
SOFTWARE ENGINEER - ELECTRICAL POWER SYSTEMS17-2071
ELECTRICAL ENGINEERS
19$88,000$100,000
SOFTWARE ENGINEER, POWER ELECTRICAL SYSTEMS17-20719$80,000$0
SENIOR SOFTWARE ENGINEER - ELECTRICAL POWER SYSTEMS17-2071
ELECTRICAL ENGINEERS
7$95,555$115,000
SENIOR SERVICES ENGINEER17-2071
ELECTRICAL ENGINEERS
6$86,700$112,500
SENIOR SOFTWARE ENGINEER15-1132
SOFTWARE DEVELOPERS, APPLICATIONS
6$91,695$103,600
SENIOR SOFTWARE ENGINEER, POWER ELECTRICAL SYSTEMS17-20716$84,400$0
SENIOR SOFTWARE PRODUCT BUSINESS ANALYST17-20716$78,000$88,000
STAFF SOFTWARE ENGINEER15-1132
SOFTWARE DEVELOPERS, APPLICATIONS
5$122,072$143,600
ELECTRICAL POWER SYSTEMS SOFTWARE ENGINEER17-2071.00
Electrical Engineers
4$90,000$100,000
SENIOR SOFTWARE ENGINEER15-11334$88,467$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
RedmondWA980521474967,000145,0002,0162,020
BothellWA98011271980,000175,2502,0202,020
CharleroiPA15022171359,07095,0002,0162,020
San JoseCA9511032132,00002,0172,017
Oakbrook TerraceIL6018132102,00002,0162,017
PhiladelphiaPA191133380,62902,0162,016
PhoenixAZ850272275,35086,0002,0162,019
ClearwaterFL337652294,80002,0182,018
WaynesboroGA308302283,17285,9542,0172,019
Jersey CityNJ0731021108,53602,0172,018

Full company payload

Company IDcompany:alstom grid
NameAlstom Grid LLC
Normalized Namealstom grid
Source Company Idscompany_dol_oflc_lca_alstom_grid_llc, company_uscis_h1b_datahub_alstom_grid_llc_tax_8868, company_uscis_h1b_datahub_alstom_grid_llc_tax_6244, company_uscis_h1b_datahub_alstom_grid_llc_tax_5886
Source NamesAlstom Grid LLC, ALSTOM GRID LLC
AliasesALSTOM GRID LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "8868",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "6244",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5886",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 227,
  "case_count": 227,
  "role_title_count": 91,
  "worksite_count": 26,
  "first_fiscal_year": 2016,
  "latest_fiscal_year": 2020,
  "latest_decision_date": "2020-09-01",
  "certified_count": 226,
  "denied_count": 1
}
Petition Activity
{
  "total_approval": 148,
  "total_denial": 4,
  "fiscal_years": [
    "2016",
    "2017",
    "2018",
    "2019",
    "2020"
  ],
  "year_metrics": [
    {
      "cities": [
        "Erie"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "22"
      ],
      "postal_codes": [
        "16531"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_alstom_grid_llc_tax_8868_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_022507"
      ],
      "continuing_approval": 4
    },
    {
      "cities": [
        "Erie",
        "Windsor"
      ],
      "states": [
        "CT",
        "PA"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "06095",
        "16531"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 36,
      "initial_approval": 12,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_alstom_grid_llc_tax_8868_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_020131",
        "sr_uscis_h1b_datahub_2017_row_020132"
      ],
      "continuing_approval": 24
    },
    {
      "cities": [
        "Erie"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "16531"
      ],
      "total_denial": 4,
      "initial_denial": 4,
      "total_approval": 30,
      "initial_approval": 4,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_alstom_grid_llc_tax_8868_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_021851"
      ],
      "continuing_approval": 26
    },
    {
      "cities": [
        "Erie",
        "Norwalk"
      ],
      "states": [
        "CT",
        "PA"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "22",
        "33"
      ],
      "postal_codes": [
        "06851",
        "16531"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 40,
      "initial_approval": 13,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_alstom_grid_llc_tax_8868_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_021786",
        "sr_uscis_h1b_datahub_2019_row_021787",
        "sr_uscis_h1b_datahub_2019_row_021788"
      ],
      "continuing_approval": 27
    },
    {
      "cities": [
        "Norwalk",
        "San Ramon"
      ],
      "states": [
        "CA",
        "CT"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "22",
        "33",
        "54"
      ],
      "postal_codes": [
        "06851",
        "94583"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 33,
      "initial_approval": 6,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_alstom_grid_llc_tax_8868_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_002414",
        "sr_uscis_h1b_datahub_2020_row_002415",
        "sr_uscis_h1b_datahub_2020_row_002417",
        "sr_uscis_h1b_datahub_2020_row_002418",
        "sr_uscis_h1b_datahub_2020_row_002419"
      ],
      "continuing_approval": 27
    },
    {
      "cities": [
        "Erie"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "22",
        "33"
      ],
      "postal_codes": [
        "16531"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_alstom_grid_llc_tax_6244_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_035715",
        "sr_uscis_h1b_datahub_2016_row_035716"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Erie"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "22",
        "33"
      ],
      "postal_codes": [
        "16531"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_alstom_grid_llc_tax_6244_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_032418",
        "sr_uscis_h1b_datahub_2017_row_032419"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "San Ramon"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "94583"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_alstom_grid_llc_tax_5886_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_002416"
      ],
      "continuing_approval": 1
    }
  ]
}
Geography
{
  "states": [
    "WA",
    "PA",
    "CA",
    "IL",
    "AZ",
    "FL",
    "GA",
    "NJ",
    "DC",
    "MA",
    "MI",
    "MN",
    "VA",
    "CT"
  ],
  "cities": [
    "Redmond",
    "Bothell",
    "Charleroi",
    "San Jose",
    "Oakbrook Terrace",
    "Philadelphia",
    "Phoenix",
    "Clearwater",
    "Waynesboro",
    "Jersey City",
    "Charleori",
    "Wayne",
    "Fremont",
    "Mountain House",
    "San Francisco",
    "San Ramon",
    "Washington",
    "Washington Dc",
    "Dorchester",
    "Woods Hole",
    "Novi",
    "Eden Prairie",
    "Mclean",
    "Erie",
    "Norwalk",
    "Windsor"
  ],
  "postal_codes": [
    "98052",
    "98011",
    "15022",
    "95110",
    "60181",
    "19113",
    "85027",
    "33765",
    "30830",
    "07310",
    "19133",
    "19087",
    "94539",
    "95391",
    "94105",
    "94583",
    "20004",
    "20009",
    "2125",
    "2543",
    "48374",
    "55344",
    "15241",
    "22102",
    "58092",
    "06095",
    "06851",
    "16531"
  ],
  "top_markets": [
    {
      "city": "Redmond",
      "state": "WA",
      "postal_code": "98052",
      "lca_count": 147,
      "role_title_count": 49,
      "wage_low_min": 67000,
      "wage_high_max": 145000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2020
    },
    {
      "city": "Bothell",
      "state": "WA",
      "postal_code": "98011",
      "lca_count": 27,
      "role_title_count": 19,
      "wage_low_min": 80000,
      "wage_high_max": 175250,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020
    },
    {
      "city": "Charleroi",
      "state": "PA",
      "postal_code": "15022",
      "lca_count": 17,
      "role_title_count": 13,
      "wage_low_min": 59070,
      "wage_high_max": 95000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2020
    },
    {
      "city": "San Jose",
      "state": "CA",
      "postal_code": "95110",
      "lca_count": 3,
      "role_title_count": 2,
      "wage_low_min": 132000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Oakbrook Terrace",
      "state": "IL",
      "postal_code": "60181",
      "lca_count": 3,
      "role_title_count": 2,
      "wage_low_min": 102000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Philadelphia",
      "state": "PA",
      "postal_code": "19113",
      "lca_count": 3,
      "role_title_count": 3,
      "wage_low_min": 80629,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Phoenix",
      "state": "AZ",
      "postal_code": "85027",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 75350,
      "wage_high_max": 86000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Clearwater",
      "state": "FL",
      "postal_code": "33765",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 94800,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Waynesboro",
      "state": "GA",
      "postal_code": "30830",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 83172,
      "wage_high_max": 85954,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Jersey City",
      "state": "NJ",
      "postal_code": "07310",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 108536,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018
    }
  ]
}
Industry
{
  "naics_codes": [
    "33531",
    "22",
    "33",
    "54"
  ]
}
Wage Summary
{
  "annualized_low_min": 59070,
  "annualized_high_max": 175250,
  "annualized_low_avg": 100346.682819383
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 31,
    "case_count": 31,
    "role_title_count": 23,
    "worksite_count": 6,
    "wage_low_min": 59070,
    "wage_high_max": 0,
    "wage_low_avg": 93985.7741935484
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 44,
    "case_count": 44,
    "role_title_count": 20,
    "worksite_count": 8,
    "wage_low_min": 67000,
    "wage_high_max": 88000,
    "wage_low_avg": 93777.4318181818
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 41,
    "case_count": 41,
    "role_title_count": 21,
    "worksite_count": 5,
    "wage_low_min": 72000,
    "wage_high_max": 0,
    "wage_low_avg": 98882.1951219512
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 67,
    "case_count": 67,
    "role_title_count": 26,
    "worksite_count": 12,
    "wage_low_min": 78000,
    "wage_high_max": 143600,
    "wage_low_avg": 101671.194029851
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q1",
    "lca_count": 7,
    "case_count": 7,
    "role_title_count": 5,
    "worksite_count": 1,
    "wage_low_min": 104000,
    "wage_high_max": 140000,
    "wage_low_avg": 117911.428571429
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 23,
    "case_count": 23,
    "role_title_count": 18,
    "worksite_count": 2,
    "wage_low_min": 80000,
    "wage_high_max": 175250,
    "wage_low_avg": 109626.565217391
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 7,
    "case_count": 7,
    "role_title_count": 6,
    "worksite_count": 2,
    "wage_low_min": 87000,
    "wage_high_max": 136000,
    "wage_low_avg": 99685.7142857143
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q4",
    "lca_count": 7,
    "case_count": 7,
    "role_title_count": 7,
    "worksite_count": 6,
    "wage_low_min": 88000,
    "wage_high_max": 145400,
    "wage_low_avg": 118314.285714286
  }
]
Links
{
  "roles": "/v1/roles?company=Alstom%20Grid%20LLC",
  "wages": "/v1/wages?company=Alstom%20Grid%20LLC",
  "trends": "/v1/trends?company=Alstom%20Grid%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=alstom+grid+llc&limit=5JSON