S

S&P Global

Delivers credit ratings, market data, indices

Sales Compensation Analyst - Commercial Modeling & Governance Automation

Sales OperationsConfirmed live in the last 24 hours
Full-time

About the Job

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-level reporting suites.
  • Proven experience operating within SOX-compliance frameworks, including 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.

Responsibilities

  • Translate and engineer complex commercial deal structures, including multi-year enterprise agreements, joint-production credit splits, co-selling models, and overlay allocations, into structured algorithmic logic and standardised business rules within the compensation calculation engine, eliminating manual offline adjustments and ensuring downstream calculation readiness.
  • Model and simulate the financial impact of proposed changes to compensation plans and crediting rules by running Python and SQL scenario analyses on historical payout data and partnering with Revenue Operations and Legal/Deal Desk to evaluate non-standard transaction structures for data feasibility and commercial accuracy.
  • Build and maintain automated reconciliation engines using Python, Alteryx, and SQL to cross-compare ledger revenues, CRM bookings, and calculated commissionable revenue, and engineer variance detection models that automatically surface anomalies, including revenue double-counting, territory misalignment, unassigned account credits, and clawback mismatches.
  • Design and maintain governance control frameworks by building systematic tracking mechanisms for all manual adjustments with full origin, justification, and approval trails; directing comprehensive quarterly and annual SOX audit documentation; and running automated control test queries to demonstrate end-to-end calculation traceability.
  • Architect and maintain enterprise Power BI reporting suites by developing advanced data models using DAX and Power Query M to visualise sales performance, attainment distributions, and compensation trends; building real-time Data Health and Anomaly monitoring dashboards; and presenting variance summaries, root cause analyses, and actionable insights directly to Finance and Commercial leadership.
  • Standardise operations and advise stakeholders by converting fragmented legacy workflows into structured SOPs with clear SLAs; serving as the senior technical point of contact for Commercial and Finance stakeholders by translating complex data logic and calculation outcomes into plain-English explanations; and conducting technical peer reviews of queries, code updates, and configuration changes prior to production deployment.

Desired Qualifications

  • Experience working within B2B SaaS or subscription-based sales compensation environments, including enterprise crediting rules, quota structures, and multi-tier incentive plan mechanics.
  • Demonstrated 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, including multi-year enterprise agreements, joint-production credit splits, co-selling models, and overlay allocations, into structured algorithmic logic within enterprise compensation calculation engines.
  • Experience partnering with Revenue Operations and Legal/Deal Desk to evaluate non-standard transaction structures for data feasibility and downstream compensation calculation readiness.
  • Experience building real-time data health and anomaly monitoring dashboards that surface 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.
  • Proven experience conducting technical peer reviews of SQL queries, automation scripts, and configuration changes prior to deployment in production compensation environments.

About the Company

S&P Global

Delivers credit ratings, market data, indices

S&P Global provides financial information and analytics for investors, corporations, and governments, including credit ratings, market data, and indices. It compiles large financial data, conducts research, and offers analytics, ratings, and benchmarks accessed via subscriptions, licenses, or transaction-based services. The company differentiates itself with an integrated suite that covers ratings, data, analytics, indices, and ESG solutions across global markets, backed by well-known brands. Its goal is to help clients make informed decisions, manage risk, and drive growth while prioritizing corporate responsibility.

Company size
10,001+
Company stage
IPO
Headquarters
New York City, New York
Founded
1917

Recently Posted Jobs

Explore more opportunities at S&P Global

See more jobs