Home / Companies / Constellation Advisers LLC

Constellation Advisers 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
Constellation Advisers LLC CONSTELLATION ADVISERS LLC	5	2	2	FY2020 to FY2022 Latest decision 2022-03-04	3	Economist 3 filings	dol_oflc_lca, uscis_h1b_employer_data_hub	Profile

Activity summary

LCA filings	5
Certified LCAs	5
Denied LCAs	0
Role titles	2
Worksites	2
Latest decision	2022-03-04
USCIS approvals	3
USCIS denials	0

Aliases and source names

Aliases	Source Names	Sources
CONSTELLATION ADVISERS LLC	Constellation Advisers LLC, CONSTELLATION ADVISERS LLC	dol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

Title	SOC	LCA filings	Low wage min	High wage max
Economist	19-3011.00 Economists	3	$200,000	$200,000
Developer	15-1132 Software Developers, Applications	2	$138,000	$190,000

Top markets

City	State	Postal Code	LCA Count	Role Title Count	Wage Low Min	Wage High Max	First Fiscal Year	Latest Fiscal Year
New York	NY	10018	3	1	200,000	200,000	2,021	2,022
New York	NY	10036	2	1	138,000	190,000	2,020	2,020

Full company payload

Company ID	company:constellation advisers
Name	Constellation Advisers LLC
Normalized Name	constellation advisers
Source Company Ids	company_dol_oflc_lca_constellation_advisers_llc, company_uscis_h1b_datahub_constellation_advisers_llc_tax_2853
Source Names	Constellation Advisers LLC, CONSTELLATION ADVISERS LLC
Aliases	CONSTELLATION ADVISERS LLC
Sources	dol_oflc_lca, uscis_h1b_employer_data_hub

Names

{
  "source_names": [
    "Constellation Advisers LLC",
    "CONSTELLATION ADVISERS LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "Constellation Advisers LLC",
      "filing_count": 3,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Constellation Advisers, LLC",
      "filing_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CONSTELLATION ADVISERS LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}

Identifiers

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

LCA Activity

{
  "lca_count": 5,
  "case_count": 5,
  "role_title_count": 2,
  "worksite_count": 2,
  "total_workers": 5,
  "first_fiscal_year": 2020,
  "first_received_date": "2020-06-16",
  "latest_fiscal_year": 2022,
  "latest_decision_date": "2022-03-04",
  "certified_count": 5,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 4,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified - Withdrawn",
      "filing_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 5,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 5,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2022,
      "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": [
    "2020",
    "2021"
  ],
  "year_metrics": [
    {
      "cities": [
        "New York"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "10036"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_constellation_advisers_llc_tax_2853_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_011538"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "New York"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "92"
      ],
      "postal_codes": [
        "10107"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_constellation_advisers_llc_tax_2853_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_012894"
      ],
      "continuing_approval": 1
    }
  ]
}

Addresses

{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "NEW YORK NY 10107",
      "city": "New York",
      "state": "NY",
      "postal_code": "10107",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-03-04",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "NEW YORK NY 10036",
      "city": "New York",
      "state": "NY",
      "postal_code": "10036",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-06-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10018",
      "city": "New York",
      "county": "New York",
      "state": "NY",
      "postal_code": "10018",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-03-04",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10036",
      "city": "New York",
      "county": "New York",
      "state": "NY",
      "postal_code": "10036",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-06-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "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": [
    "NY"
  ],
  "cities": [
    "New York"
  ],
  "postal_codes": [
    "10018",
    "10036",
    "10107"
  ],
  "top_markets": [
    {
      "city": "New York",
      "state": "NY",
      "postal_code": "10018",
      "lca_count": 3,
      "role_title_count": 1,
      "wage_low_min": 200000,
      "wage_high_max": 200000,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022
    },
    {
      "city": "New York",
      "state": "NY",
      "postal_code": "10036",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 138000,
      "wage_high_max": 190000,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020
    }
  ]
}

Industry

{
  "naics_codes": [
    "523920",
    "52",
    "92"
  ],
  "naics_breakdown": [
    {
      "value": "523920",
      "filing_count": 5,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ]
}

Wage Summary

{
  "annualized_low_min": 138000,
  "annualized_high_max": 200000,
  "annualized_low_avg": 175200
}

Trend

[
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 138000,
    "wage_high_max": 190000,
    "wage_low_avg": 138000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 200000,
    "wage_high_max": 200000,
    "wage_low_avg": 200000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 200000,
    "wage_high_max": 200000,
    "wage_low_avg": 200000
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 200000,
    "wage_high_max": 200000,
    "wage_low_avg": 200000
  }
]

Links

{
  "roles": "/v1/roles?company=Constellation%20Advisers%20LLC",
  "wages": "/v1/wages?company=Constellation%20Advisers%20LLC",
  "trends": "/v1/trends?company=Constellation%20Advisers%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=constellation+advisers+llc&limit=5JSON

Docs · Get an API key