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

Home / Companies / MOTORISTS MUTUAL INSURANCE COMPANY

MOTORISTS MUTUAL INSURANCE COMPANY H-1B company data

Summary

MOTORISTS MUTUAL INSURANCE COMPANY filed 31 H-1B labor condition applications (LCAs) with the U.S. Department of Labor between FY2016-FY2018.

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

The filings span 14 distinct role titles across 1 worksites.

The most-sponsored role was Etl Developer Ii (6 filings), with offered wages from $98,011 to $0.

Separately, USCIS H-1B Employer Data Hub records show 4 approved and 0 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
MOTORISTS MUTUAL INSURANCE COMPANY
MOTORISTS MUTUAL INSURANCE COMPANY
31141FY2016 to FY2018
Latest decision 2017-11-01
4ETL DEVELOPER II
6 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings31
Certified LCAs25
Denied LCAs0
Role titles14
Worksites1
Latest decision2017-11-01
USCIS approvals4
USCIS denials0

Aliases and source names

AliasesSource NamesSources
MOTORISTS MUTUAL INSURANCE COMPANYMOTORISTS MUTUAL INSURANCE COMPANYdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
ETL DEVELOPER II15-11336$98,011$0
ETL DEVELOPER15-11334$95,004$0
DATA ANALYST II15-11323$87,000$0
ETL DEVELOPER II15-11323$103,636$0
INTEGRATION DEVELOPER15-11322$70,044$0
QA AUTOMATION ANALYST15-11322$70,018$0
SYSTEMS ENGINEER II15-11332$93,047$0
BUSINESS ANALYST II15-11211$80,028$0
DOCUMENT MANAGEMENT TECHNICAL LEAD15-11321$120,016$0
DOCUMENT SOLUTIONS DEVELOPER15-11331$90,012$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
ColumbusOH43215311464,01202,0162,018

Full company payload

Company IDcompany:motorists mutual insurance
NameMOTORISTS MUTUAL INSURANCE COMPANY
Normalized Namemotorists mutual insurance
Source Company Idscompany_dol_oflc_lca_motorists_mutual_insurance_company, company_uscis_h1b_datahub_motorists_mutual_insurance_company_tax_9550
Source NamesMOTORISTS MUTUAL INSURANCE COMPANY
AliasesMOTORISTS MUTUAL INSURANCE COMPANY
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "MOTORISTS MUTUAL INSURANCE COMPANY"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "MOTORISTS MUTUAL INSURANCE COMPANY",
      "filing_count": 31,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "MOTORISTS MUTUAL INSURANCE COMPANY",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "9550",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 31,
  "case_count": 31,
  "role_title_count": 14,
  "worksite_count": 1,
  "total_workers": 31,
  "first_fiscal_year": 2016,
  "first_received_date": "2015-10-20",
  "latest_fiscal_year": 2018,
  "latest_decision_date": "2017-11-01",
  "certified_count": 25,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 23,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "WITHDRAWN",
      "filing_count": 6,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED-WITHDRAWN",
      "filing_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 31,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 18,
      "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": 4,
  "total_denial": 0,
  "fiscal_years": [
    "2017"
  ],
  "year_metrics": [
    {
      "cities": [
        "Columbus"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "43215"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_motorists_mutual_insurance_company_tax_9550_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_019021"
      ],
      "continuing_approval": 4
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "COLUMBUS OH 43215",
      "city": "Columbus",
      "state": "OH",
      "postal_code": "43215",
      "filing_count": 31,
      "case_count": 31,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2017-11-01",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "COLUMBUS OH 43215",
      "city": "Columbus",
      "county": "Franklin",
      "state": "OH",
      "postal_code": "43215",
      "filing_count": 31,
      "case_count": 31,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2017-11-01",
      "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": [
    "OH"
  ],
  "cities": [
    "Columbus"
  ],
  "postal_codes": [
    "43215"
  ],
  "top_markets": [
    {
      "city": "Columbus",
      "state": "OH",
      "postal_code": "43215",
      "lca_count": 31,
      "role_title_count": 14,
      "wage_low_min": 64012,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018
    }
  ]
}
Industry
{
  "naics_codes": [
    "524126",
    "52"
  ],
  "naics_breakdown": [
    {
      "value": "524126",
      "filing_count": 18,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 64012,
  "annualized_high_max": 0,
  "annualized_low_avg": 91497.4838709677
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 13,
    "case_count": 13,
    "role_title_count": 5,
    "worksite_count": 1,
    "wage_low_min": 80028,
    "wage_high_max": 0,
    "wage_low_avg": 93791.6923076923
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 11,
    "case_count": 11,
    "role_title_count": 8,
    "worksite_count": 1,
    "wage_low_min": 64012,
    "wage_high_max": 0,
    "wage_low_avg": 83329.8181818182
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 7,
    "case_count": 7,
    "role_title_count": 3,
    "worksite_count": 1,
    "wage_low_min": 90012,
    "wage_high_max": 0,
    "wage_low_avg": 100071.714285714
  }
]
Links
{
  "roles": "/v1/roles?company=MOTORISTS%20MUTUAL%20INSURANCE%20COMPANY",
  "wages": "/v1/wages?company=MOTORISTS%20MUTUAL%20INSURANCE%20COMPANY",
  "trends": "/v1/trends?company=MOTORISTS%20MUTUAL%20INSURANCE%20COMPANY"
}

Frequently asked questions

Does MOTORISTS MUTUAL INSURANCE COMPANY sponsor H-1B visas?
Yes. MOTORISTS MUTUAL INSURANCE COMPANY filed 31 H-1B labor condition applications with the U.S. Department of Labor (FY2016-FY2018), of which 25 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 MOTORISTS MUTUAL INSURANCE COMPANY filed?
MOTORISTS MUTUAL INSURANCE COMPANY has 31 H-1B LCA filings on record spanning FY2016-FY2018 across 14 role titles and 1 worksites.
What roles does MOTORISTS MUTUAL INSURANCE COMPANY sponsor for H-1B?
The most common H-1B role at MOTORISTS MUTUAL INSURANCE COMPANY is Etl Developer Ii (6 filings). Other frequent roles include Etl Developer, Data Analyst Ii, Integration Developer, Qa Automation Analyst.
What wages does MOTORISTS MUTUAL INSURANCE COMPANY offer H-1B workers?
For its most-sponsored role (Etl Developer Ii), MOTORISTS MUTUAL INSURANCE COMPANY reported offered wages ranging from $98,011 to $0 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=motorists+mutual+insurance+company&limit=5JSON