Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    compensation structure and pay band analyzer

    1

    Compensation modeling is often prone to calculation errors, inconsistent rounding, and accidental privacy leaks when handling small groups.

    $2.99

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    compensation structure and pay band analyzer

    compensation structure and pay band analyzer

    Example session with this skill installed

    Review these pay bands for the Engineering job family in USD. Ensure midpoint progression is between 8% and 12%. Check if our midpoints match the provided 2024 Tech Survey medians.

    • Read your context and instructions
    • Compiled the compensation structure

    Processed the pay band structure for Engineering. Calculated spreads, progressions, and market deltas using the deterministic analyzer.

    Compensation Structure and Pay Band Analysis — Engineering, 2024-10-24

    1. Scope, sources and assumptions

    • Sources: E1 (Internal Pay Structure), E2 (2024 Tech Survey).
    • Purpose: Band consistency and market alignment audit.
    • Approved by: Total Rewards Director.
    • Jurisdiction: US-CA.
    • Min Group Size: 5.

    2. Band structure

    GradeMinMidMaxSpread
    E180,00090,000100,0000.2500
    E292,000105,800119,6000.3000
    E3110,000126,500143,0000.3000
    PairMidpoint progressionOverlapOverlap share
    E1-E20.17558,0000.4000
    E2-E30.19569,6000.3243

    3. Findings

    CodeGrade or pairSeverityDetail
    PROG_HIGHE1-E2WarningProgression 17.55% exceeds policy limit of 12%.
    PROG_HIGHE2-E3WarningProgression 19.56% exceeds policy limit of 12%.

    4. Market comparison

    GradeMidpointMarket MedianVarianceSource
    E190,00092,000-0.0217E2 (2024-01-15)
    E2105,800104,0000.0173E2 (2024-01-15)

    5. Positioning and privacy suppression

    GradenMean compaMedian compaMean penetrationcounts
    E1120.98200.97500.4600Q1:3, Q2:5, Q3:4
    E2[n/a][n/a][n/a][n/a]Suppressed (n<5)

    6. Exclusions and proposed actions

    • 2 records excluded (missing data_use_permitted).
    • Proposed Action: Review E1-E2 progression to align with 12% policy limit. Management decision required.

    7. Items for human review

    Information gap — organizational validation required: Verify if the E2-E3 progression was intentional for senior technical roles.

    • This analysis supports, and does not replace, professional judgment and management's decision.

    Next steps

    1. Validate the progression variances in Section 3 against recruitment difficulty data.
    2. Address the data permissions for the 2 excluded records to include them in the next run.
    3. Review the suppressed E2 positioning data with authorized HRBP access.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Compensation modeling is often prone to calculation errors, inconsistent rounding, and accidental privacy leaks when handling small groups. This skill provides a deterministic environment for auditing pay structures and employee positioning. It enforces data minimisation and mathematical precision through a dedicated execution script.

    What it does

    • Structure Audit identifies inconsistencies in pay-band spreads, midpoint progressions, and grade overlaps or inversions.
    • Market Benchmarking compares internal midpoints against user-provided market medians to flag competitive gaps.
    • Positioning Analytics calculates compa-ratios and range penetration for authorised employee records.
    • Privacy Enforcement applies group-size suppression to prevent the identification of individuals in small cohorts.
    • Action Drafting generates management-ready proposals for band adjustments based on policy limits.

    How it works

    1. The developer provides a JSON payload containing pay band definitions, pseudonymous employee records, and policy limits.
    2. The skill validates the access_scope and ensures all required authorisations and data permissions are present.
    3. It executes a local Python script to perform exact decimal calculations for all compensation metrics.
    4. It generates a structured Markdown report that separates observed facts, computed results, and items requiring human review.

    Frameworks & tools

    The skill relies on a self-contained Python execution environment (scripts/run.py) and JSON schema validation for input/output integrity.

    Why this beats prompting it yourself

    Standard LLM prompting often results in "hallucinated" math or inconsistent rounding across large tables. This skill uses a deterministic script to ensure every compa-ratio and spread calculation is mathematically perfect while strictly enforcing privacy suppression rules that a raw prompt might overlook.

    Use cases

    • Audit a new salary structure for internal equity and logical progression.
    • Identify employees falling outside their assigned pay bands or quartiles.
    • Compare internal salary grades against external market surveys.
    • Draft budget estimates for proposed pay-band adjustments.

    Known limitations

    Requires annual base pay only. It does not perform pay equity diagnostics, payroll reconciliation, or diversity metrics. Market data must be supplied by the user.

    Annual pay only. No pay equity or diversity diagnostics. Market data must be user-provided. Minimum group size defaults to 5. No legal or compliance opinions.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Money-back guarantee

    Doesn't do what its page promises? You get your money back.

    Trust & safety

    Security scan

    Security scan passed 3 days ago

    Permissions

    Terminal / Shell
    Read Files
    Write Files
    Environment Variables
    Listed3 days ago

    What's inside

    Frequently Asked Questions

    Standard LLMs often struggle with precise decimal math and consistent rounding. This skill uses a deterministic Python script to ensure that every compa-ratio and midpoint progression calculation is mathematically perfect and audit-ready.

    The skill requires a structured JSON payload containing your pay band definitions and pseudonymous employee data. It is designed to work with any AI agent or platform that supports JSON input and local script execution.

    To protect sensitive information, the skill includes built-in group-size suppression. This prevents the identification of individuals in small cohorts by automatically masking results when a group size falls below your defined privacy threshold.

    You will receive the structured JSON schema for data input, the core execution script for deterministic calculations, and the system prompts required to generate the final management-ready Markdown reports.

    This skill is focused on base pay structure and market alignment. It does not currently support variable compensation (bonuses/equity), payroll reconciliation, or protected-class pay equity diagnostics.