The details and current status of data requests submitted through the Data Request Help Desk page can be seen here.


Predicting Employee Attrition

Request #565891

open
Submitted on Thursday December 1, 2016 at 6:04 am

Problem: which employees are a high ‘flight risk’ i.e. ready to resign?

Data that will be used to solve the problem: I will need data sets of employees who have voluntarily left an organisation in the past 5 years (more years if available). I will want to examine if there are commonalities among Voluntary Leavers across any of the below data points versus employees who are still in the organisation (at various tenures: 1 yr. 2-3 yrs, 4-5 yrs, 6-7 yrs, 8-10 yrs, +10 yrs):
• Tenure in the organisation
• Tenure in role
• Number of roles occupied
• Average tenure per role
• Number of promotions
• Average tenure in Band
• Last 5 performance ratings (mean, median and mode)
• Last 5 Talent ratings (mean, median and mode)
• Their first ever performance rating
• Their first ever Talent rating
• Were they on a succession plan when they left
• Number of times they were ever on a succession plan
• Number of hours spent on Learning each year that they were in the organisation
• How long ago since their last salary increase
• How long ago since their last promotion
• How long ago since the last time they got a ‘high performer’ rating
• How long ago since last time they got an ‘Identified Talent’ rating
• Their engagement index per year
• Their manager’s engagement index per year (vs industry average index)
• Their manager’s performance rating per year (vs industry average index)
• Their manager’s Talent rating per year
• Their peer’s average engagement index per year (vs industry average index)
• Their peer’s average performance ratings per year
• Their peer’s average Talent ratings per year
• Diversity (gender, age, ethnicity, nationality, religion, disability, sexual orientation)
• Number of languages spoken
• Number of international assignments/ moves
• What % above/ below team average was their past 5 bonuses
• What % above/ below team average was their base pay
• What % above/ below industry position average was their base pay
• What was their number of absent days per year (compared to team average)
• What was their number of paid leave days taken per year (compared to team average)


Response

Resources:
https://www.opm.gov/data/index.aspx
https://www.fedscope.opm.gov/
https://www.fedscope.opm.gov/separations.asp