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

Home / Companies / Redshift Enterprise Consulting Solutions, LLC

Redshift Enterprise Consulting Solutions, 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
Redshift Enterprise Consulting Solutions, LLC
REDSHIFT ENTERPRISE CONSULTING SOLUTIONS LLC
1242FY2021 to FY2025
Latest decision 2025-08-08
3Software Development Manager
3 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings12
Certified LCAs12
Denied LCAs0
Role titles4
Worksites2
Latest decision2025-08-08
USCIS approvals3
USCIS denials0

Aliases and source names

AliasesSource NamesSources
REDSHIFT ENTERPRISE CONSULTING SOLUTIONS LLCRedshift Enterprise Consulting Solutions, LLC, REDSHIFT ENTERPRISE CONSULTING SOLUTIONS LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
Software Development Manager15-1132.00
Software Developers, Applications
3$120,000$140,000
Software Development Manager15-1252.00
Software Developers
3$138,000$152,500
Computer Systems Analyst15-1211.00
Computer Systems Analysts
2$68,000$90,000
Computer Programmer15-1251.00
Computer Programmers
1$87,000$87,000
Computer Systems Analyst15-1121.00
Computer Systems Analysts
1$81,000$81,000
Director – Software Development15-1252.00
Software Developers
1$160,000$160,000
Software Development Manager15-1199.09
Information Technology Project Managers
1$112,000$112,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
AlpharettaGA3000510468,000160,0002,0212,025
HendersonNV8907421140,000140,0002,0212,021

Full company payload

Company IDcompany:redshift enterprise consulting solutions
NameRedshift Enterprise Consulting Solutions, LLC
Normalized Nameredshift enterprise consulting solutions
Source Company Idscompany_dol_oflc_lca_redshift_enterprise_consulting_solutions_llc, company_uscis_h1b_datahub_redshift_enterprise_consulting_solutions_llc_tax_0193
Source NamesRedshift Enterprise Consulting Solutions, LLC, REDSHIFT ENTERPRISE CONSULTING SOLUTIONS LLC
AliasesREDSHIFT ENTERPRISE CONSULTING SOLUTIONS LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Redshift Enterprise Consulting Solutions, LLC",
    "REDSHIFT ENTERPRISE CONSULTING SOLUTIONS LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "Redshift Enterprise Consulting Solutions LLC",
      "filing_count": 9,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Redshift Enterprise Consulting Solutions, LLC",
      "filing_count": 3,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "REDSHIFT ENTERPRISE CONSULTING SOLUTIONS LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "0193",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 12,
  "case_count": 12,
  "role_title_count": 4,
  "worksite_count": 2,
  "total_workers": 12,
  "first_fiscal_year": 2021,
  "first_received_date": "2021-03-23",
  "latest_fiscal_year": 2025,
  "latest_decision_date": "2025-08-08",
  "certified_count": 12,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 12,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 12,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 12,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 3,
  "total_denial": 0,
  "fiscal_years": [
    "2022",
    "2023"
  ],
  "year_metrics": [
    {
      "cities": [
        "Alpharetta"
      ],
      "states": [
        "GA"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "30005"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_redshift_enterprise_consulting_solutions_llc_tax_0193_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_043364"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Alpharetta"
      ],
      "states": [
        "GA"
      ],
      "fiscal_year": 2023,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "30005"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_redshift_enterprise_consulting_solutions_llc_tax_0193_2023",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2023_row_023859"
      ],
      "continuing_approval": 0
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "ALPHARETTA, GA 30005",
      "city": "Alpharetta",
      "state": "GA",
      "postal_code": "30005",
      "filing_count": 8,
      "case_count": 8,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-08-08",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "ALPHARETTA GA 30005",
      "city": "Alpharetta",
      "state": "GA",
      "postal_code": "30005",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2024-12-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "ALPHARETTA GA 30005",
      "city": "Alpharetta",
      "county": "Fulton",
      "state": "GA",
      "postal_code": "30005",
      "filing_count": 8,
      "case_count": 8,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2024-12-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ALPHARETTA GA 30005",
      "city": "Alpharetta",
      "state": "GA",
      "postal_code": "30005",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-08-08",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "HENDERSON NV 89074",
      "city": "Henderson",
      "county": "Clark",
      "state": "NV",
      "postal_code": "89074",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-03-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ALPHARETTA GA 30005",
      "city": "Alpharetta",
      "county": "Forsyth",
      "state": "GA",
      "postal_code": "30005",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-09-22",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "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": [
    "GA",
    "NV"
  ],
  "cities": [
    "Alpharetta",
    "Henderson"
  ],
  "postal_codes": [
    "30005",
    "89074"
  ],
  "top_markets": [
    {
      "city": "Alpharetta",
      "state": "GA",
      "postal_code": "30005",
      "lca_count": 10,
      "role_title_count": 4,
      "wage_low_min": 68000,
      "wage_high_max": 160000,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2025
    },
    {
      "city": "Henderson",
      "state": "NV",
      "postal_code": "89074",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 140000,
      "wage_high_max": 140000,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021
    }
  ]
}
Industry
{
  "naics_codes": [
    "541511",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541511",
      "filing_count": 12,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 68000,
  "annualized_high_max": 160000,
  "annualized_low_avg": 120083.333333333
}
Trend
[
  {
    "fiscal_year": 2021,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 140000,
    "wage_high_max": 140000,
    "wage_low_avg": 140000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 140000,
    "wage_high_max": 140000,
    "wage_low_avg": 140000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 112000,
    "wage_high_max": 112000,
    "wage_low_avg": 112000
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q3",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 81000,
    "wage_high_max": 120000,
    "wage_low_avg": 100500
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 152500,
    "wage_high_max": 152500,
    "wage_low_avg": 152500
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 152500,
    "wage_high_max": 152500,
    "wage_low_avg": 152500
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q3",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 68000,
    "wage_high_max": 90000,
    "wage_low_avg": 79000
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 160000,
    "wage_high_max": 160000,
    "wage_low_avg": 160000
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 138000,
    "wage_high_max": 138000,
    "wage_low_avg": 138000
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 87000,
    "wage_high_max": 87000,
    "wage_low_avg": 87000
  }
]
Links
{
  "roles": "/v1/roles?company=Redshift%20Enterprise%20Consulting%20Solutions%2C%20LLC",
  "wages": "/v1/wages?company=Redshift%20Enterprise%20Consulting%20Solutions%2C%20LLC",
  "trends": "/v1/trends?company=Redshift%20Enterprise%20Consulting%20Solutions%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=redshift+enterprise+consulting+solutions+llc&limit=5JSON