Based on our initial analysis, Pewlett Hackard will have numerous retiring employees. In order to help the retiring employees' future, the company wants to intoduce a Mentorship program wherein eligible retiring employees will step back into a part-time role and mentor employees. Our analysis will determine how many retirees, according to their seniorty, will be eligible for the mentorship program.
Firstly, we need to create our retiree pool together with their respective titles. We extracted a sample from Pewlett Hackard's employee population (employees.csv) of people born between January 1, 1965 & December 31, 1965. We have compiled this data into retirement_titles.csv
With some employees having multiple titles within the company given their years of service (e.g. promotions, lateral movements, etc.), we use the DISTINCT ON fuction to eliminate their old titles and only consider their most recent ones. This has been compiled into the unique_titles.csv file. We then categorized and grouped retiring employees with their respective work titles. With this clean data,we can see retired and retiring employees without double booking an Employee's No.
Here we can see that a total of 90,398 employees have retired (based on their to_date) or will be retiring (only for current employees) soon.
For a retiring employtee to be eligible for mentorship, we have set our parameters as having their birth years be 1965 and are current employees. In our analysis only a total of 1,549 employees are eligible for mentors. See image below for the compilation seen in mentorship_eligibility.csv and their groupings according to titles. See image below for a breakdown of mentors accodring to their titles and its count.
If we are only to consider current retiring employees (birth years are from 1952-1955 & to_date = '9999'-01-01), there will exactly be 72,458 positions needed to be filled. With only 1,549 available mentors, it has a ratio of only 2%. This will not be enough to jumpstart the company's mentorship program.
It is highly recommended to increase the range of our mentors' birth years to help the transition.
See image below for additional queries done:
