2017 MAR Administrative Professional Program Trends

2017 MAR Administrative Professional Program Trends








Occupation Overview
Emsi Q1 2017 Data Set
March 2017

Western Technical College

400 Seventh Street
La Crosse, Wisconsin 54601
608.785.9200

Emsi Q1 2017 Data Set | www.economicmodeling.com

1

Parameters
Occupations
20 items selected. See Appendix A for details.

Regions
Code

Description

55011

Buffalo County, WI

55023

Crawford County, WI

55053

Jackson County, WI

55057

Juneau County, WI

55063

La Crosse County, WI

55081

Monroe County, WI

55121

Trempealeau County, WI

55123

Vernon County, WI

Timeframe
2018 - 2022

Datarun
2017.1 – Employees

Emsi Q1 2017 Data Set | www.economicmodeling.com

2

Administrative Professional (2 year) 6/2013 (AED) in Western Technical College District

SOC

13-1121

43-1011

43-2011

43-2021
43-3099
43-4051
43-4071
43-4121

43-4161

43-4171
43-4199

43-6011

43-6012

43-6014

43-9021
43-9022
43-9041
43-9061

2018
Jobs

Description
Meeting,
Convention, and
Event Planners
First-Line
Supervisors of
Office and
Administrative
Support Workers
Switchboard
Operators,
Including
Answering Service
Telephone
Operators
Financial Clerks,
All Other
Customer Service
Representatives
File Clerks
Library Assistants,
Clerical
Human Resources
Assistants, Except
Payroll and
Timekeeping
Receptionists and
Information Clerks
Information and
Record Clerks, All
Other
Executive
Secretaries and
Executive
Administrative
Assistants
Legal Secretaries
Secretaries and
Administrative
Assistants, Except
Legal, Medical,
and Executive
Data Entry Keyers
Word Processors
and Typists
Insurance Claims
and Policy
Processing Clerks
Office Clerks,
General

2022
Jobs

2018 2022
Change

2018 2022 %
Change

2018 2022
Openings

Annual
Openings

Median
Hourly
Earnings

32

34

2

6%

<10

Insf. Data

$16.54

1,228

1,289

61

5%

139

35

$21.85

62

54

(8)

(13%)

<10

Insf. Data

$11.84

<10

<10

Insf.
Data

Insf.
Data

<10

Insf. Data

Insf. Data

15

16

1

7%

<10

Insf. Data

$18.22

2,155

2,204

49

2%

266

67

$14.33

79

79

0

0%

<10

Insf. Data

$13.26

186

184

(2)

(1%)

25

6

$11.62

130

130

0

0%

<10

Insf. Data

$18.49

718

748

30

4%

113

28

$11.74

180

182

2

1%

22

6

$12.35

313

317

4

1%

20

5

$21.77

68

67

(1)

(1%)

<10

Insf. Data

$17.91

1,472

1,524

52

4%

121

30

$15.99

126

128

2

2%

<10

Insf. Data

$12.97

42

41

(1)

(2%)

<10

Insf. Data

$17.47

570

590

20

4%

80

20

$14.77

4,503

4,561

58

1%

466

117

$14.29

Emsi Q1 2017 Data Set | www.economicmodeling.com

3

43-9071

Office Machine
Operators, Except
Computer

61

60

(1)

(2%)

<10

Insf. Data

$13.98

43-9199

Office and
Administrative
Support Workers,
All Other

244

248

4

2%

33

8

$15.07

12,190

12,464

274

2%

1,330

333

$15.30

Occupation Summary for Administrative Professional (2 year) 6/2013
(AED)

11,917

2.2%

$15.30/hr

Jobs (2016)

% Change (2018-2022)

Median Hourly Earnings

14% below National average

Nation: 2.9%

Nation: $17.09/hr

Growth

12,190

12,464

274

2.2%

2018 Jobs

2022 Jobs

Change (2018-2022)

% Change (2018-2022)

Occupation

2018 Jobs

2022 Jobs

Change

% Change

32

34

2

6%

1,228

1,289

61

5%

62

54

-8

-13%

7

5

-2

-29%

Financial Clerks, All Other
(43-3099)

15

16

1

7%

Customer Service
Representatives (43-4051)

2,155

2,204

49

2%

79

79

0

0%

Library Assistants, Clerical
(43-4121)

186

184

-2

-1%

Human Resources

130

130

0

0%

Meeting, Convention, and
Event Planners (13-1121)
First-Line Supervisors of
Office and Administrative
Support Workers (43-1011)
Switchboard Operators,
Including Answering Service
(43-2011)
Telephone Operators
(43-2021)

File Clerks (43-4071)

Emsi Q1 2017 Data Set | www.economicmodeling.com

4

Occupation

2018 Jobs

2022 Jobs

Change

% Change

Receptionists and
Information Clerks (43-4171)

718

748

30

4%

Information and Record
Clerks, All Other (43-4199)

180

182

2

1%

Executive Secretaries and
Executive Administrative
Assistants (43-6011)

313

317

4

1%

68

67

-1

-1%

1,472

1,524

52

4%

126

128

2

2%

42

41

-1

-2%

570

590

20

4%

4,503

4,561

58

1%

Office Machine Operators,
Except Computer (43-9071)

61

60

-1

-2%

Office and Administrative
Support Workers, All Other
(43-9199)

244

248

4

2%

Assistants, Except Payroll
and Timekeeping (43-4161)

Legal Secretaries (43-6012)
Secretaries and
Administrative Assistants,
Except Legal, Medical, and
Executive (43-6014)
Data Entry Keyers (43-9021)
Word Processors and
Typists (43-9022)
Insurance Claims and Policy
Processing Clerks (43-9041)
Office Clerks, General
(43-9061)

Percentile Earnings

$12.21/hr

$15.30/hr

$18.59/hr

25th Percentile Earnings

Median Earnings

75th Percentile Earnings

Emsi Q1 2017 Data Set | www.economicmodeling.com

5

25th Percentile
Earnings

Median Earnings

75th Percentile
Earnings

Meeting, Convention, and Event
Planners (13-1121)

$12.74

$16.54

$21.03

First-Line Supervisors of Office
and Administrative Support
Workers (43-1011)

$16.83

$21.85

$27.47

Switchboard Operators, Including
Answering Service (43-2011)

$10.12

$11.84

$14.16

Telephone Operators (43-2021)

$10.82

$13.71

$17.27

Financial Clerks, All Other
(43-3099)

$13.92

$18.22

$22.23

Customer Service
Representatives (43-4051)

$11.43

$14.33

$17.65

File Clerks (43-4071)

$10.35

$13.26

$16.21

Library Assistants, Clerical
(43-4121)

$10.03

$11.62

$13.25

Human Resources Assistants,
Except Payroll and Timekeeping
(43-4161)

$15.22

$18.49

$21.40

Receptionists and Information
Clerks (43-4171)

$9.18

$11.74

$14.14

Information and Record Clerks,
All Other (43-4199)

$9.32

$12.35

$18.43

Executive Secretaries and
Executive Administrative
Assistants (43-6011)

$18.19

$21.77

$25.77

Legal Secretaries (43-6012)

$15.14

$17.91

$21.14

Secretaries and Administrative
Assistants, Except Legal,
Medical, and Executive (43-6014)

$13.50

$15.99

$18.40

Data Entry Keyers (43-9021)

$11.29

$12.97

$15.41

Word Processors and Typists
(43-9022)

$15.07

$17.47

$19.88

Insurance Claims and Policy
Processing Clerks (43-9041)

$12.78

$14.77

$17.60

Office Clerks, General (43-9061)

$11.12

$14.29

$17.42

Office Machine Operators, Except
Computer (43-9071)

$11.91

$13.98

$16.72

Office and Administrative Support
Workers, All Other (43-9199)

$11.69

$15.07

$18.00

Occupation

Emsi Q1 2017 Data Set | www.economicmodeling.com

6

25th Percentile
Earnings

Occupation

Median Earnings

75th Percentile
Earnings

Regional Trends

Region

2018 Jobs

2022 Jobs

Change

% Change

●

Region

12,190

12,464

274

2.2%

●

State

271,603

275,085

3,482

1.3%

●

Nation

14,268,923

14,687,318

418,395

2.9%

Regional Breakdown
County

2022 Jobs

La Crosse County, WI

6,719

Monroe County, WI

1,539

Trempealeau County, WI

1,120

Vernon County, WI

757

Crawford County, WI

679

Occupation Gender Breakdown

Gender

2016 Jobs 2016 Percent

●

Males

2,209

18.5%

●

Females

9,708

81.5%

Emsi Q1 2017 Data Set | www.economicmodeling.com

7

Gender

2016 Jobs 2016 Percent

Occupation Age Breakdown

Age

2016 Jobs 2016 Percent

●

14-18

164

1.4%

●

19-24

1,304

10.9%

●

25-34

2,417

20.3%

●

35-44

2,172

18.2%

●

45-54

2,698

22.6%

●

55-64

2,490

20.9%

●

65+

672

5.6%

Occupation Race/Ethnicity Breakdown

Race/Ethnicity
●

White

●

2016 Jobs 2016 Percent
10,919

91.6%

Hispanic or Latino

281

2.4%

●

Black or African American

261

2.2%

●

Asian

250

2.1%

●

Two or More Races

109

0.9%

●

American Indian or Alaska Native

95

0.8%

●

Native Hawaiian or Other Pacific Islander

3

0.0%

Occupational Programs

10

163

311

Programs (2015)

Completions (2015)

Openings (2015)

CIP Code

Program

Emsi Q1 2017 Data Set | www.economicmodeling.com

Completions (2015)

8

Race/Ethnicity

2016 Jobs 2016 Percent

52.0207

Customer Service Management

77

52.0204

Office Management and Supervision

49

52.0401

Administrative Assistant and Secretarial
Science, General

17

52.0407

Business/Office Automation/Technology/Data
Entry

13

51.0716

Medical Administrative/Executive Assistant
and Medical Secretary

7

Industries Employing Administrative Professional (2 year) 6/2013
(AED)
Occupation
Group Jobs
in Industry
(2016)

% of
Occupation
Group in
Industry
(2016)

% of Total
Jobs in
Industry
(2016)

Local Government, Excluding Education and Hospitals

923

7.7%

11.1%

Third Party Administration of Insurance and Pension Funds

643

5.4%

52.5%

Colleges, Universities, and Professional Schools (Local
Government)

413

3.5%

23.7%

General Medical and Surgical Hospitals

401

3.4%

4.2%

Corporate, Subsidiary, and Regional Managing Offices

371

3.1%

16.5%

Industry

Appendix A - Occupations
Code

Description

13-1121

Meeting, Convention, and Event Planners

43-1011

First-Line Supervisors of Office and Administrative Support Workers

43-2011

Switchboard Operators, Including Answering Service

43-2021

Telephone Operators

43-3099

Financial Clerks, All Other

43-4051

Customer Service Representatives

43-4071

File Clerks

Emsi Q1 2017 Data Set | www.economicmodeling.com

9

Code

Description

43-4121

Library Assistants, Clerical

43-4161

Human Resources Assistants, Except Payroll and Timekeeping

43-4171

Receptionists and Information Clerks

43-4199

Information and Record Clerks, All Other

43-6011

Executive Secretaries and Executive Administrative Assistants

43-6012

Legal Secretaries

43-6014

Secretaries and Administrative Assistants, Except Legal, Medical, and Executive

43-9021

Data Entry Keyers

43-9022

Word Processors and Typists

43-9041

Insurance Claims and Policy Processing Clerks

43-9061

Office Clerks, General

43-9071

Office Machine Operators, Except Computer

43-9199

Office and Administrative Support Workers, All Other

Emsi Q1 2017 Data Set | www.economicmodeling.com

10

Appendix B - Data Sources and
Calculations
Location Quotient
Location quotient (LQ) is a way of quantifying how concentrated a particular industry, cluster, occupation, or
demographic group is in a region as compared to the nation. It can reveal what makes a particular region unique
in comparison to the national average.

Occupation Data
Emsi occupation employment data are based on final Emsi 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.

Completers Data
The completers data in this report is taken directly from the national IPEDS database published by the U.S.
Department of Education's National Center for Education Statistics.

Institution Data
The institution data in this report is taken directly from the national IPEDS database published by the U.S.
Department of Education's National Center for Education Statistics.

State Data Sources
This report uses state data from the following agencies: Illinois Department of Employment Security,
Employment Projections; Iowa Workforce Development; Michigan Department of Labor and Economic Growth,
Bureau of Labor Market Information and Strategic Initiatives; Minnesota Department of Employment and
Economic Development; Wisconsin Department of Workforce Development, Bureau of Workforce Information

Emsi Q1 2017 Data Set | www.economicmodeling.com

11