Home / Companies / Workstate Consulting LLC

Workstate Consulting 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.

Role rows Wage rows Trends

Employer	LCA filings	Role titles	Worksites	Coverage	USCIS approvals	Top role	Sources	Open
Workstate Consulting LLC WORKSTATE CONSULTING LLC	23	7	3	FY2016 to FY2021 Latest decision 2021-03-04	10	LEAD HADOOP DEVELOPER 6 filings	dol_oflc_lca, uscis_h1b_employer_data_hub	Profile

Activity summary

LCA filings	23
Certified LCAs	21
Denied LCAs	0
Role titles	7
Worksites	3
Latest decision	2021-03-04
USCIS approvals	10
USCIS denials	0

Aliases and source names

Aliases	Source Names	Sources
WORKSTATE CONSULTING LLC	Workstate Consulting LLC, WORKSTATE CONSULTING LLC	dol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

Title	SOC	LCA filings	Low wage min	High wage max
LEAD HADOOP DEVELOPER	15-1132	6	$103,979	$160,000
ASSOCIATE HADOOP DEVELOPER	15-1132	4	$63,814	$100,000
HADOOP DEVELOPER	15-1132	4	$85,000	$100,000
SENIOR HADOOP ARCHITECT	15-1132	4	$140,000	$150,000
Sr. Hadoop Developer	15-1132.00 Software Developers, Applications	2	$90,376	$110,500
Sr. Software Engineer	15-1132.00 Software Developers, Applications	2	$87,194	$110,000
SENIOR SOFTWARE ENGINEER	15-1132	1	$77,210	$105,000

Top markets

City	State	Postal Code	LCA Count	Role Title Count	Wage Low Min	Wage High Max	First Fiscal Year	Latest Fiscal Year
Columbus	OH	43215	13	7	63,814	160,000	2,016	2,021
Columbus	OH	43202	9	4	63,814	160,000	2,016	2,017
Lewis Center	OH	43035	1	1	90,376	110,500	2,020	2,020

Full company payload

Company ID	company:workstate consulting
Name	Workstate Consulting LLC
Normalized Name	workstate consulting
Source Company Ids	company_dol_oflc_lca_workstate_consulting_llc, company_uscis_h1b_datahub_workstate_consulting_llc_tax_9536
Source Names	Workstate Consulting LLC, WORKSTATE CONSULTING LLC
Aliases	WORKSTATE CONSULTING LLC
Sources	dol_oflc_lca, uscis_h1b_employer_data_hub

Identifiers

[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "9536",
    "source": "uscis_h1b_employer_data_hub"
  }
]

LCA Activity

{
  "lca_count": 23,
  "case_count": 23,
  "role_title_count": 7,
  "worksite_count": 3,
  "first_fiscal_year": 2016,
  "latest_fiscal_year": 2021,
  "latest_decision_date": "2021-03-04",
  "certified_count": 21,
  "denied_count": 0
}

Petition Activity

{
  "total_approval": 10,
  "total_denial": 0,
  "fiscal_years": [
    "2016",
    "2017",
    "2018",
    "2020",
    "2021"
  ],
  "year_metrics": [
    {
      "cities": [
        "Columbus"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "51"
      ],
      "postal_codes": [
        "43215"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_workstate_consulting_llc_tax_9536_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_008172"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Columbus"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "51"
      ],
      "postal_codes": [
        "43215"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_workstate_consulting_llc_tax_9536_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_007348"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Columbus"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "51"
      ],
      "postal_codes": [
        "43215"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_workstate_consulting_llc_tax_9536_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_007772"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Columbus"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "51"
      ],
      "postal_codes": [
        "43215"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_workstate_consulting_llc_tax_9536_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_054171"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Columbus"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "51"
      ],
      "postal_codes": [
        "43215"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_workstate_consulting_llc_tax_9536_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_059595"
      ],
      "continuing_approval": 1
    }
  ]
}

Geography

{
  "states": [
    "OH"
  ],
  "cities": [
    "Columbus",
    "Lewis Center"
  ],
  "postal_codes": [
    "43215",
    "43202",
    "43035"
  ],
  "top_markets": [
    {
      "city": "Columbus",
      "state": "OH",
      "postal_code": "43215",
      "lca_count": 13,
      "role_title_count": 7,
      "wage_low_min": 63814,
      "wage_high_max": 160000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2021
    },
    {
      "city": "Columbus",
      "state": "OH",
      "postal_code": "43202",
      "lca_count": 9,
      "role_title_count": 4,
      "wage_low_min": 63814,
      "wage_high_max": 160000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Lewis Center",
      "state": "OH",
      "postal_code": "43035",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 90376,
      "wage_high_max": 110500,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020
    }
  ]
}

Industry

{
  "naics_codes": [
    "511210",
    "51"
  ]
}

Wage Summary

{
  "annualized_low_min": 63814,
  "annualized_high_max": 160000,
  "annualized_low_avg": 100700.869565217
}

Trend

[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 6,
    "case_count": 6,
    "role_title_count": 3,
    "worksite_count": 2,
    "wage_low_min": 85000,
    "wage_high_max": 150000,
    "wage_low_avg": 118333.333333333
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 13,
    "case_count": 13,
    "role_title_count": 5,
    "worksite_count": 2,
    "wage_low_min": 63814,
    "wage_high_max": 160000,
    "wage_low_avg": 96229.2307692308
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q4",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 2,
    "wage_low_min": 90376,
    "wage_high_max": 110500,
    "wage_low_avg": 90376
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 87194,
    "wage_high_max": 110000,
    "wage_low_avg": 87194
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 87194,
    "wage_high_max": 110000,
    "wage_low_avg": 87194
  }
]

Links

{
  "roles": "/v1/roles?company=Workstate%20Consulting%20LLC",
  "wages": "/v1/wages?company=Workstate%20Consulting%20LLC",
  "trends": "/v1/trends?company=Workstate%20Consulting%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=workstate+consulting+llc&limit=5JSON

Docs · Get an API key