[北美] 分享如何在美國海投工作 以軟體為例

大家好，最近看到版上有許多畢業生OPT在即卻發現因為疫情不易取得面試
敝人畢業於美國CS排名50-70的學校，所以2018當初就是海投為主內推為輔。

去年抽到H1B的時候，研究一下發現勞工部會公布所有H1B申請案的『底薪』。
我認為那是一個很適合用來海投工作的清單：
1. 有H1B申請案，表示願意sponsor
2. 濾掉薪水低的公司，排除派遣血汗公司

*** 更正 ***
prevailing wage並非底薪的意思，定義如下：
The prevailing wage rate is defined as the average wage paid to similarly
employed workers in a specific occupation in the area of intended employment.************

只要更改一下SQL就能找出其他工作的公司清單，這邊以軟體為例。

我用的SQL是：
SELECT count(*) AS CASE_COUNTS, AVG(PREVAILING_WAGE) AS AVG_SALARY,
EMPLOYER_NAME
FROM h1bdata_2019 WHERE JOB_TITLE LIKE "%Software%"
GROUP BY EMPLOYER_NAME HAVING CASE_COUNTS > 5 ORDER BY AVG_SALARY DESC;

2019H1B申請案Software工作底薪前一百公司：
CASE_COUNTS AVG_SALARY EMPLOYER_NAME
7 275063 KRONOS INCORPORATED
7 161420 KAIZR, INC.
12 159352 WHATSAPP INC.
61 158869 NETFLIX, INC.
6 156437 SCRIBD, INC.
7 154610 BYTEDANCE INC.
9 154047 SLACK TECHNOLOGIES, INC.
13 151316 ROKU, INC.
84 150138 FACEBOOK INC.
32 149431 STUBHUB, INC.
13 149123 HGST, INC.
7 148994 INNOPEAK TECHNOLOGY, INC.
13 148991 MAPR TECHNOLOGIES, INC.
9 147807 KEEP TRUCKIN, INC.
6 147597 LIVERAMP, INC.
7 147597 OPORTUN, INC.
20 147588 VERSA NETWORKS, INC.
7 146408 MAPLEBEAR, INC.
10 146326 GLASSDOOR, INC.
49 145614 SPLUNK INC.
579 145358 FACEBOOK, INC.
6 144560 TREASURE DATA, INC.
9 144518 TWO SIGMA INSURANCE QUANTIFIED, LP
6 144089 BRANCH METRICS, INC.
137 144065 SALESFORCE.COM INC.
52 143928 ORACLE AMERICA, INC
36 143827 TWO SIGMA INVESTMENTS, LP
7 143755 FITBIT
11 143475 COUPANG GLOBAL LLC
76 143394 NVIDIA CORPORATION
10 143364 COINBASE, INC.
9 143294 QUANTENNA COMMUNICATIONS, INC.
7 143198 IMVU, INC.
6 143177 HOVER, INC.
6 143177 TEN-X INC.
7 143146 MESOSPHERE, INC.
6 142591 FUELX INC.
16 142565 MOBILEIRON, INC.
6 142272 THOUSANDEYES, INC.
7 141892 UHANA, INC.
15 141804 NETSKOPE, INC.
180 141396 OATH HOLDINGS INC.
6 140722 CLOUDERA, INC.
52 140564 TWILIO INC.
204 140369 AIRBNB, INC.
23 140179 DATA DOMAIN LLC
7 139734 ZOOX, INC.
8 139704 XILINX, INC.
14 139140 THE GAP, INC.
7 138712 CHAN ZUCKERBERG INITIATIVE LLC
10 138632 PENSANDO SYSTEMS, INC.
35 138352 FORTINET, INC.
7 138047 BROADCOM CORPORATION
23 137860 DOORDASH, INC.
14 137788 OPENDOOR LABS INC.
6 137540 LIVERAMP, INC
22 137515 BOX, INC.
43 137407 GM CRUISE LLC
7 137268 CEREBRAS SYSTEMS INC.
19 136918 QUALTRICS, LLC
13 136574 ZOOX INC.
29 136480 CREDIT KARMA, INC.
25 136268 AKT AMERICA, INC.
9 135810 BLEND LABS INC.
19 135530 INFINERA CORPORATION
215 135462 APPLE INC.
20 135205 CYNGN INC.
24 135138 LENDINGCLUB CORPORATION
281 135035 EBAY INC.
7 134720 SYNAPTICS, INC.
7 134585 EXABEAM, INC.
11 134240 SNOWFLAKE COMPUTING INC.
28 134103 EQUINIX, INC.
80 133940 SNAP INC.
136 133918 LYFT, INC.
6 133800 PLUME DESIGN, INC.
8 133557 PROOFPOINT, INC.
8 133040 MIXPANEL INC.
16 132922 CA, INC.
13 132779 AFFIRM, INC.
32 132763 THUMBTACK, INC.
12 132593 RISK MANAGEMENT SOLUTIONS, INC.
91 132455 ORACLE AMERICA, INC.
8 131885 PALANTIR TECHNOLOGIES INC.
424 131401 LINKEDIN CORPORATION
14 131291 HORTONWORKS, INC
7 131285 E*TRADE FINANCIAL CORPORATION
6 131167 QUANTUMSOFT SOLUTIONS.INC
10 131112 WESTERN DIGITAL TECHNOLOGIES, INC.
21 130880 CONTEXTLOGIC INC.
10 130814 TELENAV, INC.
6 130732 REDDIT, INC.
19 130431 RUBRIK, INC.
14 130196 BYTON NORTH AMERICA CORPORATION
6 129917 LIFE360, INC.
15 129698 ESSENTIAL PRODUCTS, INC.
130 129595 TWITTER, INC.
27 129524 OKTA, INC.
8 129275 NEXTDOOR.COM, INC.
81 128902 PURE STORAGE, INC.

https://github.com/fatliau/h1b2019database/blob/master/output_csv/software_h1b_employers.csv

完整名單我放在我的github，同時也有ReadMe說明如何處理資料載到sqlite中

有興趣的可以改一下python script用來分析2020的資料或是綠卡Perm申請案

--