Home / Companies / Constellation Agency LLC

Constellation Agency 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 Agency LLC CONSTELLATION AGENCY LLC	26	17	7	FY2017 to FY2022 Latest decision 2022-08-29	12	DIGITAL CAMPAIGN MANAGER 4 filings	dol_oflc_lca, uscis_h1b_employer_data_hub	Profile

Activity summary

LCA filings	26
Certified LCAs	24
Denied LCAs	0
Role titles	17
Worksites	7
Latest decision	2022-08-29
USCIS approvals	12
USCIS denials	1

Aliases and source names

Aliases	Source Names	Sources
CONSTELLATION AGENCY LLC	Constellation Agency LLC, CONSTELLATION AGENCY LLC	dol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

Title	SOC	LCA filings	Low wage min	High wage max
DIGITAL CAMPAIGN MANAGER	13-1161 MARKET RESEARCH ANALYSTS AND MARKETING SPECIALISTS	4	$60,000	$80,000
Associate Software Engineer	15-1132.00 Software Developers, Applications	2	$80,000	$100,000
Data Scientist	15-2031.00 Operations Research Analysts	2	$100,000	$130,000
GRAPHIC DESIGNER	27-1024 GRAPHIC DESIGNERS	2	$45,000	$80,000
ACCOUNT EXECUTIVE	13-1161 MARKET RESEARCH ANALYSTS AND MARKETING SPECIALISTS	1	$60,000	$80,000
ACCOUNT MANAGER	13-1161 MARKET RESEARCH ANALYSTS AND MARKETING SPECIALISTS	1	$55,000	$80,000
ACCOUNT MANAGER	27-3041	1	$42,869	$62,869
Associate Data Engineer	15-2041.00 Statisticians	1	$75,000	$95,000
Associate Data Scientist	15-1132.00 Software Developers, Applications	1	$80,000	$100,000
Associate Director of Campaigns	15-1199.10 Search Marketing Strategists	1	$80,000	$120,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	10038	12	11	50,000	120,000	2,019	2,021
New York	NY	10007	7	5	50,000	135,000	2,021	2,022
New York	NY	10004	3	2	42,869	80,000	2,018	2,019
Baltimore	MD	21227	1	1	160,000	160,000	2,022	2,022
Cresskill	NJ	07626	1	1	45,000	55,000	2,017	2,017
New York	NY	10017	1	1	80,000	120,000	2,022	2,022
Mckinney	TX	75072	1	1	150,000	190,000	2,022	2,022

Full company payload

Company ID	company:constellation agency
Name	Constellation Agency LLC
Normalized Name	constellation agency
Source Company Ids	company_dol_oflc_lca_constellation_agency_llc, company_uscis_h1b_datahub_constellation_agency_llc_tax_1912
Source Names	Constellation Agency LLC, CONSTELLATION AGENCY LLC
Aliases	CONSTELLATION AGENCY LLC
Sources	dol_oflc_lca, uscis_h1b_employer_data_hub

Names

{
  "source_names": [
    "Constellation Agency LLC",
    "CONSTELLATION AGENCY LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "Constellation Agency LLC",
      "filing_count": 13,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CONSTELLATION AGENCY LLC",
      "filing_count": 10,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Constellation Agency, LLC",
      "filing_count": 3,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CONSTELLATION AGENCY LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}

Identifiers

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

LCA Activity

{
  "lca_count": 26,
  "case_count": 26,
  "role_title_count": 17,
  "worksite_count": 7,
  "total_workers": 26,
  "first_fiscal_year": 2017,
  "first_received_date": "2017-03-23",
  "latest_fiscal_year": 2022,
  "latest_decision_date": "2022-08-29",
  "certified_count": 24,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 13,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 9,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Withdrawn",
      "filing_count": 2,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified - Withdrawn",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED-WITHDRAWN",
      "filing_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 25,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "H-1B1 Singapore",
      "filing_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 26,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ]
}

Petition Activity

{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 12,
  "total_denial": 1,
  "fiscal_years": [
    "2018",
    "2019",
    "2022"
  ],
  "year_metrics": [
    {
      "cities": [
        "Cresskill"
      ],
      "states": [
        "NJ"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "07626"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_constellation_agency_llc_tax_1912_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_048241"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Cresskill",
        "New York"
      ],
      "states": [
        "NJ",
        "NY"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "07626",
        "10038"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 4,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_constellation_agency_llc_tax_1912_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_049627",
        "sr_uscis_h1b_datahub_2019_row_049628"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "New York"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "10007"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 7,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_constellation_agency_llc_tax_1912_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_012803"
      ],
      "continuing_approval": 4
    }
  ]
}

Addresses

{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "NEW YORK NY 10007",
      "city": "New York",
      "state": "NY",
      "postal_code": "10007",
      "filing_count": 10,
      "case_count": 10,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-08-29",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "NEW YORK NY 10038-3953",
      "city": "New York",
      "state": "NY",
      "postal_code": "10038-3953",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-05-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "NEW YORK NY 10038",
      "city": "New York",
      "state": "NY",
      "postal_code": "10038",
      "filing_count": 6,
      "case_count": 6,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-03-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "CRESSKILL NJ 07626",
      "city": "Cresskill",
      "state": "NJ",
      "postal_code": "07626",
      "filing_count": 6,
      "case_count": 6,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2018-11-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "CRESSKILL NJ 7626",
      "city": "Cresskill",
      "state": "NJ",
      "postal_code": "7626",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-01-15",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10007",
      "city": "New York",
      "county": "New York",
      "state": "NY",
      "postal_code": "10007",
      "filing_count": 7,
      "case_count": 7,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-06-14",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BALTIMORE MD 21227",
      "city": "Baltimore",
      "county": "Baltimore City",
      "state": "MD",
      "postal_code": "21227",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-08-29",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "MCKINNEY TX 75072",
      "city": "Mckinney",
      "county": "Collin",
      "state": "TX",
      "postal_code": "75072",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-07-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10017",
      "city": "New York",
      "county": "New York",
      "state": "NY",
      "postal_code": "10017",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2021-10-15",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10038",
      "city": "New York",
      "county": "New York",
      "state": "NY",
      "postal_code": "10038",
      "filing_count": 12,
      "case_count": 12,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-05-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10004",
      "city": "New York",
      "county": "New York",
      "state": "NY",
      "postal_code": "10004",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2018-11-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CRESSKILL NJ 07626",
      "city": "Cresskill",
      "county": "Bergen",
      "state": "NJ",
      "postal_code": "07626",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-29",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 5,
    "worksite_address_count": 7,
    "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",
    "MD",
    "NJ",
    "TX"
  ],
  "cities": [
    "New York",
    "Baltimore",
    "Cresskill",
    "Mckinney"
  ],
  "postal_codes": [
    "10038",
    "10007",
    "10004",
    "21227",
    "07626",
    "10017",
    "75072"
  ],
  "top_markets": [
    {
      "city": "New York",
      "state": "NY",
      "postal_code": "10038",
      "lca_count": 12,
      "role_title_count": 11,
      "wage_low_min": 50000,
      "wage_high_max": 120000,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2021
    },
    {
      "city": "New York",
      "state": "NY",
      "postal_code": "10007",
      "lca_count": 7,
      "role_title_count": 5,
      "wage_low_min": 50000,
      "wage_high_max": 135000,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022
    },
    {
      "city": "New York",
      "state": "NY",
      "postal_code": "10004",
      "lca_count": 3,
      "role_title_count": 2,
      "wage_low_min": 42869,
      "wage_high_max": 80000,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Baltimore",
      "state": "MD",
      "postal_code": "21227",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 160000,
      "wage_high_max": 160000,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022
    },
    {
      "city": "Cresskill",
      "state": "NJ",
      "postal_code": "07626",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 45000,
      "wage_high_max": 55000,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "New York",
      "state": "NY",
      "postal_code": "10017",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 80000,
      "wage_high_max": 120000,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022
    },
    {
      "city": "Mckinney",
      "state": "TX",
      "postal_code": "75072",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 150000,
      "wage_high_max": 190000,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022
    }
  ]
}

Industry

{
  "naics_codes": [
    "541810",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "54181",
      "filing_count": 14,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "541810",
      "filing_count": 12,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ]
}

Wage Summary

{
  "annualized_low_min": 42869,
  "annualized_high_max": 190000,
  "annualized_low_avg": 75104.5769230769
}

Trend

[
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 45000,
    "wage_high_max": 55000,
    "wage_low_avg": 45000
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 42869,
    "wage_high_max": 80000,
    "wage_low_avg": 51434.5
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 7,
    "case_count": 7,
    "role_title_count": 5,
    "worksite_count": 2,
    "wage_low_min": 50000,
    "wage_high_max": 120000,
    "wage_low_avg": 60714.2857142857
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 1,
    "wage_low_min": 54850,
    "wage_high_max": 100000,
    "wage_low_avg": 64950
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 1,
    "wage_low_min": 55000,
    "wage_high_max": 115000,
    "wage_low_avg": 75000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q4",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 60000,
    "wage_high_max": 120000,
    "wage_low_avg": 73333.3333333333
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q1",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 80000,
    "wage_high_max": 130000,
    "wage_low_avg": 93333.3333333333
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q3",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 50000,
    "wage_high_max": 135000,
    "wage_low_avg": 75000
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q4",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 150000,
    "wage_high_max": 190000,
    "wage_low_avg": 155000
  }
]

Links

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

Docs · Get an API key