Employee Data Attrition Report
1 Introduction
This report commissioned by Merck Sharp & Dohme (MSD) Ireland to analyse employee data to uncover the key factors that may affect employee attrition. The report will aim to highlight the factors MSD would improve upon to increase the employee attrition rate.
2 Analysis and Commentary
2.1 Relationship between gender and attrition
The graph showcases the male employees tend to leave at a higher rate than female employees. The gives MSD an opportunity to hire more female employees as they tend to be more loyal
2.2 Does feeling valued lead to less or more employee attrition?
If employees are working for years without being rewarded, the employee will feel unappreciated and a lack of importance to a company.Employees that have not received a promotion in 10+ years working for MSD have a higher attrition rate
2.3 How many years are employees are staying in current roles?
Compared to those who departed, those who stayed had a higher median number of years. This suggests that people that leave tend to have short tenures working for MSD
2.4 Does gender effect job roles?
While both genders are represented in all the job roles, there is a number of jobs that lean towards certain genders. Female workers have a higher representation in Human Resources, Healthcare Representative, and Laboratory Technician* roles. while men have higher representation in Sales Executive, Research Scientist, and Manufacturing Director** roles.
2.5 Years at company vs years since getting a promotion
The distribution of the data points shows that majority of employees work in Research and Development. The charts shows that the concentration of employees work in the 0-20 year range with the exception of a few outliers. Many workers, especially in research and development, have not received a promotion in over five years which may be the cause of attrition in MSD.
2.6 Which department is most satisfied?
| Department | Average Job Satisfaction | Average Work-Life Balance | Average Salary Hike (%) | Number of Employees |
|---|---|---|---|---|
| Human Resources | 2.60 | 2.92 | 14.76 | 63 |
| Research & Development | 2.73 | 2.73 | 15.29 | 961 |
| Sales | 2.75 | 2.82 | 15.10 | 446 |
Research and Development has the largest number of employees and and receive higher salary increases which show that R&D is seen ad the most important department in MSD. The opposite could be said for HR as it has the lowest salary increase and job satisfaction levels.
2.7 How far do employees travel?
The vast majority of employees are based within 10KM of MSD offices located in Dublin Rd, Oakpark Or Painestown, Co. Carlow. This could be an advantage used to keep employees working here for longer.
2.8 Are employees staying long term if they are statisfied in their jobs?
Regardless of satisfaction level, retention efforts may need to concentrate on the first few years due to the amountof employees with short tenures.
2.9 What are our employees educated in?
While both genders are represented in the different education fields, the is a clear in balance that leans towards men. The education field that is most hired tend to fall into the R&D department.
2.10 Is it easier to train the younger or older employee
Employees in the 18-25 age bracket takes significantly more time to train. This is to be expected as many people in this age bracket are just entering the first job. An unexpected finding is that it takes significantly less training for employees in the 50+ age bracket showing these employees that adapt to the times and use the past experience to learn new information.
3 Conclusion
The analysis of MSD Ireland’s employee data has helped us identify a number of key findings may may play a factor in employee attrition and overall employee satisfaction. The main takeaways from the research conducted are
Male employees have a higher rate of leaving copared to female employees. This creates an opportunity to hire more female workers to combat gender in balance in the workplace and gain employees that tend to leave at a lower rate.
Employees that have not received a promotion in a number or years tend to leave at a higher rate than those who have been promoted in the same time period. Employees need to feel valued if a business wants to retain their service long-term
With greater pay increases and job satisfaction, research and development is the largest and most rewarded department. HR, on the other hand, has lower salary increases and lower satisfaction. Under performing departments should receive attention in order to boost employee satisfaction and morale.
The majority of employees come from a Life Sciences and Medical education background which aligns with MSD as they have a heavy focus on producing pharmaceuticals.
4 Bonus Meme
