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

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.

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
STERLING CONSULTING GROUP LLC
STERLING CONSULTING GROUP LLC
853FY2017 to FY2021
Latest decision 2021-03-04
4DESIGNER
2 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings8
Certified LCAs8
Denied LCAs0
Role titles5
Worksites3
Latest decision2021-03-04
USCIS approvals4
USCIS denials0

Aliases and source names

AliasesSource NamesSources
STERLING CONSULTING GROUP LLCSTERLING CONSULTING GROUP LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
DESIGNER27-10242$45,000$74,000
Senior Director, Client Services11-2021.00
Marketing Managers
2$130,000$150,000
DESIGN DIRECTOR27-10111$130,862$0
DIRECTOR, ACCOUNT SERVICES11-20111$130,000$150,000
SENIOR DIRECTOR, CLIENT SERVICES11-2021
MARKETING MANAGERS
1$150,000$170,000
STRATEGIST13-11611$65,000$75,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
San FranciscoCA941114454,000170,0002,0172,019
Los AngelesCA9006221130,000150,0002,0212,021
New YorkNY100132245,00075,0002,0172,017

Full company payload

Company IDcompany:sterling consulting group
NameSTERLING CONSULTING GROUP LLC
Normalized Namesterling consulting group
Source Company Idscompany_dol_oflc_lca_sterling_consulting_group_llc, company_uscis_h1b_datahub_sterling_consulting_group_llc_tax_0821
Source NamesSTERLING CONSULTING GROUP LLC
AliasesSTERLING CONSULTING GROUP LLC
Sourcesdol_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