pgAdmin 4, PostgreSQL 12.7
In anticipation of the “silver tsunami” of baby boomer retirements, Pewlett Hackard is undertaking an analysis of upcoming retirements. Relatedly, PH is running a separate analysis of the potential for a mentorship program, whereby soon to retire employees mentor the next generation of leaders in the company.
- Figure 1a is a query which isolates all employees born between 1952 and 1955 inclusive. There are 133,776 results, but this includes duplicative employees who held different titles at different times.
- The query depicted in Figure 1b removes those duplicative titles, and only displays the latest title, implying it will be the retirement title. With 90,398 results returned, there are 1.5x more titles than employees, implying on average every other employee was promoted during the course of their respective careers at Pewlitt Hackard.
- Figure 1c highlights the number of retiring employees by their title. There are roughly 2x the number of ‘Senior’ Titles as the respective general titled brethren. The workforce is top-heavy, and is in need of right-sizing. That said, the employees who received promotions are likely higher quality employees, and may be the ones the company would prefer to keep.
- Figure 2, with 1,549 rows returned, or less than 2% of the retiring employees, represent the employees eligible for mentorship under the proposed program. There are plenty of mentors, but not very many available mentees.
Fig3aA: Total Retiring Employees Figure 3aA shows that total employees retiring number 90,398.
Fig3aB: Total Retiring Employees
The query depicted in Figure 3aB generated this value, and is simply the sum of the count of employees by title.
Fig3bA: Total Retiring Employees
Fig3bB: Unique Mentorship Titles
Fig3bC: Only Mentorship Titles
Fig3bDi: Retirement v Mentorship by Title
Fig3bDii: Retirement v Mentorship by Title Results
There are more than enough retirement ready employees prepared to mentor the next generation of leaders. The problem will be that there are not enough of the next generation of leaders to replace the outgoing retirees. Figures 3bA-Di build the query set, culminating in 3bDii, which shows that the mentorship eligible employees are generally only about 2% of retiring employees, a number that is consistent across titles, and indeed, across the company population as a whole.
Contact:
E-Mail: chrabach@gmail.com
Twitter: @chrabach