Sales Compensation Architect – Auto Modeling & Governance

S&P Global; Washington (District of Columbia); On-site; USD 71,000 - 125,000; Full time

Benefits offered by this job

Health care coverage

Retirement planning

Education program for employees

Financial wellness programs

Job summary

S'P Global is hiring a Sales Compensation Analyst to automate complex sales compensation processes, govern optimisation rules, and deliver audit-ready data models. You will harness SQL, Python, and Power BI to support governance and leadership with actionable insights.

You will work with Finance and Revenue Ops to ensure accuracy, scalability, and compliance across enterprise deal structures, multi-tier incentives, and governance controls.

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 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 — designing audit-ready controls, running automated control test queries, and documenting end-to-end calculation traceability.

Responsibilities

• Translate and engineer complex commercial deal structures into structured algorithmic logic and standardised business rules within the compensation calculation engine.
• 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 with variance detection models and anomaly surfacing.
• Design governance control frameworks with tracking mechanisms for all manual adjustments and SOX-ready audit trails.
• Architect and maintain enterprise Power BI reporting suites with advanced data models and real-time dashboards for leadership review.
• Standardise operations and serve as the technical point of contact translating data logic for Finance and Commercial stakeholders.

Skills

SQL & Data Modelling

Automation & Scripting

Power BI Development

SOX Governance

Executive storytelling

Tools

Python

Alteryx

SQL

Power BI

Job description

S'P Global is hiring a Sales Compensation Analyst to automate complex sales compensation processes, govern optimisation rules, and deliver audit-ready data models. You will harness SQL, Python, and Power BI to support governance and leadership with actionable insights.

You will work with Finance and Revenue Ops to ensure accuracy, scalability, and compliance across enterprise deal structures, multi-tier incentives, and governance controls.