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

Home / Companies / ROSETTA MARKETING GROUP, LLC

ROSETTA MARKETING GROUP, LLC H-1B company data

Summary

ROSETTA MARKETING GROUP, LLC filed 24 H-1B labor condition applications (LCAs) with the U.S. Department of Labor between FY2016-FY2017.

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

The filings span 13 distinct role titles across 10 worksites.

The most-sponsored role was Sr. Associate, Websphere Commerce Developer (4 filings), with offered wages from $58,781 to $85,000.

Separately, USCIS H-1B Employer Data Hub records show 65 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
ROSETTA MARKETING GROUP, LLC
ROSETTA MARKETING GROUP LLC
241310FY2016 to FY2017
Latest decision 2017-05-03
65SR. ASSOCIATE, WEBSPHERE COMMERCE DEVELOPER
4 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings24
Certified LCAs21
Denied LCAs1
Role titles13
Worksites10
Latest decision2017-05-03
USCIS approvals65
USCIS denials1

Aliases and source names

AliasesSource NamesSources
ROSETTA MARKETING GROUP LLCROSETTA MARKETING GROUP, LLC, ROSETTA MARKETING GROUP LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
SR. ASSOCIATE, WEBSPHERE COMMERCE DEVELOPER15-11324$58,781$85,000
AEM BUSINESS ANALYST15-11212$105,000$0
CONSULTING MANAGER11-20212$83,762$134,500
JAVA/WEBSPHERE TECHNICAL MANAGER11-30212$138,300$152,900
MANAGER, SOFTWARE ENGINEERING15-11332$73,362$92,700
SENIOR CREATIVE DESIGNER, MANAGER27-10242$101,700$0
SENIOR DEVELOPER, WEBSPHERE COMMERCE (WCS)15-11322$95,000$0
SENIOR WEBSPHERE COMMERCE DEVELOPER15-11322$88,400$102,000
WEBSPHERE COMMERCE CLIENT TECHNICAL LEAD15-11212$95,000$0
BUSINESS ANALYSIS MANAGER13-11111$96,824$115,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
ClevelandOH441149558,781102,0002,0162,016
New YorkNY1001332105,00002,0162,017
El SegundoCA902452296,824190,0002,0162,016
San FranciscoCA9413322101,700134,5002,0162,017
DavenportIA528072173,36292,7002,0172,017
GeorgetownTX78628-772021138,300152,9002,0162,016
San Luis ObispoCA9340111101,70002,0162,016
MaxhawNC281731188,40002,0162,016
HamiltonNJ086191183,76294,6002,0162,016
AustinTX7875811110,00002,0162,016

Full company payload

Company IDcompany:rosetta marketing group
NameROSETTA MARKETING GROUP, LLC
Normalized Namerosetta marketing group
Source Company Idscompany_dol_oflc_lca_rosetta_marketing_group_llc, company_uscis_h1b_datahub_rosetta_marketing_group_llc_tax_7395
Source NamesROSETTA MARKETING GROUP, LLC, ROSETTA MARKETING GROUP LLC
AliasesROSETTA MARKETING GROUP LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "ROSETTA MARKETING GROUP, LLC",
    "ROSETTA MARKETING GROUP LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "ROSETTA MARKETING GROUP, LLC",
      "filing_count": 24,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "ROSETTA MARKETING GROUP LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "7395",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 24,
  "case_count": 24,
  "role_title_count": 13,
  "worksite_count": 10,
  "total_workers": 24,
  "first_fiscal_year": 2016,
  "first_received_date": "2014-05-08",
  "latest_fiscal_year": 2017,
  "latest_decision_date": "2017-05-03",
  "certified_count": 21,
  "denied_count": 1,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 12,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED-WITHDRAWN",
      "filing_count": 9,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "WITHDRAWN",
      "filing_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    },
    {
      "value": "DENIED",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 23,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "E-3 Australian",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 4,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 65,
  "total_denial": 1,
  "fiscal_years": [
    "2009",
    "2010",
    "2011",
    "2012",
    "2013",
    "2014",
    "2016",
    "2017"
  ],
  "year_metrics": [
    {
      "cities": [
        "Beachwood",
        "Hamilton"
      ],
      "states": [
        "NJ",
        "OH"
      ],
      "fiscal_year": 2009,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "08619",
        "44122"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 9,
      "initial_approval": 6,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_rosetta_marketing_group_llc_tax_7395_2009",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2009_row_016487",
        "sr_uscis_h1b_datahub_2009_row_016488"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "Beachwood",
        "Hamilton"
      ],
      "states": [
        "NJ",
        "OH"
      ],
      "fiscal_year": 2010,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "08619",
        "44122"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_rosetta_marketing_group_llc_tax_7395_2010",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2010_row_012313",
        "sr_uscis_h1b_datahub_2010_row_012315"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Beachwood",
        "Cleveland",
        "Independence"
      ],
      "states": [
        "NJ",
        "OH"
      ],
      "fiscal_year": 2011,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "08619",
        "44122",
        "44131"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 12,
      "initial_approval": 5,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_rosetta_marketing_group_llc_tax_7395_2011",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2011_row_013493",
        "sr_uscis_h1b_datahub_2011_row_013494",
        "sr_uscis_h1b_datahub_2011_row_013496"
      ],
      "continuing_approval": 7
    },
    {
      "cities": [
        "Cleveland"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "44114"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 8,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_rosetta_marketing_group_llc_tax_7395_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_011551"
      ],
      "continuing_approval": 8
    },
    {
      "cities": [
        "Cleveland",
        "El Segundo"
      ],
      "states": [
        "CA",
        "OH"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "44114",
        "44144",
        "90245"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 8,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_rosetta_marketing_group_llc_tax_7395_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_010801",
        "sr_uscis_h1b_datahub_2013_row_010802",
        "sr_uscis_h1b_datahub_2013_row_010803"
      ],
      "continuing_approval": 7
    },
    {
      "cities": [
        "Cleveland",
        "El Segundo"
      ],
      "states": [
        "CA",
        "OH"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "44114",
        "90245"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 10,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_rosetta_marketing_group_llc_tax_7395_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_010485",
        "sr_uscis_h1b_datahub_2014_row_010486"
      ],
      "continuing_approval": 9
    },
    {
      "cities": [
        "Cleveland"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "44114"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 9,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_rosetta_marketing_group_llc_tax_7395_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_008695"
      ],
      "continuing_approval": 9
    },
    {
      "cities": [
        "Cleveland"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "44114"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 5,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_rosetta_marketing_group_llc_tax_7395_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_007794"
      ],
      "continuing_approval": 5
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "CLEVELAND OH 44114",
      "city": "Cleveland",
      "state": "OH",
      "postal_code": "44114",
      "filing_count": 24,
      "case_count": 24,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-05-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10013",
      "city": "New York",
      "county": "New York",
      "state": "NY",
      "postal_code": "10013",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-04-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SAN FRANCISCO CA 94133",
      "city": "San Francisco",
      "county": "San Francisco",
      "state": "CA",
      "postal_code": "94133",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-05-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "DAVENPORT IA 52807",
      "city": "Davenport",
      "county": "Scott",
      "state": "IA",
      "postal_code": "52807",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-01-09",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CLEVELAND OH 44114",
      "city": "Cleveland",
      "county": "Cuyahoga",
      "state": "OH",
      "postal_code": "44114",
      "filing_count": 9,
      "case_count": 9,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-09-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "EL SEGUNDO CA 90245",
      "city": "El Segundo",
      "county": "Los Angeles",
      "state": "CA",
      "postal_code": "90245",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-09-22",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "GEORGETOWN TX 78628-7720",
      "city": "Georgetown",
      "county": "Williamson",
      "state": "TX",
      "postal_code": "78628-7720",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-07",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "MAXHAW NC 28173",
      "city": "Maxhaw",
      "county": "Union",
      "state": "NC",
      "postal_code": "28173",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-02-02",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "HAMILTON NJ 08619",
      "city": "Hamilton",
      "county": "Mercer",
      "state": "NJ",
      "postal_code": "08619",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2015-12-01",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SAN LUIS OBISPO CA 93401",
      "city": "San Luis Obispo",
      "county": "San Luis Obispo",
      "state": "CA",
      "postal_code": "93401",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2015-10-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "AUSTIN TX 78758",
      "city": "Austin",
      "county": "Travis",
      "state": "TX",
      "postal_code": "78758",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2015-10-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 1,
    "worksite_address_count": 10,
    "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": [
    "OH",
    "NY",
    "CA",
    "IA",
    "TX",
    "NC",
    "NJ"
  ],
  "cities": [
    "Cleveland",
    "New York",
    "El Segundo",
    "San Francisco",
    "Davenport",
    "Georgetown",
    "San Luis Obispo",
    "Maxhaw",
    "Hamilton",
    "Austin",
    "Beachwood",
    "Independence"
  ],
  "postal_codes": [
    "44114",
    "10013",
    "90245",
    "94133",
    "52807",
    "78628-7720",
    "93401",
    "28173",
    "08619",
    "78758",
    "44122",
    "44131",
    "44144"
  ],
  "top_markets": [
    {
      "city": "Cleveland",
      "state": "OH",
      "postal_code": "44114",
      "lca_count": 9,
      "role_title_count": 5,
      "wage_low_min": 58781,
      "wage_high_max": 102000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "New York",
      "state": "NY",
      "postal_code": "10013",
      "lca_count": 3,
      "role_title_count": 2,
      "wage_low_min": 105000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "El Segundo",
      "state": "CA",
      "postal_code": "90245",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 96824,
      "wage_high_max": 190000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "San Francisco",
      "state": "CA",
      "postal_code": "94133",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 101700,
      "wage_high_max": 134500,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Davenport",
      "state": "IA",
      "postal_code": "52807",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 73362,
      "wage_high_max": 92700,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Georgetown",
      "state": "TX",
      "postal_code": "78628-7720",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 138300,
      "wage_high_max": 152900,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "San Luis Obispo",
      "state": "CA",
      "postal_code": "93401",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 101700,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Maxhaw",
      "state": "NC",
      "postal_code": "28173",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 88400,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Hamilton",
      "state": "NJ",
      "postal_code": "08619",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 83762,
      "wage_high_max": 94600,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Austin",
      "state": "TX",
      "postal_code": "78758",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 110000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    }
  ]
}
Industry
{
  "naics_codes": [
    "541810",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541512",
      "filing_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "541810",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 58781,
  "annualized_high_max": 190000,
  "annualized_low_avg": 109241.083333333
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 20,
    "case_count": 20,
    "role_title_count": 12,
    "worksite_count": 9,
    "wage_low_min": 58781,
    "wage_high_max": 190000,
    "wage_low_avg": 112119.6
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 3,
    "worksite_count": 3,
    "wage_low_min": 73362,
    "wage_high_max": 134500,
    "wage_low_avg": 94848.5
  }
]
Links
{
  "roles": "/v1/roles?company=ROSETTA%20MARKETING%20GROUP%2C%20LLC",
  "wages": "/v1/wages?company=ROSETTA%20MARKETING%20GROUP%2C%20LLC",
  "trends": "/v1/trends?company=ROSETTA%20MARKETING%20GROUP%2C%20LLC"
}

Frequently asked questions

Does ROSETTA MARKETING GROUP, LLC sponsor H-1B visas?
Yes. ROSETTA MARKETING GROUP, LLC filed 24 H-1B labor condition applications with the U.S. Department of Labor (FY2016-FY2017), of which 21 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 ROSETTA MARKETING GROUP, LLC filed?
ROSETTA MARKETING GROUP, LLC has 24 H-1B LCA filings on record spanning FY2016-FY2017 across 13 role titles and 10 worksites.
What roles does ROSETTA MARKETING GROUP, LLC sponsor for H-1B?
The most common H-1B role at ROSETTA MARKETING GROUP, LLC is Sr. Associate, Websphere Commerce Developer (4 filings). Other frequent roles include Aem Business Analyst, Consulting Manager, Java/Websphere Technical Manager, Manager, Software Engineering.
What wages does ROSETTA MARKETING GROUP, LLC offer H-1B workers?
For its most-sponsored role (Sr. Associate, Websphere Commerce Developer), ROSETTA MARKETING GROUP, LLC reported offered wages ranging from $58,781 to $85,000 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=rosetta+marketing+group+llc&limit=5JSON