Occupational Demand/ Program Supply Analysis using Web Sources

(1)

Institutional Research Dept Washtenaw Community College MCCA Student Success Summit

September 19, 2013

Occupational Demand/ Program

Supply Analysis using Web Sources

(2)

I. Online Data Sources

II. Application of their use (first

step of the Dynamic Skills Audit)

(3)

(4)

I. Data Sources

1. Dept of Technology, Management, and Budget, State of Michigan (local demand)

2. Bureau of Labor Statistics, U.S. Dept of Labor

(to identify NAICS industry group w/most employed for a given occupation, to use for #3 below)

3. US Census Bureau, Quarterly Workforce Indicators (# new hires in an industry group)

4. Labor Insight, Burning Glass (local demand) 5. Michigan Community College Network (supply)

(5)

Caveat: there are

significant

measurement

issues with every

online source.

(6)

It is important to know

what these issues are so

that it does not lead to

misguided decisions

(7)

1. Government projections are based on

surveys and economic models

Complete employment data by

occupation is not available because it is

not collected (except in samples)

Payroll records cover everybody who

receives a paycheck but employers

report by industry, not occupation (UI

wage records). Big difference!

(8)

2. Job posting query tools are counts of

postings, not positions; only as good as

the software scanning the internet

Double or triple counting or worse is

inevitable

Since the content of job postings on

different job boards, or even within

the same job board, does not follow

standard rules, classification is not a

science

(9)

1. DTMB Data Explorer

http://www.milmi.org/

• Economic Forecast Region (local level)

-Long term Occupational Projections

(10)

(11)

(12)

(13)

(14)

2. BLS Occupational Employment Statistics

http://www.bls.gov/

• semiannual mail and phone survey of employers conducted by state workforce agencies

• covers all metropolitan and nonmetropolitan areas nationally, all industries, of varying sizes

• Use here: to identify the industry employing the largest number of individuals in a given occupation (Network Admin example)

(15)

(16)

(17)

(18)

3. US Census Bureau, Quarterly Workforce Indicators

http://ledextract.ces.census.gov/

• Data Extraction Tool

• Estimated Number of New Hires (# of individuals who started a new job) and other employment indicators by metropolitan region (using actual UI record data) • New Hires = number of individuals who were reported to be employed in a quarter who were not employed by that same employer in any of the previous 4

quarters

(19)

(20)

(21)

(22)

(23)

(24)

4. Labor Insight Burning Glass

http://laborinsight.burning-glass.com/us/

• Job postings searchable by many dimensions Occupation, education, location, time period, experience, among others

(25)

(26)

(27)

Another use of job postings data and

federal gov’t data (O’Net) is to identify

skills in demand by employers

• WCC has used BG for this purpose in

various Advanced Manufacturing,

Energy, and IT fields

• Will be discussed in next presentation

(28)

5. Michigan Community College Network

• number of awards by college and program

(29)

(30)

(31)

(32)

Link Programs to Occupations

Conduct Demand Supply Analysis

Example : Computer Network Admin

(33)

1. Use federal crosswalk to match Classification

of Instructional Programs (CIP) codes to BLS

Standard Occupational Classification (SOC)

codes

http://www.bls.gov/soc/soccrosswalks.htm

2. Matched CIP codes to WCC program codes

(WCC crosswalk)

(34)

CIP to SOC crosswalk information and download

(35)

(36)

Computer Network Admin and

Support

CIP codes 11.0901 and 11.1002

SOC codes 15-1142 and 15-1152

(37)

CIP Computer Systems Networking and Telecommunications Computer and Information Systems Security/Info Assurance SOC Network and Computer Systems Administrators

Network Systems and Data Communications Analysts

WCC Computer Networking Academy (C)

Computer Networking Operating Systems (C) Computer Networking (A)

Foundations of Computer Security (C) Network Security (C)

Computer Systems Security (A)

(38)

(39)

1. Demand

2. Supply

(40)

1. Demand in 9 SE MI counties

a. # Employed; Projected employed

b. Projected openings; # job postings

c. Annual wage

(41)

Computer Network Admin and Support

DEMAND: Gov't Projections

2008 Employed 2018 Projected Employed 10 Yr% Change

10,645

14,008

31.6%

(42)

DEMAND: Gov't Proj and

BG Job Postings QWI New Hires*

Projected Annual Openings,

2008-2018

2012 Job

Postings Last 4 quarters

521 1,023

(14,010) 493

* Total number of new hires in Computer Systems Design and Related Services (NAICS 541500) in local area was 14,010. This figure was multiplied by percent of Network Admin nationally = 493 estimate local Network Admin new hires.

(43)

Wage Estimates

2012 Estimated Mean Annual Wage 2012 Mean Annual Wage Per Postings

$72,210

$52,030

(44)

2. Supply

# Graduates, 8 SE MI community colleges

(45)

SUPPLY: # Grads

2011-12 Graduates

(46)

3. Analysis:

Compare Supply to Demand

(# grads compared to # openings)

(47)

DEMAND: Gov't

and BG Job Postings QWI

SUPPLY: Grads Projected Annual Openings, 2008-2018 2012 Job Postings New Hires 2011-12 Graduat es 521 1,023 493 193

(48)

It appears there is unmet demand

However, most of the postings require

experience and don’t ask for associate degrees

or certificates—what are those?

Government projections do not specify

requirements of positions other than new and

replacement

Perhaps most importantly, the employers are

not going to community colleges for workers

(49)

Manufacturers Need New Workforce

Strategies

Top sources for new employees

49 52% 40% 40% 32% 26% 18% 15% 14% 8% 6% Word of mouth Staffing agencies Online Job Boards Newspaper Ads Company recruiting function External search firms Company Websites Tech schools Community colleges Other

(50)

Colleges need to work with employers to

establish internships for students to gain

experience while in school, so that they are

more competitive for more jobs when they

(51)