Home / Companies / CRYSTAL BI LLC

CRYSTAL BI 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
CRYSTAL BI LLC CRYSTAL BI LLC	4	3	2	FY2016 to FY2017 Latest decision 2017-04-10	3	SENIOR SOFTWARE DEVELOPER 2 filings	dol_oflc_lca, uscis_h1b_employer_data_hub	Profile

Activity summary

LCA filings	4
Certified LCAs	4
Denied LCAs	0
Role titles	3
Worksites	2
Latest decision	2017-04-10
USCIS approvals	3
USCIS denials	0

Aliases and source names

Aliases	Source Names	Sources
CRYSTAL BI LLC	CRYSTAL BI LLC	dol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

Title	SOC	LCA filings	Low wage min	High wage max
SENIOR SOFTWARE DEVELOPER	15-1132	2	$101,088	$0
QUALITY EVANGELIST/TEST LEAD	15-1199	1	$100,000	$0
SOFTWARE DEVELOPER	15-1132	1	$85,000	$0

Top markets

City	State	Postal Code	LCA Count	Role Title Count	Wage Low Min	Wage High Max	First Fiscal Year	Latest Fiscal Year
Bellevue	WA	98006	3	3	85,000	0	2,016	2,016
Mountain View	CA	94043	1	1	124,675	0	2,017	2,017

Full company payload

Company ID	company:crystal bi
Name	CRYSTAL BI LLC
Normalized Name	crystal bi
Source Company Ids	company_dol_oflc_lca_crystal_bi_llc, company_uscis_h1b_datahub_crystal_bi_llc_tax_3728
Source Names	CRYSTAL BI LLC
Aliases	CRYSTAL BI LLC
Sources	dol_oflc_lca, uscis_h1b_employer_data_hub

Names

{
  "source_names": [
    "CRYSTAL BI LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "CRYSTAL BI LLC",
      "filing_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CRYSTAL BI LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}

Identifiers

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

LCA Activity

{
  "lca_count": 4,
  "case_count": 4,
  "role_title_count": 3,
  "worksite_count": 2,
  "total_workers": 4,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-01-21",
  "latest_fiscal_year": 2017,
  "latest_decision_date": "2017-04-10",
  "certified_count": 4,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ]
}

Petition Activity

{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 3,
  "total_denial": 0,
  "fiscal_years": [
    "2016",
    "2017"
  ],
  "year_metrics": [
    {
      "cities": [
        "Bellevue"
      ],
      "states": [
        "WA"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "98007"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_crystal_bi_llc_tax_3728_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_035436"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Bellevue"
      ],
      "states": [
        "WA"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "98007"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_crystal_bi_llc_tax_3728_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_032171"
      ],
      "continuing_approval": 1
    }
  ]
}

Addresses

{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "BELLEVUE WA 98007",
      "city": "Bellevue",
      "state": "WA",
      "postal_code": "98007",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-04-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "MOUNTAIN VIEW CA 94043",
      "city": "Mountain View",
      "county": "Santa Clara",
      "state": "CA",
      "postal_code": "94043",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-04-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BELLEVUE WA 98006",
      "city": "Bellevue",
      "county": "King",
      "state": "WA",
      "postal_code": "98006",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-14",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 1,
    "worksite_address_count": 2,
    "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": [
    "WA",
    "CA"
  ],
  "cities": [
    "Bellevue",
    "Mountain View"
  ],
  "postal_codes": [
    "98006",
    "94043",
    "98007"
  ],
  "top_markets": [
    {
      "city": "Bellevue",
      "state": "WA",
      "postal_code": "98006",
      "lca_count": 3,
      "role_title_count": 3,
      "wage_low_min": 85000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Mountain View",
      "state": "CA",
      "postal_code": "94043",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 124675,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    }
  ]
}

Industry

{
  "naics_codes": [
    "541511",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541511",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ]
}

Wage Summary

{
  "annualized_low_min": 85000,
  "annualized_high_max": 0,
  "annualized_low_avg": 102690.75
}

Trend

[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 1,
    "wage_low_min": 85000,
    "wage_high_max": 0,
    "wage_low_avg": 95362.6666666667
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 124675,
    "wage_high_max": 0,
    "wage_low_avg": 124675
  }
]

Links

{
  "roles": "/v1/roles?company=CRYSTAL%20BI%20LLC",
  "wages": "/v1/wages?company=CRYSTAL%20BI%20LLC",
  "trends": "/v1/trends?company=CRYSTAL%20BI%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=crystal+bi+llc&limit=5JSON

Docs · Get an API key