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

Home / Companies / Constellation Agency LLC

Constellation Agency LLC H-1B company data

Summary

Constellation Agency LLC filed 26 H-1B labor condition applications (LCAs) with the U.S. Department of Labor between FY2017-FY2022.

Of those, 24 were certified (a 100% certification rate among adjudicated filings).

The filings span 17 distinct role titles across 7 worksites.

The most-sponsored role was Digital Campaign Manager (4 filings), with offered wages from $60,000 to $80,000.

Separately, USCIS H-1B Employer Data Hub records show 12 approved and 1 denied H-1B petitions for this employer.

LCA filings are labor-condition applications certified by the U.S. Department of Labor, not active job postings or approved USCIS H-1B petitions.

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
Constellation Agency LLC
CONSTELLATION AGENCY LLC
26177FY2017 to FY2022
Latest decision 2022-08-29
12DIGITAL CAMPAIGN MANAGER
4 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings26
Certified LCAs24
Denied LCAs0
Role titles17
Worksites7
Latest decision2022-08-29
USCIS approvals12
USCIS denials1

Aliases and source names

AliasesSource NamesSources
CONSTELLATION AGENCY LLCConstellation Agency LLC, CONSTELLATION AGENCY LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
DIGITAL CAMPAIGN MANAGER13-1161
MARKET RESEARCH ANALYSTS AND MARKETING SPECIALISTS
4$60,000$80,000
Associate Software Engineer15-1132.00
Software Developers, Applications
2$80,000$100,000
Data Scientist15-2031.00
Operations Research Analysts
2$100,000$130,000
GRAPHIC DESIGNER27-1024
GRAPHIC DESIGNERS
2$45,000$80,000
ACCOUNT EXECUTIVE13-1161
MARKET RESEARCH ANALYSTS AND MARKETING SPECIALISTS
1$60,000$80,000
ACCOUNT MANAGER13-1161
MARKET RESEARCH ANALYSTS AND MARKETING SPECIALISTS
1$55,000$80,000
ACCOUNT MANAGER27-30411$42,869$62,869
Associate Data Engineer15-2041.00
Statisticians
1$75,000$95,000
Associate Data Scientist15-1132.00
Software Developers, Applications
1$80,000$100,000
Associate Director of Campaigns15-1199.10
Search Marketing Strategists
1$80,000$120,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
New YorkNY10038121150,000120,0002,0192,021
New YorkNY100077550,000135,0002,0212,022
New YorkNY100043242,86980,0002,0182,019
BaltimoreMD2122711160,000160,0002,0222,022
CresskillNJ076261145,00055,0002,0172,017
New YorkNY100171180,000120,0002,0222,022
MckinneyTX7507211150,000190,0002,0222,022

Full company payload

Company IDcompany:constellation agency
NameConstellation Agency LLC
Normalized Nameconstellation agency
Source Company Idscompany_dol_oflc_lca_constellation_agency_llc, company_uscis_h1b_datahub_constellation_agency_llc_tax_1912
Source NamesConstellation Agency LLC, CONSTELLATION AGENCY LLC
AliasesCONSTELLATION AGENCY LLC
Sourcesdol_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"
}

Frequently asked questions

Does Constellation Agency LLC sponsor H-1B visas?
Yes. Constellation Agency LLC filed 26 H-1B labor condition applications with the U.S. Department of Labor (FY2017-FY2022), of which 24 were certified. LCA filings are labor-condition applications certified by the U.S. Department of Labor, not active job postings or approved USCIS H-1B petitions.
How many H-1B applications has Constellation Agency LLC filed?
Constellation Agency LLC has 26 H-1B LCA filings on record spanning FY2017-FY2022 across 17 role titles and 7 worksites.
What roles does Constellation Agency LLC sponsor for H-1B?
The most common H-1B role at Constellation Agency LLC is Digital Campaign Manager (4 filings). Other frequent roles include Associate Software Engineer, Data Scientist, Graphic Designer, Account Executive.
What wages does Constellation Agency LLC offer H-1B workers?
For its most-sponsored role (Digital Campaign Manager), Constellation Agency LLC reported offered wages ranging from $60,000 to $80,000 in DOL LCA filings.
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