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

Home / Companies / ZIERRA CONSULTING LLC

ZIERRA CONSULTING 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
ZIERRA CONSULTING LLC
ZIERRA CONSULTING LLC
1053FY2016 to FY2018
Latest decision 2018-01-30
0COMPUTER PROGRAMMER
6 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings10
Certified LCAs6
Denied LCAs2
Role titles5
Worksites3
Latest decision2018-01-30
USCIS approvals0
USCIS denials1

Aliases and source names

AliasesSource NamesSources
ZIERRA CONSULTING LLCZIERRA CONSULTING LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
COMPUTER PROGRAMMER15-11316$49,920$0
APPLICATION SOFTWARE DEVELOPER15-11111$62,400$72,800
NETWORK AND COMPUTER SYSTEM ADMINISTRATOR15-11421$56,160$0
QUALITY ASSURANCE ENGINEER15-11991$73,050$0
SR. CONSULTANT15-11111$62,400$72,800

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
ShrewsburyMA015455454,08072,8002,0162,016
San AntonioTX782404249,92002,0162,017
MarlboroughMA017521183,20002,0182,018

Full company payload

Company IDcompany:zierra consulting
NameZIERRA CONSULTING LLC
Normalized Namezierra consulting
Source Company Idscompany_dol_oflc_lca_zierra_consulting_llc, company_uscis_h1b_datahub_zierra_consulting_llc_tax_5478
Source NamesZIERRA CONSULTING LLC
AliasesZIERRA CONSULTING LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "ZIERRA CONSULTING LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "ZIERRA CONSULTING LLC",
      "filing_count": 9,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "ZIERRA CONSULTING, LLC",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "ZIERRA CONSULTING LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5478",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 10,
  "case_count": 10,
  "role_title_count": 5,
  "worksite_count": 3,
  "total_workers": 15,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-03-02",
  "latest_fiscal_year": 2018,
  "latest_decision_date": "2018-01-30",
  "certified_count": 6,
  "denied_count": 2,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 6,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "DENIED",
      "filing_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    },
    {
      "value": "WITHDRAWN",
      "filing_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 10,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "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": [
    "2018"
  ],
  "year_metrics": [
    {
      "cities": [
        "Shrewsbury"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "01545"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_zierra_consulting_llc_tax_5478_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_047749"
      ],
      "continuing_approval": 0
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "MARLBOROUGH MA 01752",
      "city": "Marlborough",
      "state": "MA",
      "postal_code": "01752",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-01-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "SHREWSBURY MA 01545",
      "city": "Shrewsbury",
      "state": "MA",
      "postal_code": "01545",
      "filing_count": 9,
      "case_count": 9,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "MARLBOROUGH MA 01752",
      "city": "Marlborough",
      "county": "Middlesex County",
      "state": "MA",
      "postal_code": "01752",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-01-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SAN ANTONIO TX 78240",
      "city": "San Antonio",
      "county": "Bexar",
      "state": "TX",
      "postal_code": "78240",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SHREWSBURY MA 01545",
      "city": "Shrewsbury",
      "county": "Worcester",
      "state": "MA",
      "postal_code": "01545",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "worksite_address_count": 3,
    "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",
    "TX"
  ],
  "cities": [
    "Shrewsbury",
    "San Antonio",
    "Marlborough"
  ],
  "postal_codes": [
    "01545",
    "78240",
    "01752"
  ],
  "top_markets": [
    {
      "city": "Shrewsbury",
      "state": "MA",
      "postal_code": "01545",
      "lca_count": 5,
      "role_title_count": 4,
      "wage_low_min": 54080,
      "wage_high_max": 72800,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "San Antonio",
      "state": "TX",
      "postal_code": "78240",
      "lca_count": 4,
      "role_title_count": 2,
      "wage_low_min": 49920,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Marlborough",
      "state": "MA",
      "postal_code": "01752",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 83200,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    }
  ]
}
Industry
{
  "naics_codes": [
    "5416",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541511",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "5416",
      "filing_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 49920,
  "annualized_high_max": 72800,
  "annualized_low_avg": 60969
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 8,
    "case_count": 8,
    "role_title_count": 4,
    "worksite_count": 2,
    "wage_low_min": 49920,
    "wage_high_max": 72800,
    "wage_low_avg": 56680
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 73050,
    "wage_high_max": 0,
    "wage_low_avg": 73050
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 83200,
    "wage_high_max": 0,
    "wage_low_avg": 83200
  }
]
Links
{
  "roles": "/v1/roles?company=ZIERRA%20CONSULTING%20LLC",
  "wages": "/v1/wages?company=ZIERRA%20CONSULTING%20LLC",
  "trends": "/v1/trends?company=ZIERRA%20CONSULTING%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=zierra+consulting+llc&limit=5JSON