USE THIS SKILL when the user asks about pay structure, salary bands, compensation benchmarking, incentive design, total rewards, compa-ratio analysis, pay equity, executive compensation, variable pay, equity compensation, market pricing, salary surveys, or grade structures. Also trigger for "red circle," "green circle," "range penetration," "pay philosophy," "STI design," "LTI design," "compensation cost modeling," "gender pay gap," "equal pay," or any request to design, analyze, or benchmark compensation against market data for any employee population.
Installation
Mit Codex oder Claude installieren Kopieren Sie diesen Prompt, fügen Sie ihn in Codex, Claude oder einen anderen Assistant ein und lassen Sie die Skill-Seite prüfen und installieren.
USE THIS SKILL when the user asks about pay structure, salary bands, compensation benchmarking, incentive design, total rewards, compa-ratio analysis, pay equity, executive compensation, variable pay, equity compensation, market pricing, salary surveys, or grade structures. Also trigger for "red circle," "green circle," "range penetration," "pay philosophy," "STI design," "LTI design," "compensation cost modeling," "gender pay gap," "equal pay," or any request to design, analyze, or benchmark compensation against market data for any employee population.
Compensation Benchmarking & Total Rewards Design
Required Inputs
Input
Description
Required?
Employee data
Headcount by role, level, location, current compensation (base + variable + equity)
TTC = Total Target Compensation = Base + Target Bonus + Expected Equity Value
2. Market Data Sourcing Methodology
Survey Selection Criteria:
Criterion
Evaluation Questions
Industry coverage
Does the survey cover our specific industry segment?
Geographic coverage
Does it cover our operating locations with local data?
Company size match
Are participating companies of similar revenue and headcount?
Job match quality
Can our roles be matched at 70%+ content overlap?
Recency
Is data within 12 months? If not, apply aging factor.
Sample size
Minimum 5 companies, 20 incumbents per benchmark job?
Major Market Data Sources:
Source
Strengths
Typical Coverage
Cost
Mercer Total Remuneration Survey
Global, broad industries, robust methodology
25M+ data points, 130+ countries
$$$
Radford (Aon)
Technology, life sciences specialization
Tech-focused, equity data strong
$$$
Willis Towers Watson CDB
Large employers, global, detailed benefits
Executive through professional levels
$$$
Culpepper
Mid-market, technology, niche surveys
US + select international
$$
Payscale / Salary.com
Broad access, real-time data
Large databases, employee-reported
$
Glassdoor / LinkedIn Salary
Directional, employee-reported
Best for market trends, less reliable for precision
Free
Bureau of Labor Statistics (BLS)
Free, government data, geographic detail
US only, broad occupational categories
Free
Data Aging Factor: If survey data is X months old, apply: Aged Value = Survey Value x (1 + Annual Movement Rate x (Months / 12))
Typical annual movement: 3.0-4.5% for base salary in developed markets.
Geographic Differential:Adjusted Value = National Median x Geographic Differential Factor
Example: San Francisco = 1.25x national; Austin = 1.05x; rural markets = 0.80-0.90x.
3. Job Matching / Leveling Framework
Internal Leveling Architecture:
Grade
Level Title
Scope
Decision Authority
Management Responsibility
Typical Experience
G1
Entry / Associate
Task execution
Follows procedures
None
0-2 years
G2
Specialist / Analyst
Project components
Standard decisions within guidelines
None
2-5 years
G3
Senior Specialist
Full projects
Complex decisions within policy
May lead small teams
5-8 years
G4
Manager / Lead
Function or team
Budget and people decisions
Direct reports
7-12 years
G5
Senior Manager / Director
Department
Strategic decisions for area
Multiple teams
10-15 years
G6
VP / Senior Director
Business unit or major function
P&L or major budget authority
Large organization
15+ years
G7
SVP / C-Suite
Enterprise
Enterprise-level strategy
Enterprise scope
18+ years
Job Matching Protocol:
Match internal role to survey benchmark job based on content (not title)
Require 70%+ overlap in duties, scope, and complexity
Document match rationale for audit trail
Use blended matches if no single survey job fits (weighted average of 2 benchmarks)
Flag "unique" roles with no market match -- price by comparable internal level
4. Base Pay Analysis
Compa-Ratio Analysis:
Compa-Ratio = Actual Base Pay / Range Midpoint (or Market P50)
Interpretation
Compa-Ratio
Action
Significantly below range
< 0.85
Immediate adjustment or accelerated progression
Below range
0.85 - 0.95
Priority for next increase cycle
At market
0.95 - 1.05
Standard merit increase
Above range
1.05 - 1.15
Reduced increase; ensure performance warrants
Significantly above range (red circle)
> 1.15
Freeze or lump-sum in lieu of increase
Range Penetration Analysis:
Range Penetration = (Actual Pay - Range Min) / (Range Max - Range Min) x 100%
Expected range penetration by tenure in role: New in role = 0-25%; Developing = 25-50%; Fully competent = 50-75%; Expert/Long tenure = 75-100%.
Population Analysis Template:
Function
Headcount
Avg Compa-Ratio
% Below 0.90
% Above 1.10
Avg Range Penetration
Cost to Bring to P50 ($)
[Function]
5. Pay Band Design Methodology
Band Structure Parameters:
Parameter
Typical Range
Formula
Midpoint
Market P50 (or target percentile)
Set by market data
Spread (total range width)
40-60% for professional; 60-80% for management; 80-100%+ for executive