Data Dive: All Things Workforce Mike Carnathan Atlanta Regional - - PowerPoint PPT Presentation

Data Dive: All Things “Workforce”

Mike Carnathan Atlanta Regional Commission Neighborhood Nexus mcarnathan@atlantaregional.com

This Photo by Unknown Author is licensed under CC BY-ND

The Big Picture

Who Is Metro Atlanta’s Workforce

3

258,522, 9% 656,885, 22% 895,702, 30% 746,591, 25% 421,888, 14%

Workforce Composition By Education

Less than High School High School Diploma or GED Some College or Associate's Degree Bachelor's Degree Graduate Degree

Source: Burning Glass estimates based on ACS and LAUS

Who Is Metro Atlanta’s Workforce

4

169,787 , 6% 940,833 , 31% 291,172 , 10% 1,523,961 , 51% 53,837 , 2% Composition of the Workforce by Race/Ethnicity

Asian Black or African American Hispanic or Latino White Other

Source: Burning Glass estimates based on ACS and LAUS

Who Is Metro Atlanta’s Workforce

5

9.4% 6.0% 34.8% 5.3% 7.3% 15.1% 24.6% 27.5% 20.3% 19.7% 17.4% 38.1% 20.3% 28.2% 35.2% 31.1% 20.1% 11.8% 29.9% 23.7% 27.0% 11.1% 5.5% 16.3% 14.2%

0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%

Asian Black or African American Hispanic or Latino White Other

Workforce Composition by Race/Ethnicity

Less than High School High School Diploma or GED Some College or Associate's Degree Bachelor's Degree Graduate Degree

Source: Burning Glass estimates based on ACS and LAUS

It’s About Economic Mobility

It’s About Wages

$52,000 $54,000 $56,000 $58,000 $60,000 $62,000 $64,000 $66,000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017

Average Earnings Per Job ($2017)

US ATL

Source: Bureau of Economic Analysis; (CPI from Bureau of Labor Statistics)

$40,000 $45,000 $50,000 $55,000 $60,000 $65,000 $70,000

Earnings per Job – Metro Atlanta ($2016)

It’s About Helping Workers Move Ahead

Source: Bureau of Economic Analysis; (CPI from Bureau of Labor Statistics)

2019 Regional Economic Snapshot

Metro Atlanta’s GDP Up Nearly 24 Percent Since 2010

(In millions of Chained Dollars $2009)

Metro 2010 2011 2012 2013 2014 2015 2016 2017 % Change 2010-2017 % Change 2016-2017 New York 1,321,890 1,325,612 1,364,249 1,367,355 1,391,584 1,419,450 1,425,635 1,444,484 9.3% 1.3% Los Angeles 754,535 760,055 781,151 796,341 826,980 869,246 880,453 904,899 19.9% 2.8% Chicago 522,484 529,860 545,392 543,675 552,838 566,619 574,603 583,137 11.6% 1.5% Dallas 359,151 372,205 391,231 412,264 431,147 454,716 461,752 479,678 33.6% 3.9% Washington 426,282 432,803 435,144 431,875 434,035 442,788 450,726 460,026 7.9% 2.1% Houston 372,614 385,027 408,515 425,042 436,083 452,353 436,221 436,369 17.1% 0.0% San Francisco 321,982 321,282 337,674 350,305 368,129 389,201 411,340 425,358 32.1% 3.4% Philadelphia 344,835 346,289 352,056 363,869 366,776 375,649 381,747 387,217 12.3% 1.4% Boston 325,699 332,700 340,681 342,477 349,951 365,302 369,243 379,499 16.5% 2.8% Atlanta 269,939 274,623 278,536 288,394 299,830 311,373 324,971 334,488 23.9% 2.9% Seattle 240,771 245,216 256,930 264,336 273,733 286,317 297,254 312,587 29.8% 5.2% Miami 247,557 247,940 254,161 251,020 267,698 281,369 289,602 296,486 19.8% 2.4% San Jose 161,534 172,532 178,727 188,543 202,567 224,908 238,384 256,419 58.7% 7.6% Detroit 196,263 203,896 208,204 209,372 213,422 218,528 222,087 228,069 16.2% 2.7% Minneapolis 195,811 201,599 202,894 206,173 213,028 216,781 221,284 226,152 15.5% 2.2% Phoenix 178,640 182,412 187,477 188,075 193,215 199,361 204,015 210,968 18.1% 3.4% San Diego 173,447 179,174 181,171 186,674 189,042 190,899 197,641 201,986 16.5% 2.2% Denver 151,224 153,031 157,916 159,968 169,525 177,321 179,516 185,942 23.0% 3.6% Baltimore 150,990 154,141 155,582 156,912 158,797 160,112 164,254 165,903 9.9% 1.0% Portland 141,374 148,621 142,586 138,916 141,344 146,689 151,966 156,553 10.7% 3.0%

Source: Bureau of Economic Analysis

Metro Atlanta Outperforming Nation Last 6 Years

• 8.0
• 6.0
• 4.0
• 2.0

0.0 2.0 4.0 6.0 Jan-00 May-00 Sep-00 Jan-01 May-01 Sep-01 Jan-02 May-02 Sep-02 Jan-03 May-03 Sep-03 Jan-04 May-04 Sep-04 Jan-05 May-05 Sep-05 Jan-06 May-06 Sep-06 Jan-07 May-07 Sep-07 Jan-08 May-08 Sep-08 Jan-09 May-09 Sep-09 Jan-10 May-10 Sep-10 Jan-11 May-11 Sep-11 Jan-12 May-12 Sep-12 Jan-13 May-13 Sep-13 Jan-14 May-14 Sep-14 Jan-15 May-15 Sep-15 Jan-16 May-16 Sep-16 Jan-17 May-17 Sep-17 Jan-18 May-18 Sep-18

Year-Over-Year Percent Change in Total Nonfarm Employment

Atlanta US

Source: Bureau of Labor Statistics, State and Area Employment, Earnings, and Hours

Metro Atlanta #6 in job growth, year-over-year

4.3% 3.7% 3.6% 3.0% 2.7% 2.4% 2.4% 2.1% 2.0% 2.0% 1.7% 1.7% 0.6% 0.0% 0.5% 1.0% 1.5% 2.0% 2.5% 3.0% 3.5% 4.0% 4.5% 5.0% Houston Seattle Phoenix Dallas Charlotte Atlanta Denver San Francisco Boston Washington DC Minneapolis U.S. Chicago

Year-Over-Year Percent Change in Nonfarm Employment September 2017 – September 2018

Source: Bureau of Labor Statistics, State and Area Employment, Earnings, and Hours

Growth in Higher-Paying Sectors Slow, While Lower-Paying Sectors Soar

2.4% 0.0% 9.6% 1.4% 3.0%

• 0.5%
• 1.3%

1.5% 4.4% 3.8%

• 1.0%

1.0% 1.7% 9.1% 4.2% 2.3% 1.2%

• 0.9%

1.4% 2.7% 2.0% 1.9% 1.6% 0.4%

• 2.0%
• 1.0%

0.0% 1.0% 2.0% 3.0% 4.0% 5.0% 6.0% 7.0% 8.0% 9.0% 10.0% 11.0%

Total Nonfarm Mining & Logging Construction Manufacturing Trade, Transportation, & Utilities Information Financial Activities Professional & Business Services Education & Health Services Leisure & Hospitality Other Services Government

Year-Over-Year Percent Change in Employment, By Super Sector September 2017 - September 2018

Atlanta U.S.

Source: Bureau of Labor Statistics, State and Area Employment, Earnings, and Hours

A Look at Sector-by-Sector Employment Growth

(not seasonally adjusted)

• 30.0
• 25.0
• 20.0
• 15.0
• 10.0
• 5.0

0.0 5.0 10.0 15.0

Jan-07 May-07 Sep-07 Jan-08 May-08 Sep-08 Jan-09 May-09 Sep-09 Jan-10 May-10 Sep-10 Jan-11 May-11 Sep-11 Jan-12 May-12 Sep-12 Jan-13 May-13 Sep-13 Jan-14 May-14 Sep-14 Jan-15 May-15 Sep-15 Jan-16 May-16 Sep-16 Jan-17 May-17 Sep-17 Jan-18 May-18 Sep-18

Construction

• 20.0
• 15.0
• 10.0
• 5.0

0.0 5.0 10.0

Jan-07 May-07 Sep-07 Jan-08 May-08 Sep-08 Jan-09 May-09 Sep-09 Jan-10 May-10 Sep-10 Jan-11 May-11 Sep-11 Jan-12 May-12 Sep-12 Jan-13 May-13 Sep-13 Jan-14 May-14 Sep-14 Jan-15 May-15 Sep-15 Jan-16 May-16 Sep-16 Jan-17 May-17 Sep-17 Jan-18 May-18 Sep-18

Manufacturing

Source: Bureau of Labor Statistics, State and Area Employment, Earnings, and Hours

• 10.0
• 8.0
• 6.0
• 4.0
• 2.0

0.0 2.0 4.0 6.0

Jan-07 May-07 Sep-07 Jan-08 May-08 Sep-08 Jan-09 May-09 Sep-09 Jan-10 May-10 Sep-10 Jan-11 May-11 Sep-11 Jan-12 May-12 Sep-12 Jan-13 May-13 Sep-13 Jan-14 May-14 Sep-14 Jan-15 May-15 Sep-15 Jan-16 May-16 Sep-16 Jan-17 May-17 Sep-17 Jan-18 May-18 Sep-18

Wholesale Trade

• 10.0
• 8.0
• 6.0
• 4.0
• 2.0

0.0 2.0 4.0 6.0

Jan-07 May-07 Sep-07 Jan-08 May-08 Sep-08 Jan-09 May-09 Sep-09 Jan-10 May-10 Sep-10 Jan-11 May-11 Sep-11 Jan-12 May-12 Sep-12 Jan-13 May-13 Sep-13 Jan-14 May-14 Sep-14 Jan-15 May-15 Sep-15 Jan-16 May-16 Sep-16 Jan-17 May-17 Sep-17 Jan-18 May-18 Sep-18

Retail

A Look at Sector-by-Sector Employment Growth

(not seasonally adjusted)

Source: Bureau of Labor Statistics, State and Area Employment, Earnings, and Hours

• 10.0
• 8.0
• 6.0
• 4.0
• 2.0

0.0 2.0 4.0 6.0 8.0 10.0

Jan-07 May-07 Sep-07 Jan-08 May-08 Sep-08 Jan-09 May-09 Sep-09 Jan-10 May-10 Sep-10 Jan-11 May-11 Sep-11 Jan-12 May-12 Sep-12 Jan-13 May-13 Sep-13 Jan-14 May-14 Sep-14 Jan-15 May-15 Sep-15 Jan-16 May-16 Sep-16 Jan-17 May-17 Sep-17 Jan-18 May-18 Sep-18

Information

• 8.0
• 6.0
• 4.0
• 2.0

0.0 2.0 4.0 6.0

Jan-07 May-07 Sep-07 Jan-08 May-08 Sep-08 Jan-09 May-09 Sep-09 Jan-10 May-10 Sep-10 Jan-11 May-11 Sep-11 Jan-12 May-12 Sep-12 Jan-13 May-13 Sep-13 Jan-14 May-14 Sep-14 Jan-15 May-15 Sep-15 Jan-16 May-16 Sep-16 Jan-17 May-17 Sep-17 Jan-18 May-18 Sep-18

Financial Services

A Look at Sector-by-Sector Employment Growth

(not seasonally adjusted)

Source: Bureau of Labor Statistics, State and Area Employment, Earnings, and Hours

• 12.0
• 10.0
• 8.0
• 6.0
• 4.0
• 2.0

0.0 2.0 4.0 6.0 8.0

Jan-07 May-07 Sep-07 Jan-08 May-08 Sep-08 Jan-09 May-09 Sep-09 Jan-10 May-10 Sep-10 Jan-11 May-11 Sep-11 Jan-12 May-12 Sep-12 Jan-13 May-13 Sep-13 Jan-14 May-14 Sep-14 Jan-15 May-15 Sep-15 Jan-16 May-16 Sep-16 Jan-17 May-17 Sep-17 Jan-18 May-18 Sep-18

Professional & Business Services

0.0 1.0 2.0 3.0 4.0 5.0 6.0

Jan-07 May-07 Sep-07 Jan-08 May-08 Sep-08 Jan-09 May-09 Sep-09 Jan-10 May-10 Sep-10 Jan-11 May-11 Sep-11 Jan-12 May-12 Sep-12 Jan-13 May-13 Sep-13 Jan-14 May-14 Sep-14 Jan-15 May-15 Sep-15 Jan-16 May-16 Sep-16 Jan-17 May-17 Sep-17 Jan-18 May-18 Sep-18

Education & Health Services

A Look at Sector-by-Sector Employment Growth

(not seasonally adjusted)

Source: Bureau of Labor Statistics, State and Area Employment, Earnings, and Hours

Source: Bureau of Labor Statistics, State and Area Employment, Earnings, and Hours

• 6.0
• 4.0
• 2.0

0.0 2.0 4.0 6.0 8.0

Jan-07 May-07 Sep-07 Jan-08 May-08 Sep-08 Jan-09 May-09 Sep-09 Jan-10 May-10 Sep-10 Jan-11 May-11 Sep-11 Jan-12 May-12 Sep-12 Jan-13 May-13 Sep-13 Jan-14 May-14 Sep-14 Jan-15 May-15 Sep-15 Jan-16 May-16 Sep-16 Jan-17 May-17 Sep-17 Jan-18 May-18 Sep-18

Leisure

A Look at Sector-by-Sector Employment Growth

(not seasonally adjusted)

Average Hourly Wage by Selected Occupation

Occupation Atlanta Area United States

Financial Managers $71.92 $69.00 General and Operations Managers $58.86 $59.36 Management Analysts $46.66 $44.92 Computer Systems Analysts $43.46 $44.59 Accountants and Auditors $37.20 $37.46 Registered Nurses $33.91 $35.36 Customer Service Representatives $17.46 $17.14 Construction Laborers $17.24 $18.70 Retail Salespersons $12.00 $13.20 Cashiers $9.82 $10.64 Cooks, Fast Food $9.63 $10.39 Waiters and Waitresses $9.57 $12.15

Source: Chmura Economics, JobsEQ

Overview: What Employers Are Asking For

Job Postings by Occupations

• Feb. 1, 2018- Jan 31, 2019

21

27,514 22,546 20,399 18,000 14,520 13,556 11,763 9,031 8,035 7,527 6,789 6,788 6,534 6,392 6,322 6,162 6,157 5,921 5,911 5,766 5,659 5,494 4,805 4,658 4,612 5,000 10,000 15,000 20,000 25,000 30,000 Software Developers, Applications Registered Nurses Sales Representatives, Wholesale and Manufacturing, Except Technical… Heavy and Tractor-Trailer Truck Drivers Managers, All Other Retail Salespersons Customer Service Representatives First-Line Supervisors of Retail Sales Workers Sales Managers Management Analysts Human Resources Specialists Computer Systems Engineers/Architects Computer User Support Specialists Secretaries and Administrative Assistants, Except Legal, Medical, and… General and Operations Managers Laborers and Freight, Stock, and Material Movers, Hand Medical and Health Services Managers Maintenance and Repair Workers, General Information Technology Project Managers Computer Systems Analysts Web Developers Marketing Managers Food Service Managers Combined Food Preparation and Serving Workers, Including Fast Food Bookkeeping, Accounting, and Auditing Clerks

The jobs are categorized into the following occupations

Who’s Hiring?

• Feb. 1, 2018- Jan 31, 2019

22

9,516 5,529 5,101 4,381 3,643 3,339 2,951 2,785 2,171 2,165 2,004 2,002 1,978 1,837 1,835 1,817 1,794 1,752 1,735 1,731 1,715 1,650 1,517 1,463 1,407 1,000 2,000 3,000 4,000 5,000 6,000 7,000 8,000 9,000 10,000 Wellstar Health System Piedmont Healthcare Emory Healthcare Marriott International Incorporated Dekalb Medical Group Children's Healthcare Of Atlanta The Home Depot Incorporated Savannah Technical College Northside Hospital Deloitte Anthem Blue Cross Georgia Institute of Technology Varsity Tutors IBM Suntrust Banks United Parcel Service Incorporated Macy's Coca-Cola Enterprises Inc. U.S. Bancorp Emory University Grady Health System Lowe's Companies, Inc Capgemini Cox Communications Accenture

The following employers are hiring for the jobs

What Education?

• Feb. 1, 2018- Jan 31, 2019

23

20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 Bachelor's degree High school or vocational training Master's degree Associate's degree Doctoral degree

The following levels of education and levels of experience are requested

9+ years of experience 6 to 8 years of experience 3 to 5 years of experience 0 to 2 years of experience

What Skills?

• Feb. 1, 2018- Jan 31, 2019

24

89,225 66,003 59,363 46,949 45,897 36,343 33,474 30,160 29,257 27,773 26,586 24,036 22,459 22,352 20,240 19,675 18,986 18,939 17,601 17,280 17,232 16,795 15,706 15,325 15,005 10,000 20,000 30,000 40,000 50,000 60,000 70,000 80,000 90,000 100,000 Customer Service Sales Scheduling Project Management Budgeting Customer Contact Repair SQL Patient Care Retail Industry Knowledge Staff Management Quality Assurance and Control Accounting Java Cleaning Teaching Lifting Ability Software Development Customer Billing Product Sales Business Development Oracle JavaScript Data Entry Business Process

The following skills are most requested

Overview: High Demand Occupations

Hard To Fill Jobs

26

10 20 30 40 50 60 5,000 10,000 15,000 20,000 25,000 30,000

Hard to Fill Jobs, Last 12 Months

Number of Job Postings Days to Fill

Metro Atlanta’s In-Demand Industries

In the 2016 Metro Atlanta Regional Workforce Plan, three high demand industries were identified for the region:

Healthcare Information Technology Transportation & Logistics

Healthcare Industry Overview

Source: JobsEQ, Q2 2018

Metro Atlanta’s In-Demand Industry Clusters

Source: JobsEQ, Q2 2018

Healthcare Industry Overview Metro Atlanta’s In-Demand Industry Clusters

$15B GDP

SOC Title Current 10-Year Demand Empl Regional Average Wage Labor Exits Occ Transfers Growth Total 29-1141 Registered Nurses 28,451 $71,800 8,937 6,780 5,367 21,084 31-1014 Nursing Assistants 8,636 $27,200 5,746 4,804 1,758 12,308 43-4171 Receptionists and Information Clerks 6,704 $30,200 4,624 4,922 1,665 11,211 31-9092 Medical Assistants 8,982 $34,400 4,523 6,271 3,020 13,814 39-9021 Personal Care Aides 4,665 $22,200 4,494 3,371 2,245 10,109 43-6013 Medical Secretaries 6,012 $34,900 3,627 3,493 1,623 8,742 31-1011 Home Health Aides 4,121 $24,400 3,134 2,620 2,435 8,189 31-9091 Dental Assistants 5,252 $39,000 2,974 3,324 1,319 7,616 43-9061 Office Clerks, General 3,934 $31,000 2,452 2,369 468 5,289 29-2061 Licensed Practical and Licensed Vocational Nurses 4,953 $43,700 1,894 1,894 1,061 4,849 Total 179,143 n/a 79,653 84,747 39,895 204,294

Source: JobsEQ, Q2 2018

Healthcare Industry Overview Metro Atlanta’s In-Demand Industry Clusters

Source: JobsEQ, Q2 2018

IT Industry Overview Metro Atlanta’s In-Demand Industry Clusters

Source: JobsEQ, Q2 2018

IT Industry Overview

Metro Atlanta’s In-Demand Industry Clusters

$9.8B GDP

SOC Title Current 10-Year Demand Empl Regional Average Wage Labor Exits Occ Transfers Growth Total 15-1132 Software Developers, Applications 10,693 $105,500 1,780 6,230 4,706 12,716 15-1151 Computer User Support Specialists 4,383 $55,000 970 2,475 1,039 4,484 15-1121 Computer Systems Analysts 4,619 $91,100 919 2,298 1,072 4,289 15-1133 Software Developers, Systems Software 4,459 $103,100 691 2,420 1,061 4,172 11-3021 Computer and Information Systems Managers 2,817 $144,100 562 1,717 677 2,956 15-1131 Computer Programmers 3,720 $88,200 636 1,683 20 2,339 41-3099 Sales Representatives, Services, All Other 1,480 $61,600 526 1,413 359 2,297 11-1021 General and Operations Managers 1,943 $124,200 453 1,294 471 2,218 43-4051 Customer Service Representatives 1,368 $36,700 746 1,097 203 2,046 13-1161 Market Research Analysts and Marketing Specialists 1,298 $66,800 406 1,038 473 1,917 Total 62,274 n/a 15,650 36,637 15,897 68,183

Source: JobsEQ, Q2 2018

IT Industry Overview Metro Atlanta’s In-Demand Industry Clusters

Metro Atlanta’s In-Demand Industry Clusters

Source: JobsEQ, Q2 2018

Transportation & Logistics Industry Overview

Source: JobsEQ, Q2 2018

Metro Atlanta’s In-Demand Industry Clusters

Transportation & Logistics Industry Overview $17B GDP

Source: JobsEQ, Q2 2018

SOC Title Current 10-Year Demand Empl Regional Average Wage Labor Exits Occ Transfers Growth Total 53-7062 Laborers and Freight, Stock, and Material Movers, Hand 21,797 $27,800 11,700 20,123 3,546 35,369 53-3032 Heavy and Tractor-Trailer Truck Drivers 19,255 $44,000 8,428 12,642 1,793 22,863 53-2031 Flight Attendants 10,182 $50,100 5,320 6,189 1,501 13,010 43-4181 Reservation and Transportation Ticket Agents and Travel Clerks 7,554 $39,400 3,360 4,689 563 8,612 53-3033 Light Truck or Delivery Services Drivers 6,737 $38,500 3,018 4,527 982 8,526 53-7051 Industrial Truck and Tractor Operators 5,366 $35,100 2,022 4,333 897 7,252 53-2011 Airline Pilots, Copilots, and Flight Engineers 6,677 $105,200 1,934 4,420 493 6,846 53-7064 Packers and Packagers, Hand 1,918 $24,700 1,485 1,791 575 3,850 43-4051 Customer Service Representatives 2,729 $36,700 1,442 2,120 215 3,777 53-3021 Bus Drivers, Transit and Intercity 2,623 $34,500 2,184 1,148 389 3,721 Total 126,376 n/a 57,153 87,998 15,696 160,847

Metro Atlanta’s In-Demand Industry Clusters

Transportation & Logistics Industry Overview

37

More Stuff!

MAX Website, ALL of it: http://metroatlantaexchange.org/ http://metroatlantaexchange.org/2019/01/22/max-alert-linkedin-releases-november-2018-workforce-report-on-hiring- trends-and-skills-gap-in-metro-atlanta-2/ ARC’s Website, Specifically: https://atlantaregional.org/plans-reports/worksource-metro-atlanta-plan/ https://atlantaregional.org/workforce-economy/economic-development/labor-market-information-research/ Our 33N Blog, Specifically: https://33n.atlantaregional.com/friday-factday/friday-factday-wage-changes-for-high-middle-and-low-wage-occupations https://33n.atlantaregional.com/friday-factday/friday-factday-employment-and-wage-growth-by-occupation