Free Skill Matrix Template for Excel & Google Sheets | HR Gap Analysis Tool
Free Skill Matrix Template for Excel & Google Sheets | HR Gap Analysis Tool
An HR skills matrix is a table that maps the competencies each HR role needs at every level, from junior to lead. This HR skills matrix template comes filled in for HR Ops, Recruiter, HRBP, and People Lead — with behavioral anchors, SHRM and CIPD references, and the DACH compliance rows for Works Council law, GDPR, and the EU AI Act.
Only 50% of HR teams are confident they have the right skills to deliver real business impact, according to the AIHR Future-Ready HR Skills Report, based on 13,665 HR professionals. At the same time, 85% of CHROs name people analytics a strategic priority (Insight222 / myHRfuture). That gap between ambition and capability is the real problem — and a generic skills spreadsheet won't close it.
What makes this article different: it's not another how-to on building a matrix. It's the finished result — role-specific for the four core HR functions, with concrete behavioral anchors from junior to lead.
You'll get:
- A filled-in HR skills matrix for HR Ops, Recruiter, HRBP, and People Lead across four levels
- Behavioral anchors per level — what junior, mid, senior, and lead actually mean
- The DACH compliance rows: Works Council law (§94 BetrVG), GDPR in an HR context, and EU AI Act Article 4
- Reference frameworks for orientation: SHRM BASK 2025 and the CIPD Profession Map
- A clear decision guide: when a spreadsheet is enough — and when you need a tool
For the general build process (mapping roles, choosing a scale, calibration), see our ultimate guide to successful skill management. This article picks up where that process ends: with the populated content.
The Four Core HR Roles and Why Each Needs Its Own Matrix
The most common mistake is a single spreadsheet for the whole HR team. A recruiter then gets rated against HRBP standards — and vice versa. Each of the four core roles has a different center of gravity, and that center decides which competencies sit at the top of its matrix.
HR Ops Specialist — Process Reliability, Compliance, Data Quality
HR Ops carries the operational load: payroll, benefits, HRIS data quality, GDPR-compliant data processing. The matrix weights HR operations, data protection, and systems expertise heavily; stakeholder influence and org design only matter at lead level.
Recruiter / Talent Acquisition — Pipeline, Sourcing Depth, Candidate Experience
The recruiter lives on sourcing depth and pipeline control. Boolean search, ATS management, and — increasingly — the critical use of AI-driven screening tools are central. Employment law is needed in breadth, not at HRBP depth.
HR Business Partner (HRBP) — Stakeholder Influence, Change, Conflict Resolution
The HRBP works through advisory. Employee relations, Works Council consultation, and stakeholder management dominate the matrix. Moving from mid to senior, data literacy is the biggest bottleneck according to AIHR's analysis of HRBP skills — HRBPs show the lowest affinity for data and digital tools.
People Lead / Head of People — Strategy, Org Design, C-Level Advisory
The People Lead matrix weights strategy, people analytics, and the negotiation of works agreements most strongly. Here every competency shifts from doing to designing and owning.
| Role | Primary Competency Family | Secondary Relevance | Target Output |
|---|---|---|---|
| HR Ops Specialist | HR Operations, GDPR, HRIS | Employment law basics | Error-free, audit-ready processes |
| Recruiter / TA | Sourcing, ATS, AI tools | Stakeholder alignment | Full, high-quality pipeline |
| HRBP | Employee Relations, BetrVG, Business Partnering | People Analytics | Effective leadership advisory |
| People Lead | People strategy, Analytics, Works agreements | all families at lead level | People strategy tied to the business |
The Filled-In HR Skills Matrix for All Four Roles
This is the core of the article: a populated matrix across eleven competency families and four roles. The scale follows the proven four-level logic (L1 junior to L4 lead), which avoids middle bias. Every cell names the expected behavior — not an abstract number. Read the matrix column by column per role and use it as a starting point you adapt to your own organization.
Here's how the leveling reads across all families:
- L1 — Junior: works from templates under guidance, knows the basics
- L2 — Mid: handles day-to-day work independently, escalates edge cases
- L3 — Senior: takes ownership, makes decisions, coaches juniors
- L4 — Lead/Principal: sets standards, negotiates, owns accountability toward leadership and regulators
| Competency Family | HR Ops (L1→L4) | Recruiter / TA (L1→L4) | HRBP (L1→L4) | People Lead (L1→L4) |
|---|---|---|---|---|
| Recruiting & Sourcing / ATS | L1: maintains ATS data · L4: defines ATS workflows | L1: runs structured phone screens · L2: Boolean search independently · L3: sourcing strategy for niches · L4: sets team sourcing standards, RPO contracts | L1: knows sourcing basics · L3: advises on hiring strategy | L4: owns the overall TA strategy |
| HR Operations / Payroll & Benefits | L1: maintains HRIS, supports onboarding · L2: monthly payroll for ≤100 staff independently · L3: runs audits, benefits design · L4: shapes HR Ops processes, SLA management | L1: knows the handoffs to HR Ops | L2: understands payroll impact of actions | L4: owns the HR Ops target picture |
| Employee Relations & Employment Law | L1: knows the basics of anti-discrimination law | L1: knows discrimination rules in recruiting | L1: knows when to involve the Works Council · L2: supports disciplinary measures · L3: mediates conflicts between department heads · L4: negotiates social plans | L4: shapes the organization's ER governance |
| Works Council Law / §94 BetrVG (DACH) | L2: knows which measures need approval | L1: knows co-determination on selection guidelines (§95) | L1: knows co-determination rights · L2: prepares §94 documentation · L3: leads §94 negotiation independently · L4: shapes works agreements | L4: negotiates with the central Works Council, conciliation board |
| GDPR & HR Data Protection (DACH) | L1: knows GDPR applies · L2: applies purpose limitation · L3: documents technical measures, runs a DPIA for HR systems · L4: owns the data protection concept for the HR systems landscape | L2: handles candidate data GDPR-compliant | L3: advises on employee data protection | L4: owns HR data protection toward DPO and leadership |
| HR Analytics & Data Literacy | L2: builds reports from the HRIS | L2: reads funnel metrics (time-to-fill) | L1: reads dashboards · L3: links HR data to business KPIs | L1: understands core metrics · L3: builds people analytics dashboards · L4: defines people-metrics strategy, predictive for succession |
| HR Technology / HRIS / ATS | L3: owns HRIS data quality · L4: leads HRIS selection | L3: optimizes ATS configuration | L2: uses HR systems confidently | L4: defines the HR tech roadmap |
| AI Literacy / EU AI Act Art. 4 | L2: critically reviews AI recommendations in the HRIS | L1: understands AI-driven CV screening, knows human oversight is required · L2: reports bias incidents · L3: assesses tools against Art. 4 criteria · L4: owns AI bias control in recruiting | L2: advises on the human final decision | L4: defines a company-wide AI literacy standard for HR |
| Stakeholder Management & Business Partnering | L2: aligns with business units | L2: steers hiring managers | L1: supports one department from templates · L2: advises several leaders proactively · L3: influences director level, steers reorganizations · L4: advises C-level | L4: ties people goals to business OKRs |
| People Development & Coaching / L&D | L1: supports development planning from a template | L2: shares sourcing know-how | L2: runs development conversations · L3: coaches leaders on performance management | L3: designs career frameworks · L4: builds mentoring/succession programs |
| Change Management & Org Design | L3: supports process changes | L3: adapts sourcing to reorganizations | L3: steers complex reorganizations operationally | L4: owns org design at the company level |
| DE&I in HR Practice | L2: implements inclusive processes | L2: applies inclusive sourcing · L3: builds a diversity pipeline | L3: advises leadership on inclusive practice | L4: owns the DE&I strategy |
Adapting it in Excel or Google Sheets: Put the families as rows and create separate columns or tabs per role. For each skill, add fields for current level (self), current level (manager), target level, evidence, and review date. Sparse cells are intentional: where a family barely applies to a role, it stays thin on purpose — that's the difference from a generic one-size table.
What Junior, Mid, Senior, and Lead Actually Mean — Two Examples
Numeric levels alone say little. Behavioral anchors make them calibratable. Two DACH-relevant examples show how granular the steps should be.
HRBP along "Employee Relations & BetrVG"
- L1: Knows which measures require approval and raises questions early.
- L2: Prepares §94 documentation and supports Works Council meetings.
- L3: Runs the §94 negotiation independently and documents the outcome audit-ready.
- L4: Shapes works agreements and negotiates social plans during restructuring.
Recruiter along "Sourcing & AI Tools"
- L1: Uses the standard ATS search and knows Boolean basics.
- L2: Runs Boolean search on LinkedIn/Xing independently.
- L3: Develops sourcing strategies for niche profiles and reviews AI tools critically (Art. 4 awareness).
- L4: Sets team sourcing standards, manages agency/RPO contracts, and owns AI bias control.
Calibration rule of thumb: a level counts only when a concrete behavior is evidenced — not when someone "could in principle" do it. That's exactly why every rating carries an evidence field.
DACH Compliance in the HR Skills Matrix — BetrVG, GDPR, EU AI Act
These three rows separate a DACH-ready matrix from any international template. They aren't optional; they're legally grounded.
§94 BetrVG — Works Council Approval for Assessment Principles
A skills matrix is, at its core, a general assessment principle. Under Section 94(2) of the German Works Constitution Act (BetrVG), establishing general assessment principles requires the Works Council's approval; if no agreement is reached, a conciliation board decides. If the matrix is introduced without approval, the Works Council can — under the settled case law of the German Federal Labour Court (BAG) — demand that its application be stopped. In practice: involve the Works Council early, pilot it, and capture the outcome in a works agreement — not after the rollout.
GDPR & Section 26 BDSG — Skill Data Is Personal Data
Competency ratings are personal data. That means purpose limitation, data minimization, and a clear access concept: who may see which rating? As a rule, the assessing manager and HR — not arbitrary third parties without a legal basis. At senior level, a data protection impact assessment for the skill-management system belongs in the matrix; at lead level, the data protection concept for the entire HR systems landscape.
EU AI Act Art. 4 — AI Literacy as an Obligation for HR Teams
HR departments that use AI-driven recruiting tools (CV ranking, screening algorithms) qualify as deployers under the EU AI Act. Under Article 4 of the EU AI Act, providers and deployers must ensure their staff have a sufficient level of AI literacy. The obligation has applied since 2 February 2025; enforcement by authorities begins on 3 August 2026. That's exactly why "AI literacy" is its own matrix row — from the junior who knows the human-oversight obligation to the lead who documents the literacy measures for an audit.
HR Career Paths — From Junior to Lead
The matrix shows not just the current state but the path upward. Two established frameworks give orientation without reinventing the wheel.
- SHRM BASK 2025: Nine behavioral competencies — including Leadership & Navigation, Ethical Practice, Consultation, and Critical Evaluation — form a cross-role base. They work well as a horizontal layer every HR role should master beyond a certain level (SHRM BASK).
- CIPD Profession Map: Core Knowledge plus Core Behaviours across four impact levels (Foundation to Chartered Fellow) give European teams a clean junior→lead logic (CIPD Profession Map).
| From → To | Critical Skill for the Transition |
|---|---|
| HR Ops L2 → L3 | Taking on independent audits and GDPR ownership |
| Recruiter L2 → L3 | Sourcing strategy over individual sourcing; critical AI tool use |
| HRBP L2 → L3 | Data literacy — the biggest bottleneck on this step per AIHR |
| HRBP / People Lead L3 → L4 | Negotiating works agreements, C-level advisory |
Common Mistakes When Using HR Skills Matrices
Four mistakes are HR-specific — and costly:
- Overlooking the BetrVG obligation. Introduced without §94 approval, the matrix is challengeable. Fix: involve the Works Council before rollout, sign a works agreement.
- No GDPR concept. Without an access and deletion concept, rating data becomes a liability. Fix: define purpose limitation, set access rights, run a DPIA at senior level.
- One matrix for all roles. The recruiter gets rated against HRBP criteria — the result is unfair scores. Fix: separate columns/tabs per role, as in the matrix above.
- AI tools without an Art. 4 check. Screening algorithms without documented AI literacy are a compliance risk. Fix: keep AI literacy as its own row and document the literacy measures.
When a Spreadsheet Is Enough — and When a Skill-Management Tool Makes Sense
For a small, stable HR team, a well-maintained Excel or Google Sheets template is perfectly sufficient. As soon as review frequency, HRIS integration, audit trails, and Works Council evidence grow, the spreadsheet hits its limits.
| Criterion | Spreadsheet is enough | Dedicated tool makes sense |
|---|---|---|
| Team size | up to ~30 people rated | multiple teams, many roles |
| Review frequency | annually | quarterly with reminders |
| HRIS integration | not needed | data should flow automatically |
| Audit / BetrVG evidence | manually documentable | audit-proof history required |
If you're weighing the jump, compare vendors systematically rather than buying on instinct. Our skill-management software comparison for 2025 offers a compact decision guide with pricing and an RFP checklist. Sprad Atlas identifies gaps automatically via a large skills taxonomy — useful mainly when manual upkeep of the matrix becomes the bottleneck. For a market overview, see the skills and competency management category.
Conclusion
Three things decide how useful your HR skills matrix becomes:
- Role-specific, not generic. HR Ops, Recruiter, HRBP, and People Lead each need their own columns — use the filled-in matrix above as a starting point.
- Behavioral anchors over numbers. A level only counts once the behavior is backed by evidence.
- DACH compliance is mandatory, not optional. BetrVG (§94), GDPR, and EU AI Act Art. 4 belong in the matrix as their own rows.
Next steps: adopt the matrix and adapt it to your roles, run the DACH check (Works Council approval + GDPR concept) before rollout, and schedule a first calibration workshop with your managers.
Frequently Asked Questions (FAQ)
What competencies does an HRBP need?
The center is employee relations, Works Council consultation, and stakeholder management. The nine SHRM BASK competencies (such as Consultation, Relationship Management, Critical Evaluation) serve as a behavioral base, and the CIPD Profession Map orders them across four impact levels. The biggest bottleneck on the way from mid to senior HRBP is, per AIHR, data literacy — HRBPs show the lowest affinity for data and digital tools.
How does an HR Ops matrix differ from an HRBP matrix?
The HR Ops matrix weights HR operations, payroll/benefits, GDPR, and HRIS heavily; stakeholder influence only matters at lead level. The HRBP matrix flips that: employee relations, BetrVG negotiation, and business partnering dominate, while payroll appears only as basic knowledge. That's exactly why no shared spreadsheet works for both roles.
Does the Works Council have to approve an HR skills matrix?
As a rule, yes. A skills matrix is a general assessment principle whose establishment requires Works Council approval under Section 94(2) BetrVG; if no agreement is reached, a conciliation board decides. Without approval, the Works Council can — under the settled case law of the German Federal Labour Court (BAG) — have its application stopped. Involve it early and capture the outcome in a works agreement.
How do I include AI competencies in my HR matrix?
As a dedicated row with four levels. Background: HR teams that use AI-driven recruiting tools qualify as deployers under Article 4 of the EU AI Act and must ensure their staff have sufficient AI literacy. The obligation has applied since 2 February 2025, with enforcement from 3 August 2026. In the matrix this ranges from the junior (knows the human-oversight obligation) to the lead (owns and documents the literacy measures).
How often should an HR skills matrix be updated?
Quarterly during fast growth, annually in stable organizations — what matters is the commitment. Update it additionally on triggers: new roles, new tools (ATS, LMS), or new competencies such as AI-driven sourcing. That keeps the matrix a living management instrument rather than an archived file.
Jürgen Ulbrich
Jürgen Ulbrich has more than a decade of experience in developing and leading high-performing teams and companies. As an expert in employee referral programs as well as feedback and performance processes, Jürgen has helped over 100 organizations optimize their talent acquisition and development strategies.
