Does Workstate Consulting LLC sponsor H-1B visas?

Yes. Workstate Consulting LLC filed 23 H-1B labor condition applications with the U.S. Department of Labor (FY2016-FY2021), of which 21 were certified. LCA filings are labor-condition applications certified by the U.S. Department of Labor, not active job postings or approved USCIS H-1B petitions.

How many H-1B applications has Workstate Consulting LLC filed?

Workstate Consulting LLC has 23 H-1B LCA filings on record spanning FY2016-FY2021 across 7 role titles and 3 worksites.

What roles does Workstate Consulting LLC sponsor for H-1B?

The most common H-1B role at Workstate Consulting LLC is Lead Hadoop Developer (6 filings). Other frequent roles include Associate Hadoop Developer, Hadoop Developer, Senior Hadoop Architect, Sr. Hadoop Developer.

What wages does Workstate Consulting LLC offer H-1B workers?

For its most-sponsored role (Lead Hadoop Developer), Workstate Consulting LLC reported offered wages ranging from $103,979 to $160,000 in DOL LCA filings.

Home / Companies / Workstate Consulting LLC

Workstate Consulting LLC H-1B company data

Name: Workstate Consulting LLC H-1B / LCA filings
Creator: bluedoor

Summary

Workstate Consulting LLC filed 23 H-1B labor condition applications (LCAs) with the U.S. Department of Labor between FY2016-FY2021.

Of those, 21 were certified (a 100% certification rate among adjudicated filings).

The filings span 7 distinct role titles across 3 worksites.

The most-sponsored role was Lead Hadoop Developer (6 filings), with offered wages from $103,979 to $160,000.

Separately, USCIS H-1B Employer Data Hub records show 10 approved and 0 denied H-1B petitions for this employer.

LCA filings are labor-condition applications certified by the U.S. Department of Labor, not active job postings or approved USCIS H-1B petitions.

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

Names

{
  "source_names": [
    "Workstate Consulting LLC",
    "WORKSTATE CONSULTING LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "WORKSTATE CONSULTING LLC",
      "filing_count": 19,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Workstate Consulting LLC",
      "filing_count": 4,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "WORKSTATE CONSULTING LLC",
      "source": "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,
  "total_workers": 23,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-03-17",
  "latest_fiscal_year": 2021,
  "latest_decision_date": "2021-03-04",
  "certified_count": 21,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 17,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 4,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "WITHDRAWN",
      "filing_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 23,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 17,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ]
}

Petition Activity

{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "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
    }
  ]
}

Addresses

{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "COLUMBUS OH 43215",
      "city": "Columbus",
      "state": "OH",
      "postal_code": "43215",
      "filing_count": 23,
      "case_count": 23,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-03-04",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "COLUMBUS OH 43215",
      "city": "Columbus",
      "county": "Franklin",
      "state": "OH",
      "postal_code": "43215",
      "filing_count": 13,
      "case_count": 13,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-03-04",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "LEWIS CENTER OH 43035",
      "city": "Lewis Center",
      "county": "Delaware",
      "state": "OH",
      "postal_code": "43035",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-07-09",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "COLUMBUS OH 43202",
      "city": "Columbus",
      "county": "Franklin",
      "state": "OH",
      "postal_code": "43202",
      "filing_count": 9,
      "case_count": 9,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-08-22",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 1,
    "worksite_address_count": 3,
    "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": [
    "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"
  ],
  "naics_breakdown": [
    {
      "value": "51121",
      "filing_count": 13,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "511210",
      "filing_count": 4,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ]
}

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"
}

Frequently asked questions

Does Workstate Consulting LLC sponsor H-1B visas?: Yes. Workstate Consulting LLC filed 23 H-1B labor condition applications with the U.S. Department of Labor (FY2016-FY2021), of which 21 were certified. LCA filings are labor-condition applications certified by the U.S. Department of Labor, not active job postings or approved USCIS H-1B petitions.
How many H-1B applications has Workstate Consulting LLC filed?: Workstate Consulting LLC has 23 H-1B LCA filings on record spanning FY2016-FY2021 across 7 role titles and 3 worksites.
What roles does Workstate Consulting LLC sponsor for H-1B?: The most common H-1B role at Workstate Consulting LLC is Lead Hadoop Developer (6 filings). Other frequent roles include Associate Hadoop Developer, Hadoop Developer, Senior Hadoop Architect, Sr. Hadoop Developer.
What wages does Workstate Consulting LLC offer H-1B workers?: For its most-sponsored role (Lead Hadoop Developer), Workstate Consulting LLC reported offered wages ranging from $103,979 to $160,000 in DOL LCA filings.

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