Sales Compensation Automation & Modeling Analyst

S&P Global; Hartford (CT); On-site; USD 71,000 - 125,000; Full time

Benefits offered by this job

Health & Wellness

Flexible Downtime

Learning & Development

Retirement Planning

Job summary

S'P Global is seeking a Sales Compensation Analyst to automate complex compensation processes for the Commercial Modelling & Governance Automation function. You will translate enterprise deal structures into automated rules, build reconciliation engines, and maintain governance and Power BI reporting for Finance and Leadership.

This role requires deep SQL, Python, and Power BI skills, experience with SOX controls, and the ability to communicate complex concepts to non-technical stakeholders.

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 suites.
• 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.
• Model and simulate the financial impact of proposed changes to compensation plans and crediting rules using Python and SQL.
• Build and maintain automated reconciliation engines using Python, Alteryx, and SQL — cross-comparing ledger revenues, CRM bookings, and calculated commissionable revenue.
• Design and maintain governance control frameworks with tracking for all manual adjustments and SOX audit documentation.
• Architect and maintain enterprise Power BI reporting suites — developing advanced data models using DAX and Power Query M and building anomaly monitoring dashboards.
• Standardise operations and advise stakeholders by translating complex data logic into plain-English explanations; conduct technical peer reviews prior to production deployment.

Skills

SQL

Python

Power BI

Alteryx

SOX

Data Governance

Stakeholder comms

Tools

SQL

Python

Power BI

Alteryx

Job description

S'P Global is seeking a Sales Compensation Analyst to automate complex compensation processes for the Commercial Modelling & Governance Automation function. You will translate enterprise deal structures into automated rules, build reconciliation engines, and maintain governance and Power BI reporting for Finance and Leadership.

This role requires deep SQL, Python, and Power BI skills, experience with SOX controls, and the ability to communicate complex concepts to non-technical stakeholders.