Using LEHD data to advance economic development in the Pittsburgh region Melanie Harrington, President and CEO Elissa Waldmuller, Research Analyst Vibrant Pittsburgh
Who we are Vibrant Pittsburgh works to grow a talented and diverse workforce for the region, by attracting, retaining, elevating and educating people of all backgrounds. Vibrant Pittsburgh is focused on working collaboratively with private and public sector leadership to strengthen the region’s economic future by growing and retaining a diverse workforce and fostering a more inclusive and welcoming community.
Background 2015 Report by the Pittsburgh Workforce Diversity Indicators Initiative Vibrant Pittsburgh, Pittsburgh T oday Three Rivers Workforce Investment Board Allegheny Conference on Community Development University of Pittsburgh Center on Race and Social Problems University of Pittsburgh University Center for Social and Urban Research First round analysis focused on job sector employment, worker income, and workforce participation Local data was benchmarked against 14 peer regions Data was drawn from the 2013 LEHD program’s Quarterly Workforce Indicators
Purpose To track and report regional workforce comparative data that are designed to bring greater resources and more constructive solutions to the goal of growing and diversifying the Pittsburgh region’s workforce and population. Behind the Times: The Limited Role of Minorities in the Greater Pittsburgh Workforce is based on an analysis of workforce-related data collected by the Pittsburgh Regional Workforce Diversity Indicators Initiative .
Minority Workers’ Share of Pittsburgh Region Jobs Percentage of Jobs in the Pittsburgh Labor Overall Share of Jobs in the Pittsburgh Labor Market Held by Minority Workers by Racial Market Held by Minority Workers and Ethnic Subgroups 88.9% 7.1% 88.9% Pittsburgh 1.7% Pittsburgh 1.6% 11.1% 0.8% 0% 50% 100% White Non-Hispanic African American/Black 0% 50% 100% Hispanic/Latino Asian Percentage of White Non-Hispanic Workers Percentage of Minority Workers DATA SOURCE: U.S. Census Bureau, Longitudinal Employer-Household Dynamics data
Percentage of Overall Share of Jobs Held by Racial/Ethnic Minority Workers by Peer Region in 2013 Atlanta 44.3% Baltimore 36.8% Richmond 36.1% Charlotte 32.2% Philadelphia 28.2% Denver 26.5% Benchmark Average 25.2% Detroit 24.4% St. Louis 22.3% Milwaukee 21.5% Cleveland 21.2% Kansas City 20.5% Indianapolis 19.3% Minneapolis 16.6% Cincinnati 16.3% Pittsburgh 11.1% 0% 10% 20% 30% 40% 50% DATA SOURCE: U.S. Census Bureau, Longitudinal Employer-Household Dynamics data
Workforce participation by minority subgroups – peer regions By MSA, 2013 32% 7% 5% 1% Atlanta 26% 5% 5% 1% Baltimore 27% 4% 3% 1% Richmond 22% 6% 3% 1% Charlotte 1% 17% 5% 5% Philadelphia 5% 16% 3% 2% Denver 3% 1% 16% 5% Benchmark Average 16% 3% 3% 1% Detroit 2% 2% 1% 17% St. Louis 11% 7% 3% 1% Milwaukee 15% 4% 2% 1% Cleveland 12% 5% 2% 2% Kansas City 12% 4% 2% 1% Indianapolis 12% 2% 2% 1% Cincinnati 6% 4% 5% 2% Minneapolis 1% 7% 2% 2% Pittsburgh 0% 10% 20% 30% 40% 50% African American/Black Hispanic/Latino Asian Other DATA SOURCE: U.S. Census Bureau, Longitudinal Employer-Household Dynamics data
Percentage of Jobs Held by Minority Workers by Industry in the Pittsburgh Labor Market in 2013 19.6% Administrative and Support 16.4% Accommodation and Food Services 14.3% Health Care and Social Assistance 11.6% Information 11.6% Finance and Insurance 11.1% All NAICS 10.9% Transportation and Warehousing 10.6% Public Administration 10.3% Management of Companies and Enterprises 10.2% Educational Services 10.0% Retail Trade 9.8% Real Estate and Rental and Leasing 9.5% Arts, Entertainment, and Recreation 9.1% Professional, Scientific, and Technical Services 8.7% Other Services 7.7% Utilities 7.4% Manufacturing 6.3% Agriculture, Forestry, Fishing and Hunting 5.8% Wholesale Trade 5.5% Mining, Quarrying, Oil and Gas Extraction 5.0% Construction 0% 5% 10% 15% 20% 25% DATA SOURCE: U.S. Census Bureau, Longitudinal Employer-Household Dynamics data
Average Monthly Wages for Racial/Ethnic Minority Workers by Industry in the Pittsburgh Labor Market for 2013 $8,346 Mining, Quarrying, Oil and Gas Extraction $7,254 Utilities $6,357 Management of Companies and Enterprises $6,107 Information $5,977 Professional, Scientific, and Technical Services $5,450 Wholesale Trade $5,292 Finance and Insurance $4,893 Manufacturing $4,560 Health Care and Social Assistance $4,357 Educational Services $4,213 Construction $4,007 All NAICS $3,983 Public Administration $3,636 Real Estate and Rental and Leasing $3,500 Transportation and Warehousing $2,761 Administrative and Support and Waste… $2,552 Agriculture, Forestry, Fishing and Hunting $2,326 Other Services $2,218 Arts, Entertainment, and Recreation $2,047 Retail Trade $1,442 Accommodation and Food Services $0 $2,000 $4,000 $6,000 $8,000 Racial/Ethnic Minority Workers White Non-Hispanic Workers DATA SOURCE: U.S. Census Bureau, Longitudinal Employer-Household Dynamics data
Average Monthly Wages for Racial/Ethnic Minority Workers by Peer Region in 2013 $4,038 Detroit $3,948 Pittsburgh $3,814 Cincinnati Baltimore $3,726 $3,726 Philadelphia $3,683 Cleveland $3,675 Charlotte $3,631 Atlanta $3,597 Benchmark Average $3,523 Indianapolis $3,523 Denver $3,475 St. Louis $3,442 Richmond $3,318 Minneapolis Milwaukee $3,275 $3,162 Kansas City $0 $2,000 $4,000 $6,000 Racial/Ethnic Minority Workers White Non-Hispanic Workers DATA SOURCE: U.S. Census Bureau, Longitudinal Employer-Household Dynamics data
Average Monthly Wages of African American/Black Minority Workers by Peer Region in 2013 Baltimore $3,147 Denver $3,102 $3,094 Detroit Atlanta $3,077 $2,997 Philadelphia Charlotte $2,943 Indianapolis $2,834 $2,829 Benchmark Average Minneapolis $2,817 $2,780 Richmond Cincinnati $2,773 Cleveland $2,699 $2,666 Pittsburgh Kansas City $2,635 $2,480 Milwaukee St. Louis $2,395 $0 $2,000 $4,000 $6,000 African American/Black Minority Workers White Non-Hispanic Workers DATA SOURCE: U.S. Census Bureau, Longitudinal Employer-Household Dynamics data
Average Monthly Wages for Racial/Ethnic Minority Workers by Peer Region in 2013 Average Monthly Wages of Hispanic/Latino Average Monthly Wages for Asian Minority Minority Workers by Peer Region in 2013 Workers by Peer Region in 2013 $6,271 $3,661 Pittsburgh Pittsburgh $6,060 $3,637 Detroit Detroit $5,837 $3,599 Cleveland Cincinnati $5,790 $3,394 Baltimore Cincinnati $5,323 $3,341 Charlotte St. Louis $5,296 $3,249 Philadelphia Indianapolis $3,237 $5,203 Atlanta St. Louis $3,206 $5,153 Benchmark… Benchmark… $3,098 $5,032 Minneapolis Philadelphia $3,090 $4,947 Denver Baltimore $3,042 $4,915 Charlotte Milwaukee $3,041 $4,891 Richmond Richmond $3,007 $4,836 Cleveland Atlanta $2,978 Indianapolis $4,359 Kansas City $2,917 Kansas City $4,321 Denver $2,796 Milwaukee $4,217 Minneapolis $0 $2,000 $4,000 $6,000 $0 $2,000 $4,000 $6,000 $8,000 Hispanic/Latino Minority Workers White Non-Hispanic Workers Asian Minority Workers White Non-Hispanic Workers DATA SOURCE: U.S. Census Bureau, Longitudinal Employer-Household Dynamics data
How the data was gathered Using publicly available LEHD data from http://lehd.ces.census.gov
Click on “LED Extraction Tool”
Step 1 – Geography The following metropolitan statistical areas (MSAs) were used: Pittsburgh, PA Atlanta, GA 2 nd Baltimore, MD 3 rd Charlotte, NC Cincinnati, OH Cleveland, OH 1 st Denver, CO Detroit, MI Indianapolis, IN Kansas City, KS Milwaukee, WI Minneapolis, MN Philadelphia, PA Steps: Richmond, VA 1. Select a state – Pennsylvania St. Louis, MO 2. Select Micro/Metropolitan Areas 3. Check Pittsburgh, PA
Step 2 – Firm Characteristics Keep the default selections for: - Industry Detail Level - Firm Ownership Click “Check All” under Industries
Step 3 – Worker Characteristics In the drop down menu for “Select Worker Characteristics by” - select “Race and Ethnicity” - Check all boxes under “Race” - Check all boxes under “Ethnicity”
Step 4 – Indicators (1 of 3)
Step 4 – Indicators (2 of 3)
Step 4 – Indicators (3 of 3)
Step 5 - Quarters For this report the latest 2013 value was represented b y 1QTR 2013 + 3 previous QTR avg.
Step 6 – Summary and Export * Be sure to check “Include Labels” - Steps 1-6 were repeated for each MSA and specified year - 15 MSAs in total - 1998, 2002, 2007, 2010, 2012, & 2013 - The combined results created a workbook with over 127,000 lines of data
Cleaning Up the Data - Get rid of excess columns of information that are not beneficial - Example: Education and Sex columns - Allows for better readability and organization
Cleaning up the data Columns retained: Geography, Industry, Race, Ethnicity, Year, Quarter, Employment, New Hires, Separations, Turnovers, Average Monthly Earnings, New Hire Average Monthly Earnings,
Recommend
More recommend
