Sales Compensation Automation & Governance Analyst

S&P Global Inc.; New York, Hightstown (NY, NJ, CT); Remote; USD 71,000 - 125,000; Full time

Job summary

S&P Global Inc. is seeking a Sales Compensation Analyst to automate complex compensation processes for the Commercial Modelling & Governance team.

You will translate multi-year enterprise deals, co-selling models, and overlay rules into structured logic, build audit-ready data models, and maintain governance trails using SQL, Python, and Power BI. You will own automated reconciliation engines, design enterprise reporting, and collaborate with Revenue Ops, Legal/Deal Desk, and Finance

Qualifications

• 5+ years 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.
• Power BI development including data modelling, star schema design, complex DAX measures, and Power Query M transformations for enterprise-level reporting suites.
• Governance and SOX controls experience – audit-ready controls and end‑to‑end calculation traceability documentation.

Responsibilities

• Translate and engineer complex commercial deal structures into structured algorithmic logic and standardised rules within the compensation engine.
• Model and simulate financial impact of proposed changes to compensation plans and crediting rules using Python/SQL.
• Build and maintain automated reconciliation engines using Python, Alteryx, and SQL with variance detection models.
• Design and maintain governance frameworks with origin, justification, and approval trails; support quarterly/annual SOX audits and control tests.
• Architect and maintain enterprise Power BI reporting suites with real-time dashboards and variance summaries for Finance and leadership.
• Standardise operations and advise stakeholders by translating data logic into plain-English explanations and supervising code reviews.

Skills

Advanced SQL

Python/Pandas

Power BI

Data modelling

SOX governance

Alteryx

Revenue Ops

Tools

SQL

Job description

S&P Global Inc. is seeking a Sales Compensation Analyst to automate complex compensation processes for the Commercial Modelling & Governance team.

You will translate multi-year enterprise deals, co-selling models, and overlay rules into structured logic, build audit-ready data models, and maintain governance trails using SQL, Python, and Power BI. You will own automated reconciliation engines, design enterprise reporting, and collaborate with Revenue Ops, Legal/Deal Desk, and Finance