Home / Companies / STERLING CONSULTING GROUP LLC
STERLING CONSULTING GROUP 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 |
|---|---|---|---|---|---|---|---|---|
| STERLING CONSULTING GROUP LLC STERLING CONSULTING GROUP LLC | 8 | 5 | 3 | FY2017 to FY2021 Latest decision 2021-03-04 | 4 | DESIGNER 2 filings | dol_oflc_lca, uscis_h1b_employer_data_hub | Profile |
Activity summary
| LCA filings | 8 |
| Certified LCAs | 8 |
| Denied LCAs | 0 |
| Role titles | 5 |
| Worksites | 3 |
| Latest decision | 2021-03-04 |
| USCIS approvals | 4 |
| USCIS denials | 0 |
Aliases and source names
| Aliases | Source Names | Sources |
|---|---|---|
| STERLING CONSULTING GROUP LLC | STERLING CONSULTING GROUP LLC | dol_oflc_lca, uscis_h1b_employer_data_hub |
Top roles
| Title | SOC | LCA filings | Low wage min | High wage max |
|---|---|---|---|---|
| DESIGNER | 27-1024 | 2 | $45,000 | $74,000 |
| Senior Director, Client Services | 11-2021.00 Marketing Managers | 2 | $130,000 | $150,000 |
| DESIGN DIRECTOR | 27-1011 | 1 | $130,862 | $0 |
| DIRECTOR, ACCOUNT SERVICES | 11-2011 | 1 | $130,000 | $150,000 |
| SENIOR DIRECTOR, CLIENT SERVICES | 11-2021 MARKETING MANAGERS | 1 | $150,000 | $170,000 |
| STRATEGIST | 13-1161 | 1 | $65,000 | $75,000 |
Top markets
| City | State | Postal Code | LCA Count | Role Title Count | Wage Low Min | Wage High Max | First Fiscal Year | Latest Fiscal Year |
|---|---|---|---|---|---|---|---|---|
| San Francisco | CA | 94111 | 4 | 4 | 54,000 | 170,000 | 2,017 | 2,019 |
| Los Angeles | CA | 90062 | 2 | 1 | 130,000 | 150,000 | 2,021 | 2,021 |
| New York | NY | 10013 | 2 | 2 | 45,000 | 75,000 | 2,017 | 2,017 |
Full company payload
| Company ID | company:sterling consulting group |
| Name | STERLING CONSULTING GROUP LLC |
| Normalized Name | sterling consulting group |
| Source Company Ids | company_dol_oflc_lca_sterling_consulting_group_llc, company_uscis_h1b_datahub_sterling_consulting_group_llc_tax_0821 |
| Source Names | STERLING CONSULTING GROUP LLC |
| Aliases | STERLING CONSULTING GROUP LLC |
| Sources | dol_oflc_lca, uscis_h1b_employer_data_hub |
Names
{
"source_names": [
"STERLING CONSULTING GROUP LLC"
],
"dba_names": [],
"name_variants": [
{
"value": "STERLING CONSULTING GROUP LLC",
"filing_count": 3,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
},
{
"value": "Sterling Consulting Group LLC",
"filing_count": 2,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"source": "dol_oflc_lca"
},
{
"value": "STERLING CONSULTING GROUP LLC",
"source": "uscis_h1b_employer_data_hub"
}
]
}Identifiers
[
{
"identifier_type": "tax_id_last_four",
"identifier_value": "0821",
"source": "uscis_h1b_employer_data_hub"
}
]LCA Activity
{
"lca_count": 8,
"case_count": 8,
"role_title_count": 5,
"worksite_count": 3,
"total_workers": 8,
"first_fiscal_year": 2017,
"first_received_date": "2017-02-14",
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-03-04",
"certified_count": 8,
"denied_count": 0,
"status_breakdown": [
{
"value": "CERTIFIED",
"filing_count": 6,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
},
{
"value": "Certified",
"filing_count": 2,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"source": "dol_oflc_lca"
}
],
"visa_class_breakdown": [
{
"value": "E-3 Australian",
"filing_count": 5,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2021,
"source": "dol_oflc_lca"
},
{
"value": "H-1B",
"filing_count": 3,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2018,
"source": "dol_oflc_lca"
}
],
"full_time_position_breakdown": [
{
"value": "Y",
"filing_count": 8,
"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": 4,
"total_denial": 0,
"fiscal_years": [
"2013",
"2015",
"2018"
],
"year_metrics": [
{
"cities": [
"New York"
],
"states": [
"NY"
],
"fiscal_year": 2013,
"naics_codes": [
"54",
"56"
],
"postal_codes": [
"10013",
"10022"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 2,
"initial_approval": 0,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_sterling_consulting_group_llc_tax_0821_2013",
"source_record_ids": [
"sr_uscis_h1b_datahub_2013_row_019945",
"sr_uscis_h1b_datahub_2013_row_019946"
],
"continuing_approval": 2
},
{
"cities": [
"New York"
],
"states": [
"NY"
],
"fiscal_year": 2015,
"naics_codes": [
"54"
],
"postal_codes": [
"10013"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 1,
"initial_approval": 0,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_sterling_consulting_group_llc_tax_0821_2015",
"source_record_ids": [
"sr_uscis_h1b_datahub_2015_row_015715"
],
"continuing_approval": 1
},
{
"cities": [
"New York"
],
"states": [
"NY"
],
"fiscal_year": 2018,
"naics_codes": [
"54"
],
"postal_codes": [
"10013"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 1,
"initial_approval": 0,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_sterling_consulting_group_llc_tax_0821_2018",
"source_record_ids": [
"sr_uscis_h1b_datahub_2018_row_015662"
],
"continuing_approval": 1
}
]
}Addresses
{
"office_addresses": [
{
"address_kind": "office",
"raw_address": "NEW YORK NY 10007",
"city": "New York",
"state": "NY",
"postal_code": "10007",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-03-04",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "office",
"raw_address": "NEW YORK NY 10013",
"city": "New York",
"state": "NY",
"postal_code": "10013",
"filing_count": 5,
"case_count": 5,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-05-30",
"source_ids": [
"dol_oflc_lca"
]
}
],
"worksite_addresses": [
{
"address_kind": "worksite",
"raw_address": "LOS ANGELES CA 90062",
"city": "Los Angeles",
"county": "Los Angeles",
"state": "CA",
"postal_code": "90062",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-03-04",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SAN FRANCISCO CA 94111",
"city": "San Francisco",
"county": "San Francisco",
"state": "CA",
"postal_code": "94111",
"filing_count": 4,
"case_count": 4,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-07-12",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "NEW YORK NY 10013",
"city": "New York",
"county": "New York",
"state": "NY",
"postal_code": "10013",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017,
"latest_decision_date": "2017-02-22",
"source_ids": [
"dol_oflc_lca"
]
}
],
"summary": {
"office_address_count": 2,
"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": [
"CA",
"NY"
],
"cities": [
"San Francisco",
"Los Angeles",
"New York"
],
"postal_codes": [
"94111",
"90062",
"10013",
"10022"
],
"top_markets": [
{
"city": "San Francisco",
"state": "CA",
"postal_code": "94111",
"lca_count": 4,
"role_title_count": 4,
"wage_low_min": 54000,
"wage_high_max": 170000,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2019
},
{
"city": "Los Angeles",
"state": "CA",
"postal_code": "90062",
"lca_count": 2,
"role_title_count": 1,
"wage_low_min": 130000,
"wage_high_max": 150000,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021
},
{
"city": "New York",
"state": "NY",
"postal_code": "10013",
"lca_count": 2,
"role_title_count": 2,
"wage_low_min": 45000,
"wage_high_max": 75000,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017
}
]
}Industry
{
"naics_codes": [
"541613",
"54",
"56"
],
"naics_breakdown": [
{
"value": "541613",
"filing_count": 8,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2021,
"source": "dol_oflc_lca"
}
]
}Wage Summary
{
"annualized_low_min": 45000,
"annualized_high_max": 170000,
"annualized_low_avg": 104357.75
}Trend
[
{
"fiscal_year": 2017,
"quarter": "Q2",
"lca_count": 3,
"case_count": 3,
"role_title_count": 3,
"worksite_count": 2,
"wage_low_min": 45000,
"wage_high_max": 150000,
"wage_low_avg": 80000
},
{
"fiscal_year": 2018,
"quarter": "Q2",
"lca_count": 2,
"case_count": 2,
"role_title_count": 2,
"worksite_count": 1,
"wage_low_min": 54000,
"wage_high_max": 74000,
"wage_low_avg": 92431
},
{
"fiscal_year": 2019,
"quarter": "Q2",
"lca_count": 1,
"case_count": 1,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 150000,
"wage_high_max": 170000,
"wage_low_avg": 150000
},
{
"fiscal_year": 2021,
"quarter": "Q2",
"lca_count": 1,
"case_count": 1,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 130000,
"wage_high_max": 150000,
"wage_low_avg": 130000
},
{
"fiscal_year": 2021,
"quarter": "Q3",
"lca_count": 1,
"case_count": 1,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 130000,
"wage_high_max": 150000,
"wage_low_avg": 130000
}
]Links
{
"roles": "/v1/roles?company=STERLING%20CONSULTING%20GROUP%20LLC",
"wages": "/v1/wages?company=STERLING%20CONSULTING%20GROUP%20LLC",
"trends": "/v1/trends?company=STERLING%20CONSULTING%20GROUP%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=sterling+consulting+group+llc&limit=5JSON