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

Home / Companies / Mhill Consulting, LLC

Mhill 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
Mhill Consulting, LLC
MHILL CONSULTING LLC
1628FY2016 to FY2023
Latest decision 2023-06-14
6COMPUTER SYSTEMS ANALYST
8 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings16
Certified LCAs16
Denied LCAs0
Role titles2
Worksites8
Latest decision2023-06-14
USCIS approvals6
USCIS denials1

Aliases and source names

AliasesSource NamesSources
MHILL CONSULTING LLCMhill Consulting, LLC, MHILL CONSULTING LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
COMPUTER SYSTEMS ANALYST15-1121.00
Computer Systems Analysts
8$160,000$200,000
COMPUTER SYSTEMS ANALYST15-11214$160,000$0
Computer Systems Analysts15-1121.00
Computer Systems Analysts
2$160,000$160,000
Computer Systems Analyst15-1211.00
Computer Systems Analysts
1$200,000$200,000
COMPUTER SYSTEMS ANALYSTS15-11211$100,402$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
BostonMA0211662160,000200,0002,0172,023
BostonMA211631200,000200,0002,0202,022
DublinOH4301722160,000200,0002,0202,022
BethelCT0680111160,00002,0172,017
BrooklineMA0244511100,40202,0162,016
North BergenNJ0704711160,00002,0182,018
North WalesPA1945411160,00002,0172,017
SeattleWA9813611200,000200,0002,0222,022

Full company payload

Company IDcompany:mhill consulting
NameMhill Consulting, LLC
Normalized Namemhill consulting
Source Company Idscompany_dol_oflc_lca_mhill_consulting_llc, company_uscis_h1b_datahub_mhill_consulting_llc_tax_2142
Source NamesMhill Consulting, LLC, MHILL CONSULTING LLC
AliasesMHILL CONSULTING LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Mhill Consulting, LLC",
    "MHILL CONSULTING LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "MHILL CONSULTING LLC",
      "filing_count": 9,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Mhill Consulting, LLC",
      "filing_count": 5,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "MHILL CONSULTING, LLC",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "MHILL CONSULTING LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "2142",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 16,
  "case_count": 16,
  "role_title_count": 2,
  "worksite_count": 8,
  "total_workers": 16,
  "first_fiscal_year": 2016,
  "first_received_date": "2015-10-06",
  "latest_fiscal_year": 2023,
  "latest_decision_date": "2023-06-14",
  "certified_count": 16,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 11,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 5,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 16,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 15,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 6,
  "total_denial": 1,
  "fiscal_years": [
    "2015",
    "2016",
    "2018",
    "2021",
    "2022"
  ],
  "year_metrics": [
    {
      "cities": [
        "Brookline"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "02445"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_mhill_consulting_llc_tax_2142_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_023718"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Brookline"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "02445"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_mhill_consulting_llc_tax_2142_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_024861"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Boston"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "02116"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_mhill_consulting_llc_tax_2142_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_024198"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Boston"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "02116",
        "2116"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_mhill_consulting_llc_tax_2142_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_033856",
        "sr_uscis_h1b_datahub_2021_row_033857"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Boston"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "02116"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_mhill_consulting_llc_tax_2142_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_033888"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "BOSTON MA 02116",
      "city": "Boston",
      "state": "MA",
      "postal_code": "02116",
      "filing_count": 10,
      "case_count": 10,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-06-14",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "BOSTON MA 2116",
      "city": "Boston",
      "state": "MA",
      "postal_code": "2116",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-02-01",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "BROOKLINE MA 02445",
      "city": "Brookline",
      "state": "MA",
      "postal_code": "02445",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2015-10-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "BOSTON MA 02116",
      "city": "Boston",
      "county": "Boston City",
      "state": "MA",
      "postal_code": "02116",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-06-14",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BOSTON MA 2116",
      "city": "Boston",
      "county": "Boston City",
      "state": "MA",
      "postal_code": "2116",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-02-01",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "DUBLIN OH 43017",
      "city": "Dublin",
      "county": "Franklin",
      "state": "OH",
      "postal_code": "43017",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-01-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SEATTLE WA 98136",
      "city": "Seattle",
      "county": "King",
      "state": "WA",
      "postal_code": "98136",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-01-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NORTH BERGEN NJ 07047",
      "city": "North Bergen",
      "county": "Hudson",
      "state": "NJ",
      "postal_code": "07047",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2017-12-05",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NORTH WALES PA 19454",
      "city": "North Wales",
      "county": "Montgomery",
      "state": "PA",
      "postal_code": "19454",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-08-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BETHEL CT 06801",
      "city": "Bethel",
      "county": "Fairfield",
      "state": "CT",
      "postal_code": "06801",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-08-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BOSTON MA 02116",
      "city": "Boston",
      "county": "Suffolk",
      "state": "MA",
      "postal_code": "02116",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-07-31",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BROOKLINE MA 02445",
      "city": "Brookline",
      "county": "Middlesex",
      "state": "MA",
      "postal_code": "02445",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2015-10-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 3,
    "worksite_address_count": 9,
    "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",
    "OH",
    "CT",
    "NJ",
    "PA",
    "WA"
  ],
  "cities": [
    "Boston",
    "Dublin",
    "Bethel",
    "Brookline",
    "North Bergen",
    "North Wales",
    "Seattle"
  ],
  "postal_codes": [
    "02116",
    "2116",
    "43017",
    "06801",
    "02445",
    "07047",
    "19454",
    "98136"
  ],
  "top_markets": [
    {
      "city": "Boston",
      "state": "MA",
      "postal_code": "02116",
      "lca_count": 6,
      "role_title_count": 2,
      "wage_low_min": 160000,
      "wage_high_max": 200000,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2023
    },
    {
      "city": "Boston",
      "state": "MA",
      "postal_code": "2116",
      "lca_count": 3,
      "role_title_count": 1,
      "wage_low_min": 200000,
      "wage_high_max": 200000,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2022
    },
    {
      "city": "Dublin",
      "state": "OH",
      "postal_code": "43017",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 160000,
      "wage_high_max": 200000,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2022
    },
    {
      "city": "Bethel",
      "state": "CT",
      "postal_code": "06801",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 160000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Brookline",
      "state": "MA",
      "postal_code": "02445",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 100402,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "North Bergen",
      "state": "NJ",
      "postal_code": "07047",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 160000,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    },
    {
      "city": "North Wales",
      "state": "PA",
      "postal_code": "19454",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 160000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Seattle",
      "state": "WA",
      "postal_code": "98136",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 200000,
      "wage_high_max": 200000,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022
    }
  ]
}
Industry
{
  "naics_codes": [
    "541512",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541512",
      "filing_count": 15,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 100402,
  "annualized_high_max": 200000,
  "annualized_low_avg": 176275.125
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 100402,
    "wage_high_max": 0,
    "wage_low_avg": 100402
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 1,
    "worksite_count": 3,
    "wage_low_min": 160000,
    "wage_high_max": 0,
    "wage_low_avg": 160000
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 160000,
    "wage_high_max": 0,
    "wage_low_avg": 160000
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 200000,
    "wage_high_max": 200000,
    "wage_low_avg": 200000
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q4",
    "lca_count": 5,
    "case_count": 5,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 160000,
    "wage_high_max": 200000,
    "wage_low_avg": 176000
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q2",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 1,
    "worksite_count": 3,
    "wage_low_min": 200000,
    "wage_high_max": 200000,
    "wage_low_avg": 200000
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 200000,
    "wage_high_max": 200000,
    "wage_low_avg": 200000
  }
]
Links
{
  "roles": "/v1/roles?company=Mhill%20Consulting%2C%20LLC",
  "wages": "/v1/wages?company=Mhill%20Consulting%2C%20LLC",
  "trends": "/v1/trends?company=Mhill%20Consulting%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=mhill+consulting+llc&limit=5JSON