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

Home / Companies / Column Technologies, LLC

Column Technologies, 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
Column Technologies, LLC
COLUMN TECHNOLOGIES LLC
1494FY2019 to FY2020
Latest decision 2020-07-21
4Information Security Architect
3 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings14
Certified LCAs13
Denied LCAs0
Role titles9
Worksites4
Latest decision2020-07-21
USCIS approvals4
USCIS denials0

Aliases and source names

AliasesSource NamesSources
COLUMN TECHNOLOGIES LLCColumn Technologies, LLC, COLUMN TECHNOLOGIES LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
Information Security Architect15-1132.00
Software Developers, Applications
3$150,000$160,000
Solutions Delivery Manager11-3021.00
Computer and Information Systems Managers
3$145,000$155,000
Chief Financial Officer11-3031.00
Financial Managers
1$189,280$189,280
COMPUTER SYSTEMS ANALYST15-1121
COMPUTER SYSTEMS ANALYSTS
1$90,000$90,000
Computer Systems Analyst15-1121.00
Computer Systems Analysts
1$89,981$90,000
SALES ENGINEER41-9031
SALES ENGINEERS
1$83,500$83,500
SERVICE SUPPORT ANALYST15-1132
SOFTWARE DEVELOPERS, APPLICATIONS
1$106,430$106,430
SOFTWARE DEVELOPER15-1132
SOFTWARE DEVELOPERS, APPLICATIONS
1$115,000$115,000
SOFTWARE ENGINEER15-1132
SOFTWARE DEVELOPERS, APPLICATIONS
1$120,047$120,047
SOFTWARE ENGINEER (REMEDY)15-1132
SOFTWARE DEVELOPERS, APPLICATIONS
1$119,059$119,059

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
LombardIL601487683,500189,2802,0192,020
ChicagoIL6060731150,000160,0002,0202,020
IrvingTX7503931145,000155,0002,0202,020
New YorkNY1000511119,059119,0592,0192,019

Full company payload

Company IDcompany:column technologies
NameColumn Technologies, LLC
Normalized Namecolumn technologies
Source Company Idscompany_dol_oflc_lca_column_technologies_llc, company_uscis_h1b_datahub_column_technologies_llc_tax_8153
Source NamesColumn Technologies, LLC, COLUMN TECHNOLOGIES LLC
AliasesCOLUMN TECHNOLOGIES LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Column Technologies, LLC",
    "COLUMN TECHNOLOGIES LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "Column Technologies, LLC",
      "filing_count": 8,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "COLUMN TECHNOLOGIES, LLC",
      "filing_count": 6,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "COLUMN TECHNOLOGIES LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "8153",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 14,
  "case_count": 14,
  "role_title_count": 9,
  "worksite_count": 4,
  "total_workers": 14,
  "first_fiscal_year": 2019,
  "first_received_date": "2019-06-24",
  "latest_fiscal_year": 2020,
  "latest_decision_date": "2020-07-21",
  "certified_count": 13,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 7,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 6,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Withdrawn",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 13,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "E-3 Australian",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 13,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "N",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 4,
  "total_denial": 0,
  "fiscal_years": [
    "2020"
  ],
  "year_metrics": [
    {
      "cities": [
        "Lombard"
      ],
      "states": [
        "IL"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "60148"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_column_technologies_llc_tax_8153_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_011029"
      ],
      "continuing_approval": 3
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "LOMBARD IL 60148",
      "city": "Lombard",
      "state": "IL",
      "postal_code": "60148",
      "filing_count": 14,
      "case_count": 14,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-07-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "LOMBARD IL 60148",
      "city": "Lombard",
      "county": "Dupage",
      "state": "IL",
      "postal_code": "60148",
      "filing_count": 7,
      "case_count": 7,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-04-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CHICAGO IL 60607",
      "city": "Chicago",
      "county": "Cook",
      "state": "IL",
      "postal_code": "60607",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-07-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "IRVING TX 75039",
      "city": "Irving",
      "county": "Dallas",
      "state": "TX",
      "postal_code": "75039",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-07-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10005",
      "city": "New York",
      "county": "New York",
      "state": "NY",
      "postal_code": "10005",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-06-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 1,
    "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": [
    "IL",
    "TX",
    "NY"
  ],
  "cities": [
    "Lombard",
    "Chicago",
    "Irving",
    "New York"
  ],
  "postal_codes": [
    "60148",
    "60607",
    "75039",
    "10005"
  ],
  "top_markets": [
    {
      "city": "Lombard",
      "state": "IL",
      "postal_code": "60148",
      "lca_count": 7,
      "role_title_count": 6,
      "wage_low_min": 83500,
      "wage_high_max": 189280,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020
    },
    {
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60607",
      "lca_count": 3,
      "role_title_count": 1,
      "wage_low_min": 150000,
      "wage_high_max": 160000,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020
    },
    {
      "city": "Irving",
      "state": "TX",
      "postal_code": "75039",
      "lca_count": 3,
      "role_title_count": 1,
      "wage_low_min": 145000,
      "wage_high_max": 155000,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020
    },
    {
      "city": "New York",
      "state": "NY",
      "postal_code": "10005",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 119059,
      "wage_high_max": 119059,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019
    }
  ]
}
Industry
{
  "naics_codes": [
    "541519",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541511",
      "filing_count": 13,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "541519",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 83500,
  "annualized_high_max": 189280,
  "annualized_low_avg": 128449.785714286
}
Trend
[
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 6,
    "case_count": 6,
    "role_title_count": 6,
    "worksite_count": 2,
    "wage_low_min": 83500,
    "wage_high_max": 120047,
    "wage_low_avg": 105672.666666667
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 189280,
    "wage_high_max": 189280,
    "wage_low_avg": 189280
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 5,
    "case_count": 5,
    "role_title_count": 3,
    "worksite_count": 3,
    "wage_low_min": 89981,
    "wage_high_max": 160000,
    "wage_low_avg": 135996.2
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q4",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 145000,
    "wage_high_max": 160000,
    "wage_low_avg": 147500
  }
]
Links
{
  "roles": "/v1/roles?company=Column%20Technologies%2C%20LLC",
  "wages": "/v1/wages?company=Column%20Technologies%2C%20LLC",
  "trends": "/v1/trends?company=Column%20Technologies%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=column+technologies+llc&limit=5JSON