Using SAS, the North Carolina Office of State Personnel (NC OSP) channels multiple information sources into a single repository via the North Carolina Workforce Outlook and Retirement Knowledge System (NC WORKS) data integration system. With easy access to so much data, the state can then leverage advanced business analytics to predict employee turnover and the availability of qualified candidates needed to fill those openings.

Poised to become the seventh-largest state in the United States, North Carolina must meet an increasing population’s needs as it faces an impending state worker shortage. Of 90,000 current employees, over 58 percent are baby boomers; 10 percent are eligible to retire by 2010, and that number jumps to 38 percent by 2015.

“Workforce planning in our state government is essential if we are to compete for the talent necessary to carry out the business of the state,” says Sharon Howard, Human Resources Consultant for the NC OSP. “It’s extremely important that we begin deliberate and thoughtful workforce planning activities to ensure that we have the talent now and in the future.”

As a result, the NC OSP worked with SAS and consulting partner Zencos to implement the first phase of NC WORKS: a data warehouse and business intelligence application that enables the state government to proactively manage and forecast talent needs. This application provides state agencies with the ability to analyze employee data and plan for retirements and other attrition by capturing aggregate data from multiple internal and external sources in a single repository.

Read the full story on sas.com with PDF and videos.