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

Home / Companies / SPHERE CONSULTING INC.

SPHERE CONSULTING INC. 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
SPHERE CONSULTING INC.
SPHERE CONSULTING INC
1784FY2016 to FY2021
Latest decision 2021-08-06
44RUBY ON RAILS DEVELOPER
4 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings17
Certified LCAs17
Denied LCAs0
Role titles8
Worksites4
Latest decision2021-08-06
USCIS approvals44
USCIS denials5

Aliases and source names

AliasesSource NamesSources
SPHERE CONSULTING INCSPHERE CONSULTING INC., SPHERE CONSULTING INCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
RUBY ON RAILS DEVELOPER15-1132
SOFTWARE DEVELOPERS, APPLICATIONS
4$60,000$100,000
SENIOR SOFTWARE DEVELOPER15-1132.00
Software Developers, Applications
3$87,838$150,000
PYTHON DEVELOPER15-11322$60,000$100,000
SENIOR SOFTWARE DEVELOPER15-11322$80,912$100,000
AUTOMATION QUALITY ASSURANCE ANALYST15-11211$60,000$90,000
SENIOR PROGRAMMER ANALYST15-11211$76,000$100,000
SENIOR QA ANALYST15-11321$83,366$100,000
SENIOR RUBY ON RAILS DEVELOPER15-1132.00
Software Developers, Applications
1$82,000$125,000
SENIOR SOFTWARE DEVELOPER15-11331$83,366$100,000
SOFTWARE DEVELOPER15-11321$60,000$90,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
ChicagoIL606068581,000150,0002,0182,021
ChicagoIL606075460,00090,0002,0162,017
ChicagoIL606043276,000100,0002,0172,018
ChicagoIL606011180,912100,0002,0182,018

Full company payload

Company IDcompany:sphere consulting
NameSPHERE CONSULTING INC.
Normalized Namesphere consulting
Source Company Idscompany_dol_oflc_lca_sphere_consulting_inc, company_uscis_h1b_datahub_sphere_consulting_inc_tax_3208
Source NamesSPHERE CONSULTING INC., SPHERE CONSULTING INC
AliasesSPHERE CONSULTING INC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "SPHERE CONSULTING INC.",
    "SPHERE CONSULTING INC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "SPHERE CONSULTING INC.",
      "filing_count": 13,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "SPHERE CONSULTING, INC.",
      "filing_count": 4,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "SPHERE CONSULTING INC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "3208",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 17,
  "case_count": 17,
  "role_title_count": 8,
  "worksite_count": 4,
  "total_workers": 52,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-03-17",
  "latest_fiscal_year": 2021,
  "latest_decision_date": "2021-08-06",
  "certified_count": 17,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 13,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 4,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 17,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 16,
      "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": 44,
  "total_denial": 5,
  "fiscal_years": [
    "2010",
    "2011",
    "2012",
    "2013",
    "2014",
    "2015",
    "2016",
    "2017",
    "2018",
    "2019",
    "2020",
    "2021",
    "2022"
  ],
  "year_metrics": [
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2010,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sphere_consulting_inc_tax_3208_2010",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2010_row_022517"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2011,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 4,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sphere_consulting_inc_tax_3208_2011",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2011_row_024732"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 4,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sphere_consulting_inc_tax_3208_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_021560"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 4,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sphere_consulting_inc_tax_3208_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_020169"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 2,
      "initial_denial": 1,
      "total_approval": 6,
      "initial_approval": 3,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_sphere_consulting_inc_tax_3208_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_019814"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sphere_consulting_inc_tax_3208_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_015922"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60606"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 3,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_sphere_consulting_inc_tax_3208_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_016515"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60607"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 5,
      "initial_approval": 4,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sphere_consulting_inc_tax_3208_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_014769"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60607"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sphere_consulting_inc_tax_3208_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_015837"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Chicago",
        "Northbrook"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60062",
        "60607"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 5,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sphere_consulting_inc_tax_3208_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_015679",
        "sr_uscis_h1b_datahub_2019_row_015680"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "Northbrook"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60062"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sphere_consulting_inc_tax_3208_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_044965"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Northbrook"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60062"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sphere_consulting_inc_tax_3208_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_049051"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Northbrook"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60062"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_sphere_consulting_inc_tax_3208_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_048623"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "NORTHBROOK IL 60062",
      "city": "Northbrook",
      "state": "IL",
      "postal_code": "60062",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-08-06",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "CHICAGO IL 60607",
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60607",
      "filing_count": 12,
      "case_count": 12,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-07-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "CHICAGO IL 60606",
      "city": "Chicago",
      "county": "Cook",
      "state": "IL",
      "postal_code": "60606",
      "filing_count": 8,
      "case_count": 8,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-08-06",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CHICAGO IL 60604",
      "city": "Chicago",
      "county": "Cook",
      "state": "IL",
      "postal_code": "60604",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-05-01",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CHICAGO IL 60601",
      "city": "Chicago",
      "county": "Cook",
      "state": "IL",
      "postal_code": "60601",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-07-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CHICAGO IL 60607",
      "city": "Chicago",
      "county": "Cook",
      "state": "IL",
      "postal_code": "60607",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "worksite_address_count": 4,
    "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": [
    "IL"
  ],
  "cities": [
    "Chicago",
    "Northbrook"
  ],
  "postal_codes": [
    "60606",
    "60607",
    "60604",
    "60601",
    "60062"
  ],
  "top_markets": [
    {
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60606",
      "lca_count": 8,
      "role_title_count": 5,
      "wage_low_min": 81000,
      "wage_high_max": 150000,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021
    },
    {
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60607",
      "lca_count": 5,
      "role_title_count": 4,
      "wage_low_min": 60000,
      "wage_high_max": 90000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60604",
      "lca_count": 3,
      "role_title_count": 2,
      "wage_low_min": 76000,
      "wage_high_max": 100000,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60601",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 80912,
      "wage_high_max": 100000,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    }
  ]
}
Industry
{
  "naics_codes": [
    "5416",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541512",
      "filing_count": 12,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "5416",
      "filing_count": 4,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 60000,
  "annualized_high_max": 150000,
  "annualized_low_avg": 76671.6470588235
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 60000,
    "wage_high_max": 90000,
    "wage_low_avg": 60000
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 5,
    "case_count": 5,
    "role_title_count": 5,
    "worksite_count": 2,
    "wage_low_min": 60000,
    "wage_high_max": 100000,
    "wage_low_avg": 63200
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 6,
    "case_count": 6,
    "role_title_count": 4,
    "worksite_count": 3,
    "wage_low_min": 80912,
    "wage_high_max": 100000,
    "wage_low_avg": 82957
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 81000,
    "wage_high_max": 90000,
    "wage_low_avg": 81000
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 82000,
    "wage_high_max": 125000,
    "wage_low_avg": 82000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 87838,
    "wage_high_max": 125000,
    "wage_low_avg": 87838
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q4",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 87838,
    "wage_high_max": 150000,
    "wage_low_avg": 89419
  }
]
Links
{
  "roles": "/v1/roles?company=SPHERE%20CONSULTING%20INC.",
  "wages": "/v1/wages?company=SPHERE%20CONSULTING%20INC.",
  "trends": "/v1/trends?company=SPHERE%20CONSULTING%20INC."
}
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=sphere+consulting+inc&limit=5JSON