The purpose of our project is to determining the number of retiring employees per title, and identify employees who are eligible to participate in a mentorship program. After writing a report that summarizes your analysis to helps prepare manager for the as many current employees reach retirement age of current employees who were born between January 1, 1952 and December 31, 1955.
- Deliverable 1: The Number of Retiring Employees by Title
- Deliverable 2: The Employees Eligible for the Mentorship Program
- Deliverable 3: A written report on the employee database analysis
PostgreSQL pgAdmin
- The tables will indicate their birth and hiring date to better understand the age demographic of each employee in each postion
- There are 300,024 opening available for new hires
- Senior Engineer(29,414) has the most job openings and Manager the least (2)
- There are 1,940 employees that are eligibile for the mentorship program
The amount of roles that will need to be filled as people retire is 1,549. This is such a high number of people retiring and require that there be more time to develop new hiring. However, if more information could be collected to see why they are retiring or to give them more support through the mentoring program. The company may have to pay more to keep those from retiring to maintain their experience insight instead of finding and training new hires for high level positions There are enough qualified, retirement-ready employees in the departments to mentor the next generation of Pewlett Hackard employees there may not be enough new hire.