The purpose of the analysis is to determine the number of retiring employees per title, and identify employees who are eligible to participate in a mentorship program. Data was store and analysed using PostgreSQL database.
-
Retiring employees and their title
- In order to retrieve the titles for employees that fits the retirement criteria, we merged the employees table and the title tables by "employee number" for employees that are born between January 1st of 1952 to December 31st of 1955.
- Employees might contains multiple titles during their years in the company.
- To retrieve the current title of retiring employees, we sort the to_date in descending order and retrieve the first occurrence of the employee number.
- Total number of retiring employees by title was summarized.
-
Mentorship eligibility
- To identify employees who are eligible to participate in a mentorship program. We first selected employees who are employed currently using to_date, and are born between January 1, 1965 and December 31, 1965. Employee titles were listed.
- 90398 Employees who fit the retiring requirement with current title were listed, including 29414 senior engineers, 28254 senior staffs and 2 managers.
- 1549 current employees that are eligible for mentorship program.