6 Simple Pay Health Checks for EU Pay Transparency Readiness. Part Two: How to Analyse Gender Pay Gaps by Job Category

SkillsTrust Team

• 4 minute read

Every company has pay anomalies, but with the incoming EU Pay Transparency Directive, it’s important that employers are proactively trying to identify those anomalies before 2026. If you’re struggling to know where to start, have no fear! There are simple Excel analyses you can run to get a view of the pay health of your company.  

This is the second installment of our content series where we show you how to prepare your data and perform six easy checks in Excel to evaluate pay practices and uncover any inconsistencies. 

In this article, we will focus on calculating the pay gap per job category. There are two prerequisites for this analysis: 

  1. Simple job categories

  2. 12-month pay dataset.

Our first article details how to prepare your data for analysis, so make sure you check that out if needed. 

Once your data is prepared, we can start our first pay health analysis: Gender pay gap per job category.  

The purpose of running this analysis is to identify any job categories with male/female pay differences that are greater than 5%. Any category with a gender pay gap of  5% will have to be reviewed to understand why the gap exists and whether those reasons are objective and unrelated to gender. 

Note: The spirit of the EU Pay Transparency Directive is that pay differences should not be based on gender. Given this, we recommend investigating any pay gaps of 5% or more - whether in favour of men or women - to understand their underlying causes. 

Why 5%

Under the EU Pay Transparency Directive, a pay gap of 5% or more in any job category either needs to be objectively justified or remedied. If an unjustified pay gap of 5% or more is not remedied within 6 months, a joint pay assessment with employee representatives may be triggered. See Article 10 of the Directive for further details on Joint Pay Assessments.

How to get started

Assign every role in your company to a job category. Then calculate the average hourly pay for men and for women for each job category. 

Using the following formula, calculate the gender pay gap for the category: 

Article content

What to look for

The result will be a percentage value that is either a positive or negative number. Positive numbers are pay gaps in favour of men i.e. a 10% pay gap means that on average, men are paid 10% more in that category. Negative results are pay gaps in favour of women i.e. a -10% pay gap means that on average, women are paid 10% more in that category. 

Flag any job category with a gender pay gap greater than 5% (either in favour of men (positive value) or women (negative value)). These categories should be added to a risk list and reviewed to understand the root causes driving the pay gap.

Worked Example

In this example, we're looking at the Engineering 2 job category. This category has 3 roles in it: Graduate Software Developer, Graduate Software Engineer and IT Support Technician. For the purpose of pay transparency analysis, these roles are in the same job category. This means that they represent work of equal value and are considered to be comparators for pay-setting. 

The data shows a cluster of female employees at the lower end of the pay range (around €20k–€25k) in the IT Support Technician role, as well as the Graduate Software Developer role (€27k-€32k). Male employees are more concentrated in the mid to upper end of each role's pay scale. 

When we calculate the averages at a category level (i.e all roles together), women earn €33,391 on average compared to €37,102 for men. This results in a pay gap of 10%, meaning men in this category earn more overall. 

As the pay gap is greater than 5%, this needs to be investigated to understand what might be driving this pay gap.

Factors that may be driving a pay gap within the job category include: 

  • Miscategorised roles - there may be  roles within the job category that have been miscategorised during the job evaluation stage. If the pay range for one role differs significantly from the ranges for other roles in the same category, it may indicate that the role has been miscategorised by job family and/or job level. If the role has indeed been appropriately categorised, then a justification is required for why the pay range would be so different to the other roles. 

  • Individual Differences in Tenure, Experience, or Performance. Positioning of employees within a pay range should be guided by objective factors (ex. time in role, total experience, performance rating). Depending on the company’s method for determining pay range positioning, employees with less tenure or experience may be positioned lower in the range, while those with longer service and/or stronger performance are higher. However, if one gender is disproportionately represented among newer employees, has less prior experience, or holds fewer top performance ratings, this can contribute to a pay gap even when positioning criteria are objectively applied.

  • Representation & Small Numbers. When there are very few men or women in a job category, even small differences in individual pay levels can create a large percentage gap. For example, if only a few employees of one gender are in the group, one higher or lower salary can significantly skew the average.  Applying objective pay range positioning  rules can help confirm whether the gap is meaningful or simply a result of limited representation.

  • Part-time Work Penalty. When you look at the pay of all employees within the same job category on a normalised basis (i.e. per hour or if everyone was on the same full-time contract), it may be the case that those working part-time are making less than their full-time counterparts. 

  • Uneven Bonus and BIK participation. The EU Pay Transparency Directive takes an expansive view of total pay including base, bonus and BIK (benefits in kind). Base salaries may be consistent but inconsistencies in participation across bonus and BIK may be a factor driving the pay gap. 

  • Biased Pay-Setting. If you are still left with unexplained job category-level pay gaps, it may be an unconscious bias in pay-setting. 

Check out our previous article about pay gap drivers to dig deeper into these drivers and how to close the pay gap. 

How Do You Know if a Category-Level Pay Gap of 5% Is Justified or Not? 

The EU Pay Transparency Directive outlines that where a job category has a pay gap of 5% or more, it either needs to be justified based on objective, gender-neutral criteria. If there are no objective gender neutral reasons for a pay gap greater than 5%, the pay gap must be remedied within 6 months. You can read more about this in Article 10 of the Directive. 

To thoroughly understand your pay gaps, deeper analysis such as adjusted pay gap analysis using regression or pay gap decomposition can be very helpful. These techniques require dedicated expertise or software. 

As a starting point, a lot of value and insight can be derived from simply checking the pay gap per job category. 

Our next articles will dive into deeper analysis such as job category outliers, bonus & BIK participation and comparative pay across job families. 

You can book a call to speak with our team here if you have any questions. 

Related Articles

Read more articles

Michelle Dervan

2 Nov 2026

All About Averages | Pay Analytics 101

The Importance of the Average When talking about pay data, the term average appears time and time again, but what does it actually mean? Put simply, an average salary gives us one figure to help describe pay across a group of employees. It takes all the salary values from that group and calculates a figure that would represent a ‘typical’ employee in that group. This is useful because it allows us to compare pay between different employee groups without having to look at every individual salary. The average can become an even more powerful metric when we begin to understand and analyse the different ways it’s calculated. It might seem counterintuitive that a figure like the average can be calculated in different ways and possibly provide different answers. After all, how can the same set of salaries produce different averages? The key is that each method looks at the data differently, helping us bring a different part of the picture into focus. There are two types of average that are particularly important when it comes to understanding pay: the mean and the median. So, how do they work, and what can each tell us about pay? Let's introduce them using a simple example company, PeopleTech Ltd. The Mean: What would everyone earn if pay were shared equally? The mean is what many people think of when they hear the word average. It shows us what each employee would earn if the company's total pay were shared equally among everyone. In everyday conversation, the terms mean and average are often used interchangeably. However, this isn't technically accurate, as the mean is just one of the ways to calculate an average, as we'll explore later on. To calculate the mean, we simply add together all the salaries and divide the total by the number of employees. Let's look at the example company, PeopleTech Ltd. Imagine the five employees earn the following annual salaries: €30,000 + €40,000 + €40,000 + €50,000 + €100,000 = €260,000 PeopleTech Ltd. has a total annual salary bill of €260,000 across its five employees. To calculate the mean, we divide this total by five: €260,000 ÷ 5 = €52,000 So, the mean salary at PeopleTech Ltd. is €52,000. In other words, if the company's total salary bill were shared equally between all five employees, each person would receive €52,000. The mean is useful because it gives us an overall picture of pay across the company. However, as we'll see, it doesn't always reflect what most employees actually earn, particularly when there are significant differences between the highest and lowest salaries. The Median: What is the salary in the middle? But what happens when one or two employees earn significantly more than everyone else? This is where the median can give us a different perspective. While the mean looks at the total of all salaries, the median looks directly at the middle of the data. Imagine arranging all our employees in a straight line, from the lowest-paid to the highest-paid. The salary of the person standing in the middle would represent our median salary. Let's look at PeopleTech Ltd. again. Using the same salaries as before, we arrange them from lowest to highest: €30,000 | €40,000 | €40,000 | €50,000 | €100,000 The middle salary is €40,000, making this the median salary for PeopleTech Ltd. What makes the median particularly useful is that it is not affected by unusually high or low salaries, often referred to as outliers. In our example, let's assume the €100,000 salary belongs to the CEO, which is double the next highest salary. This unusually high salary pulls the mean upwards, making the average salary appear higher than what most employees actually earn. The median, however, is not affected by this unusually high salary. At €40,000, it gives us a different perspective on what a typical employee earns in PeopleTech Ltd. This is particularly useful for HR professionals because it helps us understand what employees typically earn, without the results being skewed by a small number of particularly high or low salaries. Neither figure is wrong. They simply tell us different things about how pay is distributed across the company. Looking at both together gives us a more complete picture than relying on either one alone. One thing to note: when there is an even number of employees, there won't be one person sitting exactly in the middle. In this case, we take the two middle salaries and calculate their average to find the median. How does this all relate to the EU Pay Transparency Directive? The EU Pay Transparency Directive requires employers to report on both the mean and median gender pay gap. These gaps are calculated by finding the average pay for male employees and the average pay for female employees, and then measuring the difference between them. The difference is expressed as a percentage of men's average pay. For example, a gender pay gap of +10% means that women's average pay is 10% lower than men's average pay. But why does the Directive want to look at both figures? The size of a company's mean gender pay gap and median gender pay gap can tell us different things about how pay is distributed across the organisation. If a company's mean gender pay gap is larger than its median gender pay gap, this could suggest that higher-paid employees are having a greater influence on the overall gap. Think back to our PeopleTech Ltd. example, where the CEO's €100,000 salary pulled the mean upwards. A similar effect could occur in an organisation where the pay gap between most male and female employees is relatively small, but a highly paid position, such as the CEO role, is occupied by a man. Even though the difference in pay across the wider workforce may be relatively modest, this one high salary could pull the mean upwards and result in a much larger overall gender pay gap. On the other hand, if a company's median gender pay gap is larger than its mean gender pay gap, this could suggest that the difference in pay is more evident across the wider workforce, rather than being driven primarily by a small number of highly or lower paid positions. In other words, the gap may be more noticeable among employees around the middle of the pay distribution, rather than being concentrated at the top. This could highlight wider differences in how men and women are paid across the organisation, and may warrant further investigation. It is important to remember that neither the mean nor the median tells us exactly why a gender pay gap exists. They are indicators that help us identify patterns and differences in pay, rather than explanations in themselves. By looking at both measures together, HR professionals can begin to build a clearer picture of pay within their organisation, identify areas that may need further investigation and take a more informed approach to understanding and addressing any gaps.

Read article

Michelle Dervan

2 Nov 2026

All About Averages | Pay Analytics 101

The Importance of the Average When talking about pay data, the term average appears time and time again, but what does it actually mean? Put simply, an average salary gives us one figure to help describe pay across a group of employees. It takes all the salary values from that group and calculates a figure that would represent a ‘typical’ employee in that group. This is useful because it allows us to compare pay between different employee groups without having to look at every individual salary. The average can become an even more powerful metric when we begin to understand and analyse the different ways it’s calculated. It might seem counterintuitive that a figure like the average can be calculated in different ways and possibly provide different answers. After all, how can the same set of salaries produce different averages? The key is that each method looks at the data differently, helping us bring a different part of the picture into focus. There are two types of average that are particularly important when it comes to understanding pay: the mean and the median. So, how do they work, and what can each tell us about pay? Let's introduce them using a simple example company, PeopleTech Ltd. The Mean: What would everyone earn if pay were shared equally? The mean is what many people think of when they hear the word average. It shows us what each employee would earn if the company's total pay were shared equally among everyone. In everyday conversation, the terms mean and average are often used interchangeably. However, this isn't technically accurate, as the mean is just one of the ways to calculate an average, as we'll explore later on. To calculate the mean, we simply add together all the salaries and divide the total by the number of employees. Let's look at the example company, PeopleTech Ltd. Imagine the five employees earn the following annual salaries: €30,000 + €40,000 + €40,000 + €50,000 + €100,000 = €260,000 PeopleTech Ltd. has a total annual salary bill of €260,000 across its five employees. To calculate the mean, we divide this total by five: €260,000 ÷ 5 = €52,000 So, the mean salary at PeopleTech Ltd. is €52,000. In other words, if the company's total salary bill were shared equally between all five employees, each person would receive €52,000. The mean is useful because it gives us an overall picture of pay across the company. However, as we'll see, it doesn't always reflect what most employees actually earn, particularly when there are significant differences between the highest and lowest salaries. The Median: What is the salary in the middle? But what happens when one or two employees earn significantly more than everyone else? This is where the median can give us a different perspective. While the mean looks at the total of all salaries, the median looks directly at the middle of the data. Imagine arranging all our employees in a straight line, from the lowest-paid to the highest-paid. The salary of the person standing in the middle would represent our median salary. Let's look at PeopleTech Ltd. again. Using the same salaries as before, we arrange them from lowest to highest: €30,000 | €40,000 | €40,000 | €50,000 | €100,000 The middle salary is €40,000, making this the median salary for PeopleTech Ltd. What makes the median particularly useful is that it is not affected by unusually high or low salaries, often referred to as outliers. In our example, let's assume the €100,000 salary belongs to the CEO, which is double the next highest salary. This unusually high salary pulls the mean upwards, making the average salary appear higher than what most employees actually earn. The median, however, is not affected by this unusually high salary. At €40,000, it gives us a different perspective on what a typical employee earns in PeopleTech Ltd. This is particularly useful for HR professionals because it helps us understand what employees typically earn, without the results being skewed by a small number of particularly high or low salaries. Neither figure is wrong. They simply tell us different things about how pay is distributed across the company. Looking at both together gives us a more complete picture than relying on either one alone. One thing to note: when there is an even number of employees, there won't be one person sitting exactly in the middle. In this case, we take the two middle salaries and calculate their average to find the median. How does this all relate to the EU Pay Transparency Directive? The EU Pay Transparency Directive requires employers to report on both the mean and median gender pay gap. These gaps are calculated by finding the average pay for male employees and the average pay for female employees, and then measuring the difference between them. The difference is expressed as a percentage of men's average pay. For example, a gender pay gap of +10% means that women's average pay is 10% lower than men's average pay. But why does the Directive want to look at both figures? The size of a company's mean gender pay gap and median gender pay gap can tell us different things about how pay is distributed across the organisation. If a company's mean gender pay gap is larger than its median gender pay gap, this could suggest that higher-paid employees are having a greater influence on the overall gap. Think back to our PeopleTech Ltd. example, where the CEO's €100,000 salary pulled the mean upwards. A similar effect could occur in an organisation where the pay gap between most male and female employees is relatively small, but a highly paid position, such as the CEO role, is occupied by a man. Even though the difference in pay across the wider workforce may be relatively modest, this one high salary could pull the mean upwards and result in a much larger overall gender pay gap. On the other hand, if a company's median gender pay gap is larger than its mean gender pay gap, this could suggest that the difference in pay is more evident across the wider workforce, rather than being driven primarily by a small number of highly or lower paid positions. In other words, the gap may be more noticeable among employees around the middle of the pay distribution, rather than being concentrated at the top. This could highlight wider differences in how men and women are paid across the organisation, and may warrant further investigation. It is important to remember that neither the mean nor the median tells us exactly why a gender pay gap exists. They are indicators that help us identify patterns and differences in pay, rather than explanations in themselves. By looking at both measures together, HR professionals can begin to build a clearer picture of pay within their organisation, identify areas that may need further investigation and take a more informed approach to understanding and addressing any gaps.

Read article

The information on this page is not intended to serve and does not serve as legal advice. All of the content, information, and material on this website are only for general informational use.

Copyright © 2026 SkillsTrust. All Rights Reserved.

The information on this page is not intended to serve and does not serve as legal advice. All of the content, information, and material on this website are only for general informational use.

Copyright © 2026 SkillsTrust. All Rights Reserved.

The information on this page is not intended to serve and does not serve as legal advice. All of the content, information, and material on this website are only for general informational use.

Copyright © 2026 SkillsTrust. All Rights Reserved.

The information on this page is not intended to serve and does not serve as legal advice. All of the content, information, and material on this website are only for general informational use.

Copyright © 2026 SkillsTrust. All Rights Reserved.