Does IDEAL CONSULT LLC. sponsor H-1B visas?

Yes. IDEAL CONSULT LLC. filed 54 H-1B labor condition applications with the U.S. Department of Labor (FY2016-FY2025), of which 54 were certified. LCA filings are labor-condition applications certified by the U.S. Department of Labor, not active job postings or approved USCIS H-1B petitions.

How many H-1B applications has IDEAL CONSULT LLC. filed?

IDEAL CONSULT LLC. has 54 H-1B LCA filings on record spanning FY2016-FY2025 across 26 role titles and 22 worksites.

What roles does IDEAL CONSULT LLC. sponsor for H-1B?

The most common H-1B role at IDEAL CONSULT LLC. is Clinical Sas Programmer (6 filings). Other frequent roles include Lead Sas Programmer, Senior Sas Programmer, Software Developer, Business Analyst.

What wages does IDEAL CONSULT LLC. offer H-1B workers?

For its most-sponsored role (Clinical Sas Programmer), IDEAL CONSULT LLC. reported offered wages ranging from $73,798 to $108,160 in DOL LCA filings.

Home / Companies / IDEAL CONSULT LLC.

IDEAL CONSULT LLC. H-1B company data

Name: IDEAL CONSULT LLC. H-1B / LCA filings
Creator: bluedoor

Summary

IDEAL CONSULT LLC. filed 54 H-1B labor condition applications (LCAs) with the U.S. Department of Labor between FY2016-FY2025.

Of those, 54 were certified (a 100% certification rate among adjudicated filings).

The filings span 26 distinct role titles across 22 worksites.

The most-sponsored role was Clinical Sas Programmer (6 filings), with offered wages from $73,798 to $108,160.

Separately, USCIS H-1B Employer Data Hub records show 38 approved and 20 denied H-1B petitions for this employer.

LCA filings are labor-condition applications certified by the U.S. Department of Labor, not active job postings or approved USCIS H-1B petitions.

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

Names

{
  "source_names": [
    "IDEAL CONSULT LLC.",
    "IDEAL CONSULT LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "IDEAL CONSULT LLC",
      "filing_count": 27,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "IDEAL CONSULT LLC.",
      "filing_count": 23,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Ideal Consult LLC",
      "filing_count": 2,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "IDEAL CONSULT, LLC.",
      "filing_count": 2,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "IDEAL CONSULT LLC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "IDEAL CONSULT LLC",
      "source": "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,
  "total_workers": 54,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-01-18",
  "latest_fiscal_year": 2025,
  "latest_decision_date": "2025-08-21",
  "certified_count": 54,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 30,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 24,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 54,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 38,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "N",
      "filing_count": 8,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}

Petition Activity

{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "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
    }
  ]
}

Addresses

{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "KING OF PRUSSIA PA 19406",
      "city": "King Of Prussia",
      "state": "PA",
      "postal_code": "19406",
      "filing_count": 54,
      "case_count": 54,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-08-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "WILMINGTON DE 19801",
      "city": "Wilmington",
      "state": "DE",
      "postal_code": "19801",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-08-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ADDISON TX 75001",
      "city": "Addison",
      "county": "Dallas",
      "state": "TX",
      "postal_code": "75001",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-06-24",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CYPRESS TX 77433",
      "city": "Cypress",
      "county": "Harris",
      "state": "TX",
      "postal_code": "77433",
      "filing_count": 9,
      "case_count": 9,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2023-10-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SPRING CITY PA 19475",
      "city": "Spring City",
      "county": "Chester",
      "state": "PA",
      "postal_code": "19475",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-08-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "AZUSA CA 91702",
      "city": "Azusa",
      "county": "Los Angeles",
      "state": "CA",
      "postal_code": "91702",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2023-10-12",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "FRISCO TX 75035",
      "city": "Frisco",
      "county": "Collin",
      "state": "TX",
      "postal_code": "75035",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-09-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "DALLAS TX 75235",
      "city": "Dallas",
      "county": "Dallas",
      "state": "TX",
      "postal_code": "75235",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2022-11-07",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ELKRIDGE MD 21075",
      "city": "Elkridge",
      "county": "Howard",
      "state": "MD",
      "postal_code": "21075",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2020-12-07",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CHAPEL HILL NC 27514",
      "city": "Chapel Hill",
      "county": "Orange",
      "state": "NC",
      "postal_code": "27514",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-06-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "WALTHAM MA 2451",
      "city": "Waltham",
      "county": "Waltham City",
      "state": "MA",
      "postal_code": "2451",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-06-02",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "RICHMOND VA 23238",
      "city": "Richmond",
      "county": "Henrico",
      "state": "VA",
      "postal_code": "23238",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-04-01",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "WILMINGTON DE 19807",
      "city": "Wilmington",
      "county": "New Castle",
      "state": "DE",
      "postal_code": "19807",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-03-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "DISTRICT OF COLUMBIA DC 20005",
      "city": "District Of Columbia",
      "county": "District Of Columbia",
      "state": "DC",
      "postal_code": "20005",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-09-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "KING PRUSSIA PA 19406",
      "city": "King Prussia",
      "county": "Montgomery",
      "state": "PA",
      "postal_code": "19406",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-03-31",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "WASHINGTON DC 20005",
      "city": "Washington",
      "county": "District Of Columbia",
      "state": "DC",
      "postal_code": "20005",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-01-24",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "KING OF PRUSSIA PA 19406",
      "city": "King Of Prussia",
      "county": "Montgomery",
      "state": "PA",
      "postal_code": "19406",
      "filing_count": 11,
      "case_count": 11,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-14",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CANTON MI 48187",
      "city": "Canton",
      "county": "Wayne",
      "state": "MI",
      "postal_code": "48187",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-06",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEW ORLEANS LA 70113",
      "city": "New Orleans",
      "county": "Orleans",
      "state": "LA",
      "postal_code": "70113",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-29",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "WILMINGTON DE 19803",
      "city": "Wilmington",
      "county": "New Castle",
      "state": "DE",
      "postal_code": "19803",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-22",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ANN ARBOR MI 48105",
      "city": "Ann Arbor",
      "county": "Washtenaw",
      "state": "MI",
      "postal_code": "48105",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-12",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "HOUSTON TX 77042",
      "city": "Houston",
      "county": "Harris",
      "state": "TX",
      "postal_code": "77042",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2016-10-19",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "PITTSBURGH PA 15222",
      "city": "Pittsburgh",
      "county": "Allegheny",
      "state": "PA",
      "postal_code": "15222",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-01-22",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 1,
    "worksite_address_count": 22,
    "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",
    "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"
  ],
  "naics_breakdown": [
    {
      "value": "541512",
      "filing_count": 39,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "541511",
      "filing_count": 7,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ]
}

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."
}

Frequently asked questions

Does IDEAL CONSULT LLC. sponsor H-1B visas?: Yes. IDEAL CONSULT LLC. filed 54 H-1B labor condition applications with the U.S. Department of Labor (FY2016-FY2025), of which 54 were certified. LCA filings are labor-condition applications certified by the U.S. Department of Labor, not active job postings or approved USCIS H-1B petitions.
How many H-1B applications has IDEAL CONSULT LLC. filed?: IDEAL CONSULT LLC. has 54 H-1B LCA filings on record spanning FY2016-FY2025 across 26 role titles and 22 worksites.
What roles does IDEAL CONSULT LLC. sponsor for H-1B?: The most common H-1B role at IDEAL CONSULT LLC. is Clinical Sas Programmer (6 filings). Other frequent roles include Lead Sas Programmer, Senior Sas Programmer, Software Developer, Business Analyst.
What wages does IDEAL CONSULT LLC. offer H-1B workers?: For its most-sponsored role (Clinical Sas Programmer), IDEAL CONSULT LLC. reported offered wages ranging from $73,798 to $108,160 in DOL LCA filings.

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