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

Home / Companies / EDGEWATER TECHNOLOGY- RANZAL, LLC

EDGEWATER TECHNOLOGY- RANZAL, LLC H-1B company data

Summary

EDGEWATER TECHNOLOGY- RANZAL, LLC filed 29 H-1B labor condition applications (LCAs) with the U.S. Department of Labor between FY2016-FY2018.

Of those, 27 were certified and 1 denied (a 96% certification rate among adjudicated filings).

The filings span 15 distinct role titles across 7 worksites.

The most-sponsored role was Hyperion Management Analyst I (7 filings), with offered wages from $59,634 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
EDGEWATER TECHNOLOGY- RANZAL, LLC
EDGEWATER TECHNOLOGY RANZAL LLC, EDGEWATER TECHNOLOGY-RANZAL LLC
29157FY2016 to FY2018
Latest decision 2018-04-23
7HYPERION MANAGEMENT ANALYST I
7 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings29
Certified LCAs27
Denied LCAs1
Role titles15
Worksites7
Latest decision2018-04-23
USCIS approvals7
USCIS denials1

Aliases and source names

AliasesSource NamesSources
EDGEWATER TECHNOLOGY RANZAL LLC, EDGEWATER TECHNOLOGY-RANZAL LLCEDGEWATER TECHNOLOGY- RANZAL, LLC, EDGEWATER TECHNOLOGY RANZAL LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
HYPERION MANAGEMENT ANALYST I13-11117$59,634$0
HYPERION INTEGRATION ANALYST II13-11113$86,798$0
BUSINESS INTELLIGENCE MANAGEMENT ANALYST I13-11112$60,000$0
HYPERION DATA INTEGRATION ANALYST II13-11112$85,000$0
HYPERION MANAGEMENT ANALYST I15-11212$80,000$0
SYSTEMS ANALYST15-11212$65,000$0
BUISNESS INTELLENGENCE MANAGMENT ANALYST 113-11111$60,000$0
BUSINESS INTELLEGENCE MANAGEMENT ANALYST I13-11111$60,000$0
BUSINESS INTELLIGENCE MANAGEMENT ANALYST II13-11111$113,000$0
ESSBASE PLANNING ANALYST I13-11111$80,000$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
White PlainsNY10604231459,63402,0162,018
Downers GroveIL605151190,00002,0162,016
BostonMA0221511103,00002,0182,018
SomervilleMA021441162,20002,0182,018
MinneapolisMN554321185,00002,0162,016
Saint LouisMO631671160,00002,0162,016
IrvingTX750631185,00002,0162,016

Full company payload

Company IDcompany:edgewater technology ranzal
NameEDGEWATER TECHNOLOGY- RANZAL, LLC
Normalized Nameedgewater technology ranzal
Source Company Idscompany_dol_oflc_lca_edgewater_technology_ranzal_llc, company_uscis_h1b_datahub_edgewater_technology_ranzal_llc_tax_2835
Source NamesEDGEWATER TECHNOLOGY- RANZAL, LLC, EDGEWATER TECHNOLOGY RANZAL LLC
AliasesEDGEWATER TECHNOLOGY RANZAL LLC, EDGEWATER TECHNOLOGY-RANZAL LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "EDGEWATER TECHNOLOGY- RANZAL, LLC",
    "EDGEWATER TECHNOLOGY RANZAL LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "EDGEWATER TECHNOLOGY - RANZAL, LLC",
      "filing_count": 13,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "EDGEWATER TECHNOLOGY- RANZAL, LLC",
      "filing_count": 11,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "EDGEWATER TECHNOLOGY- RANZAL LLC",
      "filing_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    },
    {
      "value": "EDGEWATER TECHNOLOGY - RANZAL LLC",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    },
    {
      "value": "EDGEWATER TECHNOLOGY-RANZAL, LLC",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    },
    {
      "value": "EDGEWATER TECHNOLOGY RANZAL LLC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "EDGEWATER TECHNOLOGY-RANZAL LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "2835",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 29,
  "case_count": 29,
  "role_title_count": 15,
  "worksite_count": 7,
  "total_workers": 29,
  "first_fiscal_year": 2016,
  "first_received_date": "2015-11-23",
  "latest_fiscal_year": 2018,
  "latest_decision_date": "2018-04-23",
  "certified_count": 27,
  "denied_count": 1,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 27,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "DENIED",
      "filing_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "WITHDRAWN",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 29,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 12,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "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"
  ],
  "year_metrics": [
    {
      "cities": [
        "White Plains"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "10604"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_edgewater_technology_ranzal_llc_tax_2835_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_007062"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Wakefield"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "01880"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 6,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_edgewater_technology_ranzal_llc_tax_2835_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_007455"
      ],
      "continuing_approval": 3
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "WHITE PLAINS NY 10604",
      "city": "White Plains",
      "state": "NY",
      "postal_code": "10604",
      "filing_count": 28,
      "case_count": 28,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-04-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "WHITE PLAINS NJ 10604",
      "city": "White Plains",
      "state": "NJ",
      "postal_code": "10604",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "WHITE PLAINS NY 10604",
      "city": "White Plains",
      "county": "Westchester",
      "state": "NY",
      "postal_code": "10604",
      "filing_count": 20,
      "case_count": 20,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-04-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BOSTON MA 02215",
      "city": "Boston",
      "county": "Suffolk",
      "state": "MA",
      "postal_code": "02215",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2017-12-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SOMERVILLE MA 02144",
      "city": "Somerville",
      "county": "Middlesex",
      "state": "MA",
      "postal_code": "02144",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2017-10-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "WHITE PLAINS NY 10604",
      "city": "White Plains",
      "county": "New York",
      "state": "NY",
      "postal_code": "10604",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-02",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SAINT LOUIS MO 63167",
      "city": "Saint Louis",
      "county": "Saint Louis",
      "state": "MO",
      "postal_code": "63167",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-08-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "DOWNERS GROVE IL 60515",
      "city": "Downers Grove",
      "county": "Du Page",
      "state": "IL",
      "postal_code": "60515",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-04-19",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "MINNEAPOLIS MN 55432",
      "city": "Minneapolis",
      "county": "Anoka",
      "state": "MN",
      "postal_code": "55432",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-01-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "IRVING TX 75063",
      "city": "Irving",
      "county": "Dallas",
      "state": "TX",
      "postal_code": "75063",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2015-11-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "worksite_address_count": 8,
    "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": [
    "NY",
    "IL",
    "MA",
    "MN",
    "MO",
    "TX"
  ],
  "cities": [
    "White Plains",
    "Downers Grove",
    "Boston",
    "Somerville",
    "Minneapolis",
    "Saint Louis",
    "Irving",
    "Wakefield"
  ],
  "postal_codes": [
    "10604",
    "60515",
    "02215",
    "02144",
    "55432",
    "63167",
    "75063",
    "01880"
  ],
  "top_markets": [
    {
      "city": "White Plains",
      "state": "NY",
      "postal_code": "10604",
      "lca_count": 23,
      "role_title_count": 14,
      "wage_low_min": 59634,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Downers Grove",
      "state": "IL",
      "postal_code": "60515",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 90000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Boston",
      "state": "MA",
      "postal_code": "02215",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 103000,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Somerville",
      "state": "MA",
      "postal_code": "02144",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 62200,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Minneapolis",
      "state": "MN",
      "postal_code": "55432",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 85000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Saint Louis",
      "state": "MO",
      "postal_code": "63167",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 60000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Irving",
      "state": "TX",
      "postal_code": "75063",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 85000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    }
  ]
}
Industry
{
  "naics_codes": [
    "5416",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "5415",
      "filing_count": 6,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "5416",
      "filing_count": 6,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 59634,
  "annualized_high_max": 0,
  "annualized_low_avg": 85656.0344827586
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 17,
    "case_count": 17,
    "role_title_count": 12,
    "worksite_count": 5,
    "wage_low_min": 59634,
    "wage_high_max": 0,
    "wage_low_avg": 85236.7058823529
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 5,
    "case_count": 5,
    "role_title_count": 4,
    "worksite_count": 1,
    "wage_low_min": 65000,
    "wage_high_max": 0,
    "wage_low_avg": 81359.6
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 7,
    "case_count": 7,
    "role_title_count": 3,
    "worksite_count": 3,
    "wage_low_min": 62200,
    "wage_high_max": 0,
    "wage_low_avg": 89743.2857142857
  }
]
Links
{
  "roles": "/v1/roles?company=EDGEWATER%20TECHNOLOGY-%20RANZAL%2C%20LLC",
  "wages": "/v1/wages?company=EDGEWATER%20TECHNOLOGY-%20RANZAL%2C%20LLC",
  "trends": "/v1/trends?company=EDGEWATER%20TECHNOLOGY-%20RANZAL%2C%20LLC"
}

Frequently asked questions

Does EDGEWATER TECHNOLOGY- RANZAL, LLC sponsor H-1B visas?
Yes. EDGEWATER TECHNOLOGY- RANZAL, LLC filed 29 H-1B labor condition applications with the U.S. Department of Labor (FY2016-FY2018), of which 27 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 EDGEWATER TECHNOLOGY- RANZAL, LLC filed?
EDGEWATER TECHNOLOGY- RANZAL, LLC has 29 H-1B LCA filings on record spanning FY2016-FY2018 across 15 role titles and 7 worksites.
What roles does EDGEWATER TECHNOLOGY- RANZAL, LLC sponsor for H-1B?
The most common H-1B role at EDGEWATER TECHNOLOGY- RANZAL, LLC is Hyperion Management Analyst I (7 filings). Other frequent roles include Hyperion Integration Analyst Ii, Business Intelligence Management Analyst I, Hyperion Data Integration Analyst Ii, Systems Analyst.
What wages does EDGEWATER TECHNOLOGY- RANZAL, LLC offer H-1B workers?
For its most-sponsored role (Hyperion Management Analyst I), EDGEWATER TECHNOLOGY- RANZAL, LLC reported offered wages ranging from $59,634 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=edgewater+technology+ranzal+llc&limit=5JSON