Data / Hiring / Illinois / Advanced Analytics LLC D/B/A HEXstream
Advanced Analytics LLC D/B/A HEXstream in Chicago, IL: 20 certified H-1B and PERM cases, FY2023 to FY2026
Advanced Analytics LLC D/B/A HEXstream, Chicago, IL, had 20 certified H-1B and PERM cases in Department of Labor disclosure data, decided from December 1, 2022 to February 24, 2026: 16 H-1B labor condition applications and 4 PERM labor certifications. Its most frequent role is BI/ETL Consultant in Chicago, IL, at a median offered wage of $122,970 a year.
SpecStream is the live web data engine for teams and agents. It reads the Department of Labor's H-1B and PERM disclosure files and keeps each employer's filings by role, place and wage. Ask for your own cut (a role, a state, a list of companies) and new filings arrive in your sheet, CRM, Slack or agent.
- 82-0637846Employer ID (FEIN)
- Chicago, ILAddress
- 20Certified cases
- 20Positions requested
- 0Denied or withdrawn
Certified cases by fiscal year
Fiscal years run from October 1 to September 30. The latest year covers decisions through February 24, 2026.
| Fiscal year | H-1B | PERM | Positions | Median offered wage |
|---|---|---|---|---|
| FY2023 | 7 | 0 | 7 | $124,800 |
| FY2024 | 1 | 0 | 1 | $103,783 |
| FY2025 | 4 | 0 | 4 | $122,949 |
| FY2026 | 4 | 4 | 8 | $125,143 |
Roles certified
Cases with the same job title, occupation code and worksite are grouped. Offered wage is the wage the employer filed; the range leaves out the lowest and highest 5% when a group has 20 cases or more. The prevailing wage is the one the employer filed against. A blank worksite means the file does not give one.
| Job title | Occupation | Worksite | Cases | Years | Median offered | Offered range | Median prevailing | Wage level | Program | Latest decision | Latest case number | Source |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BI/ETL Consultant | 15-1252 Software Developers | Chicago, IL | 4 | FY2023 to FY2025 | $108,892 | $103,783 to $127,339 | $98,353 | II | H-1B | September 2, 2025 | I-200-25237-263816 | dol.gov |
| ODI/ETL Developer | 15-2051 Business Intelligence Analysts | Chicago, IL | 3 | FY2026 | $89,690 | $89,690 to $89,690 | Not listed | PERM | February 24, 2026 | G-100-24288-404604 | dol.gov | |
| Integration and Analytics Lead | 15-1243 Data Warehousing Specialists | Chicago, IL | 2 | FY2023 to FY2026 | $126,048 | $124,800 to $127,297 | $100,692 | II | H-1B | December 16, 2025 | I-200-25343-467200 | dol.gov |
| Project Manager | 11-3021 Computer and Information Systems Managers | Katy, TX | 2 | FY2026 | $151,500 | $151,500 to $151,501 | $147,202 | II | H-1B | December 3, 2025 | I-200-25329-435495 | dol.gov |
| BI/ETL Consultant | 15-1252 Software Developers | Richmond, TX | 1 | FY2025 | $127,350 | $127,350 to $127,351 | $103,210 | II | H-1B | November 20, 2024 | I-200-24318-471194 | dol.gov |
| Data Scientist | 15-2051 Data Scientists | Chicago, IL | 1 | FY2023 | $86,940 | $86,940 to $86,940 | $84,718 | II | H-1B | January 12, 2023 | I-200-23005-684001 | dol.gov |
| Data Solutions Engineer | 15-1243 Data Warehousing Specialists | Chicago, IL | 1 | FY2026 | $127,296 | $127,296 to $127,297 | $113,235 | II | H-1B | December 23, 2025 | I-200-25350-485301 | dol.gov |
| Integration and Analytics Lead | 15-1252 Software Developers | Chicago, IL | 1 | FY2023 | $124,800 | $124,800 to $124,801 | $114,067 | III | H-1B | May 24, 2023 | I-200-23137-028590 | dol.gov |
| Integrations and Analytics Lead | 15-1243 Data Warehousing Specialists | Chicago, IL | 1 | FY2025 | $122,949 | $122,949 to $122,950 | $96,741 | II | H-1B | December 3, 2024 | I-200-24331-499847 | dol.gov |
| Integrations and Analytics Lead | 15-1243 Data Warehousing Specialists | Prosper, TX | 1 | FY2025 | $122,949 | $122,949 to $122,950 | $122,949 | II | H-1B | November 27, 2024 | I-200-24326-490007 | dol.gov |
| Project Manager | 15-1299 Information Technology Project Managers | Chicago, IL | 1 | FY2023 | $150,000 | $150,000 to $150,001 | $72,426 | II | H-1B | May 12, 2023 | I-200-23125-995742 | dol.gov |
| Software Developer | 15-1252 Software Developers | Chicago, IL | 1 | FY2023 | $99,382 | $99,382 to $99,383 | $94,016 | II | H-1B | January 9, 2023 | I-200-23002-674444 | dol.gov |
| Sr. Project Manager | 13-1082 Project Management Specialists | Chicago, IL | 1 | FY2026 | $122,990 | $122,990 to $122,990 | Not listed | PERM | February 23, 2026 | G-100-24282-392456 | dol.gov |
Worksite states
Also on SpecStream
- Every company hiring Software Developers in Illinois
- Every company hiring Data Scientists in Illinois
- Every company hiring Database Architects in Illinois
Updated February 24, 2026. Read from US Department of Labor, Office of Foreign Labor Certification. Public domain (U.S. government work). A certified labor condition application (H-1B, H-1B1, E-3) or PERM labor certification is an employer filing the Department of Labor approved. It is not a count of people hired or visas issued. Wages are as the employer filed them, converted to a yearly figure at 2,080 hours; a wage whose unit is missing is left blank. The files show the first worksite of a case. Free to reuse with credit to SpecStream under CC BY 4.0. Spot a wrong value? Write to [email protected] with the link to this page.