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

Home / Companies / Ocelot Consulting LLC

Ocelot Consulting 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
Ocelot Consulting LLC
OCELOT CONSULTING LLC
231215FY2020 to FY2024
Latest decision 2024-02-12
13Cloud Engineer
4 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings23
Certified LCAs23
Denied LCAs0
Role titles12
Worksites15
Latest decision2024-02-12
USCIS approvals13
USCIS denials0

Aliases and source names

AliasesSource NamesSources
OCELOT CONSULTING LLCOcelot Consulting LLC, OCELOT CONSULTING LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
Cloud Engineer15-1132.00
Software Developers, Applications
4$83,500$130,000
Cloud Engineer15-1252.00
Software Developers
4$100,000$140,000
Data Engineer15-1199.06
Database Architects
3$125,000$135,000
Senior Software Engineer15-1252.00
Software Developers
2$145,000$155,000
Cloud Data Architect15-1299.00
Computer Occupations, All Other
1$193,000$193,000
Cloud Data Engineer15-1243.00
Database Architects
1$122,000$122,000
Full Stack Developer15-1252.00
Software Developers
1$165,000$165,000
Senior Data Engineer15-1199.06
Database Architects
1$145,000$145,000
Senior Data Engineer15-1243.00
Database Architects
1$140,000$140,000
Senior Data/MLOps Engineer15-1243.00
Database Architects
1$180,000$180,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
Creve CoeurMO631416483,500193,0002,0202,023
CummingGA3004021140,000140,0002,0232,023
ChesterfieldMO6300522145,000200,0002,0222,023
Creve CouerMO6314121125,000125,0002,0212,021
MantecaCA9533711140,000140,0002,0222,022
BallwinMO6302111165,000165,0002,0232,023
Cape GirardeauMO6370111122,000122,0002,0232,023
O'fallonMO6336611180,000180,0002,0242,024
RollaMO6540111100,000100,0002,0232,023
St. LouisMO6314111170,000170,0002,0202,020

Full company payload

Company IDcompany:ocelot consulting
NameOcelot Consulting LLC
Normalized Nameocelot consulting
Source Company Idscompany_dol_oflc_lca_ocelot_consulting_llc, company_uscis_h1b_datahub_ocelot_consulting_llc_tax_8075
Source NamesOcelot Consulting LLC, OCELOT CONSULTING LLC
AliasesOCELOT CONSULTING LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Ocelot Consulting LLC",
    "OCELOT CONSULTING LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "Ocelot Consulting LLC",
      "filing_count": 23,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "OCELOT CONSULTING LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "8075",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 23,
  "case_count": 23,
  "role_title_count": 12,
  "worksite_count": 15,
  "total_workers": 23,
  "first_fiscal_year": 2020,
  "first_received_date": "2020-05-26",
  "latest_fiscal_year": 2024,
  "latest_decision_date": "2024-02-12",
  "certified_count": 23,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 23,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 23,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 23,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 13,
  "total_denial": 0,
  "fiscal_years": [
    "2020",
    "2021",
    "2022",
    "2023"
  ],
  "year_metrics": [
    {
      "cities": [
        "Creve Coeur",
        "Saint Louis"
      ],
      "states": [
        "MO"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "63141"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ocelot_consulting_llc_tax_8075_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_035089",
        "sr_uscis_h1b_datahub_2020_row_035090"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Creve Coeur",
        "Saint Louis"
      ],
      "states": [
        "MO"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "63141"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ocelot_consulting_llc_tax_8075_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_038015",
        "sr_uscis_h1b_datahub_2021_row_038016"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Saint Louis"
      ],
      "states": [
        "MO"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "63141"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 6,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ocelot_consulting_llc_tax_8075_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_037923"
      ],
      "continuing_approval": 6
    },
    {
      "cities": [
        "Saint Louis"
      ],
      "states": [
        "MO"
      ],
      "fiscal_year": 2023,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "63141"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ocelot_consulting_llc_tax_8075_2023",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2023_row_020859"
      ],
      "continuing_approval": 2
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "CREVE COEUR MO 63141",
      "city": "Creve Coeur",
      "state": "MO",
      "postal_code": "63141",
      "filing_count": 20,
      "case_count": 20,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-02-12",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "CREVE COUER MO 63141",
      "city": "Creve Couer",
      "state": "MO",
      "postal_code": "63141",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2021-12-29",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "HILLSBORO OR 97123",
      "city": "Hillsboro",
      "county": "Washington",
      "state": "OR",
      "postal_code": "97123",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-02-12",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "O'FALLON MO 63366",
      "city": "O'fallon",
      "county": "St Charles",
      "state": "MO",
      "postal_code": "63366",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-01-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "LEANDER TX 78641",
      "city": "Leander",
      "county": "Williamson",
      "state": "TX",
      "postal_code": "78641",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2023-12-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CREVE COEUR MO 63141",
      "city": "Creve Coeur",
      "county": "St Louis",
      "state": "MO",
      "postal_code": "63141",
      "filing_count": 6,
      "case_count": 6,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-08-04",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CHESTERFIELD MO 63005",
      "city": "Chesterfield",
      "county": "St Louis",
      "state": "MO",
      "postal_code": "63005",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-09-18",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CUMMING GA 30040",
      "city": "Cumming",
      "county": "Forsyth",
      "state": "GA",
      "postal_code": "30040",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2022-10-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CAPE GIRARDEAU MO 63701",
      "city": "Cape Girardeau",
      "county": "Cape Girardeau",
      "state": "MO",
      "postal_code": "63701",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-04-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ROLLA MO 65401",
      "city": "Rolla",
      "county": "Phelps",
      "state": "MO",
      "postal_code": "65401",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-04-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "TOWN AND COUNTRY MO 63017",
      "city": "Town And Country",
      "county": "St Louis",
      "state": "MO",
      "postal_code": "63017",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-03-07",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BALLWIN MO 63021",
      "city": "Ballwin",
      "county": "St Louis",
      "state": "MO",
      "postal_code": "63021",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-01-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "MANTECA CA 95337",
      "city": "Manteca",
      "county": "San Joaquin",
      "state": "CA",
      "postal_code": "95337",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-08-12",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "AUSTIN TX 78717",
      "city": "Austin",
      "county": "Williamson",
      "state": "TX",
      "postal_code": "78717",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-03-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CREVE COUER MO 63141",
      "city": "Creve Couer",
      "county": "St Louis",
      "state": "MO",
      "postal_code": "63141",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-03-01",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ST. LOUIS MO 63141",
      "city": "St. Louis",
      "county": "St Louis",
      "state": "MO",
      "postal_code": "63141",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-08-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "WELDON SPRING MO 63304",
      "city": "Weldon Spring",
      "county": "St Charles",
      "state": "MO",
      "postal_code": "63304",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-06-02",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "worksite_address_count": 15,
    "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": [
    "MO",
    "GA",
    "CA",
    "OR",
    "TX"
  ],
  "cities": [
    "Creve Coeur",
    "Cumming",
    "Chesterfield",
    "Creve Couer",
    "Manteca",
    "Ballwin",
    "Cape Girardeau",
    "O'fallon",
    "Rolla",
    "St. Louis",
    "Town And Country",
    "Weldon Spring",
    "Hillsboro",
    "Austin",
    "Leander",
    "Saint Louis"
  ],
  "postal_codes": [
    "63141",
    "30040",
    "63005",
    "95337",
    "63021",
    "63701",
    "63366",
    "65401",
    "63017",
    "63304",
    "97123",
    "78717",
    "78641"
  ],
  "top_markets": [
    {
      "city": "Creve Coeur",
      "state": "MO",
      "postal_code": "63141",
      "lca_count": 6,
      "role_title_count": 4,
      "wage_low_min": 83500,
      "wage_high_max": 193000,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2023
    },
    {
      "city": "Cumming",
      "state": "GA",
      "postal_code": "30040",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 140000,
      "wage_high_max": 140000,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023
    },
    {
      "city": "Chesterfield",
      "state": "MO",
      "postal_code": "63005",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 145000,
      "wage_high_max": 200000,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2023
    },
    {
      "city": "Creve Couer",
      "state": "MO",
      "postal_code": "63141",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 125000,
      "wage_high_max": 125000,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021
    },
    {
      "city": "Manteca",
      "state": "CA",
      "postal_code": "95337",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 140000,
      "wage_high_max": 140000,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022
    },
    {
      "city": "Ballwin",
      "state": "MO",
      "postal_code": "63021",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 165000,
      "wage_high_max": 165000,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023
    },
    {
      "city": "Cape Girardeau",
      "state": "MO",
      "postal_code": "63701",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 122000,
      "wage_high_max": 122000,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023
    },
    {
      "city": "O'fallon",
      "state": "MO",
      "postal_code": "63366",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 180000,
      "wage_high_max": 180000,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024
    },
    {
      "city": "Rolla",
      "state": "MO",
      "postal_code": "65401",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 100000,
      "wage_high_max": 100000,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023
    },
    {
      "city": "St. Louis",
      "state": "MO",
      "postal_code": "63141",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 170000,
      "wage_high_max": 170000,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020
    }
  ]
}
Industry
{
  "naics_codes": [
    "541511",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541511",
      "filing_count": 22,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "54151",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 83500,
  "annualized_high_max": 225000,
  "annualized_low_avg": 143108.695652174
}
Trend
[
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 1,
    "worksite_count": 2,
    "wage_low_min": 83500,
    "wage_high_max": 95000,
    "wage_low_avg": 90500
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 170000,
    "wage_high_max": 170000,
    "wage_low_avg": 170000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 125000,
    "wage_high_max": 125000,
    "wage_low_avg": 125000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 125000,
    "wage_high_max": 125000,
    "wage_low_avg": 125000
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 145000,
    "wage_high_max": 145000,
    "wage_low_avg": 145000
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 135000,
    "wage_high_max": 145000,
    "wage_low_avg": 140000
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 130000,
    "wage_high_max": 130000,
    "wage_low_avg": 130000
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q4",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 140000,
    "wage_high_max": 145000,
    "wage_low_avg": 142500
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 140000,
    "wage_high_max": 140000,
    "wage_low_avg": 140000
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 3,
    "wage_low_min": 140000,
    "wage_high_max": 165000,
    "wage_low_avg": 153333.333333333
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q3",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 100000,
    "wage_high_max": 122000,
    "wage_low_avg": 111000
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q4",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 193000,
    "wage_high_max": 200000,
    "wage_low_avg": 196500
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 140000,
    "wage_high_max": 140000,
    "wage_low_avg": 140000
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 180000,
    "wage_high_max": 225000,
    "wage_low_avg": 202500
  }
]
Links
{
  "roles": "/v1/roles?company=Ocelot%20Consulting%20LLC",
  "wages": "/v1/wages?company=Ocelot%20Consulting%20LLC",
  "trends": "/v1/trends?company=Ocelot%20Consulting%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=ocelot+consulting+llc&limit=5JSON