andrewlengly.com/internal-mobility-casestudy :: internal mobility case study
# Whether people who move inside a company stay longer, and what Workday should build to make internal candidates the default.
designed page ......... /internal-mobility-casestudy
THE SHORT VERSION
A data study of whether people who move inside a company stay longer, modeled on attrition and time since promotion for 1,470 employees. It compares people who changed roles with people who did not and sizes the value for a 5,000-person company. Built with Python, pandas, statsmodels and DuckDB, it recommends a two-week internal posting window and skills-profile matching. the question .......... Companies post a role outside before most of their own people even see it. What does that cost in people who leave? what i did ............ Modeled attrition against time since promotion for 1,470 employees, compared people who changed roles with people who didn’t, and sized the value for a 5,000-person company. where it stands ....... Done in November 2026. I recommend a two-week internal posting window and skills-profile matching. kind .................. Case study · Data study role .................. Analyst year .................. 2026 tools ................. Python, pandas, statsmodels, DuckDB, Jupyter, BLS API the question .......... Do people who move inside a company stay longer, and what should Workday build so they can?
THE QUESTION
# People leave for a new job they could have found down the hall. LinkedIn found employees lean toward outside jobs because those openings are easier to find and pay more. Gartner found only about half of employees know about openings at their own company. Workday’s talent marketplace sits on top of that gap. I wanted to know how much staying put in one role raises the risk of leaving, and what that risk is worth. may 2023 .............. LinkedIn Global Talent Trends
HOW I DID IT
# Two HR datasets for the pattern, government and LinkedIn data for the size.
# From records to a dollar figure
01. Promotion model
Logistic regression
1,470 employees
Controls: Tenure, time in role, level, overtime, pay and satisfaction
02. Movers vs stayers
2+ years at the company
With and without controls
03. Exit reasons
88 voluntary exits
Huebner HR Dataset
04. Sizing
JOLTS quit rate
LinkedIn retention gap
mover ................. someone whose time in their current role is shorter than their time
at the company
kept by moves ......... extra internal moves times the gap between 75% and 56% two-year
retention
The IBM data can’t separate promotions from lateral moves, so a mover is anyone who
changed roles.WHAT THE DATA SHOWS
# Each year without a promotion raises the odds of leaving by 15%. # Chance a typical employee leaves, by years since promotion just promoted ......... 6% 1 year ................ 7% 2 years ............... 8% 3 years ............... 9% 4 years ............... 10% 5 years ............... 11% 6 years ............... 13% 8 years ............... 16% Everything else held at the median. Odds ratio 1.15 per year, interval 1.07 to 1.23, p < 0.001. IBM HR Analytics dataset, synthetic. # Share who left, people with 2+ years at the company same role since hire (ibm, 176) 19% changed roles (ibm, 1,079) 12% no internal move (linkedin, at 2 years) 44% internal move (linkedin, at 2 years) 25% source ................ LinkedIn Talent Connect 2022 The mover gap in the IBM data is significant on its own (p = 0.02). With controls the odds ratio is 0.67 and the interval runs from 0.41 to 1.10, so that result alone can’t settle it. LinkedIn’s data across millions of profiles points the same way. In the Huebner data, 40 of 88 voluntary exits gave a reason an internal move can answer. Leaving for another position was the most common.
OPPORTUNITY
# Four more points of internal moves is worth about $1.4 million a year. quits a year at 5,000 people 1,330 extra internal moves 200 more people still there at 2 years 38 value per year of moves $1.39M BLS puts the private-sector quit rate at 26.6% for 2025. Raising internal moves from 8% to 12% a year adds 200 moves, and LinkedIn’s 19-point gap keeps about 38 more of those people. At $4,700 per hire plus about $24,400 of lost output while a replacement ramps, that avoids about $1.1 million. Skipping part of the outside search adds about $0.3 million. A move often opens a backfill, so only 30% of search cost counts as saved. The move rates are assumptions.
MY RECOMMENDATION
# Make the internal candidate the default. two-week internal window On by default for every requisition, with exceptions for urgent backfills and licenses nobody inside holds. tell matched people first Notify them the day a role posts. About half of employees don’t know about openings at their own company. skills profiles ....... Employees fill them in and managers confirm, with fields for career interests and willingness to move teams. rank by risk .......... Sort matches on skill overlap, then surface people three or more years past their last promotion first. no manager veto ....... Managers see an application after the employee applies and can’t block it. report the payoff ..... Show customers their internal fill rate and two-year retention of movers.
LIMITS
# What this data can’t tell you. synthetic data ........ Both HR datasets were built for teaching. LinkedIn’s and Bidwell’s research carries the outside evidence. who gets moved ........ People who move may already be stronger or more engaged. A real test compares matched employees. moves are mixed ....... The IBM data treats promotions and lateral moves as one group.
WHAT’S NEXT
# What I’d build on top of this. a flight-risk list .... Turn the promotion model into a monthly list of people past the three-year mark with a matching open role. promotion vs lateral Split movers by type with real HRIS data to see which kind of move keeps people longer. manager hoarding ...... Measure which teams lose few people to internal moves and still see high outside quits. window test ........... Compare fill time and quality for roles posted with and without the two-week window. pay gap tracker ....... Compare internal move raises with outside offers, since bigger pay bumps pull people to outside jobs.
TL;DR
studied ............... Whether people who move inside a company stay longer, modeled on attrition for 1,470 employees. found ................. Each year without a promotion raises the odds of leaving by 15%. # by the numbers 1.15 ................ Odds ratio of leaving per year since promotion 19% ................. Left, same role since hire 12% ................. Left, changed roles the catch ............. Both HR datasets are synthetic, built for teaching. LinkedIn’s research carries the outside evidence. next .................. Turn the promotion model into a monthly list of people past three years with a matching open role.
LINKS
open internal mobility /studies/internal-mobility.pdf the analyst side ...... /machine/analyst
# end of /machine/internal-mobility-casestudy. andrew.leng.ly@gmail.com · leave machine mode