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

Home / Companies / Artisan Consulting, Inc.

Artisan Consulting, Inc. 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
Artisan Consulting, Inc.
ARTISAN CONSULTING INC
3023FY2017 to FY2025
Latest decision 2025-09-26
14Photovoltaic Engineer
21 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings30
Certified LCAs30
Denied LCAs0
Role titles2
Worksites3
Latest decision2025-09-26
USCIS approvals14
USCIS denials0

Aliases and source names

AliasesSource NamesSources
ARTISAN CONSULTING INCArtisan Consulting, Inc., ARTISAN CONSULTING INCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
Photovoltaic Engineer17-2199.11
Solar Energy Systems Engineers
21$59,280$78,998
PHOTOVOLTAIC ENGINEER17-2199
ENGINEERS, ALL OTHER
6$61,402$80,309
Lead Controls Engineer17-2199.11
Solar Energy Systems Engineers
1$92,622$92,622
PHOTOVOLTAIC ENGINEER17-20711$80,500$0
Photovoltaic Engineer17-2071.00
Electrical Engineers
1$102,000$102,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
TroyMI4808422159,280102,0002,0172,025
Bloomfield HillsMI483047266,06192,6222,0242,025
TroyMI483261162,23462,2342,0192,019

Full company payload

Company IDcompany:artisan consulting
NameArtisan Consulting, Inc.
Normalized Nameartisan consulting
Source Company Idscompany_dol_oflc_lca_artisan_consulting_inc, company_uscis_h1b_datahub_artisan_consulting_inc_tax_4745
Source NamesArtisan Consulting, Inc., ARTISAN CONSULTING INC
AliasesARTISAN CONSULTING INC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Artisan Consulting, Inc.",
    "ARTISAN CONSULTING INC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "Artisan Consulting, Inc.",
      "filing_count": 23,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "ARTISAN CONSULTING, INC.",
      "filing_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "ARTISAN CONSULTING INC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "4745",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 30,
  "case_count": 30,
  "role_title_count": 2,
  "worksite_count": 3,
  "total_workers": 31,
  "first_fiscal_year": 2017,
  "first_received_date": "2017-03-06",
  "latest_fiscal_year": 2025,
  "latest_decision_date": "2025-09-26",
  "certified_count": 30,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 20,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 7,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified - Withdrawn",
      "filing_count": 3,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 30,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 30,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 14,
  "total_denial": 0,
  "fiscal_years": [
    "2009",
    "2011",
    "2012",
    "2013",
    "2016",
    "2018",
    "2020",
    "2021",
    "2022"
  ],
  "year_metrics": [
    {
      "cities": [
        "Rochester"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2009,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "48306"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_artisan_consulting_inc_tax_4745_2009",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2009_row_037300"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Rochester Hills"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2011,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "48307"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_artisan_consulting_inc_tax_4745_2011",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2011_row_035782"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Troy"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "48084"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_artisan_consulting_inc_tax_4745_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_031860"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Troy"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "48084"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_artisan_consulting_inc_tax_4745_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_030466"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Troy"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "48084"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_artisan_consulting_inc_tax_4745_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_025833"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Troy"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "48084"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_artisan_consulting_inc_tax_4745_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_025298"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Troy"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "22"
      ],
      "postal_codes": [
        "48084"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_artisan_consulting_inc_tax_4745_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_004237"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Troy"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "22",
        "54"
      ],
      "postal_codes": [
        "48084"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_artisan_consulting_inc_tax_4745_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_004844",
        "sr_uscis_h1b_datahub_2021_row_004845"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Troy"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "22"
      ],
      "postal_codes": [
        "48084"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_artisan_consulting_inc_tax_4745_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_004711"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "TROY MI 48084",
      "city": "Troy",
      "state": "MI",
      "postal_code": "48084",
      "filing_count": 22,
      "case_count": 22,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-09-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "BLOOMFIELD HILLS MI 48304",
      "city": "Bloomfield Hills",
      "state": "MI",
      "postal_code": "48304",
      "filing_count": 7,
      "case_count": 7,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-07-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "TROY MI 48326",
      "city": "Troy",
      "state": "MI",
      "postal_code": "48326",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-02-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "TROY MI 48084",
      "city": "Troy",
      "county": "Oakland",
      "state": "MI",
      "postal_code": "48084",
      "filing_count": 22,
      "case_count": 22,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-09-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BLOOMFIELD HILLS MI 48304",
      "city": "Bloomfield Hills",
      "county": "Oakland",
      "state": "MI",
      "postal_code": "48304",
      "filing_count": 6,
      "case_count": 6,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-06-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BLOOMFIELD HILLS MI 48304",
      "city": "Bloomfield Hills",
      "state": "MI",
      "postal_code": "48304",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-07-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "TROY MI 48326",
      "city": "Troy",
      "county": "Oakland",
      "state": "MI",
      "postal_code": "48326",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-02-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 3,
    "worksite_address_count": 4,
    "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": [
    "MI"
  ],
  "cities": [
    "Troy",
    "Bloomfield Hills",
    "Rochester",
    "Rochester Hills"
  ],
  "postal_codes": [
    "48084",
    "48304",
    "48326",
    "48306",
    "48307"
  ],
  "top_markets": [
    {
      "city": "Troy",
      "state": "MI",
      "postal_code": "48084",
      "lca_count": 22,
      "role_title_count": 1,
      "wage_low_min": 59280,
      "wage_high_max": 102000,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2025
    },
    {
      "city": "Bloomfield Hills",
      "state": "MI",
      "postal_code": "48304",
      "lca_count": 7,
      "role_title_count": 2,
      "wage_low_min": 66061,
      "wage_high_max": 92622,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2025
    },
    {
      "city": "Troy",
      "state": "MI",
      "postal_code": "48326",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 62234,
      "wage_high_max": 62234,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019
    }
  ]
}
Industry
{
  "naics_codes": [
    "541330",
    "22",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541330",
      "filing_count": 30,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 59280,
  "annualized_high_max": 102000,
  "annualized_low_avg": 71854.9666666667
}
Trend
[
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 61402,
    "wage_high_max": 0,
    "wage_low_avg": 61402
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 61589,
    "wage_high_max": 0,
    "wage_low_avg": 73876
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 1,
    "worksite_count": 2,
    "wage_low_min": 62234,
    "wage_high_max": 80309,
    "wage_low_avg": 68259
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 59280,
    "wage_high_max": 76066,
    "wage_low_avg": 67673
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 77834,
    "wage_high_max": 77834,
    "wage_low_avg": 77834
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 77834,
    "wage_high_max": 77834,
    "wage_low_avg": 77834
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 102000,
    "wage_high_max": 102000,
    "wage_low_avg": 102000
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 59280,
    "wage_high_max": 65000,
    "wage_low_avg": 61949.3333333333
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q3",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 70000,
    "wage_high_max": 78998,
    "wage_low_avg": 74499
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 67246,
    "wage_high_max": 75000,
    "wage_low_avg": 69830.6666666667
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q3",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 1,
    "worksite_count": 2,
    "wage_low_min": 72000,
    "wage_high_max": 72000,
    "wage_low_avg": 72000
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q3",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 66061,
    "wage_high_max": 78500,
    "wage_low_avg": 70655.5
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q4",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 67246,
    "wage_high_max": 92622,
    "wage_low_avg": 79934
  }
]
Links
{
  "roles": "/v1/roles?company=Artisan%20Consulting%2C%20Inc.",
  "wages": "/v1/wages?company=Artisan%20Consulting%2C%20Inc.",
  "trends": "/v1/trends?company=Artisan%20Consulting%2C%20Inc."
}
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=artisan+consulting+inc&limit=5JSON