ChatGPT Prompts for Compensation Analysts: Pay Structures, Equity, Market Data
Compensation analysts manage the financial heart of the employer-employee relationship. They benchmark against market data, design pay structures, analyze pay equity, model merit budgets, and build incentive plans — all while balancing internal fairness, external competitiveness, and budget constraints. AI can help structure analysis, model scenarios, and draft compensation communications.
These prompts are adapted from Skillent's HR AI Prompt Library.
Want 190,000+ professional AI prompts?
Get Skillent Pro — $9/monthMarket Analysis & Benchmarking
1. Market Benchmarking Analysis
Role: Compensation analyst
Task: Conduct a market benchmarking analysis for [job family/role group]
Input:
- Internal job titles and current salaries: [list]
- Market survey data: [paste or describe source: Mercer, Radford, CompAnalyst, etc.]
- Company size, industry, geography
Analysis:
1. Match internal jobs to survey benchmark jobs (match by scope, reports, complexity)
2. Calculate compa-ratios (actual / market median)
3. Identify jobs significantly below market (<0.85 compa-ratio)
4. Identify jobs above market (>1.15 compa-ratio — may be structural or market premium)
5. Recommend target market position (50th, 60th, 75th percentile — and why)
6. Calculate cost to bring below-market jobs to target
Format: Benchmarking report with compa-ratio analysis and recommendations
Include: Data source limitations and confidence intervals
2. Salary Survey Data Integration
Role: Compensation analyst
Task: Create a process for integrating multiple salary survey sources
Sources: [list surveys used: Mercer, Radford, Aon, Culpepper, etc.]
Process:
1. Job matching rules (primary survey per job family, secondary for validation)
2. Data age adjustment (adjust old data by market movement factor)
3. Company-size adjustment (scale data to match company size)
4. Geographic differential (adjust for location if multi-site)
5. Weighting methodology (if using multiple surveys, how to weight?)
6. Outlier handling (when to exclude data points)
7. Composite calculation (final market rate per job)
8. Documentation (audit trail for each rate)
Format: Survey integration methodology document
Include: Decision tree for handling conflicts between surveys
3. Geographic Differential Analysis
Role: Compensation analyst
Task: Analyze geographic pay differentials for [company with locations in: list cities/states]
Data sources: BLS, ACS, cost-of-living indices, market salary surveys
For each location:
1. Cost of living index vs. HQ location
2. Market salary differential (% above/below HQ market)
3. Pay practice at local competitors
4. Remote work policy (if remote, do you pay HQ rate or local rate?)
5. Minimum wage requirements (state/local)
6. Pay transparency laws (state-specific)
Analysis:
- Recommended pay differential per location
- Impact on total payroll cost
- Policy recommendation (local rate, HQ rate, or tiered)
Format: Geographic pay analysis report
Include: Implementation plan and communication recommendations
Pay Structure Design
4. Salary Range Structure Builder
Role: Compensation analyst
Task: Design a salary range structure for [company type/size]
Parameters:
- Number of grades/levels: [number]
- Market target position: [50th/60th/75th percentile]
- Range spread per grade: [typically 40-60%, wider for senior levels]
- Grade overlap: [typically 40-50% to allow promotion without grade change]
- Midpoint progression between grades: [typically 8-15%]
Process:
1. Define grade midpoints (based on market data for benchmark jobs in each grade)
2. Calculate minimum and maximum for each grade (midpoint × (1 ± spread/2))
3. Calculate overlap between adjacent grades
4. Map all employees to grades
5. Identify out-of-range employees (below min or above max — red circle/green circle)
6. Create remediation plan for out-of-range employees
Format: Salary range table with grade, midpoint, min, max, overlap
Include: Green/red circle policy (how to handle employees outside ranges)
5. Job Evaluation Matrix
Role: Compensation analyst
Task: Create a job evaluation matrix using [method: point factor/ranking/classification]
Factors:
1. Knowledge (education, experience, specialized training)
2. Complexity (problem-solving, analytical requirements, decision-making scope)
3. Responsibility (budget, people, impact on business results)
4. Physical demands (if applicable — for non-office roles)
5. Working conditions (if applicable — for hazardous environments)
For each factor:
- Degrees/levels (1-5 with definitions)
- Point values per degree
- Weight (importance relative to other factors)
Evaluation process:
1. Score each job on each factor
2. Sum points per job
n3. Map point ranges to grades
4. Validate: do jobs in the same grade have similar scope?
Format: Job evaluation manual with factor definitions and scoring guide
Include: Appeals process for managers who disagree with grade assignment
6. Pay Mix Optimization
Role: Total rewards analyst
Task: Analyze and optimize the pay mix for [role/level]
Current pay mix:
- Base salary: [% of total compensation]
- Target bonus: [%]
- LTI (equity): [%]
- Benefits value: [%]
Market comparison:
- Base salary market position: [percentile]
- Total cash market position: [percentile]
- Total rewards market position: [percentile]
Analysis:
1. Is our mix aligned with market practice for this role?
2. Is base salary competitive? (if too low, hard to attract; too high, fixed cost)
3. Is variable pay competitive? (if too low, no performance incentive; too high, risk averse)
4. Is equity competitive? (for tech/startup roles, equity is critical)
5. Is benefits competitive? (may offset lower base for some employees)
Recommend: Optimal pay mix with rationale and cost impact
Format: Pay mix analysis with recommendations
Pay Equity & Compliance
7. Pay Equity Audit Plan
Role: Compensation analyst
Task: Create a pay equity audit plan for [company]
Scope:
1. Define comparison groups (job family → grade → similar scope)
2. Collect data (salary, bonus, equity value, tenure, performance rating, hire date, demographic data)
3. Statistical model: regression controlling for legitimate factors (tenure, performance, experience, level, location)
4. Identify unexplained gaps >5% by demographic (gender, race, age)
5. Root cause analysis for each gap (starting salary, promotion timing, negotiation)
6. Remediation strategy (adjust base, adjust bonus, adjust equity — or process fixes)
7. Budget estimate for remediation
8. Ongoing monitoring plan (annual audit, new hire pay audit, promotion pay audit)
Documentation:
- Methodology and data sources
- Results and limitations
- Actions taken
- Note: Consider conducting under attorney-client privilege for litigation protection
Format: Pay equity audit plan
Include: Timeline, budget, and risk assessment
8. Pay Transparency Preparation
Role: Compensation analyst
Task: Create a pay transparency compliance plan for [states where company has employees: CA, CO, NY, WA, etc.]
Requirements by state:
1. [State]: Salary range in job posting? Yes/No. Range format requirements?
2. [State]: Pay scale upon request? Yes/No. When must employer provide?
3. [State]: Pay history ban? Can we ask about prior salary?
4. [State]: Internal posting requirements? Must we post internally first?
5. [State]: Record-keeping requirements? What must we document?
Preparation:
1. Establish salary ranges for all positions (if not already)
2. Train hiring managers on talking about compensation
3. Update job posting templates with range language
4. Create compensation philosophy document (how we set pay and why)
5. Review internal pay practices for equity before disclosure
6. Create FAQ for employees about pay ranges and transparency
Format: Pay transparency compliance checklist by state
Include: Implementation timeline and manager training materials
9. Executive Compensation Benchmarking
Role: Executive compensation analyst
Task: Benchmark executive compensation for [executive role: CEO/CFO/CTO/VP]
Data sources: proxy statements (DEF 14A), executive compensation surveys, board survey
Analysis:
1. Base salary: [company] vs. peer group [list] vs. market percentile
2. Annual bonus: target % of base, max payout, performance metrics used
3. Long-term incentives: grant value, vehicle (RSU, stock option, PSU), vesting schedule
4. Benefits and perquisites: what's included and market comparison
5. Total direct compensation: base + bonus + LTI value
6. Pay-for-performance alignment: compensation vs. company performance vs. peer performance
Peer group selection:
- Industry match
- Revenue size match
- Complexity match
- Growth stage match
Format: Executive compensation benchmarking report
Include: Peer group construction methodology and data sources
Modeling & Communication
10. Merit Increase Model
Role: Compensation analyst
Task: Model merit increase scenarios for [budget year]
Budget parameters:
- Total merit budget: [% of payroll]
- Payroll base: [$ total]
Distribution methods to model:
1. Flat % (everyone gets same % — simple but low impact on retention)
2. Performance-based (higher performers get more — recommended)
3. Compa-ratio adjusted (below-market get more to close gaps)
4. Combination (performance × compa-ratio matrix)
For each method:
- Calculate cost
- Show impact by performance rating
- Show impact by compa-ratio
- Identify winners and losers vs. current pay
Matrix recommendation:
[Performance × Compa-ratio grid with recommended % per cell]
Example: Top performer, below market: 6%. Meets performer, at market: 3%. Below performer, above market: 0%.
Format: Merit model with recommendation
Include: Manager communication materials
11. Sales Incentive Plan Design
Role: Compensation analyst specializing in sales compensation
Task: Design a sales incentive plan for [sales role: inside sales/field sales/account executive]
Plan components:
1. Base salary: [amount or % of OTE — on-target earnings]
2. Target variable: [amount or % of OTE]
3. OTE (base + target variable): [$]
4. Commission structure: [flat rate / tiered / quota-based]
5. Quota: [$ annual] and quota attainment distribution
6. Accelerators: [above 100% attainment: 1.5x, 2x, etc.]
7. Decelerators: [below 80% attainment, if applicable]
8. Cap: [maximum payout, if any — typically 200-300% of target]
9. SPIFs: [special incentives for strategic products/behaviors]
10. ramp: [first 3-6 months at reduced quota]
11. Territory/account rotation policy
Model scenarios:
- At 80% attainment: [$ earnings]
- At 100% attainment: [$ earnings = OTE]
- At 120% attainment: [$ earnings]
- At 150% attainment: [$ earnings]
Format: Sales incentive plan document
Include: P&L impact model at various attainment levels
12. Compensation Communication Template
Role: Compensation analyst
Task: Create compensation communication templates for [audience]
Template 1 — Manager comp conversation guide:
- Opening: purpose, confidentiality, appreciation
- Review current compensation: base, bonus received, equity value
- Market context: where they sit vs. market (without revealing specific data)
- Performance linkage: how performance affected comp decisions
- Merit increase: amount, %, effective date
- Bonus: amount and how calculated
- Equity (if applicable): grant, vesting, value
- Career/comp trajectory: what does future growth look like here?
- Questions: allow time, don't rush
Template 2 — Employee total rewards statement:
- Total compensation summary (base, bonus, equity, benefits value)
- Market comparison (general position: at/above/below market — not specific data)
- Benefits value breakdown (health, retirement, PTO, perks)
- Year-over-year growth (total comp this year vs. last year)
Format: Communication template library
Tone: Transparent, appreciative, clear
Best Practices
1. Always verify market data — AI may reference outdated survey data. Verify against current survey cuts and adjust for data age.
2. Use multiple data sources — Single-survey benchmarks are risky. Triangulate across at least 2-3 surveys for key roles.
3. Document methodology — Compensation decisions are scrutinized in audits and litigation. Document data sources, calculations, and rationale.
4. Consider attorney privilege — Pay equity analyses may be discoverable. Consult employment counsel about conducting analyses under privilege.
5. Communicate clearly — Pay decisions are personal and emotional. Train managers to explain compensation without making promises. See our performance review prompts for comp-conversation integration.
190,000+ professional AI prompts for HR and every other industry.
Get Skillent Pro — $9/month