FY2007 LCA Counts by Occupation

In order to analyze the occupational breakdown of LCAs I ran this query against the FY2007 EFILE data:

SELECT 
	SUM(Nbr_Immigrants) AS [Count], 
	LCASE(EFILE_FY2007_DATA.Job_Title) AS JOB_TITLE, 
	Wage_Rate_Per_1, 
	AVG(Wage_rate_From_1) AS WAGE
FROM EFILE_FY2007_DATA
GROUP BY 
	LCASE(EFILE_FY2007_DATA.Job_Title), 
	Wage_Rate_Per_1
ORDER BY SUM(Nbr_Immigrants) DESC;

The full data is here as a 2meg zipped Excel file. (The query returned about 68,000 rows. I had to truncate to 65,000 to do the copy/paste from Access to Excel.)

Raw data obtained from here: http://www.flcdatacenter.com/CaseData.aspx 

The top 100 results are below. While it's difficult to determine the precise percent of H-1b that are "software related," clearly bulk are IT jobs. The total number of immigrants sought was 764,776. This is because DOL "approves everything" and many employers file LCA for 10 workers than only apply for a few - or none.

This is the "from" (lower) pay range. Some LCAs also include a "to" (upper) scale.

Some of the results, in yellow, do seem crazy.

 

Count JOB_TITLE Wage WAGE
117854 programmer analyst Year $56,144.66
38171 software engineer Year $70,923.57
22595 computer programmer Year $60,137.67
19159 systems analyst Year $59,014.06
12436 project manager Year $77,104.72
11761 computer programmer analyst Year $60,411.94
10425 business systems analyst Year $62,242.95
10020 slicer dicer Hour $17.04
8999 programmer analyst Hour $347.23
8369 programmer/analyst Year $61,300.88
8137 computer systems analyst Year $62,027.80
7211 business analyst Year $58,295.18
5324 assistant professor Year $86,294.49
5232 database administrator Year $61,006.88
4885 teacher Year $40,558.44
4830 main job Hour $17.50
4338 senior software engineer Year $92,505.12
3987 erp analyst Year $52,749.94
3588 research associate Year $47,661.57
3410 system administrator Year $52,817.79
3338 network administrator Year $55,888.90
3269 computer systems analysts Year $56,142.63
2891 accountant Year $50,196.32
2818 market research analyst Year $50,455.92
2813 business system analyst Year $56,419.03
2705 engineer Hour $191.50
2658 financial analyst Year $61,575.43
2510 software developer Year $73,455.71
2488 software programmer Year $51,840.36
2458 programmer analyst ii Year $65,746.45
2339 computer programmer 2 Year $60,636.32
2287 associate Year $98,843.39
2186 senior systems analyst Year $75,400.45
2080 senior consultant Year $87,171.32
2079 physical therapist Hour $142.59
2064 applications developer Year $97,620.75
2019 network & computer systems administrators Year $51,193.58
2008 consultant Year $73,644.56
1953 technical analyst Year $67,313.78
1931 network and computer systems administrator Year $53,745.23
1879 computer programmers Year $53,831.10
1827 management analyst Year $69,192.47
1782 engineer Year $64,207.40
1753 special education teacher Year $43,444.61
1736 elementary school teacher Year $40,719.24
1729 computer system analyst Year $77,046.35
1702 postdoctoral fellow Year $40,581.55
1684 pharmacist Hour $74.67
1627 computer software engineer Year $61,895.21
1618 analyst Year $65,541.08
1562 computer programmer/analyst Year $56,352.67
1550 network & computer systems administrator Year $52,288.83
1546 programmer Year $54,875.39
1524 computer software engineer, applications Year $70,943.50
1519 quality management 101 Year $99,000.00
1501 technology consultant iii Year $75,267.81
1442 accountant Hour $64.36
1440 mechanical engineer Year $73,317.12
1439 programmer / analyst Year $52,334.90
1438 programmer  analyst Year $55,374.38
1431 design engineer Year $71,974.73
1404 floor moper Hour $10.00
1387 physical therapist Year $65,298.57
1385 technology consultant ii Year $73,436.63
1368 senior programmer analyst Year $88,710.28
1363 systems analyst Hour $80.63
1358 medical resident Year $46,353.95
1307 quality assurance analyst Year $60,780.52
1303 research fellow Year $54,866.63
1277 graphic designer Year $49,941.09
1275 hardware engineer Year $80,149.51
1266 business development manager Year $79,355.01
1256 system analyst Year $58,328.10
1222 secondary school teacher Year $41,865.23
1204 software development engineer Year $86,580.29
1201 senior analyst Year $76,036.07
1170 staff accountant Year $45,622.81
1168 postdoctoral research associate Year $40,308.00
1166 software engineer Hour $626.43
1164 project engineer Year $62,347.95
1164 systems engineer Year $70,852.33
1160 analyst programmer 2 Year $53,680.70
1159 assistant project manager Year $64,240.54
1157 physician Year $151,740.29
1111 business analysts Hour $25.17
1108 software development engineer in test Year $79,870.66
1098 computer system analysts Year $54,849.10
1095 network engineer Year $60,118.28
1094 computer software engineer applications Year $72,526.75
1077 resident physician Year $57,332.99
1040 network computer system administrator Year $51,546.15
1038 systems administrator Year $59,037.58
1016 electrical engineer Year $74,093.13
995 elementary teacher Year $42,151.16
991 director, organizational effectiveness and change Year $130,000.00
991 systems analyst ii Year $60,204.44
983 manager Year $93,805.89
977 software engineer ii Year $73,004.30
975 programmer analyst, level 1 Year $43,728.71