As a Compensation Practitioner, there is a good chance that you are a fan of organizing and analyzing things — and job families are no exception.
Over the years, I have frequently had the need to organize job data into meaningful matrices so that I could quickly review and compare jobs across multiple families for internal equity and career progression. What I needed was a pivot-table, but for text, instead of numbers.
This excel tool, which you can download below, is exactly that!
This job family matrix creator allows you to load all of your Organization’s jobs, job families and subfamilies and salary grades into a spreadsheet, and then create pivot-table like reports that organized how jobs are aligned, by grade, across a job family and subfamily. Here’s an example of what this tool can do, below:
Think you might have some use for this? Enter your work email below and we’ll send you a link to download it!