Skills matrix template
List your team and the skills the work needs, rate each person from 0 to 4 and set a target level for each skill. The matrix shows every gap and every skill that rests on one person; copy it to Google Sheets or print it.
Data team
Below target At or above target
0 None · 1 Learning · 2 Working · 3 Advanced · 4 Expert, can teach it
How to use the skills matrix
- Start from the work. Pick the skills the team needs over the next year, not every skill anyone has. Five to ten columns stay readable.
- Set a target per skill. The level the team needs from the people who do that work. A skill the whole team uses daily needs 2 or more from most people; a specialist skill needs 3 or 4 from at least two.
- Rate from evidence. Let each person rate themselves, then agree the level with their manager from real work. A 4 means they could teach it.
- Read the columns. A skill with fewer than two people at target is a risk: one absence or resignation stops that work. Close it by training someone already at 2, or make it the core of the next hire and test it with a work sample test.
More on hiring for skills: skills-based hiring, structured interview questions and the competency framework template.
Questions
What is a skills matrix
A grid with people in the rows and skills in the columns. Each cell holds the level a person has in a skill, and each skill has the level the team needs. Read across a row and you see one person's gaps; read down a column and you see how many people can actually do that work.
How do I rate skill levels
Use one short scale for every skill and define each step by what the person can do, not by how long they have done it. This template uses 0 None, 1 Learning, 2 Working, 3 Advanced and 4 Expert. Rate from evidence, such as work samples, reviews or a check by someone at level 4, and let the person rate themselves first so the conversation starts from both views.
What is a skills gap analysis
The comparison between the skills a team has now and the skills it needs. The US Office of Personnel Management puts it at the centre of its five-step workforce planning model: build a picture of where gaps exist between the competencies people have and those the work will require, then choose how to close them, by training, hiring or redesigning the work.
How do I use a skills matrix in hiring
Look down the columns before you write a job ad. A skill with nobody at the target level, or with only one person, is what the next hire should bring. Then assess candidates on that skill with a work sample or structured interview questions rather than a line on a CV.