Home / Companies / IDEAL CONSULT LLC.

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

Role rows Wage rows Trends

Employer	LCA filings	Role titles	Worksites	Coverage	USCIS approvals	Top role	Sources	Open
IDEAL CONSULT LLC. IDEAL CONSULT LLC	54	26	22	FY2016 to FY2025 Latest decision 2025-08-21	38	CLINICAL SAS PROGRAMMER 6 filings	dol_oflc_lca, uscis_h1b_employer_data_hub	Profile

Activity summary

LCA filings	54
Certified LCAs	54
Denied LCAs	0
Role titles	26
Worksites	22
Latest decision	2025-08-21
USCIS approvals	38
USCIS denials	20

Aliases and source names

Aliases	Source Names	Sources
IDEAL CONSULT LLC	IDEAL CONSULT LLC., IDEAL CONSULT LLC	dol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

Title	SOC	LCA filings	Low wage min	High wage max
CLINICAL SAS PROGRAMMER	15-2041 Statisticians	6	$73,798	$108,160
CLINICAL SAS PROGRAMMER	15-2041.00 Statisticians	3	$108,160	$116,840
LEAD SAS PROGRAMMER	15-2041.00 Statisticians	3	$141,440	$141,440
SENIOR SAS PROGRAMMER	43-9111.00 Statistical Assistants	3	$92,000	$92,000
SOFTWARE DEVELOPER	15-1252.00 Software Developers	3	$110,240	$124,800
BUSINESS ANALYST	15-1121	2	$60,000	$80,000
DEVELOPER/ANALYST	15-1132	2	$70,000	$90,000
IT ENGINEER IV (SR. SAS DATA ANALYTICS)	15-1199.07 Data Warehousing Specialists	2	$105,000	$118,560
SAS PROGRAMMER	15-2041.00 Statisticians	2	$141,440	$141,440
SAS PROGRAMMER	43-9111.00 Statistical Assistants	2	$141,440	$141,440

Top markets

City	State	Postal Code	LCA Count	Role Title Count	Wage Low Min	Wage High Max	First Fiscal Year	Latest Fiscal Year
King Of Prussia	PA	19406	11	10	65,000	100,000	2,016	2,019
Cypress	TX	77433	9	2	141,440	141,440	2,021	2,024
Elkridge	MD	21075	5	1	82,000	108,160	2,018	2,021
Canton	MI	48187	4	2	65,354	90,000	2,016	2,018
Dallas	TX	75235	4	2	124,800	124,800	2,022	2,023
Frisco	TX	75035	4	2	92,000	92,000	2,018	2,023
Wilmington	DE	19807	2	1	87,000	99,840	2,019	2,020
Azusa	CA	91702	1	1	133,120	133,120	2,024	2,024
District Of Columbia	DC	20005	1	1	118,560	118,560	2,020	2,020
Washington	DC	20005	1	1	105,000	105,000	2,020	2,020

Full company payload

Company ID	company:ideal consult
Name	IDEAL CONSULT LLC.
Normalized Name	ideal consult
Source Company Ids	company_dol_oflc_lca_ideal_consult_llc, company_uscis_h1b_datahub_ideal_consult_llc_tax_4845, company_uscis_h1b_datahub_ideal_consult_llc_tax_5024
Source Names	IDEAL CONSULT LLC., IDEAL CONSULT LLC
Aliases	IDEAL CONSULT LLC
Sources	dol_oflc_lca, uscis_h1b_employer_data_hub

Identifiers

[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "4845",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5024",
    "source": "uscis_h1b_employer_data_hub"
  }
]

LCA Activity

{
  "lca_count": 54,
  "case_count": 54,
  "role_title_count": 26,
  "worksite_count": 22,
  "first_fiscal_year": 2016,
  "latest_fiscal_year": 2025,
  "latest_decision_date": "2025-08-21",
  "certified_count": 54,
  "denied_count": 0
}

Petition Activity

{
  "total_approval": 38,
  "total_denial": 20,
  "fiscal_years": [
    "2009",
    "2010",
    "2011",
    "2012",
    "2013",
    "2014",
    "2015",
    "2016",
    "2017",
    "2018",
    "2019",
    "2020",
    "2021",
    "2022",
    "2023"
  ],
  "year_metrics": [
    {
      "cities": [
        "King Of Prussia"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2009,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "19406"
      ],
      "total_denial": 3,
      "initial_denial": 3,
      "total_approval": 2,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ideal_consult_llc_tax_4845_2009",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2009_row_026740"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "King Of Prussia"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2010,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "19406"
      ],
      "total_denial": 3,
      "initial_denial": 3,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ideal_consult_llc_tax_4845_2010",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2010_row_020471"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "King Of Prussia"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2011,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "19406"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ideal_consult_llc_tax_4845_2011",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2011_row_022349"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "King Of Prussia"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "19406"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ideal_consult_llc_tax_4845_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_019313"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "King Of Prussia"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "19406"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 4,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ideal_consult_llc_tax_4845_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_018096"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "King Of Prussia"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "19406"
      ],
      "total_denial": 2,
      "initial_denial": 2,
      "total_approval": 8,
      "initial_approval": 4,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ideal_consult_llc_tax_4845_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_017706",
        "sr_uscis_h1b_datahub_2014_row_017731"
      ],
      "continuing_approval": 4
    },
    {
      "cities": [
        "King Of Prussia"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "19406"
      ],
      "total_denial": 2,
      "initial_denial": 1,
      "total_approval": 4,
      "initial_approval": 1,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_ideal_consult_llc_tax_4845_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_014139"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "Chester Springs",
        "East Brunswick",
        "King Of Prussia"
      ],
      "states": [
        "NJ",
        "PA"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "08816",
        "19406",
        "19425"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 3,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ideal_consult_llc_tax_4845_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_014757",
        "sr_uscis_h1b_datahub_2016_row_014758",
        "sr_uscis_h1b_datahub_2016_row_014759"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "East Brunswick",
        "King Of Prussia"
      ],
      "states": [
        "NJ",
        "PA"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "08816",
        "19406"
      ],
      "total_denial": 2,
      "initial_denial": 1,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_ideal_consult_llc_tax_4845_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_013206",
        "sr_uscis_h1b_datahub_2017_row_013207"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "East Brunswick",
        "King Of Prussia"
      ],
      "states": [
        "NJ",
        "PA"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "08816",
        "19406"
      ],
      "total_denial": 2,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 2,
      "petition_count_id": "petition_count_uscis_h1b_archive_ideal_consult_llc_tax_4845_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_014113",
        "sr_uscis_h1b_datahub_2018_row_014114"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "King Of Prussia"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "19406"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ideal_consult_llc_tax_4845_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_014042"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "King Of Prussia"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "19406"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ideal_consult_llc_tax_4845_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_023356"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "King Of Prussia"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "19406"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 5,
      "initial_approval": 2,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_ideal_consult_llc_tax_4845_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_025362"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "King Of Prussia"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "19406"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ideal_consult_llc_tax_4845_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_025302"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "King Of Prussia"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2023,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "19406"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ideal_consult_llc_tax_4845_2023",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2023_row_013984"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "East Brunswick"
      ],
      "states": [
        "NJ"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "08816"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ideal_consult_llc_tax_5024_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_010388"
      ],
      "continuing_approval": 0
    }
  ]
}

Geography

{
  "states": [
    "PA",
    "TX",
    "MD",
    "MI",
    "DE",
    "CA",
    "DC",
    "LA",
    "MA",
    "NC",
    "VA",
    "NJ"
  ],
  "cities": [
    "King Of Prussia",
    "Cypress",
    "Elkridge",
    "Canton",
    "Dallas",
    "Frisco",
    "Wilmington",
    "Azusa",
    "District Of Columbia",
    "Washington",
    "New Orleans",
    "Waltham",
    "Ann Arbor",
    "Chapel Hill",
    "King Prussia",
    "Pittsburgh",
    "Spring City",
    "Addison",
    "Houston",
    "Richmond",
    "Chester Springs",
    "East Brunswick"
  ],
  "postal_codes": [
    "19406",
    "77433",
    "21075",
    "48187",
    "75235",
    "75035",
    "19807",
    "91702",
    "20005",
    "19801",
    "19803",
    "70113",
    "2451",
    "48105",
    "27514",
    "15222",
    "19475",
    "75001",
    "77042",
    "23238",
    "08816",
    "19425"
  ],
  "top_markets": [
    {
      "city": "King Of Prussia",
      "state": "PA",
      "postal_code": "19406",
      "lca_count": 11,
      "role_title_count": 10,
      "wage_low_min": 65000,
      "wage_high_max": 100000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Cypress",
      "state": "TX",
      "postal_code": "77433",
      "lca_count": 9,
      "role_title_count": 2,
      "wage_low_min": 141440,
      "wage_high_max": 141440,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2024
    },
    {
      "city": "Elkridge",
      "state": "MD",
      "postal_code": "21075",
      "lca_count": 5,
      "role_title_count": 1,
      "wage_low_min": 82000,
      "wage_high_max": 108160,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021
    },
    {
      "city": "Canton",
      "state": "MI",
      "postal_code": "48187",
      "lca_count": 4,
      "role_title_count": 2,
      "wage_low_min": 65354,
      "wage_high_max": 90000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Dallas",
      "state": "TX",
      "postal_code": "75235",
      "lca_count": 4,
      "role_title_count": 2,
      "wage_low_min": 124800,
      "wage_high_max": 124800,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2023
    },
    {
      "city": "Frisco",
      "state": "TX",
      "postal_code": "75035",
      "lca_count": 4,
      "role_title_count": 2,
      "wage_low_min": 92000,
      "wage_high_max": 92000,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2023
    },
    {
      "city": "Wilmington",
      "state": "DE",
      "postal_code": "19807",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 87000,
      "wage_high_max": 99840,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020
    },
    {
      "city": "Azusa",
      "state": "CA",
      "postal_code": "91702",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 133120,
      "wage_high_max": 133120,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024
    },
    {
      "city": "District Of Columbia",
      "state": "DC",
      "postal_code": "20005",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 118560,
      "wage_high_max": 118560,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020
    },
    {
      "city": "Washington",
      "state": "DC",
      "postal_code": "20005",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 105000,
      "wage_high_max": 105000,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020
    }
  ]
}

Industry

{
  "naics_codes": [
    "541512",
    "54"
  ]
}

Wage Summary

{
  "annualized_low_min": 60000,
  "annualized_high_max": 141440,
  "annualized_low_avg": 100677.722222222
}

Trend

[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 8,
    "case_count": 8,
    "role_title_count": 7,
    "worksite_count": 3,
    "wage_low_min": 60000,
    "wage_high_max": 100000,
    "wage_low_avg": 69193.25
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 5,
    "case_count": 5,
    "role_title_count": 5,
    "worksite_count": 3,
    "wage_low_min": 68515,
    "wage_high_max": 90000,
    "wage_low_avg": 70165.6
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 9,
    "case_count": 9,
    "role_title_count": 6,
    "worksite_count": 7,
    "wage_low_min": 70100,
    "wage_high_max": 90000,
    "wage_low_avg": 84555.5555555556
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 79200,
    "wage_high_max": 87000,
    "wage_low_avg": 83100
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 3,
    "wage_low_min": 99840,
    "wage_high_max": 140000,
    "wage_low_avg": 114946.666666667
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 118560,
    "wage_high_max": 118560,
    "wage_low_avg": 118560
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q1",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 108160,
    "wage_high_max": 141440,
    "wage_low_avg": 130346.666666667
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q2",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 3,
    "worksite_count": 3,
    "wage_low_min": 92000,
    "wage_high_max": 141440,
    "wage_low_avg": 120760
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 7,
    "case_count": 7,
    "role_title_count": 5,
    "worksite_count": 6,
    "wage_low_min": 83200,
    "wage_high_max": 141440,
    "wage_low_avg": 113070
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 124800,
    "wage_high_max": 124800,
    "wage_low_avg": 124800
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 124800,
    "wage_high_max": 124800,
    "wage_low_avg": 124800
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 124800,
    "wage_high_max": 124800,
    "wage_low_avg": 124800
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q4",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 92000,
    "wage_high_max": 141440,
    "wage_low_avg": 116720
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q1",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 133120,
    "wage_high_max": 141440,
    "wage_low_avg": 138666.666666667
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 125653,
    "wage_high_max": 125653,
    "wage_low_avg": 125653
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 91520,
    "wage_high_max": 91520,
    "wage_low_avg": 91520
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 110240,
    "wage_high_max": 110240,
    "wage_low_avg": 110240
  }
]

Links

{
  "roles": "/v1/roles?company=IDEAL%20CONSULT%20LLC.",
  "wages": "/v1/wages?company=IDEAL%20CONSULT%20LLC.",
  "trends": "/v1/trends?company=IDEAL%20CONSULT%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=ideal+consult+llc&limit=5JSON

Docs · Get an API key