Skip to content

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