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

Home / Companies / SJ CONSULTING GROUP INC.

SJ CONSULTING GROUP 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
SJ CONSULTING GROUP INC.
SJ CONSULTING GROUP INC
1234FY2017 to FY2024
Latest decision 2024-05-14
1DATA ANALYST
4 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings12
Certified LCAs11
Denied LCAs1
Role titles3
Worksites4
Latest decision2024-05-14
USCIS approvals1
USCIS denials3

Aliases and source names

AliasesSource NamesSources
SJ CONSULTING GROUP INCSJ CONSULTING GROUP INC., SJ CONSULTING GROUP INCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
DATA ANALYST15-1199
COMPUTER OCCUPATIONS, ALL OTHER
4$48,000$54,995
MANAGEMENT ANALYSTS13-11114$47,216$0
DATA ANALYST13-1111
MANAGEMENT ANALYSTS
2$48,859$49,200
Data Administrator15-1242.00
Database Administrators
1$58,800$58,800
DATA ANALYST15-20311$41,756$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
SewickleyPA151435241,75602,0172,018
WarrendalePA150864148,00049,2002,0192,019
HoustonTX770432154,99554,9952,0192,019
WarrendalePA15086-75271158,80058,8002,0242,024

Full company payload

Company IDcompany:sj consulting group
NameSJ CONSULTING GROUP INC.
Normalized Namesj consulting group
Source Company Idscompany_dol_oflc_lca_sj_consulting_group_inc, company_uscis_h1b_datahub_sj_consulting_group_inc_tax_4953
Source NamesSJ CONSULTING GROUP INC., SJ CONSULTING GROUP INC
AliasesSJ CONSULTING GROUP INC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "SJ CONSULTING GROUP INC.",
    "SJ CONSULTING GROUP INC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "SJ CONSULTING GROUP INC.",
      "filing_count": 10,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "SJ CONSULTING GROUP INC",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "SJ Consulting Group Inc.",
      "filing_count": 1,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "SJ CONSULTING GROUP INC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "4953",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 12,
  "case_count": 12,
  "role_title_count": 3,
  "worksite_count": 4,
  "total_workers": 13,
  "first_fiscal_year": 2017,
  "first_received_date": "2017-03-24",
  "latest_fiscal_year": 2024,
  "latest_decision_date": "2024-05-14",
  "certified_count": 11,
  "denied_count": 1,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 10,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 1,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "DENIED",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 12,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 12,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 1,
  "total_denial": 3,
  "fiscal_years": [
    "2019"
  ],
  "year_metrics": [
    {
      "cities": [
        "Sewickley",
        "Warrendale"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "15086",
        "15143"
      ],
      "total_denial": 3,
      "initial_denial": 3,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sj_consulting_group_inc_tax_4953_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_012818",
        "sr_uscis_h1b_datahub_2019_row_012819"
      ],
      "continuing_approval": 0
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "WARRENDALE PA 15086-7527",
      "city": "Warrendale",
      "state": "PA",
      "postal_code": "15086-7527",
      "filing_count": 7,
      "case_count": 7,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-05-14",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "SEWICKLEY PA 15143",
      "city": "Sewickley",
      "state": "PA",
      "postal_code": "15143",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "WARRENDALE PA 15086-7527",
      "city": "Warrendale",
      "county": "Allegheny",
      "state": "PA",
      "postal_code": "15086-7527",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-05-14",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "WARRENDALE PA 15086",
      "city": "Warrendale",
      "county": "Butler",
      "state": "PA",
      "postal_code": "15086",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "HOUSTON TX 77043",
      "city": "Houston",
      "county": "Harris",
      "state": "TX",
      "postal_code": "77043",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SEWICKLEY PA 15143",
      "city": "Sewickley",
      "county": "Allegheny",
      "state": "PA",
      "postal_code": "15143",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-26",
      "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": [
    "PA",
    "TX"
  ],
  "cities": [
    "Sewickley",
    "Warrendale",
    "Houston"
  ],
  "postal_codes": [
    "15143",
    "15086",
    "77043",
    "15086-7527"
  ],
  "top_markets": [
    {
      "city": "Sewickley",
      "state": "PA",
      "postal_code": "15143",
      "lca_count": 5,
      "role_title_count": 2,
      "wage_low_min": 41756,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Warrendale",
      "state": "PA",
      "postal_code": "15086",
      "lca_count": 4,
      "role_title_count": 1,
      "wage_low_min": 48000,
      "wage_high_max": 49200,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Houston",
      "state": "TX",
      "postal_code": "77043",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 54995,
      "wage_high_max": 54995,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Warrendale",
      "state": "PA",
      "postal_code": "15086-7527",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 58800,
      "wage_high_max": 58800,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024
    }
  ]
}
Industry
{
  "naics_codes": [
    "541614",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541614",
      "filing_count": 12,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 41756,
  "annualized_high_max": 58800,
  "annualized_low_avg": 49555.75
}
Trend
[
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 41756,
    "wage_high_max": 0,
    "wage_low_avg": 41756
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 47216,
    "wage_high_max": 0,
    "wage_low_avg": 47216
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 6,
    "case_count": 6,
    "role_title_count": 1,
    "worksite_count": 2,
    "wage_low_min": 48000,
    "wage_high_max": 54995,
    "wage_low_avg": 50874.8333333333
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 58800,
    "wage_high_max": 58800,
    "wage_low_avg": 58800
  }
]
Links
{
  "roles": "/v1/roles?company=SJ%20CONSULTING%20GROUP%20INC.",
  "wages": "/v1/wages?company=SJ%20CONSULTING%20GROUP%20INC.",
  "trends": "/v1/trends?company=SJ%20CONSULTING%20GROUP%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=sj+consulting+group+inc&limit=5JSON