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

Home / Companies / COLUMBIA IT SERVICES LLC

COLUMBIA IT SERVICES 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.

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
COLUMBIA IT SERVICES LLC
COLUMBIA IT SERVICES LLC
1195FY2016 to FY2019
Latest decision 2019-09-03
2APPLICATION DEVELOPER
2 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings11
Certified LCAs9
Denied LCAs0
Role titles9
Worksites5
Latest decision2019-09-03
USCIS approvals2
USCIS denials5

Aliases and source names

AliasesSource NamesSources
COLUMBIA IT SERVICES LLCCOLUMBIA IT SERVICES LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
APPLICATION DEVELOPER15-1132
SOFTWARE DEVELOPERS, APPLICATIONS
2$76,000$76,000
SOFTWARE ENGINEER15-11332$62,000$0
DATABASE ARCHITECT15-11991$50,000$0
FINANCIAL ANALYST13-20511$51,000$0
INTEGRATION ENGINEER15-11321$60,000$0
NETWORK ENGINEER15-11421$53,000$0
QUALITY ASSURANCE ENGINEER15-11991$40,000$0
RF ENGINEER17-20711$50,000$0
SOFTWARE ANALYST15-11331$62,000$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
HollywoodFL330206540,00002,0162,016
AshburnVA201482176,00076,0002,0192,019
DavieFL333251150,00002,0162,016
HolllywoodFL330201162,00002,0162,016
HollywoodVA330201160,00002,0162,016

Full company payload

Company IDcompany:columbia it
NameCOLUMBIA IT SERVICES LLC
Normalized Namecolumbia it
Source Company Idscompany_dol_oflc_lca_columbia_it_services_llc, company_uscis_h1b_datahub_columbia_it_services_llc_tax_9153
Source NamesCOLUMBIA IT SERVICES LLC
AliasesCOLUMBIA IT SERVICES LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "COLUMBIA IT SERVICES LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "COLUMBIA IT SERVICES LLC",
      "filing_count": 9,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    },
    {
      "value": "COLUMBIA IT SERVICES LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "9153",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 11,
  "case_count": 11,
  "role_title_count": 9,
  "worksite_count": 5,
  "total_workers": 33,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-01-14",
  "latest_fiscal_year": 2019,
  "latest_decision_date": "2019-09-03",
  "certified_count": 9,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 9,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "WITHDRAWN",
      "filing_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 10,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "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": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 2,
  "total_denial": 5,
  "fiscal_years": [
    "2017"
  ],
  "year_metrics": [
    {
      "cities": [
        "Davie",
        "Fort Lauderdale"
      ],
      "states": [
        "FL"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "33325"
      ],
      "total_denial": 5,
      "initial_denial": 5,
      "total_approval": 2,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_it_services_llc_tax_9153_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_043467",
        "sr_uscis_h1b_datahub_2017_row_043468"
      ],
      "continuing_approval": 0
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "DAVIE FL 33325",
      "city": "Davie",
      "state": "FL",
      "postal_code": "33325",
      "filing_count": 10,
      "case_count": 10,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-09-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "DAVIE GA 33325",
      "city": "Davie",
      "state": "GA",
      "postal_code": "33325",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-08-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "ASHBURN VA 20148",
      "city": "Ashburn",
      "county": "Loudoun",
      "state": "VA",
      "postal_code": "20148",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-09-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ASHBURN VA 20148",
      "city": "Ashburn",
      "county": "Virginia",
      "state": "VA",
      "postal_code": "20148",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-08-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "HOLLYWOOD FL 33020",
      "city": "Hollywood",
      "county": "Broward",
      "state": "FL",
      "postal_code": "33020",
      "filing_count": 6,
      "case_count": 6,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-14",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "HOLLLYWOOD FL 33020",
      "city": "Holllywood",
      "county": "Broward",
      "state": "FL",
      "postal_code": "33020",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-14",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "HOLLYWOOD VA 33020",
      "city": "Hollywood",
      "county": "Broward",
      "state": "VA",
      "postal_code": "33020",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-14",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "DAVIE FL 33325",
      "city": "Davie",
      "county": "Broward",
      "state": "FL",
      "postal_code": "33325",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-01-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "worksite_address_count": 6,
    "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": [
    "FL",
    "VA"
  ],
  "cities": [
    "Hollywood",
    "Ashburn",
    "Davie",
    "Holllywood",
    "Fort Lauderdale"
  ],
  "postal_codes": [
    "33020",
    "20148",
    "33325"
  ],
  "top_markets": [
    {
      "city": "Hollywood",
      "state": "FL",
      "postal_code": "33020",
      "lca_count": 6,
      "role_title_count": 5,
      "wage_low_min": 40000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Ashburn",
      "state": "VA",
      "postal_code": "20148",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 76000,
      "wage_high_max": 76000,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Davie",
      "state": "FL",
      "postal_code": "33325",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 50000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Holllywood",
      "state": "FL",
      "postal_code": "33020",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 62000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Hollywood",
      "state": "VA",
      "postal_code": "33020",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 60000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    }
  ]
}
Industry
{
  "naics_codes": [
    "54151",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "54151",
      "filing_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 40000,
  "annualized_high_max": 76000,
  "annualized_low_avg": 58363.6363636364
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 9,
    "case_count": 9,
    "role_title_count": 8,
    "worksite_count": 4,
    "wage_low_min": 40000,
    "wage_high_max": 0,
    "wage_low_avg": 54444.4444444444
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 76000,
    "wage_high_max": 76000,
    "wage_low_avg": 76000
  }
]
Links
{
  "roles": "/v1/roles?company=COLUMBIA%20IT%20SERVICES%20LLC",
  "wages": "/v1/wages?company=COLUMBIA%20IT%20SERVICES%20LLC",
  "trends": "/v1/trends?company=COLUMBIA%20IT%20SERVICES%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=columbia+it+services+llc&limit=5JSON