Transcript ONLINE WIA Program Information

Using Data to Support Local
Economic & Workforce
Development Efforts
September 11, 2012
Name of Presentation Here
Familiarity with basic data sources and
research techniques
For this template, you
will be using ONLY
EMSI and LMI
Gateway. However,
you should be aware
of the multitude of
data sources you
should be using to get
a handle on what’s
going on with your
region’s key industry
groups.
Types of Templates
We have developed three major types of
templates to present data to stakeholders
1. Regional Profile
2. Industry Profile
3. Site Selection
a) Constant elements
b) Custom elements
Regional Profiles
• How it is used
• Elements
• Geography
• People
• Demographics
• Race
• Hispanic Origin
• Age
• Workforce
• Educational Attainment
• Occupational Makeup
• Economy
The audience for
geographic profiles
includes:
1. Workforce
Boards
2. Local
Governments
3. Economic
Developers
4. Business/Industry
Leaders
5. Business
Associations
Regional Profile: Data Elements
& Sources
Element
Geography
Data Source
Wikipedia, County Websites
People
U.S. Census American Factfinder
Demographics (Race, Hispanic
U.S. Census American Factfinder
Origin, Age)
Workforce (Educational
Attainment, Occupational
U.S. Census American Factfinder
Makeup)
EMSI (Jobs, Earnings & Sales
Economy
Legacy Report)
EMSI Highlight: Industry Base
Industry Profiles
• How it is used
• Elements
• Industry Background
• Top Occupations
• Regional Occupational
Makeup
• Regional Growth
• Density Map/Concentration
• Entrepreneurial Activity
• Top 10 Employers
• Age Bands
The audience for
industry profiles
includes:
1. Workforce
Investment
Boards, Local
Governments,
and other
community
leaders
2. Job seekers
3. Businesses
Industry Profile: Data Elements &
Sources
Element
Industry Background
Top Occupations
Regional Occupational
Makeup
Regional Growth
Economy
Density Map & Concentration
by County
Entrepreneurial Activ ity
Top 10 Employers
Age Bands
Data Source
BLS, BEA, Industry Journals, Web
Research
EMSI (Staffing Patterns Report)
EMSI (Jobs by Occupation
Legacy Report) and State
Workforce Center Database
EMSI (Jobs by Industry Legacy
Report)
EMSI (Jobs, Earnings & Sales
Legacy Report)
EMSI GIS
EMSI (Jobs by Industry Legacy
Report for Complete and
Cov ered Employment)
Colorado Department of Labor
and Employment
Colorado Demography Office
EMSI Highlight: Regional Occupational Makeup
Top 20 Occupations, Information Technology Sector, Metro Denver
SOC
Code
Description
13-1111 Management analysts
2012
Jobs
Available
Annual
Applicants Openings
Applicants
Median
per Job
Wage
Opening
10th
Percentile
Wage
25th
Percentile
Wage
Average
Wage
75th
Percentile
Wage
90th
Percentile
Wage
15,524
371
652
0.57
$ 25.43 $
13.77 $
17.79 $
30.05 $
37.17 $
52.52
5,329
222
202
1.10
$ 29.44 $
14.33 $
21.15 $
31.41 $
39.56 $
51.47
Computer software engineers, systems
software
10,176
203
167
1.22
$ 43.27 $
30.00 $
35.35 $
44.56 $
53.49 $
63.45
13-1199 Business operation specialists, all other
22,536
881
692
1.27
$ 30.81 $
16.87 $
23.05 $
32.85 $
40.45 $
52.10
Secretaries, except legal, medical, and
43-6014
executive
28,419
645
504
1.28
$ 16.04 $
10.94 $
13.14 $
16.45 $
19.63 $
23.19
Computer software engineers,
applications
12,995
400
232
1.72
$ 42.46 $
27.83 $
34.02 $
43.24 $
51.00 $
62.20
25,491
1,619
846
1.91
$ 26.15 $
16.80 $
20.09 $
30.04 $
35.70 $
47.91
69.72
Network systems and data
15-1081
communications analysts
15-1032
15-1031
13-2011 Accountants and auditors
17-2061 Computer hardware engineers
763
47
24
1.96
$ 47.43 $
25.94 $
36.09 $
47.77 $
59.13 $
7,943
458
220
2.08
$ 34.56 $
21.75 $
27.36 $
36.37 $
44.24 $
23,594
2,153
755
2.85
$ 46.39 $
22.40 $
31.22 $
54.43 $
69.86
$
107.50
15-1061 Database administrators
2,359
180
57
3.16
$ 34.51 $
18.52 $
24.50 $
35.01 $
44.97 $
54.03
Sales representatives, wholesale and
41-4011 manufacturing, technical and scientific
products
6,495
632
181
3.49
$ 34.12 $
15.51 $
23.72 $
38.66 $
49.00 $
63.62
Network and computer systems
administrators
6,359
659
168
3.92
$ 36.27 $
21.40 $
28.09 $
36.66 $
44.06 $
53.80
15-1051 Computer systems analysts
11-1021 General and operations managers
15-1071
54.73
15-1021 Computer programmers
4,169
435
85
5.12
$ 33.01 $
18.04 $
24.60 $
34.96 $
42.57 $
56.65
15-1041 Computer support specialists
7,567
1,408
250
5.63
$ 24.25 $
15.31 $
18.81 $
25.27 $
30.89 $
37.43
41-3099 Sales representatives, services, all other
9,177
1,915
309
6.20
$ 24.22 $
13.08 $
17.10 $
28.83 $
35.47 $
50.42
Executive secretaries and administrative
43-6011
assistants
19,157
2,797
441
6.34
$ 21.19 $
14.42 $
17.07 $
22.01 $
26.03 $
31.41
43-4051 Customer service representatives
26,159
8,598
1,223
7.03
$ 15.77 $
10.46 $
12.83 $
16.81 $
19.88 $
24.57
3,508
572
78
7.33
$ 52.34 $
36.47 $
43.08 $
55.44 $
63.62 $
98.36
4,302
1,128
119
9.48
$ 35.49 $
22.52 $
28.25 $
36.28 $
43.77 $
52.29
11-3021
Computer and information systems
managers
15-1099 Computer specialists, all other
Source: EMSI Complete Employment - 2011.4 and Connecting Colorado Applicant Search
Regional Occupational Makeup (Cont.)
The last step is to provide the competitive wage intelligence. This is
done based on the number of applicants per job opening.
You can see that since
the number of
applicants per job
opening is 1.21 for Sales
representatives, you’d
yellow the 75th and 90th
percentiles
Regional Occupational Makeup (Cont.)
What you’ve just done here is provide business intelligence about
supply/demand in various occupations and show how this might
affect where the wage offer would fall.
In order to obtain the ‘available applicants’ you need to be in
partnership with your workforce center, because this data comes
directly from your statewide workforce development data base.
In Colorado this database is called Connecting Colorado.
This is one of our most popular data products. Businesses, economic
developers and site selectors have found the information of great
value.
Site Selection Reports
Constant elements of a site selection report
include:
1. Background
2. Competitive Labor Force
3. Regional Economy
4. Concentration Map and Table
5. Sector Employment Breakdown
6. Industry Growth Projections
7. Competitive Wage Analysis
8. Directions on using Competitive Wage
Analysis
9. Top Companies in Region
Optional elements include any other
inquiries. In the case of the sample, this
includes age bands, entrepreneurial activity
and a narrative about staffing cost savings
from using workforce centers
The audience for
site selection reports
includes:
1. Economic
developers
2. Site selectors,
real estate
developers or
others helping
business clients
make a location
decision
3. Business
prospects who
are working the
site selectors
Site Selection Report: Data
Elements and Sources
Element
Background
Competitiv e Labor Force
Regional Economy
Density Map & Concentration
by County
Sector Employment
Breakdown
Industry Growth Projections
Competitiv e Wage Analysis
Data Source
Who is preparing the report and for whom it is
intended
Colorado generally markets on the quality of its
labor force, so usually a bar chart showing
comparativ e educational attainment is prov ided
EMSI (Jobs, Earnings & Sales Legacy Report)
EMSI GIS
EMSI GIS
EMSI (Jobs by Industry Legacy Report)
EMSI (Jobs by Occupation Legacy Report) and
State Workforce Center Database
Directions on Using
Competitiv e Wage Analysis
Brief explanation of how to use the table
Top Companies in Region
Your state's LMI Div ision or EMSI Claritas Data from
the new Analyst Industry Report
EMSI Highlight: Concentration
Tables and Map
Site selectors and their business
clients love the GIS products.
We usually provide both the
map and the table showing
employment concentration by
county
Successful partnerships bring in new
jobs!
•DSEDP was lead
organization
•Arledge Partners
was Site Selector
•Expansion of San
Francisco based
company
•160 jobs
anticipated with 130
jobs to date
Gov. Hickenlooper Joins Area Elected Officials
and Trulia Executives at the Grand Opening of
the New Trulia Centennial Office
Gordon Composite/Polystrand
•Denver South Economic Development
Partnership (DSEDP) was lead
•Gordon Composites Inc. (GCI) moving HQ
from Montrose, CO
•DSEDP Partnership
• Xcel Energy
• Douglas County
• Arapahoe/ Douglas Works!
•Arapahoe/Douglas Works! is AT the table!
Groundbreaking, June 2011
Planned opening June 2012
Ribbon Cutting August 3, 2012
Now Open!
Questions
&
Answers
Dawn Gardner
Business Development Supervisor
6964 S. Lima Street
Centennial, CO 80124
303-636-1275
[email protected]
www.adworks.org
Patrick Holwell
Workforce Economist
6964 S. Lima Street
Centennial, CO 80124
303-636-1251
[email protected]
www.adworks.org