Greater Dubuque Development Corporation Skills Gap Analyisis Copyrighted
July 17, 2017
City of Dubuque Consent Items # 28.
ITEM TITLE: Greater Dubuque Development Corporation Skills Gap
Analysis
SUMMARY: City Manager transmitting the Fall 2016 Greater Dubuque
Region Skills Gap Analysis from the Greater Dubuque
Development Corp.
SUGGESTED DISPOSITION: Suggested Disposition: Receive and File
ATTACHMENTS:
Description Type
Skills Gap Analysis Supporting Documentation
GREATER DUBUQUE REGION
SKILLS GAP ANALYSIS
rHLL L016
Presented by
Emsi.1 l e
Greater
Dubuque
DEVELOPMENT CORP.
NORTHEAST IOWA
COMMUNITY COLLEGE
•
Introduction......................................................................................................................................................................................2
Background ...................................................................................................................................................................................2
Region...............................................................................................................................................................................................2
Definitions.....................................................................................................................................................................................2
LaborMarket Overview.................................................................................................................................................................3
DemographicInformation.................................................................................................................................................................4
ProjectedWorking age Population................................................................................................................................................4
Projected Population by Race/Ethnicity ........................................................................................................................................5
ProjectedPopulation by Gender....................................................................................................................................................5
Educational Attainment Overview.....................................................................................................................................................6
SkillGaps by Occupation...................................................................................................................................................................7
OrganizationalMethod..................................................................................................................................................................7
AppendixA......................................................................................................................................................................................10
Definitions...................................................................................................................................................................................10
AppendixB......................................................................................................................................................................................12
Standard Occupation Codes and Definitions(For Occupations in top 60) ....................................................................................12
1
INTRODUCTION
BACKGROUND ' I ■
In 2014,Greater Dubuque Development Corporation contracted with Smart Solutions to develop a regional Skills Gap Analysis to
identify both skill and training deficiencies in the local economy.The purpose of the Skills Gap Analysis is to provide economic
developers, workforce developers,and educators with information on projected workforce shortages(gaps)and to identify
strategies to mitigate these shortages.
In 2015, Northeast Iowa Community College obtained access to EMSI Analyst through a statewide grant awarded to Iowa's
community colleges through the Department of Labor.The College partnered with Greater Dubuque Development Corporation on
the implementation of EMSI Analyst and the development of the 2015 Skills Gap Analysis,as well as this 2016 Analysis.
EMSI is a leading provider of historical databases of economic, industry,occupation,demographic,and education completion data.
EMSI's primary data sources for this skills gap analysis are the Bureau of Labor Statistics and the National Center for Education
Statistics' Integrated Postsecondary Education Data System (IPEDS). This report utilizes EMSI and IPEDS data as primary sources,
based on EMSI's 2016 3,d quarter data release.
This analysis contains data for seven counties: SAUR
HOWARD CRAWFORD RICHIAND
• Clayton, IA wINxESHIOc AWNAI(EE
• Delaware, IA CHICWW
• Dubuque, IA IOWA
FAYEIIE nAnoN GRANT
• Jackson, IA eRrAnER
• Jones, IA — - - uFAVEtrE GR
• Jo Daviess, IL -
RIACKHAWK RACHANAPI DELIWAAE DUBUQUE
• Grant, WI _ _ STEPHE
The analysis also covers the Dubuque Metropolitan Statistical Area (MSA), io�Es .Acrsuw
a SWON [INN !- - CARROLL
defined by the Office of Management and Budget as, "urban areas in the
cuNrCN
United States centered on an urban cluster with a population of 50,000 or CEDAR WHITESIDE
more." Dubuque's MSA is the same as Dubuque County. SHIER 1OWA JOHNSON scop
MUSCATINE
DEFINITIONS
The term "skills gap" can be used to refer to either(or both)of the following phenomenon:
• the available pool of prospective employees compared to the jobs available in a particular occupation,and
• the skills and abilities possessed by current or prospective employees compared to the requirements of available jobs
We'll refer to the first challenge as the "Labor Skills Gap"and the second as the "Technical Skills Gap." This report focuses on Labor.
This report provides the following information:
• Occupations projected to have the greatest number of openings by 2026 in the region (paying over$16/hr. median wage).
• The difference between projected jobs and anticipated graduates possessing training from local higher education
institutions.
2
LABOR MARKET OVERVIEW
Dubuque Region 2016 - 2026 Employment
11. 1 .
169,465 161,905 Region 1 1
170,000
26
160,000 Dubuque MSA 9.3% 12.2%
150,000 -
Dubuque Region 5.2% 10.7%
Iowa 5.4% 11.0%
140,000 129,043 Nation 6.2% 10.1%
130,000
120,000 116,591
WorkingPopulation
110,000 Region
2006- 1 .100,000 2016 2026
-Working Age Population -Employment Dubuque MSA 7.3% -1.8%
Dubuque Region 1.8% -4.5%
Iowa 5.2% -2.3%
Nation 8.5% -0.6%
October 2016 Unemployment by County
49 Earnings per Worker
4.3% (Median Hourly)
3.6% 3.6% 3.8%
3.1% 3.2% 3.4%
MSA
Region
Iowa
T Nation
Nation Jo Daviess Jackson Jones Dubuque Grant Clayton Delaware
Employment in the Dubuque MSA is projected to grow(12.2%) at a rate slightly above the projections for the
region (10.7%), State of Iowa (11.0%) and the Nation (10.1%).
While the working age population (age 15 to 69) is projected to remain relatively flat nationally (-0.6%),greater
declines are projected in Iowa (2.3%) and the Dubuque MSA (1.8%),with the greatest decline projected for the
region at 4.5%.
Iowa's labor force participation rate hovers around 70%; The labor force participation rate is the percentage of
the eligible age population that is either employed or actively seeking work. Nationally the rate currently 62.3%.
The region's unemployment rate remains low and below the national unemployment rate; highlighting the
region's need to import workforce in as part of an overall workforce strategy.
The Dubuque MSA's median hourly earnings per worker of$17.89/hr. is 7% less than the State median and only
slightly higher (2%) than the region's median hourly wage.
Of the 8 MSAs in Iowa, Dubuque's median wage ranks 61".
Notes:
• Median Hourly Earnings Per Worker:The hourly earnings, excluding benefits,of a worker in that group. In the
occupational report, it represents the midpoint of the wage distribution for an occupation: half of the workers make
more, half of them make less. Source:EMSI, Inc. (EMSI Proprietary estimates will likely vary from other state and federal
estimates.)
3
DEMOGRAPHIC • •
Source for Demographic Information from 2006 through 2026:
• ALL demographic data is from the U.S. Census Bureau's Population Estimates program and the U.S.Census Bureau and
Bureau of Labor Statistics Current Population Survey. (See appendix A).
PROJECTED WORKING AGE POPULATI
2.1
20K
18K
16K
14K
12K
10F
8h
6h
4K
2K
OK
Y Y Y Y Y Y Y Y Y Y Y 3Y Y Y Y
si`'c N�oc iE3 �id°c yi`'s #➢c y#Df #$ �,C' s•1•'3
01' 01" o a o 0 o p 0 o o o o�
J 5 �Og `yam O� y O� y< < y� � y� � y O� •i � �Y
'L 'L 'S 'S 1Q P � y (� 6 1 1 QP ,tcT
eh
The graph above represents projected working age population for the 7-county region
CountyWorking Age Population Working Age Population
• (2016-2026) Dubuque (2016-2026)
/ 1 1 1
Age Pop. Pop. Total Total Age Pop. Pop. Total Total
1 1 1 1
Pop. o Pop. '••
15 to 19 16,237 16,345 6.6% 6.6% 15 to 19 6,645 6,648 3.2% 3.2%
20 to 24 18,323 15,393 7.4% 6.2% 20 to 24 6,760 6,258 3.2% 3.0%
25 to 29 13,638 11,605 5.5% 4.7% 25 to 29 6,218 5,390 3.0% 2.6%
30 to 34 14,473 14,715 5.9% 5.9% 9 to 34 6,420 6,028 3.1% 2.9%
35 to 39 13,042 14,562 5.3% 5.9% 35 to 39 5,450 6,458 2.6% 3.1%
40 to 44 12,915 14,645 5.2% 5.9% 40 to 44 5,145 6,417 2.5% 3.1%
45 to 49 14,037 13,161 5.7% 5.3% 45 to 49 5,750 5,449 2.8% 2.6%
50 to 54 17,154 13,000 7.0% 5.2% 50 to 54 6,701 5,143 3.2% 2.5%
55 to 59 18,554 14,187 7.5% 5.7% 55 to 59 6,968 5,730 3.3% 2.7%
60 to 64 17,029 16,899 6.9% 6.8% 60 to 64 6,380 6,488 3.1% 3.1%
65 to 69 14,063 17,393 5.7% 7.0% 65 to 69 5,058 6,281 2.4% 3.0%
Total
Population 169,465 161,905 68.8% 65.2% PopulationTotal 67,495 66,290 32.4% 31.7%
4
PROJECTED POPULATION BY RACE/ETHNICITY
Hispanic= (HIS)
Non-Hispanic= (NHS)
Race/Ethnicity Race/Ethnicity
7 County Region(2016-2026) Dubuque
2016 2026 % A 2016 2026 %
Race/Ethnicity Pop Pop 2016 2026 Race/Ethnicity Pop Pop 2016 2026
Pop Pop Pop Pop
White (NHS) 230,786 230,305 93.7% 92.8% White (NHS) 89,109 90,398 91.4% 90.2%
Black(NHS) 4,550 5,271 1.8% 2.1% Black(NHS) 2,942 3,443 3-
White (HIS) 4,339 4,937 1.8% 2.0% White (HIS) 1,919 2,186 2.0% 2.2%
Asian (NHS) 2,587 3,023 1.1% ' 1.2% Asian (NHS) 1,426 1,707 1-
Two or More 2,344 2,812 1.0% 1.1% Two or More 1,317 1,533 1.4% 1.5%
Races(NHS) Races (NHS)
Native Hawaiian 485 575 0.2% 0.2% Native 299 335 0
or Pacific Hawaiian or
Islander(NHS) Pacific Islander
� (NHS)
American Indian 425 461 0.2% 0.2% American 162 173 0.2% 0.2%
or Alaskan (NHS) Indian or
Alaskan (NHS)
Black(HIS) 211 290 0.1% 0.1% Black(HIS) 122 17
American Indian 185 237 0.1% 0.1% American 104 136 0.1% 0.1%
or Alaskan Indian or
Native (HIS) Alaskan Native
(HIS)
Two or More 181 220 0.1% 0.1% Two or More 86 1
Races(HIS) Races (HIS)
Asian (HIS) 73 98 0.0% 0.0% Asian (HIS) 49 69 0.1% 0.1%
Native Hawaiian 22 21 0.0% 0.0% Native
or Pacific Hawaiian or
Islander(HIS) Pacific Islander
(HIS)
Total 246,188 248,250 ^^"6 Total 97,546 100,264 100% 100%
PROJECTED POPULATION BY GENDER -
7 County Region (2016-2026) Dubuque
Gender 2016 2026 %2016 %2016 Gender 2016 2026 %2016 OA 2016
Pop Pop Pop Pop Pop Pop Pop Pop
Males 124,268 125,647 50.5% 50.6% Females 49,227 50,421 50.5% 50.3%
Females 121,920 122,603 49.5% 49.4 Males 48,318 49,844 4W
° 49.7%
Total 246,188 248,250 100.0% 100.0% Total 97,545 100,265 100.0% 100.0%
5
EDUCATIONAL ATTAINMENT OVERVIEW
E 2006Population 2016 population
80.00K
70.00K
60.00K
50.00K
N
40.00K
30.00K
20.00K
10.00K
0.00K
Dei9 GCS'
The graph above represents educational attainment for the 7 county region.
7 County Region(2006-2016) Dubuque (2006-2016)
Education Level /16 % %Total Education Level 2016
'.• Chg. 'v• 'o• Chg. 'o•
<9th Grade 7,376 2.5% 4% <9th Grade 2,486 1.7% 4%
9th- 12th Grade 8,220 0.4% 5% 9th- 12th Grade 3,330 5.6% 5%
High School Diploma 66,756 2.5% 40% High School Diploma 24,241 4.7% 37%
Some College 32,827 0.9% 20% Some College 12,105 1.2% 18%
Associate's Degree 15,590 4.3% 9% Associate's Degree 5,794 7.8% 9%
Bachelor's Degree 23,596 2.6% 14% Bachelor's Degree 11,453 4.7% 17%
Graduate and Higher 12,439 5.6% 7% Graduate and Higher 6,098 5.5% 9%
Total 166,804 65,507 100%
Notes:
1) The adult population is defined as the population 25 and older for the purposes of this analysis.
2) The data in the tables above represents the highest level of education attained by the total population of each set.
3) For example, in the Dubuque MSA there is not a 37%graduation rates of High School Students;the table shows that 37%of
the Dubuque MSA population has a High School Diploma as their highest level of educational achievement.
6
SKILL GAPS BY OCCUPATION
ORGANIZATIONAL METHOD
T All occupations where the 2016 median hourly earnings adjusted to only include an amount>$15.99/hr.
T Openings greater than 10(Openings represents replacementjobs and BLS employee growth estimates).
T Top 60 occupations with a skills gap greater than 0. (Skills gap is the difference between projected openings and graduates.)
T Sorted by largest skills gap to smallest.
T Growth, Replacements,Openings, Graduates,and Skills Gap all represent 2016-2026, 10-year estimates.
T Graduate values of AD(Advanced Degree), HS(High School or Equivalent),XP (Experience) indicate typical levels of education
required,which we do not train for in the region.
2016 2015Description r r Growth OpeRank Rank Jobs Jobs ments ings uates Gap Hourly
Earnings
n Grad Skills Median- Heavy and Tractor-Trailer Truck Drivers 2214 2456 272 414 686 270 416 $15.09
23 First-Line Supervisors of Office and 793 937 144 133 277 XP 277 $20.49
2 Administrative Support Workers
3 - Construction Laborers 1092 1315 223 244 467 240 227 $16.42
3 First-Line Supervisors of Production and 722 764 42 123 165 XP 165 $23.38
4 Operating Workers
5 Inspectors,Testers,Sorters,Samplers,and 424 470 46 115 161 0 161 $16.89
5 Weighers
4 First-Line Supervisors of Mechanics, 310 359 49 67 116 XP 116 $26.76
6 Installers,and Repairers
First-Line Supervisors of Construction467 79 W34 113 XP 113 $26.25
7 Trades and Extraction Workers
8 7 Industrial Machinery Mechanics 428 535 107 127 234 130 104 $22.46
9 21 Highway Maintenance Workers 301 316 15 83 98 HS 98 $20.27
10 8 Cement Masons and Concrete Finishers 319 403 84 44 128 30 98 $17.67
11 10 Pharmacists 228 256 28 60 88 AD 88 $53.32
24 First-Line Supervisors of Helpers,Laborers, 143 161 18 50 68 XP 68 $20.53
12 and Material Movers,Hand
first-Line Supervisors of Transportation and
16 Material-Moving Machine and Vehicle 139 158 19 48 67 XP 67 $24.05
13 Operators
14 34 Brickmasons and Blockmasons 205 243 38 52 90 30 60 $20.86
15 - Postal Service Mail Carriers 314 239 -75 128 53 HS 53 $25.25
16 43 Crane and Tower Operators 108 120 12 40 52 0 52 $21.18
20 Dispatchers,Except Police,Fire,and 105 124 19 30 49 HS 49 $18.53
17 Ambulance
18 9 Dental Hygienists 152 169 17 32 49 0 49 $31.77
19 22 Lawyers 190 208 18 30 48 AD 48 $34.89
50 Education Administrators,Elementary and 230 245 15 69 84 40 44 $42.71
20 Secondary School
21 - Family and General Practitioners 163 152 -11 54 43 AD 43 $94.57
22 - Food Batchmakers 157 157 0 42 42 HS 42 $17.20
7
2016 2015 2016 2026 Replace Open Grad Skills Median
Description Growth Hourly
Rank Rank Jobs Jobs ments ings uates Gap Earnings
1 Operating Engineers and Other 556 624 68 104 172 130 42 $22.21
23 Construction Equipment Operators
Computer-Controlled Machine Tool 638 752 114 217 331 290 41 $17.06
24 Operators,Metal and Plastic
25 - Chief Executives 176 183 7 33 40 XP 40 $62.21
Sales Representatives,Wholesale and
12 Manufacturing,Except Technical and 1265 1324 59 280 339 300 39 $23.05
26 Scientific Products
27 39 Speech-Language Pathologists 68 86 18 20 38 AD 38 $30.31
33 Special Education Teachers,Kindergarten 126 138 12 25 37 0 37 $22.81
28 and Elementary School
Heating,Air Conditioning,and Refrigeration 208 250 42 35 77 40 37 $22.00
29 Mechanics and Installers
30 14 Human Resources Specialists 341 379 38 89 127 90 37 $20.82
31 - Mental Health Counselors 76 94 18 18 36 AD 36 $19.47
40 First-Line Supervisors of Police and 86 91 5 31 36 XP 36 $34.10
32 Detectives
33 - Compliance Officers 117 135 18 18 36 0 36 $26.08
34 2 Electricians 511 484 -27 123 96 60 36 $23.07
52 Supervisors of Non-Retail Sales 163 178 15 20 35 XP 35 $24.05
35 Workers
36 48 School
Education Teachers,Secondary 130 138 8 26 34 0 34 $26.10
37 51 Occupational Therapists 64 83 19 14 33 0 33 $29.00
38 38 Education Administrators,Postsecondary 177 194 17 54 71 40 31 $36.35
39 36 Sheet Metal Workers 112 125 13 27 40 10 30 $22.43
32 Telecommunications Line Installers and 42 61 19 11 30 0 30 $23.32
40 Repairers
41 30 Paralegals and Legal Assistants 97 103 6 23 29 0 29 $18.40
42 19 Librarians 116 120 4 23 27 0 27 $20.45
43 58 Veterinarians 92 99 7 18 25 0 25 $33.17
44 56 Fundraisers 79 92 13 12 25 0 25 $19.40
31 Telecommunications Equipment Installers 71 85 14 10 24 0 24 $23.94
45 and Repairers,Except Line Installers
46 - Construction and Building Inspectors 64 69 5 18 23 0 23 $25.23
47 26 Painters,Construction and Maintenance 106 113 7 26 33 10 23 $18.46
48 47 Chiropractors 53 65 12 11 23 AD 23 $34.08
49 - Dentists,General 56 65 9 14 23 AD 23 $71.12
48 First-Line Supervisors of Landscaping,Lawn 50 60 10 11 21 XP 21 $19.74
50 Service,and Groundskeeping Workers
51 - Financial Managers 614 705 91 160 251 230 21 $40.07
52 - Occupational Therapy Assistants 29 40 11 10 21 0 21 $25.82
First-Line Supervisors of Fire Fighting and 36 39 3 17 20 XP 20 $33.64
53 Prevention Workers
8
2016 2015 2016 2026 Replace Open Grad Skills Median
Description
Rank Rank Jobs Jobs ments ings uates Gap Earnings
First-Line Supervisors of Farming,Fishing, 66 67 1 19 20 XP 20 $25.61
54 and Forestry Workers
Claims Adjusters,Examiners,and 228 317 89 70 159 140 19 $23.17
55 Investigators
56 53 Special Education Teachers,Middle School 62 68 6 12 18 0 18 $25.16
Property,Real Estate,and Community 46 54 8 9 17 0 17 $20.22
57 Association Managers
42 Morticians,Undertakers,and Funeral 55 58 3 13 16 0 16 $27.10
58 Directors
59 - Optometrists 20 25 5 10 15 AD 15 $44.83
60 - Sales Engineers 29 34 5 9 14 0 14 $37.56
Total 14804 16673 1869 3442 5555 1680 2655
Top 60 Regional Skills Gap Notes:
• Some graduates are counted in multiple occupations because their degree would qualify them for multiple occupations(i.e.
a business graduate could be an insurance agent or a sales rep). The relevant occupations per degree are determined by a
proprietary EMSI crosswalk(version 2015.4 utilized for this report).
• The total projected graduates(1680)represents unduplicated educational certificates and degrees projections based on the
2015 IPEDS regional total of 168 awards relevant to the Top 60 occupations projected out 10 years.
• The Skills Gap total(2655) is calculated by 1) removing the openings that require Experience or a HS Diploma/Equivalent
and 2)subtracting from that the number of projected graduates. Experienced openings are removed because we cannot fill
that gap with graduates alone. High School openings are removed because we experience relatively high graduation rates in
our region. (4,335-1,680=2,655)
• Utilizing the same methodology, the 2015 Skills Gap (based on 2015 Top 60 Occupations and relevant regional graduates
from the 2014 IPEDS report)was slightly higher at 2,827.
Total Regional Skills Gap:
• The complete Regional Skills Gap Analysis includes 404 unique occupations projecting 42,544 openings due to growth and
replacements in the next ten years.
• Total regional college degrees or certificates awarded in the 2015 IPEDS was 5,121,which projects out to 51,210 in the next
10 years.
• Isolating regional openings for occupations requiring more than a High School diploma, but not significant experience,
31,249 openings are projected.
• Therefore,a complete Skills Gap of our region suggests a negative skills gap of 19,961 additional graduates than newjob
openings.
How can this be explained?
1) We may have a mis-alignment of degrees and certificates for the in-demand jobs in our regional economy.
2) We may have out-migration of skilled graduates to other communities.
3) We may not be successfully importing in talent with the skills for which we do not educate for regionally.
4) We may have unknown barriers to hiring new graduates, such as reluctance to hire and train, lack of employer or
community connections with students before they graduate to keep them here,and or narrow qualification requirements.
9
DEFINITIONS
How does EMSIcalculate projections ?
If you use an EMSI product or service, chances are you've seen some of our labor market projections. We provide
detailed job estimates, by industry and occupation, for each of the next 10 years from the current year.
A common question that we get from clients who see these figures is where do EMS I projections come from? The short
answer is that we create our projections based on past trends carried forward, and published projections from state and
federal sources. If you're after something a little more detailed, read on.
The first step in both our industry and occupation projections is our robust industry data. We first create simple short-,
mid-, and long-term trend lines for every industry and county based on the historical data.
Those lines are then averaged and dampened to prevent extreme change. We then incorporate national industry
projections (BLS national employment projections) as well as state and regional projections provided by state labor
market organizations to adjustthese numbers again.
Finally, we take aggregate geography and industry group figures for 10-year percentage change and make sure it
matches the corresponding published geography and industry numbers.
EMSI projections will not match the BLS or any other individual state projections atthe mostdetailed level. This can be
explained in a variety of ways.
Differences in Coverage
EMS I has broken out our labor market data into four different classes of worker thatallow our clients to dig into specific
elements of their economy. In moststates, the firsttwo classes of workers (QCEW Employees and Non-QCEW
E mployees) are mostclosely comparable to the industry projections from the published sources. We don't expect our
self-employment and proprietors projections to match BLS and state-level projections.
We Don't Use BLS/State Occupation Projections
(exceptfor our Annual J ob Openings estimates)
Our occupation projections are based off of our industry numbers with our projected, regionalized staffing pattern applied
to the figures. As a result, the occupation projections will necessarily differ from BLS occupation numbers.
Differences in Methodology
E MSI uses a combination of BLS, state, and internal projection methods. This will naturally differ from the BLS and state
projections alone.
Release Lag
EMSI projections are based on the most recent ava Ila ble data and published projections, butthe BLS and states release
only long-term projections on a two-year basis. EMSI's internal projections are more heavily weighted as state/national
projections age.
10
Occupation Data
EMSI occupation employmentdata are based on final E MSI industry data and final EMSI staffing patterns. Wage
estimates are based on Occupational Employment Statistics (QCEW and Non-QCEW Employees classes of worker) and
the American Community Survey (Self-Employed and Extended Proprietors). Occupational wage estimates also affected
by county-level EMSI earnings by industry.
Staffing Patterns Data
The staffing pattern data in this reportare compiled from several sources using a specialized process. For QCEW and
Non-QCEW Employees classes of worker, sources include Occupational EmploymentStatistics, the National Industry-
Occupation Employment Matrix, and the American Community Survey. For the Self-Employed and Extended Proprietors
classes of worker, the primary source is the American Community Survey, with a small amountof information from
Occupational Employment Statistics.
State Data Sources
This reportuses state data from the following agencies: Illinois DepartmentofEmploymentSecurity, Employment
Projections; Iowa Workforce Development; Wisconsin Departmentof Workforce Development, Bureau of Workforce
Information
Primary Data Source Information Legend
This is a breakoutof the edition of the source used by EMSI. Shaded values indicate a change from the previous set.
Property LAbbrev Source Agency Version Used Version Used
(EMSI 2016.2) (EM SI 2016.1)
State Personal Income SPI BEA 2014 2013
Local Area Personal Income LPI BEA 2013 2013
Industry Economic Accounts IEA BEA 4 2002-2013
American Community Survey ACS Census 2005-2014 2005-2014
County Business Patterns CBP Census 2013 2013
ZIP Code Business Patterns ZBP Census 2013 2013
Nonemployer Statistics NES Census 2013 2013
Quarterly Census of Employment and Wages QCEW BLS 2015Q3 2015Q2
Current Employment Statistics CES BLS February 2016 December 2015
Natl. Employment Projections EP BLS 2014-2024 2012-2022
Occupational Employment Statistics OES BLS 2014 2014
Railroad Retirement Board,State/County RRB RRB 2013/2012 2013/2012
Business-Level Data Infogroup Updated Separately Updated Separately
Long-term state industry projections Individual states varies by state varies by state
LEHD/Quarterly Workforce Indicators QWI Census 2015Q2(states vary) 2015Q2(states vary)
Consumer Expenditure Survey CEX BLS 2014 2012
Current Population Survey CPS Census 2014 2013
Census of Governments COG Census 2012 2007
Gross Domestic Product by State GSP BEA 2014 2013
Origin-Destination Employment Statistics LODES Census 2013 2009
11
STANDARD OCCUPATION CODES AND DEFINITIONS (FOR OCCUPATIONS IN TOP 60)
O*NETSOC Title Description
Code
Brickmasons and Lay and bind building materials,such as brick,structural tile,concrete block,cinder block,glass block,and
47-2021.00 Blockmasons terra-cotta block,with mortar and other substances to construct or repair walls,partitions,arches,sewers,
and other structures.
Cement Masons and Smooth and finish surfaces of poured concrete,such as floors,walks,sidewalks,roads,or curbs using a
47-2051.00 Concrete Finishers variety of hand and power tools.Align forms for sidewalks,curbs,or gutters; patch voids;and use saws to
cut expansion joints.
Determine and formulate policies and provide overall direction of companies or private and public sector
11-1011.00 Chief Executives organizations within guidelines set up by a board of directors or similar governing body.Plan,direct,or
coordinate operational activities at the highest level of management with the help of subordinate
executives and staff managers.
29-1011.00 Chiropractors Assess,treat,and care for patients by manipulation of spine and musculoskeletal system.May provide
spinal adjustment or address sacral or pelvic misalignment.
Claims Adjusters, Review settled claimsto determine that payments and settlements are made in accordance with company
13-1031.00 Examiners,and practices and procedures.Confer with legal counsel on claims requiring litigation.May also settle insurance
Investigators claims.
Examine,evaluate,and investigate eligibility for or conformity with laws and regulations governing
13-1041.00 Compliance Officers contract compliance of licenses and permits,and perform other compliance and enforcement inspection
and analysis activities not classified elsewhere.
Computer-
51-4011.00 Controlled Machine Operate computer-controlled machines or robotsto perform one or more machine functions on metal or
Tool Operators, plastic work pieces.
Metal and Plastic
Inspect structures using engineering skills to determine structural soundness and compliance with
47-4011.00 Construction and
Building Inspectors specifications,building codes,and other regulations.Inspections may be general in nature or may be
limited to a specific area,such as electrical systems or plumbing.
Perform tasks involving physical labor at construction sites.May operate hand and power tools of all types:
Construction air hammers,earth tampers,cement mixers,small mechanical hoists,surveying and measuring equipment,
61.00
Laborers and a variety of other equipment and instruments.May clean and prepare sites,digtrenches,set bracesto
' support the sides of excavations,erect scaffolding,and clean up rubble,debris and other waste materials.
May assist other craft workers.
53-7021.00 Crane and Tower Operate mechanical boom and cable ortower and cable equipment to lift and move materials,machines,
Operators or products in many directions.
29-2021.00 Dental Hygienists Clean teeth and examine oral areas,head,and neckfor signs of oral disease.May educate patients on oral
hygiene,take and develop x rays,or applyfluoride or sealants.
Examine,diagnose,and treat diseases,injuries,and malformations of teeth and gums.Maytreat diseases
29-1021.00 Dentists,General of nerve,pulp,and other dental tissues affecting oral hygiene and retention of teeth.May fit dental
appliances or provide preventive care.
Dispatchers,Except Schedule and dispatch workers,work crews,equipment,or service vehiclesfor conveyance of materials,
freight,or passengers,orfor normal installation,service,or emergency repairs rendered outside the place
43-5032.00 Police,Fire,and of business.Duties may include using radio,telephone,or computer to transmit assignments and compiling
Ambulance statistics and reports on work progress.
Education
Administrators, Plan,direct,or coordinate the academic,administrative,or auxiliary activities of public or private
11-9032.00 Elementary and elementary or secondary level schools.
Secondary School
■
Education Plan,direct,or coordinate research,instructional,student administration and services,and other
11-9033.00 Administrators, educational activities at postsecondary institutions,including universities,colleges,and junior and
Postsecondary community colleges.
12
O*NETSOC Title Description
Code
47-2111.00 Electricians Install,maintain,and repair electrical wiring,equipment,and fixtures.Ensure that work is in accordance
with relevant codes.May install or service street lights,intercom systems,or electrical control systems.
29-1062.00 Family and General Physicians who diagnose,treat,and help prevent diseases and injuries that commonly occur in the general
Practitioners population.May refer patients to specia l ists when needed for further diagnosis or treatment.
Plan,direct,or coordinate accounting,investing,banking,insurance,securities,and otherfinancial
11-3031.00 Financial Managers activities of a branch,office,or department of an establishment.
First-Line
Supervisors of
47-1011.00 Construction Trades Directly supervise and coordinate activities of construction or extraction workers.
and Extraction
Workers
First-Line
Supervisors of
45-1011.00 Farming, Fishing, Directly supervise and coordinate the activities of agricultural,forestry,aquacultural,and related workers.
and Forestry
Workers
First-Line
Supervisors of
53-1021.00 Helpers,Laborers, Directly supervise and coordinate the activities of helpers,laborers,or material movers.
and Material
Movers,Hand
First-Line
Supervisors of Directly supervise and coordinate activities of workers engaged in landscaping or groundskeeping
37-1012.00 Landscaping,Lawn activities.Work may involve reviewing contractsto ascertain service,machine,and workforce
Service,and requirements;answering inquiries from potential customers regarding methods,material,and price
Groundskeeping ranges;and preparing estimates according to labor,material,and machine costs.
Workers
First-Line
Supervisors of
49-1011.00 Mechanics, Directly supervise and coordinate the activities of mechanics,installers,and repairers.
Installers,and
Repairers
First-Line Directly supervise and coordinate activities of sales workers other than retail sales workers.May perform
41-1012.00 Supervisors of Non-
Retail Sales Workers duties such as budgeting,accounting,and personnel work,in addition to supervisory duties.
First-Line
Supervisors of Office
43-1011.00 and Administrative Directly supervise and coordinate the activities of clerical and administrative support workers.
Support Workers
First-Line Directly supervise and coordinate the activities of production and operating workers,such as inspectors,
51-1011.00 Supervisors of production and Precision workers,machine setters and operators,assemblers,fabricators,and plant and system
Operating Workers operators.
First-Line ■
Supervisors of
53-1031.00 Transportation and Directly supervise and coordinate activities of transportation and material-moving machine and vehicle
Material-Moving operators and helpers.
Machine and
Vehicle Operators -
First-Line
33-1012.00 Supervisors of Police Directly supervise and coordinate activities of members of police force.
and Detectives
13
O*NETSOC Title Description
Code
First-Line
33-1021.00 Supervisors of Fire Directly supervise and coordinate activities of workers engaged in fire fighting and fire prevention and
Fighting and control.
Prevention Workers
Organize activities to raise funds or otherwise solicit and gather monetary donations or other gifts for an
13-1131.00 Fundraisers organization.May design and produce promotional materials.May also raise awareness of the
organization's work,goals,and financial needs.
51-3092.00 Food Batchmakers Set up and operate equipment that mixes or blends ingredients used in the manufacturing of food
products.Includes candy makers and cheese makers.
Heating and Air
Conditioning
49-9021.01 Mechanics and Install,service,or repair heating and air conditioning systems in residences or commercial establishments.
Installers
■ Heating,Air
Conditioning,and
49-9021.00 Refrigeration Install or repair heating,central air conditioning,or refrigeration systems,including oil burners,hot-air
Mechanics and furnaces,and heating stoves.
Installers
Heavy and Tractor- Drive a tractor-trailer combination or a truck with a capacity of at least 26,000 pounds Gross Vehicle
53-3032.00 Trailer Truck Drivers Weight(GVW).May be required to unload truck.Requires commercial drivers' license.
Highway Maintain highways,municipal and rural roads,airport runways,and rights-of-way.Duties include patching
47-4051.00 Maintenance broken or eroded pavement,repairing guard rails,highway markers,and snow fences.May also mow or
Workers clear brush from along road or plow snow from roadway.
13-1071.00 Human Resources Perform activities in the human resource area.Includes employment specialists who screen,recruit,
Specialists interview,and place workers.
49-9041.00 Industrial Machinery Repair,install,adjust,or maintain industrial production and processing machinery or refinery and pipeline
Mechanics distribution systems.
Inspectors,Testers, Inspect,test,sort,sample,or weigh nonagricultural raw materials or processed,machined,fabricated,or
51-9061.00 Sorters,Samplers, assembled parts or products for defects,wear,and deviations from specifications.May use precision
and Weighers measuring instruments and complextest equipment.
Represent clients in criminal and civil litigation and other legal proceedings,draw up legal documents,or
23-1011.00 Lawyers manage or advise clients on legal transactions.May specialize in a single area or may practice broadly in
many areas of law.
Administer libraries and perform related library services.Work in a variety of settings,including public
libraries,educational institutions,museums,corporations,government agencies,law firms,non-profit
organizations,and healthcare providers.Tasks may include selecting,acquiring,cataloguing,classifying,
25-4021.00 Librarians circulating,and maintaining library materials;and furnishing reference,bibliographical,and readers'
advisory services.May perform in-depth,strategic research,and synthesize,analyze,edit,and filter
information.May set up or work with databases and information systems to catalogue and access
information.
Mental Health Counsel with emphasis on prevention.Work with individuals and groupsto promote optimum mental and
21-1014.00 Counselors emotional health.May help individuals deal with issues associated with addictions and substance abuse;
family,parenting,and marital problems;stress management;self-esteem;and aging.
Morticians, Perform varioustasks to arrange and direct funeral services,such as coordinating transportation of bodyto
39-4031.00 Undertakers,and mortuary,interviewing family or other authorized person to arrange details,selecting pallbearers,aiding
Funeral Directors with the selection of officials for religious rites,and providing transportation for mourners.
Occupational Assess,plan,organize,and participate in rehabilitative programs that help build or restore vocational,
29-1122.00 Therapists homemaking,and daily living skills,as well as general independence,to persons with disabilities or
developmental delays. i
Occupational Assist occupational therapists in providing occupational therapy treatments and procedures.May,in
31-2011.00
Therapy Assistants accordance with State laws,assist in development of treatment plans,carry out routine functions,direct
activity programs,and document the progress of treatments.Generally requires formal training.
14
O*NETSOC Title Description
Code
Operating Engineers Operate one or several types of power construction equipment,such as motor graders,bulldozers,
and Other scrapers,compressors,pumps,derricks,shovels,tractors,or front-end loaders to excavate,move,and
47-2073.00 Construction grade earth,erect structures,or pour concrete or other hard surface pavement.May repair and maintain
Equipment equipment in addition to other duties.
Operators
Diagnose,manage,and treat conditions and diseases of the human eye and visual system.Examine eyes
29-1041.00 Optometrists and visual system,diagnose problems or impairments,prescribe corrective lenses,and provide treatment.
May prescribe therapeutic drugs to treat specific eye conditions.
Painters, Paint walls,equipment,buildings,bridges,and other structural surfaces,using brushes,rollers,and spray
47-2141.00 Construction and guns.May remove old paint to prepare surface priorto painting.May mix colors or oilsto obtain desired
Maintenance color or consistency.
23-2011.00 Paralegals and Legal Assist lawyers by investigating facts,preparing legal documents,or researching legal precedent.Conduct
Assistants research to support a legal proceeding,to formulate a defense,or to initiate legal action.
Dispense drugs prescribed by physicians and other health practitioners and provide information to patients
s about medications and their use. May advise physicians and other health practitioners on the selection,
dosage,interactions,and side effects of medications.
Postal Service Mail
43-5052.00 Sort mail for delivery.Deliver mail on established route by vehicle or on foot.
Carriers
Property,Real
Estate,and Plan,direct,or coordinate the selling,buying,leasing,or governance activities of commercial,industrial,or
11-9141.00 Community residential real estate properties.Includes managers of homeowner and condominium associations,rented
Association or leased housing units,buildings,or land (including rights-of-way).
Managers
41-9031.00 Sales Engineers Sell business goods or services,the selling of which requires a technical background equivalent to a
baccalaureate degree in engineering.
Sales
Representatives,
Wholesale and Sell goods for wholesalers or manufacturers to businesses or groups of individuals.Work requires
41-4012.00 Manufacturing, substantial knowledge of items sold.
Except Technical
and Scientific
Products ' _ ==J
Fabricate,assemble,install,and repair sheet metal products and equipment,such as ducts,control boxes,
drainpipes,and furnace casings.Work may involve any of the following:setting up and operating
47-2211.00 Sheet Metal fabricating machines to cut,bend,and straighten sheet metal;shaping metal over anvils,blocks,or forms
Workers using hammer,operating soldering and welding equipment tojoin sheet metal parts;or inspecting,
assembling,and smoothing seams and joints of burred surfaces.Includes sheet metal duct installers who
install prefabricated sheet metal ducts used for heating,air conditioning,or other purposes.
Special Education
Teachers, Teach elementary school subjects to educationally and physically handicapped students.Includes teachers
25-2052.00 who specialize and work with audibly and visually handicapped students and those who teach basic
Kindergarten and
Elementary School academic and life processes skills to the mentally impaired.
Special Education Teach secondary school subjects to educationally and physically handicapped students.Includes teachers
25-2054.00 Teachers,Secondary who specialize and work with audibly and visually handicapped students and those who teach basic
School academic and life processes skills to the mentally impaired.
Special Education Teach middle school subjectsto educationally and physically handicapped students.Includes teachers who
25-2053.00 Teachers,Middle specialize and work with audibly and visually handicapped students and those who teach basic academic
School and life processes skillsto the mentally impaired.
Assess and treat persons with speech,language,voice,and fluency disorders.May select alternative
Pathologists
29-1127.00 Speech-Language communication systems and teach their use.May perform research related to speech and language
problems.
15
O*NETSOC Title Description
Code
Telecommunications Install,set-up,rearrange,or remove switching,distribution,routing,and dialing equipment used in central
Equipment Installers offices or headends.Service or repair telephone,cable television,Internet,and other communications
49-2022.00 and Repairers,
Except Line equipment on customers'property. Y May install communications equipment or communications wiringin
Installers buildings.
Telecommunications
49-9052.00 Line Installers and Install and repair telecommunications cable,including fiber optics.
Repairers
29-1131.00 Veterinarians Diagnose,treat,or research diseases and injuries of animals.Includes veterinarians who conduct research
and development,inspect livestock,or care for pets and companion animals.
16