Skills mapping for consulting firms: method, template and tools

Skills mapping is a structured review of what every employee knows, at what level and with how much experience. The result is a shared picture of the skills your organisation has today and what is missing.

In a consulting firm, skills mapping is more than an HR exercise. Skills are what you sell. This guide gives you a six step method, a template to start from and an honest answer on when a spreadsheet is enough.

Skills mapping or skills inventory?

The terms are often used interchangeably, but they mean different things.

A skills inventory is a snapshot. You collect what everyone knows right now. Skills mapping goes one step further and compares what you have with what you need. That comparison reveals the gap, and the gap is what drives decisions on training, hiring or subcontractors.

The inventory is step one of the mapping. You need both.

Why consulting firms map skills differently

Most guides to skills mapping are written for HR in a typical organisation. There it is about development reviews and long term workforce planning. A consulting firm differs in three ways that change how you should do it.

Skills are the product. When a client asks for an architect with Azure and public sector experience, the answer should take minutes, not a round of emails to every consultant manager. Your skills map is your inventory.

Clients want evidence, not self assessment. A level on a scale is not enough in a proposal. Clients ask how many years, on which assignments and when the skill was last used. Skills mapping in a consulting firm must therefore connect to assignment history.

You need to be able to sell from it. The same data should become CVs, matches and a view of which deals you can take on. A skills map that only lives in an HR report generates no revenue.

There is a fourth difference. Many consulting firms staff projects with subcontractors and partners. The skills map then includes capacity you do not employ.

Skills mapping in six steps

1. Decide what the skills map is for

The purpose sets the level of detail. For sales and matching you need specific technologies, tools, industries and roles. For development planning, broader areas are enough.

Most consulting firms need both. Start with sales and matching. That is where skills mapping pays for itself fastest, and it gives consultants a reason to fill it in.

2. Build a shared list of skills

Without a shared list, one consultant writes “React”, another “React.js” and a third “frontend”. Nobody can search that. The list, often called a skills taxonomy, is the foundation for everything else.

Group the list into categories: technologies and tools, methods, roles, industries, languages and certifications. Start narrow. 150 well defined skills beat 1,500 duplicates. Let consultants suggest new skills, but let one person approve them.

3. Choose a level scale and define every level

A scale without definitions produces inconsistent answers. “Advanced” means different things to different people. Describe each level in terms of knowledge, experience, leadership and independence, as in the template below.

A five level scale of the kind used in public sector framework agreements for consulting services works well. Your skills map then speaks the same language as tender documents, and you do not have to translate levels every time you bid. Separate roles from technologies too. A project manager role requires more years than a single tool for the same level.

4. Let consultants fill it in and managers calibrate

Self assessment is the fastest method, but it needs a counterweight. The most common model is that the consultant fills in the profile and their manager reviews it in a short conversation.

Three things make consultants actually do it. Connect the skills map to their CV, so the work pays off immediately. Pre fill what you already know from existing CVs and assignments. And set a clear time box: around 30 minutes, with a deadline within two weeks.

5. Analyse the result against demand

This is where the inventory becomes a map. Look at three things.

Coverage: which skills do you have plenty of, and which are held by only one or two people? A skill that only one person has is a risk, however popular it is.

Gap against demand: compare with what clients actually ask for. Sales requests and lost deals are the best source. A skill clients ask for often that you lack is lost revenue every time.

Future needs: which skills will clients ask for a year from now? This takes leadership judgement, not just data.

6. Keep the skills map alive

A skills map updated once a year is out of date three months later. Build updates into what already happens. When an assignment ends, the consultant updates their profile. Once a quarter, each consultant manager reviews their team.

Track how many profiles have been updated in the last six months. It is the simplest measure of whether the skills map is alive.

Skills mapping template

The template has four parts. Copy the structure freely and adapt it to your business.

Category	Example skills
Technologies and tools	Azure, AWS, Java, Python, React, SAP S/4HANA, Power BI.
Methods	Scrum, SAFe, ITIL, Lean, service design.
Roles	Project manager, solution architect, test lead, Scrum Master, business analyst.
Industries	Public sector, banking and finance, energy, telecoms, life science.
Languages	English, Swedish, Finnish, German.
Certifications	PMP, AWS Solutions Architect, Azure Administrator, ISTQB.
Soft skills	Client communication, change management, workshop facilitation.

Part 2. Level scale

The scale has five levels and two variants: one for roles, one for technologies, tools, methods and processes.

Roles

Level	Knowledge	Experience	Leadership	Independence
1 Basic	Recently completed training in the area.	Short work experience, not used to consulting.	Needs supervision.	Can perform simple tasks independently.
2 Intermediate	Trained in the area, handles some complexity.	1 to 3 years as a consultant in the area, has taken part in or delivered several similar assignments.	Needs some supervision.	Can perform defined tasks independently.
3 High competence	High competence in the area.	4 to 8 years as a consultant in the area, role model for consultants at lower levels. At least 2 years at level 2.	Responsible for a sub area, can lead a small team.	Works independently.
4 Very high competence	Strong generalist, or very high competence in the area.	Has taken part in large assignments and delivered with very high quality. Normally reached after 9 to 12 years as a consultant. At least 2 years at level 3.	Leads larger teams.	Very high.
5 Expert	Top tier competence, recognised as an expert in the market.	As level 4, with at least 3 years at level 4.	Extensive experience in leading positions.	Very high.

Technologies, tools, methods and processes

Level	Knowledge	Experience	Leadership	Independence
1 Basic	Recently completed training in the area.	University studies or other experience.	Needs supervision.	Can perform simple tasks independently.
2 Intermediate	Trained in the area, handles some complexity.	Has used the skill in practice on an assignment.	Needs some supervision.	Can perform defined tasks independently.
3 High competence	High competence in the area.	Has used the skill on several assignments and is confident with it.	Works independently and can support colleagues.	Works independently.
4 Very high competence	Strong generalist, or very high competence in the area.	Has used the skill for several years in different environments and assignments.	Works independently and can lead and develop colleagues.	Very high.
5 Expert	Top tier competence, recognised as an expert in the market.	Has used the skill continuously for several years, in many environments, with expertise deep enough to be seen as an expert.	Can train, lead and coach new colleagues.	Very high.

Level 3 is the most important threshold in a consulting firm. That is where the consultant works independently and the skill becomes sellable.

Part 3. Skills matrix example

Consultant	Azure	Project management	Public sector	Power BI	Last on assignment
Amira Haddad	4 (6 years)	2	4 (5 years)	3	Current
Erik Lindqvist	1	5 (16 years)	3	1	2026
Priya Nair	3 (3 years)	1	1	5 (7 years)	2025

The matrix shows two things at once. Amira is the first choice for an Azure deal in the public sector. And only one person reaches level 4 or above in project management, which is a risk.

Part 4. What every profile should contain

Field	Why
Skill from the shared list.	Searchability
Level 1 to 5.	Comparability
Years of experience.	Clients ask
Last used.	Recency
Assignments where the skill was used.	Evidence in proposals and CVs.
Interest in developing.	Input to the development plan.

Spreadsheet or skills mapping software?

A spreadsheet works for a first inventory in a small firm. Below 20 consultants, with one person owning the file, it will take you a long way.

Five signs the spreadsheet has stopped working:

1. There are several versions of the file and nobody knows which is current.
2. Consultants stop updating it, because it gives them nothing back.
3. Sales asks consultant managers instead of searching themselves.
4. CVs are updated separately and say something different from the skills map.
5. You cannot see who is available when a skill is requested.

The last one is decisive. In a consulting firm, skills without availability are only half the answer. The right consultant, booked for the next six months, does not help the deal.

When choosing a tool, ask four questions. Can the skills map become a CV directly? Can sales search on skills and availability at the same time? Can subcontractors and partners be included? And does the profile update when an assignment ends, or does it take a separate effort?

How it works in Cinode

In Cinode, skills, levels and assignment history live in the consultant’s profile. The same data becomes the CV and the basis for matching against assignments.

You define the skills each role requires with skill sets and see the gap in a gap analysis. Each consultant’s development is tracked in a growth plan.

Nearly 10,000 companies use Cinode for free. It is the easiest way to use the template above without a spreadsheet.

Get started for free. Book a demo.

Frequently asked questions about skills mapping

What is skills mapping? A structured review of what employees know, at what level and with what experience, compared with what the business needs. The result shows both strengths and gaps.

What is the difference between skills mapping and a skills inventory? A skills inventory collects what everyone knows right now. Skills mapping compares that with demand and reveals the gap. The inventory is the first step of the mapping.

How long does skills mapping take? For an individual consultant, around 30 minutes if the profile is pre filled from CVs and assignments. For a whole consulting firm, typically two to four weeks including calibration with managers.

How often should a skills map be updated? Continuously when an assignment ends, with a team review every quarter. A yearly skills map is out of date within months.

Which level scale should we use? A five level scale where every level is described in terms of knowledge, experience, leadership and independence. Many consulting firms use the levels from public sector framework agreements. Separate roles from technologies, since the experience requirements differ.

How do we get consultants to fill it in? Connect the skills map to their CV so the work pays off, pre fill what you already know and set a clear deadline. Skills maps used only by HR rarely get filled in.

Is there a free skills matrix template? Yes. The template in this article contains a list of skills, a level scale, a skills matrix and profile fields, and is free to use. It can also be used directly in the free version of Cinode.

Read more

Skills mapping is one part of a wider approach to skills. The guide to skills management in consulting firms covers the whole picture, from mapping to matching and development.