Data Analysis — Portfolio Project

The 13% Barrier

UK Gender Pay Gap Analysis — 82,935 employer submissions, 2018–2025

PythonPlotlyPandasNumPy82,935 Records10,409 Employers8 Charts3 Dashboards
The Problem
Establishing the baseline: the scale and structure of the UK gender pay gap across 82,935 employer submissions. The Glass Ceiling Index (GCI) — a custom derived metric — reveals the structural barrier that the headline pay gap figure alone obscures.
Key FindingAcross 82,935 employer submissions spanning 2018–2025, the gender pay gap consistently sits nearly 3× above the EU Pay Transparency Directive’s 5% mandatory-audit threshold.
Key FindingFemale representation drops 13+ percentage points from the lower to the top pay quartile. The glass ceiling is not a metaphor — it is a measurable, data-verified gradient.
Key FindingThe Glass Ceiling Index (GCI = Female% Lower Quartile − Female% Top Quartile) reveals structural inequality that the headline pay gap conceals. A positive GCI means fewer women reach senior roles.
The Evidence
A deeper look at which companies fall at the extremes of the distribution, which have already achieved near-parity, and how both the pay gap and GCI have trended from 2018 to 2025.
Key FindingAt the extremes, some employers show a reverse glass ceiling — more women at the top than the bottom — proving structural equity is genuinely achievable.
Key Finding1,617 employers (15.5% of 2025 reporters) have already achieved near-parity with a GCI between −1% and +1%. The benchmark exists; the challenge is scaling it.
Key FindingThe median pay gap declined from ~14% in 2018 to ~13% in 2025 — roughly 0.13 percentage points per year. All seven years remain above the EU 5% audit threshold.
The Solution
If current trends hold, gender pay parity is 67 years away. This section models what three evidence-based policy interventions could achieve — and why 2050 is a realistic, achievable target rather than an aspiration.
Key FindingExtrapolating the current rate of change, gender pay parity is not projected until 2093. Three targeted interventions could accelerate this to 2050, saving 43 years.
Key Finding① Replace headline pay gap with GCI  ·  ② Three-tier compliance (monitor → review → mandate)  ·  ③ Mandatory Promotion Pipeline Audits. Combined impact: parity 43 years sooner.
About
Project background, methodology, key findings, and tech stack.

About This Project

This analysis explores the UK Gender Pay Gap reporting dataset published by the UK Government, covering 82,935 employer submissions from 2018 to 2025. The project introduces the Glass Ceiling Index (GCI) — a custom derived metric that quantifies gender representation inequality across the pay distribution more precisely than the headline pay gap figure.

The Glass Ceiling Index (GCI)

GCI = Female% Lower Quartile − Female% Top Quartile
A positive value signals fewer women reach senior pay bands — the glass ceiling. A negative value indicates a reverse pattern. Unlike the headline pay gap, GCI is not confounded by occupational composition; it directly measures within-firm progression inequality.

Key Findings

1
The 2025 median pay gap of ~13% sits nearly 3× above the EU Pay Transparency Directive’s 5% mandatory-audit threshold — and has barely moved in 7 years.
2
Female representation drops an average of 13+ percentage points from lower to top quartile across all 2025 reporters — a structural glass ceiling, not a pay gap artefact.
3
1,617 employers (15.5% of 2025 reporters) have already achieved GCI near-parity (±1%), proving structural equity is achievable at scale.
4
At the current rate of ~0.13 pp/year decline, parity is not projected until 2093. Three policy interventions compress this timeline to 2050, saving 43 years.

Methodology

Data sourced from the UK Government Gender Pay Gap Reporting Service (gender-pay-gap.service.gov.uk). Reporting year extracted from submission due dates. Employers with missing quartile data excluded from GCI calculations. Status-quo projection uses linear extrapolation from the 2018–2025 trend. Accelerated projection reflects confirmed intervention-scenario outcomes.

Tech Stack

  • Python 3.11 — Data pipeline & orchestration
  • Pandas — Data wrangling (82,935 rows, 27 columns)
  • NumPy — Statistical analysis & projections
  • Plotly — Interactive visualisations (8 charts)
  • HTML / CSS / JS — Dashboard shell & tab navigation

Dataset Stats

82,935 total submissions
10,409 unique employers (2025)
8 reporting years
27 data columns
1,617 parity employers
43 yrs saved by interventions

Data Source

UK Government Gender Pay Gap Reporting Service
gender-pay-gap.service.gov.uk
Coverage: 2018–2025 mandatory employer submissions