In my company there are 15000 employees currently out of which 3000 are engineers with different years of experience.
Over the last 10 years the company has approximately 40000 employees out of which there are around 6000 engineers who joined and then resigned during this period.
My present HRMS application has unique entry for all these 40000 employees along with their salary details.
The salary details of the 3000 engineers are also included here. However their salary range is not fixed. It varies on their experience, trade, soft skills etc.
Over the 10 years the monthly salary range for engineers vary from $ 8000 - $ 40000. The salary range for them in last 5 years is between $ 27000 - $ 40000
I am designing a new Recruitment application that needs to have the average salary for each job title.
So here's the confusion. If I need to know the current average salary of engineers, what will be the most accurate logic? A direct average salary of the 3000 engineers will not help due to the high variation.
Thanks in advance !!!!