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

Home / Companies / MERCER DIGITAL

MERCER DIGITAL 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
MERCER DIGITAL
MERCER DIGITAL
3694FY2016 to FY2019
Latest decision 2019-02-06
0WORKDAY CONSULTANT
10 filings
dol_oflc_lcaProfile

Activity summary

LCA filings36
Certified LCAs31
Denied LCAs2
Role titles9
Worksites4
Latest decision2019-02-06
USCIS approvals0
USCIS denials0

Aliases and source names

AliasesSource NamesSources
MERCER DIGITALMERCER DIGITALdol_oflc_lca

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
WORKDAY CONSULTANT15-1121
COMPUTER SYSTEMS ANALYSTS
10$57,600$105,000
WORKDAY CONSULTANT13-11115$50,000$70,000
WORKDAY CONSULTANT15-11324$70,000$100,000
SENIOR WORKDAY CONSULTANT15-11213$90,000$110,000
MANAGEMENT CONSULTANT13-11112$55,931$70,000
SENIOR SOFTWARE DEVELOPER15-11322$125,000$170,000
SENIOR WORKDAY CONSULTANT15-1132
SOFTWARE DEVELOPERS, APPLICATIONS
2$99,200$155,000
WORKDAY CONSULTANT15-20312$60,000$80,000
IT IMPLEMENTATION CONSULTANT15-11321$60,000$80,000
SENIOR WORKDAY INTEGRATIONS CONSULTANT15-11991$80,000$130,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
DallasTX7524430950,000170,0002,0162,019
CentertonAR727192170,00070,0002,0162,019
ChicagoIL606062170,00090,0002,0172,018
The WoodlandsTX773802257,910165,0002,0172,017

Full company payload

Company IDcompany:mercer digital
NameMERCER DIGITAL
Normalized Namemercer digital
Source Company Idscompany_dol_oflc_lca_cpsg_partners_llc
Source NamesMERCER DIGITAL
AliasesMERCER DIGITAL
Identifiers-
Sourcesdol_oflc_lca
Names
{
  "source_names": [
    "MERCER DIGITAL"
  ],
  "dba_names": [
    "MERCER DIGITAL"
  ],
  "name_variants": [
    {
      "value": "CPSG PARTNERS, LLC",
      "filing_count": 21,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CPSG PARTNERS LLC",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    },
    {
      "value": "MERCER DIGITAL",
      "filing_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ]
}
LCA Activity
{
  "lca_count": 36,
  "case_count": 36,
  "role_title_count": 9,
  "worksite_count": 4,
  "total_workers": 83,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-01-14",
  "latest_fiscal_year": 2019,
  "latest_decision_date": "2019-02-06",
  "certified_count": 31,
  "denied_count": 2,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 28,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED-WITHDRAWN",
      "filing_count": 3,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "WITHDRAWN",
      "filing_count": 3,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "DENIED",
      "filing_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 34,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "E-3 Australian",
      "filing_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 27,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 0,
  "total_denial": 0,
  "fiscal_years": [],
  "year_metrics": []
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "DALLAS TX 75244",
      "city": "Dallas",
      "state": "TX",
      "postal_code": "75244",
      "filing_count": 35,
      "case_count": 35,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-02-06",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "HOBOKEN NJ 07030",
      "city": "Hoboken",
      "state": "NJ",
      "postal_code": "07030",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-12",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "DALLAS TX 75244",
      "city": "Dallas",
      "county": "Dallas",
      "state": "TX",
      "postal_code": "75244",
      "filing_count": 30,
      "case_count": 30,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-02-06",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CENTERTON AR 72719",
      "city": "Centerton",
      "county": "Benton",
      "state": "AR",
      "postal_code": "72719",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2018-12-19",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CHICAGO IL 60606",
      "city": "Chicago",
      "county": "Cook",
      "state": "IL",
      "postal_code": "60606",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-06-04",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "THE WOODLANDS TX 77380",
      "city": "The Woodlands",
      "county": "Montgomery",
      "state": "TX",
      "postal_code": "77380",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-08-03",
      "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": [
    "TX",
    "AR",
    "IL"
  ],
  "cities": [
    "Dallas",
    "Centerton",
    "Chicago",
    "The Woodlands"
  ],
  "postal_codes": [
    "75244",
    "72719",
    "60606",
    "77380"
  ],
  "top_markets": [
    {
      "city": "Dallas",
      "state": "TX",
      "postal_code": "75244",
      "lca_count": 30,
      "role_title_count": 9,
      "wage_low_min": 50000,
      "wage_high_max": 170000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Centerton",
      "state": "AR",
      "postal_code": "72719",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 70000,
      "wage_high_max": 70000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60606",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 70000,
      "wage_high_max": 90000,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018
    },
    {
      "city": "The Woodlands",
      "state": "TX",
      "postal_code": "77380",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 57910,
      "wage_high_max": 165000,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    }
  ]
}
Industry
{
  "naics_codes": [
    "541511"
  ],
  "naics_breakdown": [
    {
      "value": "541511",
      "filing_count": 27,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 50000,
  "annualized_high_max": 170000,
  "annualized_low_avg": 73393.8333333333
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 9,
    "case_count": 9,
    "role_title_count": 3,
    "worksite_count": 2,
    "wage_low_min": 55931,
    "wage_high_max": 105000,
    "wage_low_avg": 66814.5555555556
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 11,
    "case_count": 11,
    "role_title_count": 3,
    "worksite_count": 3,
    "wage_low_min": 50000,
    "wage_high_max": 170000,
    "wage_low_avg": 78537.2727272727
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 14,
    "case_count": 14,
    "role_title_count": 7,
    "worksite_count": 2,
    "wage_low_min": 55931,
    "wage_high_max": 155000,
    "wage_low_avg": 71981.2142857143
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 70000,
    "wage_high_max": 148800,
    "wage_low_avg": 84600
  }
]
Links
{
  "roles": "/v1/roles?company=MERCER%20DIGITAL",
  "wages": "/v1/wages?company=MERCER%20DIGITAL",
  "trends": "/v1/trends?company=MERCER%20DIGITAL"
}
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=mercer+digital&limit=5JSON