Home / Companies / Sistar Mortgage

Sistar Mortgage 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
Sistar Mortgage SISTAR MORTGAGE	13	3	3	FY2018 to FY2021 Latest decision 2021-07-27	6	Data Engineer 8 filings	dol_oflc_lca, uscis_h1b_employer_data_hub	Profile

Activity summary

LCA filings	13
Certified LCAs	10
Denied LCAs	0
Role titles	3
Worksites	3
Latest decision	2021-07-27
USCIS approvals	6
USCIS denials	0

Aliases and source names

Aliases	Source Names	Sources
SISTAR MORTGAGE	Sistar Mortgage, SISTAR MORTGAGE	dol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

Title	SOC	LCA filings	Low wage min	High wage max
Data Engineer	15-1141.00 Database Administrators	8	$91,520	$135,200
Data Engineer	15-1141 Database Administrators	3	$101,920	$135,200
MARKET RESEARCH ANALYST (REAL ESTATE)	13-1161	1	$84,000	$0
Network Administrator & Support	15-1143.00 Computer Network Architects	1	$72,740	$72,740

Top markets

City	State	Postal Code	LCA Count	Role Title Count	Wage Low Min	Wage High Max	First Fiscal Year	Latest Fiscal Year
Sterling Heights	MI	48310	11	2	72,740	135,200	2,020	2,021
Shelby Township	MI	48315	1	1	84,000	0	2,018	2,018
Frisco	TX	75035	1	1	101,920	101,920	2,021	2,021

Full company payload

Company ID	company:sistar mortgage
Name	Sistar Mortgage
Normalized Name	sistar mortgage
Source Company Ids	company_dol_oflc_lca_sistar_mortgage, company_uscis_h1b_datahub_sistar_mortgage_tax_5411
Source Names	Sistar Mortgage, SISTAR MORTGAGE
Aliases	SISTAR MORTGAGE
Sources	dol_oflc_lca, uscis_h1b_employer_data_hub

Names

{
  "source_names": [
    "Sistar Mortgage",
    "SISTAR MORTGAGE"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "Sistar Mortgage",
      "filing_count": 12,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "SISTAR MORTGAGE",
      "filing_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "SISTAR MORTGAGE",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}

Identifiers

[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5411",
    "source": "uscis_h1b_employer_data_hub"
  }
]

LCA Activity

{
  "lca_count": 13,
  "case_count": 13,
  "role_title_count": 3,
  "worksite_count": 3,
  "total_workers": 13,
  "first_fiscal_year": 2018,
  "first_received_date": "2018-08-31",
  "latest_fiscal_year": 2021,
  "latest_decision_date": "2021-07-27",
  "certified_count": 10,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 6,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified - Withdrawn",
      "filing_count": 3,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Withdrawn",
      "filing_count": 3,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 13,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "N",
      "filing_count": 10,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Y",
      "filing_count": 3,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ]
}

Petition Activity

{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 6,
  "total_denial": 0,
  "fiscal_years": [
    "2016",
    "2018",
    "2020",
    "2021"
  ],
  "year_metrics": [
    {
      "cities": [
        "Shelby Township"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "48315"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sistar_mortgage_tax_5411_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_000546"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Shelby Township"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "48315"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sistar_mortgage_tax_5411_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_000526"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Sterling Heights"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "48310"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sistar_mortgage_tax_5411_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_043742"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Sterling Heights"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "48310"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sistar_mortgage_tax_5411_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_047671",
        "sr_uscis_h1b_datahub_2021_row_047672"
      ],
      "continuing_approval": 3
    }
  ]
}

Addresses

{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "STERLING HEIGHTS MI 48310",
      "city": "Sterling Heights",
      "state": "MI",
      "postal_code": "48310",
      "filing_count": 12,
      "case_count": 12,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-07-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "SHELBY TOWNSHIP MI 48315",
      "city": "Shelby Township",
      "state": "MI",
      "postal_code": "48315",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-09-07",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "STERLING HEIGHTS MI 48310",
      "city": "Sterling Heights",
      "county": "Macomb",
      "state": "MI",
      "postal_code": "48310",
      "filing_count": 11,
      "case_count": 11,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-07-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "FRISCO TX 75035",
      "city": "Frisco",
      "county": "Collin",
      "state": "TX",
      "postal_code": "75035",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-04-29",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SHELBY TOWNSHIP MI 48315",
      "city": "Shelby Township",
      "county": "Macomb",
      "state": "MI",
      "postal_code": "48315",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-09-07",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "worksite_address_count": 3,
    "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": [
    "MI",
    "TX"
  ],
  "cities": [
    "Sterling Heights",
    "Shelby Township",
    "Frisco"
  ],
  "postal_codes": [
    "48310",
    "48315",
    "75035"
  ],
  "top_markets": [
    {
      "city": "Sterling Heights",
      "state": "MI",
      "postal_code": "48310",
      "lca_count": 11,
      "role_title_count": 2,
      "wage_low_min": 72740,
      "wage_high_max": 135200,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021
    },
    {
      "city": "Shelby Township",
      "state": "MI",
      "postal_code": "48315",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 84000,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Frisco",
      "state": "TX",
      "postal_code": "75035",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 101920,
      "wage_high_max": 101920,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021
    }
  ]
}

Industry

{
  "naics_codes": [
    "522310",
    "52"
  ],
  "naics_breakdown": [
    {
      "value": "522310",
      "filing_count": 13,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ]
}

Wage Summary

{
  "annualized_low_min": 72740,
  "annualized_high_max": 135200,
  "annualized_low_avg": 112856.923076923
}

Trend

[
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 84000,
    "wage_high_max": 0,
    "wage_low_avg": 84000
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 91520,
    "wage_high_max": 91520,
    "wage_low_avg": 91520
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q1",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 101920,
    "wage_high_max": 135200,
    "wage_low_avg": 124106.666666667
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 101920,
    "wage_high_max": 135200,
    "wage_low_avg": 124106.666666667
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 1,
    "worksite_count": 2,
    "wage_low_min": 101920,
    "wage_high_max": 135200,
    "wage_low_avg": 118560
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 72740,
    "wage_high_max": 72740,
    "wage_low_avg": 72740
  }
]

Links

{
  "roles": "/v1/roles?company=Sistar%20Mortgage",
  "wages": "/v1/wages?company=Sistar%20Mortgage",
  "trends": "/v1/trends?company=Sistar%20Mortgage"
}

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=sistar+mortgage&limit=5JSON

Docs · Get an API key