This query outputs the 3 job titles with the most open positions by state.

employer_state
ranking
job_title
total_positions
AK1Elementary School Teacher20
AK2Special Education Teacher (K-12)18
AK3SECONDARY SCHOOL TEACHER16
AK3MIDDLE SCHOOL TEACHER16
AL1Aircraft Technologies Engineer830
AL2Assistant Professor267
AL3AIRCRAFT TECHNOLOGIES ENGINEER121
AR1Software Engineer III933
AR2Senior Software Engineer596
AR3Staff Software Engineer235
AZ1Teacher156
AZ2Aeronautical Scientific Technician 140
AZ3Senior Software Engineer137
CA1Software Engineer30693
CA2Senior Software Engineer8578
CA3Staff Software Engineer5115
CO1Assistant Professor82
CO2Software Developer80
CO3Software Engineer61
CT1Software Developer168
CT2Associate Research Scientist117
CT3Software Engineer112
DC1Teacher122
DC2Associate49
DC3Assistant Professor36
DE1Software Developer162
DE2Assistant Professor50
DE3Software Engineer47
FL1ADVANCED SOFTWARE DEVELOPER3610
FL2SENIOR SOFTWARE DEVELOPER2534
FL3ADVANCED BUSINESS ANALYST740
GA1Software Developer1143
GA2Software Engineer624
GA3SOFTWARE DEVELOPER372
GU1CIVIL ENGINEER145
GU2ELECTRICAL ENGINEER54
GU3Civil Engineer48
HI1Assistant Professor14
HI2Assistant Professor 13
HI3Project Engineer - Civil12
IA1Software Engineer111
IA2Software Developer110
IA3Postdoctoral Research Associate69
ID1Fire Fighting Pilot11
ID2Medical Technologist10
ID3Assistant Professor8
ID3Mental Health Case Manager8
IL1Software Engineer1050
IL2Applications Consultant 31000
IL3Software Developer954
IN1Assistant Professor203
IN2Software Developer130
IN3Engineer Lead88
KS1Software Developer66
KS2Software Engineer61
KS3Medical Technologist58
KY1Senior Software Engineer73
KY2Assistant Professor63
KY3Software Engineer45
LA1Assistant Professor88
LA2Medical Technologist45
LA3Postdoctoral Fellow30
MA1Research Fellow545
MA2Consultant534
MA3Senior Software Engineer439
MD1Architect2631
MD2Software Developer1228
MD3Developer1082
ME1Hospitalist37
ME2Software Developer17
ME3Data Engineer9
ME3Postdoctoral Associate9
MI1Software Engineer1237
MI2Software Developer898
MI3SOFTWARE DEVELOPER478
MN1Senior Software Engineer453
MN2Software Engineer303
MN3Clinical Resident125
MO1Software Developer248
MO2Software Engineering Senior Advisor186
MO3Software Engineer116
MP1Accountant12
MP2ACCOUNTANT8
MP3ACCOUNTANTS6
MP3Physical Therapist6
MS1Assistant Professor45
MS2Mathematics Teacher27
MS3Postdoctoral Associate15
MT1SOFTWARE DEVELOPER33
MT2Medical Technologist14
MT3Hospitalist6
NC1Application Developer680
NC2Software Developer592
NC3Software Engineer481
ND1Medical Technologist33
ND2Medical Laboratory Scientist29
ND3Mechanical Engineer24
NE1SOFTWARE DEVELOPER87
NE2DATA ANALYST70
NE3DATA ENGINEER60