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

Home / Companies / TESSELLATI, LLC

TESSELLATI, 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
TESSELLATI, LLC
TESSELLATI LLC
541FY2016 to FY2024
Latest decision 2024-06-10
0MARKET RESEARCH ANALYST
2 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings5
Certified LCAs5
Denied LCAs0
Role titles4
Worksites1
Latest decision2024-06-10
USCIS approvals0
USCIS denials1

Aliases and source names

AliasesSource NamesSources
TESSELLATI LLCTESSELLATI, LLC, TESSELLATI LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
MARKET RESEARCH ANALYST13-11612$42,058$0
Business Analyst13-1161.00
Market Research Analysts and Marketing Specialists
1$67,683$67,683
DIGITAL MARKETING ANALYST13-11611$41,800$0
Digital Marketing Campaign Analyst13-1161.00
Market Research Analysts and Marketing Specialists
1$67,683$67,683

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
SalemMA019705441,80067,6832,0162,024

Full company payload

Company IDcompany:tessellati
NameTESSELLATI, LLC
Normalized Nametessellati
Source Company Idscompany_dol_oflc_lca_tessellati_llc, company_uscis_h1b_datahub_tessellati_llc_tax_8467
Source NamesTESSELLATI, LLC, TESSELLATI LLC
AliasesTESSELLATI LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "TESSELLATI, LLC",
    "TESSELLATI LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "TESSELLATI, LLC",
      "filing_count": 5,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "TESSELLATI LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "8467",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 5,
  "case_count": 5,
  "role_title_count": 4,
  "worksite_count": 1,
  "total_workers": 5,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-03-15",
  "latest_fiscal_year": 2024,
  "latest_decision_date": "2024-06-10",
  "certified_count": 5,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 5,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 4,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 0,
  "total_denial": 1,
  "fiscal_years": [
    "2019"
  ],
  "year_metrics": [
    {
      "cities": [
        "Salem"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "01970"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_tessellati_llc_tax_8467_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_019555"
      ],
      "continuing_approval": 0
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "SALEM MA 01970",
      "city": "Salem",
      "state": "MA",
      "postal_code": "01970",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-06-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "SALEM MA 01970",
      "city": "Salem",
      "county": "Essex",
      "state": "MA",
      "postal_code": "01970",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-06-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 1,
    "worksite_address_count": 1,
    "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": [
    "MA"
  ],
  "cities": [
    "Salem"
  ],
  "postal_codes": [
    "01970"
  ],
  "top_markets": [
    {
      "city": "Salem",
      "state": "MA",
      "postal_code": "01970",
      "lca_count": 5,
      "role_title_count": 4,
      "wage_low_min": 41800,
      "wage_high_max": 67683,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024
    }
  ]
}
Industry
{
  "naics_codes": [
    "541613",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541613",
      "filing_count": 4,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 41800,
  "annualized_high_max": 67683,
  "annualized_low_avg": 52793
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 44741,
    "wage_high_max": 0,
    "wage_low_avg": 44741
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 42058,
    "wage_high_max": 0,
    "wage_low_avg": 42058
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 41800,
    "wage_high_max": 0,
    "wage_low_avg": 41800
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q3",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 67683,
    "wage_high_max": 67683,
    "wage_low_avg": 67683
  }
]
Links
{
  "roles": "/v1/roles?company=TESSELLATI%2C%20LLC",
  "wages": "/v1/wages?company=TESSELLATI%2C%20LLC",
  "trends": "/v1/trends?company=TESSELLATI%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=tessellati+llc&limit=5JSON