Pay Equity Audit Snapshot: Find Unexplained Pay Gaps Before They Find You

The problem this kills

You know you should be watching for pay equity. But every time someone asks "are we okay?", the honest answer is a shrug and a promise to look into it. Pulling the comp data, deciding who counts as comparable to whom, controlling for the legitimate stuff like tenure and performance, and writing it up in a way that would hold up to scrutiny — that's a project, not an afternoon. So it slips. Then a pattern that was small and fixable becomes a big, expensive, public one.

The frustrating part is that the signal is already sitting in your HRIS export. Two people in the same role, same level, same location — one paid noticeably less, and nothing in their tenure, performance, or experience explains it. That's a cohort worth a closer look. You don't need a data scientist or a fancy platform to surface those. You need something repeatable that groups people fairly, measures the gaps your real factors don't account for, ranks where to look first, and — critically — keeps a human firmly in charge of what it means and what to do about it. You can build that yourself.

What you'll build

A confidential internal web tool for your HR/comp team. You import a comp snapshot — one row per employee, with role, level, location, pay, tenure, performance, and whatever legitimate explanatory factors your company actually uses. The tool groups employees into comparable cohorts using rules you define, then measures the pay differences within each cohort that your explanatory factors don't account for. It suppresses tiny cohorts so you never draw conclusions from two people, and it ranks the flagged cohorts so you know where to start. Each flagged cohort lands on a review screen where HR reads the pattern, adds notes, and decides: investigate, monitor, or dismiss — with a reason. Only the cohorts HR marks for action get exported as remediation candidates, alongside a complete cohort-analysis CSV for your records. The tool surfaces patterns; a person interprets and acts. Nothing about anyone's pay is ever changed automatically.

What's inside the Implementation Plan

The downloadable plan is a step-by-step file you paste into an AI coding agent. It opens by interviewing you about your business — how you define "comparable," which factors your company treats as legitimate explanations for pay differences, the exact columns and naming in your HRIS export, your headcount and how big your cohorts tend to be, your minimum cohort size for reporting, and the messy realities like dual job titles, part-timers, and people mid-promotion. It reads a short spec back to you for a thumbs-up, then builds the tool around your definitions instead of a generic template. From there it walks the agent through the data model, the confidential CSV import, the cohort-forming and gap-analysis engine, small-cohort suppression, the ranked review-and-annotate screen, the human decision gate, and the remediation-candidates and cohort-analysis exports. Every step ends with a ready-to-copy prompt.

The governance it includes (this is the point)

This is sensitive data, and the plan treats it that way. It builds in login so only your comp team can open the tool, strict row-level security so each organization only ever sees its own people, and small-cohort suppression so individuals can't be singled out from a group of two. It keeps a complete audit trail of every review decision and annotation — who looked at what cohort, what they concluded, and when. And it enforces a hard human-in-the-loop gate: the tool flags and ranks, but a person reviews every flagged cohort and decides what to investigate or remediate. There are no automatic pay adjustments and no writes to your system of record without a person's sign-off. The plan also reminds you, plainly, that this is an analysis aid and not legal advice — for a formal audit, loop in counsel — and it steers you away from misusing protected attributes.

Who it's for

HR and compensation leaders, total-rewards owners, and people-ops teams who are expected to monitor pay equity but don't have a repeatable, defensible way to do it. If you can describe what makes two of your employees genuinely comparable, you can build this.

You've got this — open the plan, paste the first prompt, and you'll be looking at your first ranked cohort list this weekend.