Sales Compensation Automation Engineer

S&P Global

Trenton (NJ)

On-site

USD 71,000 - 125,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

S'P Global in the United States is seeking a Sales Compensation Analyst to automate complex commercial deals and governance for our Market Intelligence unit. You will engineer data models, run scenario analyses, and deliver auditable processes that scale.

You will partner with Revenue Ops, Legal/Deal Desk, Finance and Leadership to implement SOX controls, build Power BI dashboards, and translate intricate compensation rules into robust, production-ready logic.

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.
  • Advanced Power BI expertise including data modelling, star schema design, complex DAX measures, and Power Query M transformations for enterprise-level reporting.
  • Proven experience operating within SOX-compliance frameworks — designing audit-ready controls, running automated control test queries, and producing end-to-end calculation traceability documentation.

Responsibilities

  • Translate and engineer complex commercial deal structures 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 — running Python and SQL scenario analyses on historical payout data and liaising with Revenue Ops and Legal/Deal Desk to evaluate non-standard transaction structures.
  • Build and maintain automated reconciliation engines using Python, Alteryx, and SQL — cross-comparing ledger revenues, CRM bookings, and calculated commissionable revenue, and detecting anomalies.
  • Design and maintain governance control frameworks — tracking manual adjustments with full origin, justification, and approval trails; supporting SOX audit docs and automated tracing queries.
  • Architect and maintain enterprise Power BI reporting suites — developing data models with DAX and Power Query M, and presenting variance summaries and root-cause analyses to Finance and Leadership.

Skills

SQL and Data Modelling
Automation and Scripting
Power BI Development
Governance and SOX Controls
Analytics & Financial Modelling

Tools

Python/Pandas
Alteryx

Job description

S'P Global in the United States is seeking a Sales Compensation Analyst to automate complex commercial deals and governance for our Market Intelligence unit. You will engineer data models, run scenario analyses, and deliver auditable processes that scale.

You will partner with Revenue Ops, Legal/Deal Desk, Finance and Leadership to implement SOX controls, build Power BI dashboards, and translate intricate compensation rules into robust, production-ready logic.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sales Compensation Automation & Governance Analyst
Sales Compensation Automation & Governance Analyst

S&P Global Inc. • New York (NY), Hightstown (NJ)

Remote
USD 71,000 - 125,000
Sales Compensation Automation & Modeling Analyst
Sales Compensation Automation & Modeling Analyst

S&P Global • Hartford (CT)

On-site
USD 71,000 - 125,000
Health & Wellness
Flexible Downtime
Learning & Development
+1
Sales Compensation Automation & Governance Analyst
Sales Compensation Automation & Governance Analyst

S&P Global • New York (NY)

Remote
USD 71,000 - 125,000
Annual incentive plan
Sales Compensation Automation & Governance Analyst
Sales Compensation Automation & Governance Analyst

S&P Global • United States

On-site
USD 71,000 - 125,000
Sales Compensation Automation & Governance Analyst
Sales Compensation Automation & Governance Analyst

S&P Global • Cary (NC)

On-site
USD 71,000 - 125,000
Health & Wellness benefits
Flexible downtime
Continuous learning
+3
Automation-Driven Sales Compensation Analyst
Automation-Driven Sales Compensation Analyst

S&P Global • Richmond (VA)

On-site
USD 71,000 - 125,000
Health & Wellness
Flexible downtime
Continuous learning
+2
Sales Compensation Architect – Auto Modeling & Governance
Sales Compensation Architect – Auto Modeling & Governance

S&P Global • Washington

On-site
USD 71,000 - 125,000
Health care coverage
Retirement planning
Education program for employees
+1
Sales Compensation Automation & Analytics Lead
Sales Compensation Automation & Analytics Lead

S&P Global • Chicago (IL)

On-site
USD 71,000 - 125,000
Health & Wellness
Flexible Downtime
Continuous Learning
+2
Sales Compensation Data Architect & Strategy Lead
Sales Compensation Data Architect & Strategy Lead

S&P Global • Chicago (IL)

On-site
USD 104,000 - 183,000
Health care coverage
Retirement plan
Continuing education program et al.
+1
Sales Compensation Architect - Financial Modeling & Planning
Sales Compensation Architect - Financial Modeling & Planning

Remote Jobs • New York (NY)

On-site
USD 71,000 - 125,000
Health & Wellness
Flexible Downtime
Continuous Learning
+2