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

Home / Companies / Data Warehouse Consultants, LLC

Data Warehouse Consultants, LLC H-1B company data

Summary

Data Warehouse Consultants, LLC filed 12 H-1B labor condition applications (LCAs) with the U.S. Department of Labor between FY2017-FY2025.

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

The filings span 5 distinct role titles across 2 worksites.

The most-sponsored role was Senior Computer Systems Consultant (3 filings), with offered wages from $91,650 to $0.

Separately, USCIS H-1B Employer Data Hub records show 7 approved and 1 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
Data Warehouse Consultants, LLC
DATA WAREHOUSE CONSULTANTS LLC
1252FY2017 to FY2025
Latest decision 2025-08-25
7SENIOR COMPUTER SYSTEMS CONSULTANT
3 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings12
Certified LCAs12
Denied LCAs0
Role titles5
Worksites2
Latest decision2025-08-25
USCIS approvals7
USCIS denials1

Aliases and source names

AliasesSource NamesSources
DATA WAREHOUSE CONSULTANTS LLCData Warehouse Consultants, LLC, DATA WAREHOUSE CONSULTANTS LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
SENIOR COMPUTER SYSTEMS CONSULTANT15-11213$91,650$0
Senior Consultant15-1243.01
Data Warehousing Specialists
2$111,540$111,540
Senior Consultant, Predictive Analytics15-1121.00
Computer Systems Analysts
2$97,630$114,400
COMPUTER SYSTEMS CONSULTANT15-11211$72,800$0
Senior Consultant15-1199.07
Data Warehousing Specialists
1$94,600$94,600
Senior Consultant, Predictive Analytics15-1211.00
Computer Systems Analysts
1$122,460$122,460
Senior Consultant, Predictive Analytics15-1243.00
Database Architects
1$144,300$144,300
SENIOR SOFTWARE ENGINEER15-11321$80,080$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
SewickleyPA1514311472,800144,3002,0172,025
PittsburghPA152371180,08002,0182,018

Full company payload

Company IDcompany:data warehouse consultants
NameData Warehouse Consultants, LLC
Normalized Namedata warehouse consultants
Source Company Idscompany_dol_oflc_lca_data_warehouse_consultants_llc, company_uscis_h1b_datahub_data_warehouse_consultants_llc_tax_0118, company_uscis_h1b_datahub_data_warehouse_consultants_llc_tax_118
Source NamesData Warehouse Consultants, LLC, DATA WAREHOUSE CONSULTANTS LLC
AliasesDATA WAREHOUSE CONSULTANTS LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Data Warehouse Consultants, LLC",
    "DATA WAREHOUSE CONSULTANTS LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "Data Warehouse Consultants, LLC",
      "filing_count": 6,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "DATA WAREHOUSE CONSULTANTS, LLC",
      "filing_count": 4,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Data Warehouse Consultants LLC",
      "filing_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "DATA WAREHOUSE CONSULTANTS LLC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "DATA WAREHOUSE CONSULTANTS LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "0118",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "118",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 12,
  "case_count": 12,
  "role_title_count": 5,
  "worksite_count": 2,
  "total_workers": 12,
  "first_fiscal_year": 2017,
  "first_received_date": "2017-03-07",
  "latest_fiscal_year": 2025,
  "latest_decision_date": "2025-08-25",
  "certified_count": 12,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 7,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 12,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 12,
      "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": 7,
  "total_denial": 1,
  "fiscal_years": [
    "2017",
    "2018",
    "2021",
    "2022"
  ],
  "year_metrics": [
    {
      "cities": [
        "Sewickley"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "99"
      ],
      "postal_codes": [
        "15143"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_data_warehouse_consultants_llc_tax_0118_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_007662"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Sewickley"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "99"
      ],
      "postal_codes": [
        "15143"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_data_warehouse_consultants_llc_tax_0118_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_008143"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Pittsburgh"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "99"
      ],
      "postal_codes": [
        "15237"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_data_warehouse_consultants_llc_tax_0118_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_014581"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Pittsburgh",
        "Sewickley"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "51",
        "54"
      ],
      "postal_codes": [
        "15143",
        "15237"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_data_warehouse_consultants_llc_tax_0118_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_014420",
        "sr_uscis_h1b_datahub_2022_row_014421",
        "sr_uscis_h1b_datahub_2022_row_014422"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Pittsburgh"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "99"
      ],
      "postal_codes": [
        "15237"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_data_warehouse_consultants_llc_tax_118_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_014582"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "SEWICKLEY PA 15143",
      "city": "Sewickley",
      "state": "PA",
      "postal_code": "15143",
      "filing_count": 8,
      "case_count": 8,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-08-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "PITTSBURGH PA 15237",
      "city": "Pittsburgh",
      "state": "PA",
      "postal_code": "15237",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-05-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "SEWICKLEY PA 15143",
      "city": "Sewickley",
      "county": "Allegheny",
      "state": "PA",
      "postal_code": "15143",
      "filing_count": 10,
      "case_count": 10,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-05-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SEWICKLEY PA 15143",
      "city": "Sewickley",
      "state": "PA",
      "postal_code": "15143",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-08-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "PITTSBURGH PA 15237",
      "city": "Pittsburgh",
      "county": "Allegheny",
      "state": "PA",
      "postal_code": "15237",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-19",
      "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": [
    "PA"
  ],
  "cities": [
    "Sewickley",
    "Pittsburgh"
  ],
  "postal_codes": [
    "15143",
    "15237"
  ],
  "top_markets": [
    {
      "city": "Sewickley",
      "state": "PA",
      "postal_code": "15143",
      "lca_count": 11,
      "role_title_count": 4,
      "wage_low_min": 72800,
      "wage_high_max": 144300,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2025
    },
    {
      "city": "Pittsburgh",
      "state": "PA",
      "postal_code": "15237",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 80080,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    }
  ]
}
Industry
{
  "naics_codes": [
    "5416",
    "51",
    "54",
    "99"
  ],
  "naics_breakdown": [
    {
      "value": "5416",
      "filing_count": 6,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "54151",
      "filing_count": 3,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "541511",
      "filing_count": 3,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 72800,
  "annualized_high_max": 144300,
  "annualized_low_avg": 102566.666666667
}
Trend
[
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 72800,
    "wage_high_max": 0,
    "wage_low_avg": 88562.5
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 80080,
    "wage_high_max": 0,
    "wage_low_avg": 80080
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 97630,
    "wage_high_max": 97630,
    "wage_low_avg": 97630
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 114400,
    "wage_high_max": 114400,
    "wage_low_avg": 114400
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 94600,
    "wage_high_max": 94600,
    "wage_low_avg": 94600
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 122460,
    "wage_high_max": 122460,
    "wage_low_avg": 122460
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q3",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 111540,
    "wage_high_max": 111540,
    "wage_low_avg": 111540
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 144300,
    "wage_high_max": 144300,
    "wage_low_avg": 144300
  }
]
Links
{
  "roles": "/v1/roles?company=Data%20Warehouse%20Consultants%2C%20LLC",
  "wages": "/v1/wages?company=Data%20Warehouse%20Consultants%2C%20LLC",
  "trends": "/v1/trends?company=Data%20Warehouse%20Consultants%2C%20LLC"
}

Frequently asked questions

Does Data Warehouse Consultants, LLC sponsor H-1B visas?
Yes. Data Warehouse Consultants, LLC filed 12 H-1B labor condition applications with the U.S. Department of Labor (FY2017-FY2025), of which 12 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 Data Warehouse Consultants, LLC filed?
Data Warehouse Consultants, LLC has 12 H-1B LCA filings on record spanning FY2017-FY2025 across 5 role titles and 2 worksites.
What roles does Data Warehouse Consultants, LLC sponsor for H-1B?
The most common H-1B role at Data Warehouse Consultants, LLC is Senior Computer Systems Consultant (3 filings). Other frequent roles include Senior Consultant, Senior Consultant, Predictive Analytics, Computer Systems Consultant, Senior Software Engineer.
What wages does Data Warehouse Consultants, LLC offer H-1B workers?
For its most-sponsored role (Senior Computer Systems Consultant), Data Warehouse Consultants, LLC reported offered wages ranging from $91,650 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=data+warehouse+consultants+llc&limit=5JSON