A competency matrix is a table that cross-references the competencies required for each position with the current skill level demonstrated by each employee. It allows you to quickly identify skills gaps and decide what training is needed, who to reassign, and how to prepare for succession. Below you'll find the steps to create it, a template you can copy, and instructions on how to fill it with evidence, such as performance results. competency tests, and not just with opinions.
Table of Contents
What is a competency matrix and what is it used for?
The matrix has two axes. One lists competencies (knowledge, skills, and observable behaviors); the other lists positions or people. Each cell indicates a level: the level required for the position and the level the person possesses. The difference between the two is the gap.
It should not be confused with nearby pieces:
- Competency model: It defines which competencies the organization values and how they are described. The matrix translates this into specific positions and people.
- Job description: It explains roles and responsibilities. The matrix translates those roles into measurable competencies.
- Taxonomy of skills: Organize the entire vocabulary of company skills. If you don't already have it, the guide for build a skills taxonomy It's a good starting point; the matrix takes from there the skills that matter for each role.
A matrix is not a one-time document. The World Economic Forum estimates in its Future of Jobs Report 2025 That, on average, 39% of workers' current skills will be transformed or become outdated between 2025 and 2030. That is why the matrix calls for periodic reviews.
What types of skills should it include?
There is no single classification. A practical way to organize the catalog is into four groups:
- Technical or job-related: specific knowledge and tools (Excel, SQL, tax regulations, forklift operation).
- Soft skills or transversal skills: communication, teamwork, adaptability, critical thinking.
- Leadership: Team management, decision-making, people development. These skills only apply to certain positions.
- Organizational: those that the company expects from everyone and that reflect its culture, such as customer focus or integrity.
Within each position, it helps to distinguish between core and differentiating competencies. Lyle and Signe Spencer, in Competence at Work (1993) called the skills that any person needs to perform the job acceptably a threshold, and the skills that separate outstanding performance from average performance differentiators. The latter carry the most weight when deciding on promotions or successions.
How to build a competency matrix step by step
Step 1: Define the scope
Start with one area or job family, not the entire company: a pilot program lets you test the scale and format before scaling up. Also, decide what you'll use it for first (training, succession planning, mobility), because that changes the level of detail.
Step 2: Build the skills catalog
Gather the area leaders and two or three high-performing employees and ask what constitutes a good result in each role. Compare the results with job descriptions and external benchmarks. In Mexico, the CONOCER National Registry of Competency Standards It is an official catalog of standards that describe what a person needs to know and do to perform a function; it can help you write technical competencies using a proven language.
Limit the list. Between eight and twelve competencies per position is usually manageable; with thirty, nobody updates the matrix.
Step 3: Define a scale of domain levels
Each level should describe observable behavior, not adjectives. A five-point scale is common:
| Level | Name | What is observed |
|---|---|---|
| 0 | Without domain | She hasn't applied it at work |
| 1 | Essential | It is applied with guidance and frequent supervision. |
| 2 | Intermediate | It applies it autonomously in everyday situations. |
| 3 | Advanced | Solve complex or unusual cases without help |
| 4 | Expert | Teach others, define standards, or improve the process |
Next, write down what each level means for each competency. «Level 3 Communication» should say something like «presents findings to non-technical areas and adjusts the message according to the audience.».
How to set the required level and calculate the gap?
With the catalog and scale ready, three more steps are needed for the matrix to have useful data.
Step 4: Set the required level per position
With leaders, assign each position the level it needs in each competency. Not everything has to be at level 3 or 4: a junior analyst might require Excel at level 2 and negotiation at level 1. Inflating requirements creates artificial gaps and training plans that no one needs.
Step 5: Measure the current level with evidence
This is where the quality of the matrix comes into play: the current level must be based on comparable evidence, not a first impression. Below you will see which sources to use and how to combine them.
Step 6: Calculate the gap and validate
Subtract the current level from the required level. Review the results with each leader before making decisions: sometimes the gap reveals that the required level was incorrectly set, not that the person needs training.
Competency matrix template to copy
This template cross-references one position (data analyst) with three collaborators. You can copy it to a spreadsheet and repeat it for each position.
| Competence | Guy | Required level | Contributor A | Contributor B | Contributor C | Main evidence |
|---|---|---|---|---|---|---|
| Advanced Excel | Technique | 3 | 3 | 2 | 4 | Excel technical test |
| SQL | Technique | 2 | 1 | 2 | 3 | Practical exercise |
| Critical thinking | Cross | 3 | 2 | 3 | 3 | Situational test + case |
| Communication of results | Cross | 3 | 3 | 1 | 2 | Evaluated presentation + 360 |
| Internal customer focus | Organizational | 2 | 2 | 2 | 1 | Leader evaluation |
| Total gap (sum of deficits) | 2 | 3 | 2 |
How to read it:
- Individual gap: In each cell, if the current level is lower than the required level, the difference indicates a development need. Contributor B has a two-level gap in communicating results.
- Equipment gap: If several people fail in the same line, the problem is usually related to the process or collective training, not individual training.
- Strengths: Those who exceed the required level (the C collaborator in Excel and SQL) can be a mentor or a candidate for a position with more technical demands.
A practical tip: add a column with the date of the last measurement. A matrix with data from two years ago gives a false sense of control.
How to fill the matrix with evidence, not just self-perception?
Self-assessment can be useful for starting a conversation, but it has its limitations: people tend to respond according to what they believe is desirable, and those with limited mastery of a skill often have less judgment when assessing their own level. A matrix filled out solely in this way reflects perception, not mastery.
It combines several sources and gives more weight to those that observe behavior or results:
| Source of evidence | What does it contribute? | Limitation |
|---|---|---|
| Self-assessment | Personal vision, motivation to develop | Desirability and self-perception bias |
| Leader evaluation | Knowledge of daily work | Halo effect, poor comparability between leaders |
| 360 Evaluation | Various perspectives on observable behaviors | It requires confidentiality and good calibration |
| Technical and psychometric tests | Comparable results between individuals | You have to choose tests that are valid for the position |
| Work samples or cases | Direct evidence of performance | More expensive to design and qualify |
| Certifications | External recognition of a standard | They may not reflect the current level. |
Standardized tests offer what other sources lack: the same instrument, applied equally to everyone, with comparable results. They must have evidence of reliability and validity for their intended use, as required by the Standards for Educational and Psychological Testing from AERA, APA, and NCME. Platforms like Hirint apply psychometric and technical tests of skills and soft skills to measure the current level of each employee and bring it to the matrix; even so, the result of a test is just one more piece of data, and the final interpretation is made by the leader and HR.
What is the matrix used for: gaps, training, and succession?
A well-filled matrix feeds into several talent decisions:
- Gap detection: It shows what skills are lacking in an individual, a team, or an entire department. If you want to delve deeper, there's a guide for Identify talent gaps and close them with a strategic map.
- Training: Turn the gaps into a prioritized plan. Large gaps in critical skills come first; smaller ones can be addressed with mentoring or guided practice. To move from diagnosis to action, review how to work with the employee development with data.
- Internal mobility: allows you to find, within the company, people whose profile is already close to that of a vacancy. Thus the internal mobility It relies on evidence and not just on who is most visible.
- Succession: By comparing candidates for a key position against the required skill level, you can see who is ready today and who would be ready with a development plan. Many companies cross-reference this information with a 9-box matrix of performance and potential; he talent mapping extend that analysis to the entire organization.
- Selection: The required level for each position serves as a search profile and as a guide for structuring interviews.
Common mistakes and data safety
- Too many competitions: A long list becomes impossible to measure and maintain. Prioritize those that change decisions.
- Levels without description: If "level 3" is not defined by behaviors, each leader interprets it in their own way and the data is not comparable.
- Inflated requirements: Setting everything to the maximum level creates gaps that don't exist.
- Fill it out with self-assessment only: It produces an optimistic matrix that does not withstand the first difficult promotion.
- Use it to punish: If employees perceive that the matrix is used for firing people, they will respond defensively and the information will lose value.
- Do not update it: Without a review date, the matrix ages with the position.
One more thing to keep in mind: the results are personal data. In Mexico, the Federal Law on the Protection of Personal Data Held by Private Parties, The law, published in the Official Gazette of the Federation on March 20, 2025, subjects the processing of personal data to the consent of the data subject, except for the exceptions it provides. Inform collaborators about how the results will be used and who will see them, and review the case with your legal department according to applicable regulations.
A competency matrix doesn't make decisions for anyone; it organizes information so leaders and HR can make better decisions. If you'd like to see how to create your own with comparable results, you can schedule a meeting with the Hirint team.
Frequently Asked Questions
What is the difference between a competency matrix and a skills matrix?
In practice, they are often used interchangeably. When they are distinguished, the skills matrix typically focuses on specific technical skills, such as software or a language, while the competency matrix also includes behaviors and attitudes, such as leadership or communication. The important thing is that both define observable levels and are supported by comparable evidence.
How do you create a competency matrix in Excel?
Create a sheet for each position. In the rows, list the competencies; in the columns, the required level, and a column for each employee with their current level. Add a formula that subtracts the current level from the required level and conditional formatting to highlight any gaps. Add a column for evidence and another with the date of the last measurement.
How often is the competency matrix updated?
An annual review is a reasonable minimum, aligned with the performance cycle. It's advisable to update it sooner if job responsibilities change, a new tool is adopted, an area is restructured, or an employee completes a training program. Recording the date of each measurement helps identify which data is no longer reliable.
Who should participate in building the matrix?
HR coordinates and oversees the methodology, but the content is contributed by the leaders of each area and individuals with in-depth knowledge of the role. Including high-performing employees helps identify differentiating competencies. Final validation with the leaders ensures the matrix doesn't remain merely a theoretical HR exercise.