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

Home / Companies / Automotive Lighting, LLC

Automotive Lighting, 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
Automotive Lighting, LLC
AUTOMOTIVE LIGHTING LLC
56294FY2016 to FY2020
Latest decision 2019-11-26
50ELECTRICAL ENGINEER
5 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile
MARELLI AUTOMOTIVE LIGHTING LLC
MARELLI AUTOMOTIVE LIGHTING LLC
0--FY- to FY-
Latest decision -
19-uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings56
Certified LCAs55
Denied LCAs1
Role titles29
Worksites4
Latest decision2019-11-26
USCIS approvals50
USCIS denials1

Aliases and source names

AliasesSource NamesSources
AUTOMOTIVE LIGHTING LLCAutomotive Lighting, LLC, AUTOMOTIVE LIGHTING LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
ELECTRICAL ENGINEER17-2071
ELECTRICAL ENGINEERS
5$65,000$65,000
PROJECT ENGINEER17-21415$73,000$0
DESIGNER17-2141
MECHANICAL ENGINEERS
3$85,000$87,550
MANUFACTURING ENGINEER17-2141
MECHANICAL ENGINEERS
3$63,128$80,000
VALIDATION ENGINEER17-2141
MECHANICAL ENGINEERS
3$62,650$80,000
CATIA DESIGNER17-21412$95,000$0
ELECTRONICS VALICATION ENGINEER17-2071
ELECTRICAL ENGINEERS
2$85,000$85,000
EXTERIOR AUTOMOTIVE LIGHTING DESIGNER17-2141
MECHANICAL ENGINEERS
2$90,000$100,170
MECHANICAL ENGINEER17-2141
MECHANICAL ENGINEERS
2$85,000$85,000
METHODOLOGIES ENGINEER17-21122$66,000$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
Auburn HillsMI48326472462,650120,0002,0162,020
ClarkstonMI483466461,29899,0002,0172,019
PulaskiTN384782297,00097,0002,0162,020
ClarkstonMI483261163,12863,1282,0192,019

Full company payload

Company IDcompany:automotive lighting
NameAutomotive Lighting, LLC
Normalized Nameautomotive lighting
Source Company Idscompany_dol_oflc_lca_automotive_lighting_llc, company_uscis_h1b_datahub_automotive_lighting_llc_tax_9804
Source NamesAutomotive Lighting, LLC, AUTOMOTIVE LIGHTING LLC
AliasesAUTOMOTIVE LIGHTING LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Automotive Lighting, LLC",
    "AUTOMOTIVE LIGHTING LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "AUTOMOTIVE LIGHTING, LLC",
      "filing_count": 52,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Automotive Lighting, LLC",
      "filing_count": 4,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "AUTOMOTIVE LIGHTING LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "9804",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 56,
  "case_count": 56,
  "role_title_count": 29,
  "worksite_count": 4,
  "total_workers": 56,
  "first_fiscal_year": 2016,
  "first_received_date": "2015-10-30",
  "latest_fiscal_year": 2020,
  "latest_decision_date": "2019-11-26",
  "certified_count": 55,
  "denied_count": 1,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 39,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED-WITHDRAWN",
      "filing_count": 11,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 4,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified - Withdrawn",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "DENIED",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 53,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "E-3 Australian",
      "filing_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 45,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 50,
  "total_denial": 1,
  "fiscal_years": [
    "2009",
    "2011",
    "2012",
    "2013",
    "2014",
    "2015",
    "2016",
    "2017",
    "2018",
    "2019"
  ],
  "year_metrics": [
    {
      "cities": [
        "Farmington Hills"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2009,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "48335"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_automotive_lighting_llc_tax_9804_2009",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2009_row_035352"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Auburn Hills"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2011,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "48326"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_automotive_lighting_llc_tax_9804_2011",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2011_row_034028"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Auburn Hills"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "48326"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_automotive_lighting_llc_tax_9804_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_030305"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Auburn Hills"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "48326"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_automotive_lighting_llc_tax_9804_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_028791"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "Auburn Hills"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "48326"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_automotive_lighting_llc_tax_9804_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_028474"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "Auburn Hills"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "48326"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_automotive_lighting_llc_tax_9804_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_023189"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Auburn Hills"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "48326"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 6,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_automotive_lighting_llc_tax_9804_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_024272"
      ],
      "continuing_approval": 4
    },
    {
      "cities": [
        "Auburn Hills",
        "Detroit"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "48226",
        "48326"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 11,
      "initial_approval": 5,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_automotive_lighting_llc_tax_9804_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_021727",
        "sr_uscis_h1b_datahub_2017_row_021728"
      ],
      "continuing_approval": 6
    },
    {
      "cities": [
        "Auburn Hills",
        "Clarkston"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "48326",
        "48346"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 11,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_automotive_lighting_llc_tax_9804_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_023582",
        "sr_uscis_h1b_datahub_2018_row_023583"
      ],
      "continuing_approval": 8
    },
    {
      "cities": [
        "Auburn Hills",
        "Clarkston"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "48326",
        "48346"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 7,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_automotive_lighting_llc_tax_9804_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_023641",
        "sr_uscis_h1b_datahub_2019_row_023642"
      ],
      "continuing_approval": 4
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "AUBURN HILLS MI 48326",
      "city": "Auburn Hills",
      "state": "MI",
      "postal_code": "48326",
      "filing_count": 46,
      "case_count": 46,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2019-11-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "CLARKSTON MI 48346",
      "city": "Clarkston",
      "state": "MI",
      "postal_code": "48346",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2018-10-29",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "CLARKSTON MI 48343",
      "city": "Clarkston",
      "state": "MI",
      "postal_code": "48343",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-15",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "AUBURN HILLS MI 48346",
      "city": "Auburn Hills",
      "state": "MI",
      "postal_code": "48346",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-02-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "AUBURN HILLS MI 48326",
      "city": "Auburn Hills",
      "county": "Oakland",
      "state": "MI",
      "postal_code": "48326",
      "filing_count": 47,
      "case_count": 47,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2019-11-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "PULASKI TN 38478",
      "city": "Pulaski",
      "county": "Giles",
      "state": "TN",
      "postal_code": "38478",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2019-10-15",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CLARKSTON MI 48346",
      "city": "Clarkston",
      "county": "Oakland",
      "state": "MI",
      "postal_code": "48346",
      "filing_count": 6,
      "case_count": 6,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-09",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CLARKSTON MI 48326",
      "city": "Clarkston",
      "county": "Oakland",
      "state": "MI",
      "postal_code": "48326",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-15",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 4,
    "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": [
    "MI",
    "TN"
  ],
  "cities": [
    "Auburn Hills",
    "Clarkston",
    "Pulaski",
    "Detroit",
    "Farmington Hills"
  ],
  "postal_codes": [
    "48326",
    "48346",
    "38478",
    "48226",
    "48335"
  ],
  "top_markets": [
    {
      "city": "Auburn Hills",
      "state": "MI",
      "postal_code": "48326",
      "lca_count": 47,
      "role_title_count": 24,
      "wage_low_min": 62650,
      "wage_high_max": 120000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2020
    },
    {
      "city": "Clarkston",
      "state": "MI",
      "postal_code": "48346",
      "lca_count": 6,
      "role_title_count": 4,
      "wage_low_min": 61298,
      "wage_high_max": 99000,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Pulaski",
      "state": "TN",
      "postal_code": "38478",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 97000,
      "wage_high_max": 97000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2020
    },
    {
      "city": "Clarkston",
      "state": "MI",
      "postal_code": "48326",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 63128,
      "wage_high_max": 63128,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019
    }
  ]
}
Industry
{
  "naics_codes": [
    "336321",
    "33",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "336321",
      "filing_count": 25,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "336320",
      "filing_count": 20,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 61298,
  "annualized_high_max": 120000,
  "annualized_low_avg": 86185.8392857143
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 11,
    "case_count": 11,
    "role_title_count": 8,
    "worksite_count": 2,
    "wage_low_min": 65000,
    "wage_high_max": 0,
    "wage_low_avg": 88545.4545454545
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 11,
    "case_count": 11,
    "role_title_count": 8,
    "worksite_count": 2,
    "wage_low_min": 62650,
    "wage_high_max": 0,
    "wage_low_avg": 82476.2727272727
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 15,
    "case_count": 15,
    "role_title_count": 11,
    "worksite_count": 2,
    "wage_low_min": 61298,
    "wage_high_max": 0,
    "wage_low_avg": 88804.4
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 14,
    "case_count": 14,
    "role_title_count": 13,
    "worksite_count": 3,
    "wage_low_min": 63128,
    "wage_high_max": 100170,
    "wage_low_avg": 80989.1428571429
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q1",
    "lca_count": 5,
    "case_count": 5,
    "role_title_count": 5,
    "worksite_count": 2,
    "wage_low_min": 75000,
    "wage_high_max": 120000,
    "wage_low_avg": 95850.8
  }
]
Links
{
  "roles": "/v1/roles?company=Automotive%20Lighting%2C%20LLC",
  "wages": "/v1/wages?company=Automotive%20Lighting%2C%20LLC",
  "trends": "/v1/trends?company=Automotive%20Lighting%2C%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=automotive+lighting+llc&limit=5JSON