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

Home / Companies / CRESTTEK LLC

CRESTTEK 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
CRESTTEK LLC
CRESTTEK LLC
2933422FY2016 to FY2020
Latest decision 2020-01-21
194MECHANICAL ENGINEER
95 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings293
Certified LCAs289
Denied LCAs1
Role titles34
Worksites22
Latest decision2020-01-21
USCIS approvals194
USCIS denials24

Aliases and source names

AliasesSource NamesSources
CRESTTEK LLCCRESTTEK LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
MECHANICAL ENGINEER17-2141
MECHANICAL ENGINEERS
95$60,000$80,000
DESIGN ENGINEER17-2141
MECHANICAL ENGINEERS
59$61,000$89,000
CAE ENGINEER17-2141
MECHANICAL ENGINEERS
43$70,000$88,000
ELECTRICAL ENGINEER17-2071
ELECTRICAL ENGINEERS
22$61,700$100,000
PRODUCT ENGINEER17-214112$73,000$0
SENIOR DESIGN ENGINEER17-2141
MECHANICAL ENGINEERS
5$90,000$90,000
INTERACTION DESIGNER 217-20714$61,700$0
PRODUCT ENGINEER17-20714$80,000$0
CAE Engineer L317-2141.00
Mechanical Engineers
3$115,000$115,000
EMBEDDED SOFTWARE ENGINEER17-20723$86,000$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
RaymondOH43067991560,000115,0002,0162,020
DublinOH4301778670,00002,0162,018
WarrenMI4809326562,37978,4782,0162,019
Farmington HillsMI4833116375,00089,0002,0162,020
NoviMI4837713473,00002,0172,018
WarrenMI480909361,70002,0162,018
MilfordMI483807461,70002,0162,017
TroyMI480847378,47802,0172,018
WarrenMI480926370,00002,0162,018
Auburn HillsMI483265485,00095,0002,0182,020

Full company payload

Company IDcompany:cresttek
NameCRESTTEK LLC
Normalized Namecresttek
Source Company Idscompany_dol_oflc_lca_cresttek_llc, company_uscis_h1b_datahub_cresttek_llc_tax_1987
Source NamesCRESTTEK LLC
AliasesCRESTTEK LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "1987",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 293,
  "case_count": 293,
  "role_title_count": 34,
  "worksite_count": 22,
  "first_fiscal_year": 2016,
  "latest_fiscal_year": 2020,
  "latest_decision_date": "2020-01-21",
  "certified_count": 289,
  "denied_count": 1
}
Petition Activity
{
  "total_approval": 194,
  "total_denial": 24,
  "fiscal_years": [
    "2014",
    "2015",
    "2016",
    "2017",
    "2018",
    "2019",
    "2020"
  ],
  "year_metrics": [
    {
      "cities": [
        "Sterling Heights",
        "Troy"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "54",
        "56"
      ],
      "postal_codes": [
        "48083",
        "48313"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 14,
      "initial_approval": 7,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_cresttek_llc_tax_1987_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_027416",
        "sr_uscis_h1b_datahub_2014_row_027417",
        "sr_uscis_h1b_datahub_2014_row_027418"
      ],
      "continuing_approval": 7
    },
    {
      "cities": [
        "Dublin",
        "Sterling Heights"
      ],
      "states": [
        "MI",
        "OH"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "54",
        "56"
      ],
      "postal_codes": [
        "43017",
        "48313"
      ],
      "total_denial": 4,
      "initial_denial": 1,
      "total_approval": 45,
      "initial_approval": 25,
      "continuing_denial": 3,
      "petition_count_id": "petition_count_uscis_h1b_archive_cresttek_llc_tax_1987_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_022270",
        "sr_uscis_h1b_datahub_2015_row_022271",
        "sr_uscis_h1b_datahub_2015_row_022272"
      ],
      "continuing_approval": 20
    },
    {
      "cities": [
        "Dublin",
        "Sterling Heights"
      ],
      "states": [
        "MI",
        "OH"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "43017",
        "48313"
      ],
      "total_denial": 2,
      "initial_denial": 2,
      "total_approval": 43,
      "initial_approval": 30,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_cresttek_llc_tax_1987_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_023229",
        "sr_uscis_h1b_datahub_2016_row_023230"
      ],
      "continuing_approval": 13
    },
    {
      "cities": [
        "Dublin"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "43017"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 31,
      "initial_approval": 9,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_cresttek_llc_tax_1987_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_020734"
      ],
      "continuing_approval": 22
    },
    {
      "cities": [
        "Dublin"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "43017"
      ],
      "total_denial": 4,
      "initial_denial": 0,
      "total_approval": 27,
      "initial_approval": 3,
      "continuing_denial": 4,
      "petition_count_id": "petition_count_uscis_h1b_archive_cresttek_llc_tax_1987_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_022536"
      ],
      "continuing_approval": 24
    },
    {
      "cities": [
        "Dublin"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "43017"
      ],
      "total_denial": 10,
      "initial_denial": 6,
      "total_approval": 20,
      "initial_approval": 2,
      "continuing_denial": 4,
      "petition_count_id": "petition_count_uscis_h1b_archive_cresttek_llc_tax_1987_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_022495"
      ],
      "continuing_approval": 18
    },
    {
      "cities": [
        "Dublin"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "43017"
      ],
      "total_denial": 3,
      "initial_denial": 3,
      "total_approval": 14,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_cresttek_llc_tax_1987_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_012281"
      ],
      "continuing_approval": 14
    }
  ]
}
Geography
{
  "states": [
    "OH",
    "MI",
    "NC",
    "CA",
    "IN",
    "MA"
  ],
  "cities": [
    "Raymond",
    "Dublin",
    "Warren",
    "Farmington Hills",
    "Novi",
    "Milford",
    "Troy",
    "Auburn Hills",
    "Dearborn",
    "Greensboro",
    "Plymouth",
    "Irvine",
    "Marysville",
    "Columbus",
    "Canton",
    "Bingham Farms",
    "Pontiac",
    "Sterling Heights"
  ],
  "postal_codes": [
    "43067",
    "43017",
    "48093",
    "48331",
    "48377",
    "48090",
    "48380",
    "48084",
    "48092",
    "48326",
    "48124",
    "27409",
    "48170",
    "92618",
    "43040",
    "47201",
    "02021",
    "48025",
    "48340",
    "48083",
    "43212",
    "48313"
  ],
  "top_markets": [
    {
      "city": "Raymond",
      "state": "OH",
      "postal_code": "43067",
      "lca_count": 99,
      "role_title_count": 15,
      "wage_low_min": 60000,
      "wage_high_max": 115000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2020
    },
    {
      "city": "Dublin",
      "state": "OH",
      "postal_code": "43017",
      "lca_count": 78,
      "role_title_count": 6,
      "wage_low_min": 70000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Warren",
      "state": "MI",
      "postal_code": "48093",
      "lca_count": 26,
      "role_title_count": 5,
      "wage_low_min": 62379,
      "wage_high_max": 78478,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Farmington Hills",
      "state": "MI",
      "postal_code": "48331",
      "lca_count": 16,
      "role_title_count": 3,
      "wage_low_min": 75000,
      "wage_high_max": 89000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2020
    },
    {
      "city": "Novi",
      "state": "MI",
      "postal_code": "48377",
      "lca_count": 13,
      "role_title_count": 4,
      "wage_low_min": 73000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Warren",
      "state": "MI",
      "postal_code": "48090",
      "lca_count": 9,
      "role_title_count": 3,
      "wage_low_min": 61700,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Milford",
      "state": "MI",
      "postal_code": "48380",
      "lca_count": 7,
      "role_title_count": 4,
      "wage_low_min": 61700,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Troy",
      "state": "MI",
      "postal_code": "48084",
      "lca_count": 7,
      "role_title_count": 3,
      "wage_low_min": 78478,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Warren",
      "state": "MI",
      "postal_code": "48092",
      "lca_count": 6,
      "role_title_count": 3,
      "wage_low_min": 70000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Auburn Hills",
      "state": "MI",
      "postal_code": "48326",
      "lca_count": 5,
      "role_title_count": 4,
      "wage_low_min": 85000,
      "wage_high_max": 95000,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2020
    }
  ]
}
Industry
{
  "naics_codes": [
    "541330",
    "54",
    "56"
  ]
}
Wage Summary
{
  "annualized_low_min": 58157,
  "annualized_high_max": 115000,
  "annualized_low_avg": 76531.1979522184
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 117,
    "case_count": 117,
    "role_title_count": 14,
    "worksite_count": 10,
    "wage_low_min": 58157,
    "wage_high_max": 0,
    "wage_low_avg": 71195.3760683761
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 53,
    "case_count": 53,
    "role_title_count": 10,
    "worksite_count": 13,
    "wage_low_min": 61700,
    "wage_high_max": 0,
    "wage_low_avg": 73649.9433962264
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 89,
    "case_count": 89,
    "role_title_count": 14,
    "worksite_count": 12,
    "wage_low_min": 65000,
    "wage_high_max": 0,
    "wage_low_avg": 81918.1348314607
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 22,
    "case_count": 22,
    "role_title_count": 9,
    "worksite_count": 9,
    "wage_low_min": 67200,
    "wage_high_max": 100000,
    "wage_low_avg": 81740.4090909091
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q1",
    "lca_count": 8,
    "case_count": 8,
    "role_title_count": 7,
    "worksite_count": 5,
    "wage_low_min": 73000,
    "wage_high_max": 115000,
    "wage_low_avg": 88541
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 3,
    "worksite_count": 1,
    "wage_low_min": 73000,
    "wage_high_max": 115000,
    "wage_low_avg": 98251
  }
]
Links
{
  "roles": "/v1/roles?company=CRESTTEK%20LLC",
  "wages": "/v1/wages?company=CRESTTEK%20LLC",
  "trends": "/v1/trends?company=CRESTTEK%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=cresttek+llc&limit=5JSON