Measuring Middle-Skills Gaps within the Finger Lakes Regional Economy

MEASURING MIDDLE-SKILLS OCCUPATIONAL GAPS WITHIN THE FINGER LAKES REGIONAL ECONOMY VERSION 1.0

Workforce forward.

INTRODUCTION & PURPOSE

The past years have brought increased emphasis on the importance of a community college’s role as a key partner in a region’s overall economic and workforce development strategy. The increased awareness, both locally and nationally, of a growing skills gap within industry for occupations requiring less than a bachelor’s degree, but more than a high school diploma – the so-called middle-skills gap – has become a dominant theme in conversations within the business community, among public leaders and within the workforce development community of practice. In response to these changes and to better support Monroe Community College’s role as a provider of workforce and career oriented programs to the Greater Rochester area, MCC embarked on an ambitious data project to quantify and estimate the likely middle-skills gaps across five key workforce clusters within the Finger Lakes regional economy: Advanced Manufacturing, Skilled Trades, Information and Computer Technology, Hospitality and Tourism, and Health Care. In conducting this project, a variety of labor market and workforce intelligence sources were used including the incorporation of the latest in workforce oriented big data services integrating both traditional and real time labor market data. The primary goals of this project were to quantify skill gaps in business and industry and provide direction for the development of new programs and delivery methods in order to increase the number of graduates in occupations where more qualified workers are needed. A highlight of this work is the occupational grouping gap analysis dashboard. It is used to identify and measure educational attainment through certificate and associate degree completions against estimated annual openings for 23 middle-skills occupational groups. This is an attempt to measure the supply of workers being created through the region’s educational system against the estimated labor demand for occupations aligned to their respective programs. For a select number of occupational groups, we have been able to include a program-based economic impact

2

analysis. This provides an estimation of the marginal value of each student completion relative to the Finger Lakes regional economy. In the future, MCC will extend these impact calculations to all of the occupational groups included in this book. Applying this labor supply versus labor demand measurement model to the Advanced Manufacturing cluster has already led to impactful results with MCC being able to estimate the significant shortage in the availability of machinists in the region. The relevant occupational gap analysis dashboard guided MCC in responding to the shortage by launching a new accelerated version of its Precision Tooling Certificate. With this new 22-week intensive program format, MCC is poised to increase the number of machinists being produced annually for the region by 37.5%. Ultimately, this publication is intended to function as a reference document that provides a deeper and more data-driven understanding of local workforce dynamics, particularly as they relate to estimated labor supply and demand analysis. It is our hope that this information will complement current and future discussions about regional workforce policy and demonstrate how vital it is to the region in making additional investments in middle-skilled career-oriented education and training programs. This publication is a working framework and as a result we anticipate the development of updated versions in the future. Together, using a better workforce measurement model to guide and develop investments in education and training, and create more compelling grant narratives, we can move our community’s workforce forward and ensure our businesses thrive into the future.

How to use this report.

Sincerely, Todd M. Oldham, MBA

Vice President, Economic Development and Innovative Workforce Services toldham@monroecc.edu www.linkedin.com/in/toldham

KEY REGIONAL WORKFORCE CLUSTERS

3

WORKFORCE CLUSTERS

TABLE OF CONTENTS

4

5 7

121 123 129 135 141 147 149 155 161 169 175 181 181 182 183 185 185 186

ADVANCED MANUFACTURING

HOSPITALITY & TOURISM

Tooling & Machining

Travel & Tourism Golf Management Hotel Management

Applied Integrated Technologies/Mechatronics

15 23 31 39 47 49 63 71 79 85

Optical Systems Technology

Mechanical Engineering Technology Electrical Engineering Technologies

Event Planning

HEALTH CARE

Clinical & Medical Lab Technology Dental Hygiene & Assisting Health Information Technology

SKILLED TRADES

Heating, Ventilation & Air Conditioning (HVAC)

Automotive Technologies Construction Technologies

Radiologic Technology

Welding Millwright

Nursing

ADDITIONAL INFORMATION

Economic Development & Innovative Workforce Services at MCC

91 93

Acknowledgements

INFORMATION & COMPUTER TECHNOLOGY

Computer Information Systems Computer Systems Technologies

Data Sources

101 107 113

Computer Science

APPENDIX

Information Technology

Income Benchmarks, Monroe County, NY 2010-13 Self-Sufficiency Standard for Monroe County, NY 2010

© 2015 Monroe Community College (MCC), Economic Development & Innovative Workforce Services. All rights reserved.

ADVANCED MANUFACTURING

The Rochester area is regarded for its technologically advanced and diverse collection of machining and manufacturing corporations. Xerox, Kodak, Bausch & Lomb, Johnson & Johnson, Harris and ITT are some examples. Advanced manufacturing companies specialize in high-volume parts production, short-run assemblies, complicated engineering designs, and/or automated manufacturing process jobs. The Advanced Manufacturing occupational groupings include: Tooling & Machining, Applied Integrated Technologies/Mechatronics, Mechanical Engineering Technologies, Electrical Engineering Technologies, and Optical Systems Technology. Advanced Manufacturing centers upon improving the performance of industry through the innovative application of technologies, processes and methods to product design and production.

OCCUPATIONAL GROUPINGS FOR ADVANCED MANUFACTURING

6

ADVANCED MANUFACTURING

ADVANCED MANUFACTURING

TOOLING & MACHINING

The precision machining industry in the Rochester area is one of the most technologically advanced fields. Machinists with the proper skill sets are in high demand as a result of their training in quality control and metrology. Computer numerically controlled (“CNC”) machines are employed in most modern-day machine shops and mass production facilities to increase accuracy and efficiency when forming metal parts. CNC machining, laser and water jet technology, electric discharge machining (“wire EDM”), computer aided design (“CAD”), computer aided manufacturing (“CAM”) design, and manufacturing programs are all examples of this cutting edge technology. Highly-specialized, skilled machinists are helping to meet the rising local and global demand of innovative products and technologies.

TOOLING & MACHINING OCCUPATIONAL GROUP DEFINITION STANDARD OCCUPATIONAL CLASSIFICATIONS (SOC), OCCUPATIONS, WAGES & ESTIMATED DEMAND 8

WAGES

SOC Occupations

10th 50th 90th Est.Annual Percentile Percentile Percentile Demand

49-9043.00 51-4011.00 51-4012.00 51-4021.00 51-4022.00 51-4023.00 51-4031.00 51-4032.00 51-4033.00 51-4034.00 51-4041.00 51-4061.00 51-4062.00 51-4071.00 51-4072.00 51-4081.00 51-4111.00 51-4192.00 51-4193.00 51-4194.00 51-9071.07

Maintenance Workers, Machinery

$11.75 $20.63

$28.66

12 33

Computer-Controlled Machine Tool Operators, Metal and Plastic Computer Numerically Controlled Machine Tool Programmers, Metal and Plastic Extruding and Drawing Machine Setters, Operators , and Tenders, Metal and Plastic Forging Machine Setters, Operators, And Tenders, Metal and Plastic Rolling Machine Setters, Operators, and Tenders, Metal and Plastic Cutting, Punching, and Press Machine Setters, Operators, and Tenders, Metal and Plastic Drilling and Boring Machine Tool Setters, Operators,and Tenders, Metal and Plastic Grinding, Lapping, Polishing, and Buffing Machine Tool Setters, Operators, and Tenders, Metal and Plastic Lathe and Turning Machine Tool Setters, Operators, and Tenders, Metal and Plastic

11.36 14.06 10.33 11.46 11.12 10.95 10.33 13.02 10.31 18.79 9.02 7.98 7.37 8.65 6.13 8.34 9.60 12.10 11.33 11.33

16.03 21.07 15.22 14.16 16.83 15.43 16.26 16.49 19.68 18.30 24.22 12.23 13.65 17.29 23.82 13.28 12.18 18.06 16.55 9.02

28.53 28.84 22.71 26.88 21.65 21.94 27.08 22.10 23.74 25.59 28.98 15.41 11.85 22.89 24.27 29.50 17.26 17.78 23.36 21.56

9 8 5 2 9 2

11 17 71

Machinists

Model Makers, Metal and Plastic Patternmakers, Metal and Plastic Foundry Mold and Coremakers

0 0 0

Molding, Coremaking, and Casting Machine Setters, Operators, and Tenders, Metal and Plastic Multiple Machine Tool Setters, Operators, and Tenders, Metal and Plastic

23 11

Tool and Die Makers

8 4 4 2 3

Layout Workers, Metal and Plastic

Plating and Coating Machine Setters, Operators, and Tenders, Metal and Plastic

Tool Grinders, Filers and Sharpeners

Precious Metal Workers

TOTALS $11.17 $17.42 $25.16

231

Wages and demand based on the 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. © 2015 MCC

TOOLING & MACHINING OCCUPATIONAL GROUP HOURLY WAGES

9

$ 30

$ 25.16

$ 25

$ 25 SELF-SUFFICIENCY STANDARD FOR 2 ADULTS + 1 PRESCHOOLER & 1 SCHOOL AGE CHILD (MONROE COUNTY)

$ 20

$ 18 SELF-SUFFICIENCY STANDARD FOR 1 ADULT + 1 PRESCHOOLER (MONROE COUNTY)

$ 17.42

$ 15

Hourly Wage

$ 10

$ 11.17

$ 5

0

High Wage (90th Percentile)

Entry Level Wage (10th Percentile)

Median Wage (50th Percentile)

Wage curve based on the 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. Complete self-sufficiency data is located in the Appendix: Self-Sufficiency Standard for Monroe County, NY 2010.

© 2015 MCC

TOOLING & MACHINING GAP ANALYSIS: REGIONAL PROGRAM COMPLETIONS VS. ESTIMATED ANNUAL OPENINGS

10

This measurement aims to provide a high-level gap analysis, comparing the total estimated number of learners completing a relevant middle-skill training and education program against estimated industry demands for middle-skill workers by occupational grouping. For more detailed completion data, click here.

Middle-Skill Education Provider

2012 Estimated Annual Estimated Completions Job Openings Gap (∆)

Monroe Community College Monroe 2 Orleans BOCES Rochester Institute of Technology Finger Lakes Community College

36 10 11 15

231 -159 **

TOTAL

72 *

* The 72 annual regional completions represent a supply of 31.2 % new tooling and machining trained workers produced locally against an estimated annual demand of 231 openings.

** This suggests that in this occupational group, about 68.8 % of tooling and machining-related jobs may go unfilled each year in the region due to an insufficient number of graduates produced locally .

2013 TOTAL WORKFORCE 9,181 Tooling and Machining Workers

10-year aging out projection: 23.2 % are approaching retirement age

Source: IPEDS and noncredit self-reported data from applicable education providers. © 2015 MCC

TOOLING & MACHINING PER WORKER METRICS FOR MCC’S PRECISION TOOLING & MACHINING RELATED PROGRAMS

11

Field

Value

Number of Completers in Workforce in 2014*

267

Marginal Annual Impact per Completer (Compared to Full-Time High School Educated Worker)

$75,500

Estimated Lifetime Earnings of Completers

$694,300

* Based on 10-years of MCC program completion data. Please see the source document indicated below for details.

2014 ECONOMIC IMPACT OF MCC’S PRECISION TOOLING & MACHINING RELATED PROGRAMS

Impact Type Initial Effect Direct Effect Indirect Effect Induced Effect

Value ($) $13,424,000 $1,752,000

$344,000

$4,635,000

Total Economic Impact in 2014

$20,156,000

Source: Monroe Community College Program Based Economic Impact Analysis.

© 2015 MCC

12

TOOLING & MACHINING REAL TIME LABOR MARKET DATA TOP SKILL CLUSTERS: BASED ON ONLINE JOB POSTINGS 2011-14

13

431 1

Construction: General Production: General Common Skills: Communication & Coordination Software & Programming Skills Common Skills: Environment Skills Common Skills: Problem Solving Repair: General Common Skills: Project & Process Flow Skills Common Skills: Language Digital Media/Design: Tech Development/Design Production: Welding Supply Chain & Logistics: General

392 1

326 1

286 1

270 1

254 1

201 1

154 1

75 1 75 1

73 1

56 1 54 1

Engineering: Drafting Manufacturing: General Customer Service: Basic Assistance

49 1

48 1

0 50 100 150 200 250 300 350 400 450 Number of Postings (10 County Region)

Based on 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. Data Source: Burning Glass Labor/Insight © 2015 MCC

TOOLING & MACHINING REAL TIME LABOR MARKET DATA TOP SKILLS: BASED ON ONLINE JOB POSTINGS 2011-14

14

783 1

Machining Computer Numerical Control (CNC)

755 1

Inspection Blueprints Machine Operation Lathes

571 1

450 1

449 1

398 1

Mathematics Micrometers Grinders Repair Machine Tools Machinery Calipers Computerized Numerical Control Lathes

334 1

246 1

229 1

222 1

189 1

163 1

152 1

132 1

126 1

Dimensions 0 100 200 300 400 500 600 700 800 Number of Postings (10 County Region)

Based on 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. Data Source: Burning Glass Labor/Insight © 2015 MCC

ADVANCED MANUFACTURING

APPLIED INTEGRATED TECHNOLOGIES/MECHATRONICS

From automation to construction to optics, the Rochester region is home to many businesses that require engineering professionals. Applied Integrated Technology is a unique, interdisciplinary program in high technology fields applying the principles of science, engineering, and mathematics to solve technical problems. Mechatronics stems from blending mechanical and electronics in a relatively new approach to product design and development, merging the principles of electrical, mechanical, computer and industrial engineering. Mechatronic systems are often referred to as “smart” devices because of the incorporation of sensors, actuators and computer control systems. Mechatronics has become synonymous with products that exhibit fast, precise performance. A mechatronics engineer unites the principles of mechanics, electronics, and computing to generate a simpler, more economical and reliable system.

APPLIED INTEGRATED TECHNOLOGIES/MECHATRONICS OCCUPATIONAL GROUP DEFINITION STANDARD OCCUPATIONAL CLASSIFICATIONS (SOC), OCCUPATIONS, WAGES & ESTIMATED DEMAND 16

WAGES

SOC Occupations

10th 50th 90th Est.Annual Percentile Percentile Percentile Demand

17-3024.00 Electro-Mechanical Technicians

$15.77 $19.75 15.42 20.86 13.71 24.32 15.81 21.70 11.75 20.63 12.91 15.59 14.06 21.07 10.40 14.99 10.31 18.30 18.79 24.22 7.98 12.23

$28.57

1

47-2073.00 Operating Engineers and Other Construction Equipment Operators 49-2094.00 Electrical and Electronics Repairers, Commercial and Industrial Equipment

33.61 40.46 31.20 28.66 23.20 28.84 23.22 25.59 28.98 15.41 20.02

43

8

49-9041.00 Industrial Machinery Mechanics 49-9043.00 Maintenance Workers, Machinery 51-2023.00 Electromechanical Equipment Assemblers

42 12

3 9 5 0 0 0

51-4012.00 Computer Numerically Controlled Machine Tool Programmers, Metal and Plastic 51-4035.00 Milling and Planing Machine Setters, Operators, and Tenders, Metal and Plastic

51-4041.00 Machinists

71

51-4061.00 Model Makers, Metal and Plastic 51-4062.00 Patternmakers, Metal and Plastic

51-7032.00 Patternmakers, Wood

18 19.20

TOTALS $12.97 $19.91 $29.14

194

Wages and demand based on the 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. © 2015 MCC

APPLIED INTEGRATED TECHNOLOGIES/MECHATRONICS OCCUPATIONAL GROUP HOURLY WAGES

17

$ 29.14

$ 30

$ 25

$ 25 SELF-SUFFICIENCY STANDARD FOR 2 ADULTS + 1 PRESCHOOLER & 1 SCHOOL AGE CHILD (MONROE COUNTY)

$ 20

$ 19.91

$ 18 SELF-SUFFICIENCY STANDARD FOR 1 ADULT + 1 PRESCHOOLER (MONROE COUNTY)

$ 15

$ 12.97

Hourly Wage

$ 10

$ 5

0

Entry Level Wage (10th Percentile)

Median Wage (50th Percentile)

High Wage (90th Percentile)

Wage curve based on the 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. Complete self-sufficiency data is located in the Appendix: Self-Sufficiency Standard for Monroe County, NY 2010.

© 2015 MCC

APPLIED INTEGRATED TECHNOLOGIES/MECHATRONICS GAP ANALYSIS: REGIONAL PROGRAM COMPLETIONS VS. ESTIMATED ANNUAL OPENINGS

18

This measurement aims to provide a high-level gap analysis, comparing the total estimated number of learners completing a relevant middle-skill training and education program against estimated industry demands for middle-skill workers by occupational grouping. For more detailed completion data, click here.

Middle-Skill Education Provider

2012 Estimated Annual Estimated Completions Job Openings Gap (∆)

Monroe Community College Rochester Institute of Technology

0

194 -166 **

18 10

Monroe 2 Orleans BOCES

TOTAL

28 *

Note: To address the skills gap in the AIT occupational group, Monroe Community College is developing a program in mechatronics which is scheduled to launch in Fall 2016. Completions from this new program will be reflected in future analyses.

* The 28 annual regional completions represent a supply of 14.4 % new AIT trained workers produced locally against an estimated annual demand of 194 openings.

10-year aging out projection: 22.4 % are approaching retirement age

2013 TOTAL WORKFORCE 8,159 AIT Workers

** This suggests that in this occupational group, about 85.6 % of AIT-related jobs may go unfilled each year in the region due to an insufficient number of graduates produced locally.

Source: IPEDS and noncredit self-reported data from applicable education providers. © 2015 MCC

APPLIED INTEGRATED TECHNOLOGIES/MECHATRONICS ESTIMATED PER WORKER METRICS FOR MCC’S APPLIED INTEGRATED TECHNOLOGIES/MECHATRONICS PROGRAM 19

The economic impact data below is an estimate based on a conservative projection of 20 MCC mechatronics program completers. The MCC mechatronics program is scheduled to launch in Fall 2016.

Field

Value

Estimated Number of Completers in Workforce in 2014*

20

Marginal Annual Impact per Completer (Compared to Full-Time High School Educated Worker)

$45,600

Estimated Lifetime Earnings of Completers

$727,600

* Based on 10-years of MCC program completion data. Please see the source document indicated below for details.

ESTIMATED ECONOMIC IMPACT OF MCC’S APPLIED INTEGRATED TECHNOLOGIES/MECHATRONICS PROGRAM

Impact Type Initial Effect Direct Effect Indirect Effect Induced Effect

Value ($)

$602,000 $78,000 $15,000 $237,000

Total Economic Impact

$933,000

Source: Monroe Community College Program Based Economic Impact Analysis. © 2015 MCC

20

APPLIED INTEGRATED TECHNOLOGIES/MECHATRONICS REAL TIME LABOR MARKET DATA TOP SKILL CLUSTERS: BASED ON ONLINE JOB POSTINGS 2011-14

21

404 1

Common Skills: Business Environment Skills Common Skills: Communication & Coordination Software & Programming Skills Common Skills: Problem Solving Construction: General Repair: General Production: General Common Skills: Project & Process Flow Skills Engineering: Mechanical Repair: HVAC Supply Chain & Logistics: General Construction: Plumbing Advanced Manufacturing: Process Improvement Manufacturing: General Customer Service: Basic Assistance

374 1

312 1

309 1

265 1

252 1

229 1

188 1

147 1

129 1

112 1

104 1

91 1

69 1

66 1

0 50 100 150 200 250 300 350 400 450 Number of Postings (10 County Region)

Based on 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. Data Source: Burning Glass Labor/Insight © 2015 MCC

APPLIED INTEGRATED TECHNOLOGIES/MECHATRONICS REAL TIME LABOR MARKET DATA TOP SKILLS: BASED ON ONLINE JOB POSTINGS 2011-14

22

Machining Computer Numerical Control (CNC) Inspection Repair Blueprints Lathes Mathematics Mechanical Assembly Grinders Soldering HVAC Machinery Machine Tools Manufacturing Processes Micrometers

371 1

305 1

269 1

264 1

224 1

222 1

150 1

99 1

99 1

94 1

89 1

87 1

84 1

79 1

78 1

0 50 100 150 200 250 300 350 400 Number of Postings (10 County Region)

Based on 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. Data Source: Burning Glass Labor/Insight © 2015 MCC

ADVANCED MANUFACTURING

OPTICAL SYSTEMS TECHNOLOGY

Rochester’s nickname is “The World’s Image Center” because of its roots in optics, xerography and photography, and because Rochester is still an educational and commercial leader in photonics today. Bausch & Lomb, Corning, Kodak and Xerox make this area a research and manufacturing hub, rich with knowledge, experience and innovation in optics manufacturing, metrology and imaging. Optical Systems Technology offers a unique range of work choices in high technology fields. Career pathways and advancement in optics diverge into three main areas: production & development, fabrication and metrology. Optics offers opportunities to work in research, development, design, production, quality control, and testing and evaluation of optical components and systems, along with sales and service. Technicians produce, test, and handle optical components that are used in lasers and sophisticated electro-optical systems for defense, homeland security, aerospace, biomedical equipment, digital displays, telecom and nanotechnology.

OPTICAL SYSTEMS TECHNOLOGY OCCUPATIONAL GROUP DEFINITION STANDARD OCCUPATIONAL CLASSIFICATIONS (SOC), OCCUPATIONS, WAGES & ESTIMATED DEMAND 24

WAGES

SOC Occupations

10th 50th 90th Est.Annual Percentile Percentile Percentile Demand

17-3012.02 Electrical Drafters

$18.21 $28.18 12.49 21.10 15.77 19.75 15.28 23.63 17.74 25.92 13.91 21.36 13.71 24.23 12.91 15.59 10.33 16.49 10.00 14.19

$43.15

4

17-3023.01 Electronics Engineering Technicians 17-3024.00 Electro-Mechanical Technicians 17-3026.00 Industrial Engineering Technicians

30.49 28.57 46.03 38.28 32.03 40.46 23.20 22.10 19.13

31

1

23

17-3029.00 Engineering Technicians, Except Drafters, All Other

8

49-2022.00 Telecommunications Equipment Installers and Repairers, Except Line Installers 49-2094.00 Electrical and Electronics Repairers, Commercial and Industrial Equipment

22

8 3

51-2023.00 Electromechanical Equipment Assemblers

51-4033.00 Grinding, Lapping, Polishing, and Buffing Machine Tool Setters, Operators, and Tenders, Metal and Plastic

11

51-9022.00 Grinding and Polishing Workers, Hand

4

TOTALS $13.68 $21.45 $33.65

115

Wages and demand based on the 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. © 2015 MCC

OPTICAL SYSTEMS TECHNOLOGY OCCUPATIONAL GROUP HOURLY WAGES

25

$ 33.65

$ 30

$ 25

$ 25 SELF-SUFFICIENCY STANDARD FOR 2 ADULTS + 1 PRESCHOOLER & 1 SCHOOL AGE CHILD (MONROE COUNTY)

$ 21.45

$ 20

$ 18 SELF-SUFFICIENCY STANDARD FOR 1 ADULT + 1 PRESCHOOLER (MONROE COUNTY)

$ 15

Hourly Wage

$ 13.68

$ 10

$ 5

0

High Wage (90th Percentile)

Entry Level Wage (10th Percentile)

Median Wage (50th Percentile)

Wage curve based on the 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. Complete self-sufficiency data is located in the Appendix: Self-Sufficiency Standard for Monroe County, NY 2010.

© 2015 MCC

OPTICAL SYSTEMS TECHNOLOGY GAP ANALYSIS: REGIONAL PROGRAM COMPLETIONS VS. ESTIMATED ANNUAL OPENINGS

26

This measurement aims to provide a high-level gap analysis, comparing the total estimated number of learners completing a relevant middle- skill training and education program against estimated industry demands for middle-skill workers by occupational grouping. For more detailed completion data, click here.

Middle-Skill Education Provider

2012 Estimated Annual Estimated Completions Job Openings Gap (∆)

Monroe Community College Finger Lakes Community College Rochester Institute of Technology Genesee Community College

4 9 9 6

115 -87 **

TOTAL

28 *

* The 28 annual regional completions represent a supply of 24.3 % new OST trained workers produced locally against an estimated annual demand of 115 openings.

10-year aging out projection: 20 % are approaching retirement age

** This suggests that in this occupational group, about 75.7 % of OST-related jobs may go unfilled each year in the region due to an insufficient number of graduates produced locally.

2013 TOTAL WORKFORCE 7,720 OST Workers

Source: IPEDS © 2015 MCC

OPTICAL SYSTEMS TECHNOLOGY PER WORKER METRICS FOR MCC’S OPTICAL SYSTEMS TECHNOLOGY PROGRAM

27

Field

Value

Number of Completers in Workforce in 2014* 29 Marginal Annual Impact per Completer (Compared to Full-Time High School Educated Worker) $121,500 Estimated Lifetime Earnings of Completers $702,300

* Based on 10-years of MCC program completion data. Please see the source document indicated below for details.

2014 ECONOMIC IMPACT OF MCC’S OPTICAL SYSTEMS TECHNOLOGY PROGRAM

Impact Type Initial Effect Direct Effect Indirect Effect Induced Effect

Value ($) $2,191,000 $312,000 $64,000 $1,007,000

Total Economic Impact in 2014

$3,575,000

Source: Monroe Community College Program Based Economic Impact Analysis.

© 2015 MCC

28

OPTICAL SYSTEMS TECHNOLOGY REAL TIME LABOR MARKET DATA TOP SKILL CLUSTERS: BASED ON ONLINE JOB POSTINGS 2011-14

29

406 1

Common Skills: Communication &Coordination Repair: General Common Skills: Problem Solving Software & Programming Skills Common Skills: Business Environmental Skills Engineering: Electrical & Electronic Customer Service: Basic Assistance Common Skills: Project & Process Flow Skills Production: General Sales: General Construction: General Customer Service: Sales Engineering: General Construction: Electrical Construction: General

386 1

369 1

270 1

268 1

254 1

251 1

201 1

183 1

169 1

169 1

71 1

64 1

55 1

54 1

0 50 100 150 200 250 300 350 400 450 Number of Postings (10 County Region)

Based on 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. Data Source: Burning Glass Labor/Insight © 2015 MCC

OPTICAL SYSTEMS TECHNOLOGY REAL TIME LABOR MARKET DATA TOP SKILLS: BASED ON ONLINE JOB POSTINGS 2011-14

30

Repair Electrical Work Inspection Schematic Diagrams

400 1

177 1

153 1

116 1 116 1 115 1

Blueprints Hand Tools Surveys Solderings Mechanical Assembly Wiring Test Equipment Equipment Installation Broadband Programmable Logic Controller Machinery

112 1 107 1

99 1

91 1

89 1

84 1

81 1

73 1

72 1

0 50 100 150 200 250 300 350 400 Number of Postings (10 County Region)

Based on 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. Data Source: Burning Glass Labor/Insight © 2015 MCC

ADVANCED MANUFACTURING

MECHANICAL ENGINEERING TECHNOLOGY

Understanding how products and machinery work is the focus of mechanical engineering technology. Mechanical engineers research, design, and build machines and equipment of all types. Drafting is the leading skill in mechanical engineering which can lead to specializing in the design of engines, consumer goods, electronics, or heavy machinery. Engineering comes to life in the form of tools, systems and devices. Understanding how products and machinery work and how to design, make, or use them is the focus of building these skills. From consumer products to wind turbines, the Rochester region is home to many corporations with a demand for mechanical engineers, drafters and technicians.

MECHANICAL ENGINEERING TECHNOLOGY OCCUPATIONAL GROUP DEFINITION STANDARD OCCUPATIONAL CLASSIFICATIONS (SOC), OCCUPATIONS, WAGES & ESTIMATED DEMAND 32

WAGES

SOC Occupations

10th 50th 90th Est.Annual Percentile Percentile Percentile Demand

17-3011.01 Architectural Drafters 17-3011.02 Civil Drafters 17-3012.01 Electronic Drafters 17-3012.02 Electrical Drafters 17-3013.00 Mechanical Drafters

$13.65 $19.65

$28.57

8

18.21 28.18

43.15

4

14.27 23.28 11.39 17.79 15.77 19.75 18.76 24.17 18.66 31.92 15.81 21.70 11.75 20.63 10.21 17.06 7.83 9.37

36.48 25.79 28.57 36.16 15.97 41.91 31.20 28.66 28.03

8 2 1 5 3 8

17-3021.00 Aerospace Engineering and Operations Technicians

17-3024.00 Electro-Mechanical Technicians 17-3027.00 Mechanical Engineering Technicians 25-4013.00 Museum Technicians and Conservators 27-1021.00 Commercial and Industrial Designers 49-9041.00 Industrial Machinery Mechanics 49-9043.00 Maintenance Workers, Machinery

42 12 69

51-9061.00 Inspectors, Testers, Sorters, Samplers, and Weighers

TOTALS $12.84 $19.92 $30.31

161

Wages and demand based on the 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. © 2015 MCC

MECHANICAL ENGINEERING TECHNOLOGY OCCUPATIONAL GROUP HOURLY WAGES

33

$ 30.31

$ 30

$ 25

$ 25 SELF-SUFFICIENCY STANDARD FOR 2 ADULTS + 1 PRESCHOOLER & 1 SCHOOL AGE CHILD (MONROE COUNTY)

$ 19.92

$ 20

$ 18 SELF-SUFFICIENCY STANDARD FOR 1 ADULT + 1 PRESCHOOLER (MONROE COUNTY)

$ 15

Hourly Wage

$ 10

$ 12.84

$ 5

0

High Wage (90th Percentile)

Entry Level Wage (10th Percentile)

Median Wage (50th Percentile)

Wage curve based on the 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. Complete self-sufficiency data is located in the Appendix: Self-Sufficiency Standard for Monroe County, NY 2010.

© 2015 MCC

MECHANICAL ENGINEERING TECHNOLOGY GAP ANALYSIS: REGIONAL PROGRAM COMPLETIONS VS. ESTIMATED ANNUAL OPENINGS

34

This measurement aims to provide a high-level gap analysis, comparing the total estimated number of learners completing a relevant middle-skill training and education program against estimated industry demands for middle-skill workers by occupational grouping. For more detailed completion data, click here.

Middle-Skill Education Provider

2012 Estimated Annual Estimated Completions Job Openings Gap (∆)

Monroe Community College Finger Lakes Community College Rochester Institute of Technology Genesee Community College

31 33 46 11

161 -40 **

TOTAL

121 *

* The 121 annual regional completions represent a supply of 75.2 % new MET trained workers produced locally against an estimated annual demand of 161 openings.

10-year aging out projection: 24.7 % are approaching retirement age

** This suggests that in this occupational group, about 24.8 % of MET-related jobs may go unfilled each year in the region due to an insufficient number of graduates produced locally.

2013 TOTAL WORKFORCE 5,466 MET Workers

Source: IPEDS © 2015 MCC

MECHANICAL ENGINEERING TECHNOLOGY PER WORKER METRICS FOR MCC’S MECHANICAL ENGINEERING TECHNOLOGY PROGRAM 35

Field

Value

Number of Completers in Workforce in 2014*

115

Marginal Annual Impact per Completer (Compared to Full-Time High School Educated Worker)

$64,700

Estimated Lifetime Earnings of Completers

$682,700

* Based on 10-years of MCC program completion data. Please see the source document indicated below for details.

2014 ECONOMIC IMPACT OF MCC’S MECHANICAL ENGINEERING TECHNOLOGY PROGRAM

Impact Type Initial Effect Direct Effect Indirect Effect Induced Effect

Value ($) $4,669,000 $629,000 $124,000 $2,043,000

Total Economic Impact in 2014

$7,465,000

Source: Monroe Community College Program Based Economic Impact Analysis. © 2015 MCC

36

MECHANICAL ENGINEERING TECHNOLOGY REAL TIME LABOR MARKET DATA TOP SKILL CLUSTERS: BASED ON ONLINE JOB POSTINGS 2011-14

37

461 1

Common Skills: Communication &Coordination Software & Programming Skills Common Skills: Problem Solving Common Skills: Project & Process Flow Skills Common Skills: Business Environment Skills Construction: General Engineering: Drafting Repair: General Production: General Engineering: Mechanical Engineering: Electrical & Electronic Construction: Plumbing Engineering: General Construction: Electrical Finance: Financial Compliance & Risk Mgmt

451 1

359 1

343 1

322 1

157 1

145 1

134 1

121 1

91 1

85 1

80 1

74 1

59 1

57 1

0 50 100 150 200 250 300 350 400 450 500 Number of Postings (10 County Region)

Based on 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. Data Source: Burning Glass Labor/Insight © 2015 MCC

MECHANICAL ENGINEERING TECHNOLOGY REAL TIME LABOR MARKET DATA TOP SKILLS: BASED ON ONLINE JOB POSTINGS 2011-14

38

Inspection Capability Maturity Model (CMM) Micrometers Repair Computer Aided Drafting/Design (CAD) Calipers

413 1

166 1

165 1

149 1

138 1

118 1

Machining Blueprints AutoCAD Calibration Mathematics

105 1 103 1 97 1

91 1

79 1

Machinery Hand Tools Welding Internal Auditing

58 1

54 1 54 1

49 1

0 50 100 150 200 250 300 350 400 450 Number of Postings (10 County Region)

Based on 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. Data Source: Burning Glass Labor/Insight © 2015 MCC

ADVANCED MANUFACTURING

ELECTRICAL ENGINEERING TECHNOLOGIES

The role of Electrical Engineering technicians can be as varied as the workplaces they find themselves in: a pristine lab environment, a fabrication company, or a consulting firm. The Monroe County area is home to many electronics and optics manufacturers. Job growth is anticipated by virtue of constant emerging technologies. Electrical Engineering technicians are prepared to research, design, develop, test and supervise the manufacturing and installation of electrical equipment, components, or systems for commercial, industrial and scientific use. They test and modify developmental and operational electrical machinery, electrical control equipment, and circuitry in industrial and commercial plants and laboratories.

ELECTRICAL ENGINEERING TECHNOLOGIES OCCUPATIONAL GROUP DEFINITION STANDARD OCCUPATIONAL CLASSIFICATIONS (SOC), OCCUPATIONS, WAGES & ESTIMATED DEMAND 40

WAGES

SOC Occupations

10th 50th 90th Est.Annual Percentile Percentile Percentile Demand

17-3012.01 Electronic Drafters

$18.21 $28.18

$43.15

4

17-3012.02 Electrical Drafters 17-3023.01 Electronics Engineering Technicians 17-3023.03 Electrical Engineering Technicians 17-3024.00 Electro-Mechanical Technicians 27-4011.00 Audio and Video Equipment Technicians

12.49 21.10

30.49

31

15.77 19.75 11.01 17.70 10.72 20.68 16.40 21.12 13.52 27.86 13.91 21.36 13.71 24.23 13.42 18.13 12.65 16.09 8.39 10.41 14.06 21.07 10.40 14.99

28.57 31.86 32.25 35.64 33.19 32.03 40.46 22.02 20.98 15.46 28.84 23.22

1

10

27-4012.00 Broadcast Technicians

4 2 2 8 7 5 0 9 5

27-4014.00 Sound Engineering Technicians

49-2021.00 Radio, Cellular, and Tower Equipment Installers and Repairers

49-2022.00 Telecommunications Equipment Installers and Repairers, Except Line Installers 49-2094.00 Electrical and Electronics Repairers, Commercial and Industrial Equipment 49-2095.00 Electrical and Electronics Repairers, Powerhouse, Substation, and Relay 49-2097.00 Electronic Home Entertainment Equipment Installers and Repairers

22

49-9061.00 Camera and Photographic Equipment Repairers

51-4012.00 Computer Numerically Controlled Machine Tool Programmers, Metal and Plastic 51-4035.00 Milling and Planing Machine Setters, Operators, Tenders, Metal and Plastic

TOTALS $13.24 $20.99 $31.30

110

Wages and demand based on the 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. © 2015 MCC

ELECTRICAL ENGINEERING TECHNOLOGIES OCCUPATIONAL GROUP HOURLY WAGES

41

$ 31.30

$ 30

$ 25

$ 25 SELF-SUFFICIENCY STANDARD FOR 2 ADULTS + 1 PRESCHOOLER & 1 SCHOOL AGE CHILD (MONROE COUNTY)

$ 20.99

$ 20

$ 18 SELF-SUFFICIENCY STANDARD FOR 1 ADULT + 1 PRESCHOOLER (MONROE COUNTY)

$ 15

$ 13.24

Hourly Wage

$ 10

$ 5

0

High Wage (90th Percentile)

Entry Level Wage (10th Percentile)

Median Wage (50th Percentile)

Wage curve based on the 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. Complete self-sufficiency data is located in the Appendix: Self-Sufficiency Standard for Monroe County, NY 2010.

© 2015 MCC

ELECTRICAL ENGINEERING TECHNOLOGIES GAP ANALYSIS: REGIONAL PROGRAM COMPLETIONS VS. ESTIMATED ANNUAL OPENINGS

42

This measurement aims to provide a high-level gap analysis, comparing the total estimated number of learners completing a relevant middle-skill training and education program against estimated industry demands for middle-skill workers by occupational grouping. For more detailed completion data, click here.

Middle-Skill Education Provider

2012 Estimated Annual Estimated Completions Job Openings Gap (∆)

Monroe Community College Rochester Institute of Technology Genesee Community College

12 19

110 -63 **

6

Monroe 2 Orleans BOCES

10

TOTAL

47 *

* The 47 annual regional completions represent a supply of 42.7 % new EET trained workers produced locally against an estimated annual demand of 110 openings.

** This suggests that in this occupational group, about 57.3 % of EET-related jobs may go unfilled each year in the region due to an insufficient number of graduates produced locally.

10-year aging out projection: 18.9 % are approaching retirement age

2013 TOTAL WORKFORCE 4,033 EET Workers

Source: IPEDS © 2015 MCC

ELECTRICAL ENGINEERING TECHNOLOGIES PER WORKER METRICS FOR MCC’S ELECTRICAL ENGINEERING TECHNOLOGY PROGRAM

43

Field

Value

Number of Completers in Workforce in 2014* 102 Marginal Annual Impact per Completer (Compared to Full-Time High School Educated Worker) $209,100 Estimated Lifetime Earnings of Completers $895,400

* Based on 10-years of MCC program completion data. Please see the source document indicated below for details.

2014 ECONOMIC IMPACT OF MCC’S ELECTRICAL ENGINEERING TECHNOLOGY PROGRAM

Impact Type Initial Effect Direct Effect Indirect Effect Induced Effect

Value ($) $13,382,000 $1,579,000

$317,000

$6,102,000

Total Economic Impact in 2014

$21,381,000

Source: Monroe Community College Program Based Economic Impact Analysis.

© 2015 MCC

44

ELECTRICAL ENGINEERING TECHNOLOGIES REAL TIME LABOR MARKET DATA TOP SKILL CLUSTERS: BASED ON ONLINE JOB POSTINGS 2011-14

45

Common Skills: Communication & Coordination Software & Programming Skills Common Skills: Problem Solving Repair: General Common Skills: Business Environmental Skills Common Skills: Project & Process Flow Skills

306 1

238 1

234 1

177 1

159 1

151 1

Engineering: Electrical & Electronic Customer Service: Basic Assistance

113 1

111 1

Construction: General Production: General Construction: Electrical Engineering: Drafting

102 1 95 1

72 1

39 1

Physical Abilities: General Common Skills: Language Customer Service: Technical & Electronic 0

31 1 31 1

30 1

50 100 150 200 250 300 350 Number of Postings (10 County Region)

Based on 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. Data Source: Burning Glass Labor/Insight © 2015 MCC

ELECTRICAL ENGINEERING TECHNOLOGIES REAL TIME LABOR MARKET DATA TOP SKILLS: BASED ON ONLINE JOB POSTINGS 2011-14

46

187 1

Repair Computer Numerical Control (CNC) Inspection Machining Blueprints Surveys Equipment Installation Broadband Lathes Computer Aided Drafting/Design (CAD) Telecommunications CNC Mill Mathematics Test Equipment Electrical Systems

178 1

134 1

113 1

87 1

87 1

83 1

81 1

76 1

75 1

64 1

60 1

58 1

58 1

48 1

0 20 40 60 80 100 120 140 160 180 200 Number of Postings (10 County Region)

Based on 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. Data Source: Burning Glass Labor/Insight © 2015 MCC

The most challenging segment of the workforce for employers to staff with talent is the skilled trades – the welders, electricians, and machinists that are so prevalent in manufacturing and construction. Heating, Ventilation & Air Conditioning, Automotive Technologies, Construction Technologies, Welding, and Millwright are all skilled trades that provide a promising career path. These middle-skill occupations need an influx of new talent.

SKILLED TRADES

OCCUPATIONAL GROUPINGS FOR SKILLED TRADES

48

SKILLED TRADES

HEATING, VENTILATION & AIR CONDITIONING

Heating, ventilation, and air conditioning (“HVAC”) technicians are skilled workers who design, install, maintain, and troubleshoot air conditioning, heating, ventilating, and commercial refrigeration systems. Employers include independent heating and air conditioning contractors; public utilities; and maintenance, engineering, or facilities departments in industry, schools, and hospitals. An HVAC technician is a professional in both service and support. They can install and repair systems, as well as maintain them. They may work on their own as independent contractors or be employed by a company that specializes in climate control solutions for business and residential properties.

SKILLED TRADES

HEATING, VENTILATION & AIR CONDITIONING OCCUPATIONAL GROUP DEFINITION STANDARD OCCUPATIONAL CLASSIFICATIONS (SOC), OCCUPATIONS, WAGES & ESTIMATED DEMAND

WAGES

SOC Occupations

10th 50th 90th Est.Annual Percentile Percentile Percentile Demand

50

17-3011.01 Architectural Drafters

13.65 12.49 15.77 15.02 15.28 18.76 37.15 16.15 13.97 13.74 13.66 9.50

19.65 21.10 19.75 18.01 23.63 24.17 15.33 58.96 22.22 26.16 21.95 23.59 12.90 24.23 14.27 18.64 19.14 20.63 13.11 15.59 28.48 24.85 21.21

28.57 30.49 28.57 28.74 46.03 36.16 24.29 69.01 32.19 34.15 33.92 32.62 16.18 40.46 19.18 28.44 25.15 28.66 19.99 23.20 36.34 31.46 28.40

8

17-3023.01 Electronics Engineering Technicians 17-3023.03 Electrical Engineering Technicians 17-3024.00 Electro-Mechanical Technicians 17-3025.00 Environmental Engineering Technicians 17-3026.00 Industrial Engineering Technicians 17-3027.00 Mechanical Engineering Technicians

31

1 2 5 4 2

23

43-5041.00 Meter Readers, Utilities

47-2011.00 Boilermakers 47-2111.00 Electricians

64 55 16 29

47-2152.01 Pipe Fitters and Steamfitters

47-2152.02 Plumbers 47-2211.00 Sheet Metal Workers

47-4011.00 Construction and Building Inspectors

49-2092.00 Electric Motor, Power Tool, and Related Repairers

9.66

1 8 6

49-2094.00 Electrical and Electronics Repairers, Commercial & Industrial Equipment 49-9012.00 Control and Valve Installers and Repairers, Except Mechanical Door

13.71

9.43

49-9021.01 Heating and Air Conditioning Mechanics and Installers

11.90

49

49-9021.02 Refrigeration Mechanics and Installers 49-9031.00 Home Appliance Repairers 49-9043.00 Maintenance Workers, Machinery

9.76

7

11.75

12 16

49-9098.00 Helpers – Installation, Maintenance, and Repair Workers

8.67

51-2023.00 Electromechanical Equipment Assemblers

12.91 16.51 18.21 14.98

3 5 5 1

51-8013.00 Power Plant Operators

51-8021.00 Stationary Engineers and Boiler Operators

51-9193.00 Cooling and Freezing Equipment Operators and Tenders

TOTALS $13.76 $21.90 $32.32

360

Wages and demand based on the 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. © 2015 MCC

HEATING, VENTILATION & AIR CONDITIONING OCCUPATIONAL GROUP HOURLY WAGES

$ 32.32

$ 30

51

$ 25

$ 25 SELF-SUFFICIENCY STANDARD FOR 2 ADULTS + 1 PRESCHOOLER & 1 SCHOOL AGE CHILD (MONROE COUNTY)

$ 21.90

$ 20

$ 18 SELF-SUFFICIENCY STANDARD FOR 1 ADULT + 1 PRESCHOOLER (MONROE COUNTY)

$ 15

$ 13.76

Hourly Wage

$ 10

$ 5

0

High Wage (90th Percentile)

Entry Level Wage (10th Percentile)

Median Wage (50th Percentile)

Wage curve based on the 10 county region: Genesee, Livingston, Monroe, Ontario, Orleans, Schuyler, Seneca, Wayne, Wyoming and Yates. Complete self-sufficiency data is located in the Appendix: Self-Sufficiency Standard for Monroe County, NY 2010.

© 2015 MCC

HEATING, VENTILATION & AIR CONDITIONING GAP ANALYSIS: REGIONAL PROGRAM COMPLETIONS VS. ESTIMATED ANNUAL OPENINGS

This measurement aims to provide a high-level gap analysis, comparing the total estimated number of learners completing a relevant middle-skill training and education program against estimated industry demands for middle-skill workers by occupational grouping. For more detailed completion data, click here.

52

Middle-Skill Education Provider

2012 Estimated Annual Estimated Completions Job Openings Gap (∆)

Monroe Community College Monroe 2 Orleans BOCES Rochester Institute of Technology Finger Lakes Community College Genesee Community College

51 56 21

360 -220 **

3 9

TOTAL

140 *

* The 140 annual regional completions represent a supply of 38.4 % new HVAC trained workers produced locally against an estimated annual demand of 360 openings.

10-year aging out projection: 20.7 % are approaching retirement age

** This suggests that in this occupational group, about 61.1 % of HVAC-related jobs may go unfilled each year in the region due to an insufficient number of graduates produced locally.

2013 TOTAL WORKFORCE 13,639 HVAC Workers

Source: IPEDS © 2015 MCC