Sales Compensation Analyst (Commercial Modeling & Governance Automation)

S&P Global•Hightstown, NJ

About The Position

The Sales Compensation Analyst serves as an analytical and engineering resource for S&P Global Market Intelligence’s sales compensation function. The role turns complex commercial deal structures, incentive plans, and governance requirements into automated, audit-ready data models and calculation logic. It supports a global participant population and partners with Commercial, Finance, Revenue Operations, and Legal/Deal Desk stakeholders, translating technical data and compensation outcomes into clear explanations.

Requirements

At least 5 years of experience in sales compensation analytics, financial modelling, or commercial data governance within a multinational organisation.
Advanced SQL proficiency for data modelling, validation, and complex multi-table reconciliation across ledger revenues, CRM systems, and compensation engines.
Hands-on experience using Python/Pandas or Alteryx to build automated reconciliation workflows, variance-detection models, and data-pipeline scripts.
Advanced Power BI expertise, including data modelling, star-schema design, complex DAX measures, and Power Query M transformations for enterprise reporting.
Proven experience working within SOX-compliance frameworks, designing audit-ready controls, running automated control-test queries, and producing end-to-end calculation traceability documentation.
Indefinite right to work in the United States.

Nice To Haves

Experience in B2B SaaS or subscription-based sales compensation, including enterprise crediting rules, quota structures, and multi-tier incentive plans.
Experience presenting complex data logic, calculation methodologies, and compensation model outcomes to Finance and Commercial executive leadership in clear, non-technical language.
Experience translating complex commercial contract mechanics into structured algorithmic logic within enterprise compensation calculation engines.
Experience partnering with Revenue Operations and Legal/Deal Desk to assess non-standard transaction structures for data feasibility and downstream compensation calculation readiness.
Experience building real-time data-health and anomaly-monitoring dashboards that identify unmapped accounts, missing credit assignments, adjustment-volume trends, and pipeline-integrity issues.
Experience designing and maintaining standardised adjustment protocols with systematic approval-trail tracking for manual compensation overrides.
Experience conducting technical peer reviews of SQL queries, automation scripts, and configuration changes before production deployment in compensation environments.

Responsibilities

Translate complex commercial deal structures—including multi-year enterprise agreements, joint-production credit splits, co-selling models, and overlay allocations—into structured logic and standardised business rules in the compensation calculation engine.
Model and simulate the financial impact of proposed compensation plan and crediting-rule changes using Python and SQL analyses of historical payout data.
Partner with Revenue Operations and Legal/Deal Desk to assess non-standard transaction structures for data feasibility and compensation calculation readiness.
Build and maintain automated reconciliation engines using Python, Alteryx, and SQL to compare ledger revenues, CRM bookings, and calculated commissionable revenue.
Develop variance-detection models to surface anomalies such as revenue double-counting, territory misalignment, unassigned account credits, and clawback mismatches.
Design and maintain governance controls and tracking for manual adjustments, including origin, justification, and approval trails.
Prepare quarterly and annual SOX audit documentation and run automated control-test queries to demonstrate calculation traceability.
Develop and maintain enterprise Power BI reporting suites, including data models using DAX and Power Query M, performance and compensation visualisations, and real-time data-health and anomaly dashboards.
Present variance summaries, root-cause analyses, and actionable insights to Finance and Commercial leadership.
Standardise legacy workflows into structured SOPs with clear SLAs.
Serve as a senior technical point of contact for Commercial and Finance stakeholders, explaining complex data logic and calculation outcomes in plain English.
Conduct technical peer reviews of queries, code updates, and configuration changes before production deployment.