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