Home / Companies / ROSETTA MARKETING GROUP, LLC

ROSETTA MARKETING GROUP, 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.

Role rows Wage rows Trends

Employer	LCA filings	Role titles	Worksites	Coverage	USCIS approvals	Top role	Sources	Open
ROSETTA MARKETING GROUP, LLC ROSETTA MARKETING GROUP LLC	24	13	10	FY2016 to FY2017 Latest decision 2017-05-03	65	SR. ASSOCIATE, WEBSPHERE COMMERCE DEVELOPER 4 filings	dol_oflc_lca, uscis_h1b_employer_data_hub	Profile

Activity summary

LCA filings	24
Certified LCAs	21
Denied LCAs	1
Role titles	13
Worksites	10
Latest decision	2017-05-03
USCIS approvals	65
USCIS denials	1

Aliases and source names

Aliases	Source Names	Sources
ROSETTA MARKETING GROUP LLC	ROSETTA MARKETING GROUP, LLC, ROSETTA MARKETING GROUP LLC	dol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

Title	SOC	LCA filings	Low wage min	High wage max
SR. ASSOCIATE, WEBSPHERE COMMERCE DEVELOPER	15-1132	4	$58,781	$85,000
AEM BUSINESS ANALYST	15-1121	2	$105,000	$0
CONSULTING MANAGER	11-2021	2	$83,762	$134,500
JAVA/WEBSPHERE TECHNICAL MANAGER	11-3021	2	$138,300	$152,900
MANAGER, SOFTWARE ENGINEERING	15-1133	2	$73,362	$92,700
SENIOR CREATIVE DESIGNER, MANAGER	27-1024	2	$101,700	$0
SENIOR DEVELOPER, WEBSPHERE COMMERCE (WCS)	15-1132	2	$95,000	$0
SENIOR WEBSPHERE COMMERCE DEVELOPER	15-1132	2	$88,400	$102,000
WEBSPHERE COMMERCE CLIENT TECHNICAL LEAD	15-1121	2	$95,000	$0
BUSINESS ANALYSIS MANAGER	13-1111	1	$96,824	$115,000

Top markets

City	State	Postal Code	LCA Count	Role Title Count	Wage Low Min	Wage High Max	First Fiscal Year	Latest Fiscal Year
Cleveland	OH	44114	9	5	58,781	102,000	2,016	2,016
New York	NY	10013	3	2	105,000	0	2,016	2,017
El Segundo	CA	90245	2	2	96,824	190,000	2,016	2,016
San Francisco	CA	94133	2	2	101,700	134,500	2,016	2,017
Davenport	IA	52807	2	1	73,362	92,700	2,017	2,017
Georgetown	TX	78628-7720	2	1	138,300	152,900	2,016	2,016
San Luis Obispo	CA	93401	1	1	101,700	0	2,016	2,016
Maxhaw	NC	28173	1	1	88,400	0	2,016	2,016
Hamilton	NJ	08619	1	1	83,762	94,600	2,016	2,016
Austin	TX	78758	1	1	110,000	0	2,016	2,016

Full company payload

Company ID	company:rosetta marketing group
Name	ROSETTA MARKETING GROUP, LLC
Normalized Name	rosetta marketing group
Source Company Ids	company_dol_oflc_lca_rosetta_marketing_group_llc, company_uscis_h1b_datahub_rosetta_marketing_group_llc_tax_7395
Source Names	ROSETTA MARKETING GROUP, LLC, ROSETTA MARKETING GROUP LLC
Aliases	ROSETTA MARKETING GROUP LLC
Sources	dol_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"
}

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

Docs · Get an API key