Home / Companies / Data Warehouse Consultants, LLC
Data Warehouse Consultants, 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.
| Employer | LCA filings | Role titles | Worksites | Coverage | USCIS approvals | Top role | Sources | Open |
|---|---|---|---|---|---|---|---|---|
| Data Warehouse Consultants, LLC DATA WAREHOUSE CONSULTANTS LLC | 12 | 5 | 2 | FY2017 to FY2025 Latest decision 2025-08-25 | 7 | SENIOR COMPUTER SYSTEMS CONSULTANT 3 filings | dol_oflc_lca, uscis_h1b_employer_data_hub | Profile |
Activity summary
| LCA filings | 12 |
| Certified LCAs | 12 |
| Denied LCAs | 0 |
| Role titles | 5 |
| Worksites | 2 |
| Latest decision | 2025-08-25 |
| USCIS approvals | 7 |
| USCIS denials | 1 |
Aliases and source names
| Aliases | Source Names | Sources |
|---|---|---|
| DATA WAREHOUSE CONSULTANTS LLC | Data Warehouse Consultants, LLC, DATA WAREHOUSE CONSULTANTS LLC | dol_oflc_lca, uscis_h1b_employer_data_hub |
Top roles
| Title | SOC | LCA filings | Low wage min | High wage max |
|---|---|---|---|---|
| SENIOR COMPUTER SYSTEMS CONSULTANT | 15-1121 | 3 | $91,650 | $0 |
| Senior Consultant | 15-1243.01 Data Warehousing Specialists | 2 | $111,540 | $111,540 |
| Senior Consultant, Predictive Analytics | 15-1121.00 Computer Systems Analysts | 2 | $97,630 | $114,400 |
| COMPUTER SYSTEMS CONSULTANT | 15-1121 | 1 | $72,800 | $0 |
| Senior Consultant | 15-1199.07 Data Warehousing Specialists | 1 | $94,600 | $94,600 |
| Senior Consultant, Predictive Analytics | 15-1211.00 Computer Systems Analysts | 1 | $122,460 | $122,460 |
| Senior Consultant, Predictive Analytics | 15-1243.00 Database Architects | 1 | $144,300 | $144,300 |
| SENIOR SOFTWARE ENGINEER | 15-1132 | 1 | $80,080 | $0 |
Top markets
| City | State | Postal Code | LCA Count | Role Title Count | Wage Low Min | Wage High Max | First Fiscal Year | Latest Fiscal Year |
|---|---|---|---|---|---|---|---|---|
| Sewickley | PA | 15143 | 11 | 4 | 72,800 | 144,300 | 2,017 | 2,025 |
| Pittsburgh | PA | 15237 | 1 | 1 | 80,080 | 0 | 2,018 | 2,018 |
Full company payload
| Company ID | company:data warehouse consultants |
| Name | Data Warehouse Consultants, LLC |
| Normalized Name | data warehouse consultants |
| Source Company Ids | company_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 Names | Data Warehouse Consultants, LLC, DATA WAREHOUSE CONSULTANTS LLC |
| Aliases | DATA WAREHOUSE CONSULTANTS LLC |
| Sources | dol_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"
}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