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

Home / Companies / Open Analytics, LLC

Open Analytics, 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
Open Analytics, LLC
OPEN ANALYTICS LLC
291011FY2016 to FY2022
Latest decision 2022-05-27
14COMPUTER PROGRAMMER/DEVELOPER
7 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings29
Certified LCAs29
Denied LCAs0
Role titles10
Worksites11
Latest decision2022-05-27
USCIS approvals14
USCIS denials1

Aliases and source names

AliasesSource NamesSources
OPEN ANALYTICS LLCOpen Analytics, LLC, OPEN ANALYTICS LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
COMPUTER PROGRAMMER/DEVELOPER15-1132
SOFTWARE DEVELOPERS, APPLICATIONS
7$93,933$108,784
COMPUTER PROGRAMMER15-11315$61,000$0
BUSINESS ANALYST15-11214$65,000$0
Computer Programmer/Developer15-1132.00
Software Developers, Applications
3$96,595$121,763
SOFTWARE DEVELOPER15-11322$66,456$0
SOFTWARE ENGINEER15-1132
SOFTWARE DEVELOPERS, APPLICATIONS
2$72,000$72,000
Clinical Informatics Analyst15-1121.01
Informatics Nurse Specialists
1$72,779$72,779
COMPUTER PROGRAMMER ANALYST15-11321$90,000$0
LEAD MECHANICAL ENGINEER17-2141
MECHANICAL ENGINEERS
1$93,000$93,000
MECHANICAL ENGINEER17-21411$93,000$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
ViennaVA2218213361,000121,7632,0162,022
ChantillyVA201513293,000173,4752,0182,020
McleanVA221023266,60096,5952,0172,020
SunnyvaleCA9408621108,784108,7842,0192,019
MentorOH440602172,00072,0002,0182,019
IrwindaleCA917061193,00093,0002,0192,019
MalvernPA193551170,00002,0162,016
OaksPA194561166,45602,0162,016
ArlingtonVA222021172,77972,7792,0222,022
HerndonVA201711165,00002,0172,017

Full company payload

Company IDcompany:open analytics
NameOpen Analytics, LLC
Normalized Nameopen analytics
Source Company Idscompany_dol_oflc_lca_open_analytics_llc, company_uscis_h1b_datahub_open_analytics_llc_tax_2228
Source NamesOpen Analytics, LLC, OPEN ANALYTICS LLC
AliasesOPEN ANALYTICS LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "2228",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 29,
  "case_count": 29,
  "role_title_count": 10,
  "worksite_count": 11,
  "first_fiscal_year": 2016,
  "latest_fiscal_year": 2022,
  "latest_decision_date": "2022-05-27",
  "certified_count": 29,
  "denied_count": 0
}
Petition Activity
{
  "total_approval": 14,
  "total_denial": 1,
  "fiscal_years": [
    "2016",
    "2017",
    "2018",
    "2019",
    "2020",
    "2022"
  ],
  "year_metrics": [
    {
      "cities": [
        "Herndon"
      ],
      "states": [
        "VA"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "20171"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_open_analytics_llc_tax_2228_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_028628"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Herndon"
      ],
      "states": [
        "VA"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "20171"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_open_analytics_llc_tax_2228_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_025824"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Herndon"
      ],
      "states": [
        "VA"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "20171"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_open_analytics_llc_tax_2228_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_028114"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Herndon"
      ],
      "states": [
        "VA"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "20171"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 1,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_open_analytics_llc_tax_2228_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_028367"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Herndon"
      ],
      "states": [
        "VA"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "20171"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_open_analytics_llc_tax_2228_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_035554"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "Herndon"
      ],
      "states": [
        "VA"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "20171"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_open_analytics_llc_tax_2228_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_038475"
      ],
      "continuing_approval": 1
    }
  ]
}
Geography
{
  "states": [
    "VA",
    "CA",
    "OH",
    "PA"
  ],
  "cities": [
    "Vienna",
    "Chantilly",
    "Mclean",
    "Sunnyvale",
    "Mentor",
    "Irwindale",
    "Malvern",
    "Oaks",
    "Arlington",
    "Herndon",
    "Reston"
  ],
  "postal_codes": [
    "22182",
    "20151",
    "22102",
    "94086",
    "44060",
    "91706",
    "19355",
    "19456",
    "22202",
    "20171",
    "20190"
  ],
  "top_markets": [
    {
      "city": "Vienna",
      "state": "VA",
      "postal_code": "22182",
      "lca_count": 13,
      "role_title_count": 3,
      "wage_low_min": 61000,
      "wage_high_max": 121763,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2022
    },
    {
      "city": "Chantilly",
      "state": "VA",
      "postal_code": "20151",
      "lca_count": 3,
      "role_title_count": 2,
      "wage_low_min": 93000,
      "wage_high_max": 173475,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2020
    },
    {
      "city": "Mclean",
      "state": "VA",
      "postal_code": "22102",
      "lca_count": 3,
      "role_title_count": 2,
      "wage_low_min": 66600,
      "wage_high_max": 96595,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2020
    },
    {
      "city": "Sunnyvale",
      "state": "CA",
      "postal_code": "94086",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 108784,
      "wage_high_max": 108784,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Mentor",
      "state": "OH",
      "postal_code": "44060",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 72000,
      "wage_high_max": 72000,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Irwindale",
      "state": "CA",
      "postal_code": "91706",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 93000,
      "wage_high_max": 93000,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Malvern",
      "state": "PA",
      "postal_code": "19355",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 70000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Oaks",
      "state": "PA",
      "postal_code": "19456",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 66456,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Arlington",
      "state": "VA",
      "postal_code": "22202",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 72779,
      "wage_high_max": 72779,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022
    },
    {
      "city": "Herndon",
      "state": "VA",
      "postal_code": "20171",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 65000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    }
  ]
}
Industry
{
  "naics_codes": [
    "541512",
    "54"
  ]
}
Wage Summary
{
  "annualized_low_min": 61000,
  "annualized_high_max": 173475,
  "annualized_low_avg": 89541.1724137931
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 6,
    "case_count": 6,
    "role_title_count": 3,
    "worksite_count": 3,
    "wage_low_min": 61000,
    "wage_high_max": 0,
    "wage_low_avg": 66909.3333333333
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 6,
    "case_count": 6,
    "role_title_count": 3,
    "worksite_count": 4,
    "wage_low_min": 65000,
    "wage_high_max": 0,
    "wage_low_avg": 73025
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 2,
    "wage_low_min": 72000,
    "wage_high_max": 0,
    "wage_low_avg": 111000
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 9,
    "case_count": 9,
    "role_title_count": 3,
    "worksite_count": 4,
    "wage_low_min": 72000,
    "wage_high_max": 108784,
    "wage_low_avg": 95875.6666666667
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 96595,
    "wage_high_max": 96595,
    "wage_low_avg": 96595
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q4",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 96595,
    "wage_high_max": 173475,
    "wage_low_avg": 135035
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q3",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 72779,
    "wage_high_max": 121763,
    "wage_low_avg": 97271
  }
]
Links
{
  "roles": "/v1/roles?company=Open%20Analytics%2C%20LLC",
  "wages": "/v1/wages?company=Open%20Analytics%2C%20LLC",
  "trends": "/v1/trends?company=Open%20Analytics%2C%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=open+analytics+llc&limit=5JSON