Sales Compensation Automation & Governance Analyst

S&P Global

United States

On-site

USD 71,000 - 125,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

S&P Global is seeking a Sales Compensation Analyst to automate complex compensation processes, model financial impacts, and build governance controls. The role blends advanced SQL, Python, and Power BI to deliver scalable, audit-ready data and insights for Finance and Commercial leadership.

You will translate multi-year contract structures into algorithmic logic, maintain automated reconciliation engines, and drive enterprise reporting.

Qualifications

  • Experience: 5+ years in sales compensation analytics, financial modelling, or commercial data governance within a multinational organisation.
  • SQL and Data Modelling: Advanced SQL proficiency for data modelling, validation, and complex multi-table reconciliation across ledger revenues, CRM systems, and compensation engines.
  • Automation and Scripting: Hands-on experience using Python/Pandas or Alteryx to build automated reconciliation workflows, variance detection models, and data pipeline scripts.
  • Power BI Development: Advanced Power BI expertise including data modelling, star schema design, complex DAX measures, and Power Query M transformations for enterprise-level reporting suites.
  • Governance and SOX Controls: 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 using Python and SQL scenario analyses.
  • Build and maintain automated reconciliation engines using Python, Alteryx, and SQL — cross-comparing ledger revenues, CRM bookings, and calculated revenue, with variance detection models.
  • Design and maintain governance control frameworks — tracking manual adjustments with full origin, justification, and approval trails; SOX audit documentation; automated control tests.
  • Architect and maintain enterprise Power BI reporting suites — data models, real-time health dashboards, variance summaries, and executive presentations.

Skills

Sales compensation analytics
Financial modelling
Data governance
SQL
Python
Power BI
SOX controls
Data modelling

Tools

SQL
Python
Alteryx
Power BI

Job description

S&P Global is seeking a Sales Compensation Analyst to automate complex compensation processes, model financial impacts, and build governance controls. The role blends advanced SQL, Python, and Power BI to deliver scalable, audit-ready data and insights for Finance and Commercial leadership.

You will translate multi-year contract structures into algorithmic logic, maintain automated reconciliation engines, and drive enterprise reporting.

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 • Cary (NC)

On-site
USD 71,000 - 125,000
Health & Wellness benefits
Flexible downtime
Continuous learning
+3
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 & 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 & 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
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 Engineer
Sales Compensation Automation Engineer

S&P Global • Trenton (NJ)

On-site
USD 71,000 - 125,000
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 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
Sales Compensation & Financial Modelling Analyst
Sales Compensation & Financial Modelling Analyst

S&P Global • Washington

Remote
USD 71,000 - 125,000
Health care
Flexible downtime
Continuous Learning
+3