PA Launches Data Warehouse

by Michelle Massie
January 16, 2015

The state of Pennsylvania recently rolled out its data warehouse, which integrates program and workforce data from public agencies with earnings and employment data in an effort to answer key policy questions that the state has identified.

The data warehouse, called PA-WDQI, eventually will be able to analyze the state’s supply and demand of workers. The system is managed by the Center for Workforce Information & Analysis, which is the labor market information arm of the Pennsylvania Department of Labor & Industry (L&I). It is a collaborative effort with the state’s Department of Human Services (DHS).

In 2012, Pennsylvania received a Workforce Data Quality Initiative grant from the U.S. Department of Labor to build a longitudinal database of workforce data and link it to education data to help improve the overall performance of workforce development programs.

The PA-WDQI integrates data from multiple sources:

  • Workforce program participants
  • Human services program participants
  • Wage data of workers
  • Job postings
  • Occupational employment projections
  • Postsecondary education completers

One of the accomplishments of PA-WDQI is the establishment of a data sharing agreement between L&I and DHS to allow for the exchange of data and ongoing analysis.

The PA-WDQI team is currently testing data quality and exploring which data will be shared with stakeholders to help address policy questions such as:

  • For all employed individuals, what are the average wages and average length of employment retention?
  • For individuals that have utilized public assistance or workforce programs, what is the employment rate, average wages and average employment retention?
  • What occupations are currently experiencing labor surpluses/shortages?
  • How does the distribution of postsecondary completers align to the employment distribution of the workforce?

PA-WDQI does not currently have a public-facing interface.

The state hopes to expand the data warehouse to include more education and training data over time.