Sales Compensation Analyst – Commercial Modeling, Governance Automation
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Sales Compensation Analyst automating commercial modeling, reconciliation, and SOX governance for S&P Global Market Intelligence. Building SQL, Python, Alteryx, and Power BI compensation infrastructure.
Responsibilities:
- Translate and engineer complex commercial deal structures into structured algorithmic logic and standardised business rules
- Model and simulate the financial impact of proposed compensation plan and crediting rule changes
- Run Python and SQL scenario analyses on historical payout data
- Partner with Revenue Operations and Legal/Deal Desk on non-standard transaction structures
- Build and maintain automated reconciliation engines using Python, Alteryx, and SQL
- Cross-compare ledger revenues, CRM bookings, and calculated commissionable revenue
- Engineer variance detection models for revenue double-counting, territory misalignment, unassigned account credits, and clawback mismatches
- Design and maintain governance control frameworks and manual-adjustment approval trails
- Direct quarterly and annual SOX audit documentation
- Run automated control test queries for end-to-end calculation traceability
- Architect and maintain enterprise Power BI reporting suites using DAX and Power Query M
- Build real-time data health and anomaly monitoring dashboards
- Present variance summaries, root cause analyses, and actionable insights to Finance and Commercial leadership
- Convert legacy workflows into structured SOPs with clear SLAs
- Serve as senior technical point of contact for Commercial and Finance stakeholders
- Conduct technical peer reviews of queries, code updates, and configuration changes before production deployment
Requirements:
- 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
- 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
- Proven experience operating within SOX-compliance frameworks
- Experience designing audit-ready controls, running automated control test queries, and producing end-to-end calculation traceability documentation
- Experience working within B2B SaaS or subscription-based sales compensation environments
- Experience presenting complex data logic and compensation model outcomes to Finance and Commercial executive leadership
- Experience translating complex commercial contract mechanics into structured algorithmic logic
- Experience partnering with Revenue Operations and Legal/Deal Desk
- Experience building real-time data health and anomaly monitoring dashboards
- Experience designing and maintaining standardised adjustment protocols
- Proven experience conducting technical peer reviews
- Indefinite right to work in the United States
Benefits:
- Annual incentive plan
- Health care coverage
- Generous time off
- Continuous learning resources
- Competitive pay
- Retirement planning
- Continuing education program
- Company-matched student loan contribution
- Financial wellness programs
- Family benefits and perks
- Retail discounts
- Referral incentive awards
Similar Jobs
Senior Cybersecurity and GRC Analyst
Senior cybersecurity analyst protecting Conjointly’s all-in-one survey research platform. Supporting SOC 2, ISO 27001 and ISO 27701 governance, risk and compliance.
Occupational Health Governance and Contract Lead
UK Occupational Health governance and contract lead overseeing outsourced services for GSK, a global biopharma company. Managing suppliers, compliance, performance, budgets and service improvements.
Practice Lead, Fraud, Trust and Safety
Practice Lead owning fraud and trust-and-safety consulting delivery, client confidence, and practice growth. Leading teams and advising complex organizations through FiveBy’s fully remote consultancy.
GRC Analyst
GRC Analyst strengthening RxBenefits’ healthcare compliance, risk, and security controls. Managing audits, assessments, GRC records, vendors, and executive risk reporting.
Risk Adjustment Program Lead
Risk adjustment program lead improving Medicare Advantage and ACA performance for Capital Blue Cross. Analyzing results, coordinating vendors, and driving operational initiatives.
Data Governance Analyst
Data Governance & Analytics Analyst governing enterprise data for AFL, a fiber-optic cable and connectivity manufacturer. Developing analytics, dashboards, AI-enabled insights, and data quality frameworks.
Clinical Data Risk Analyst
Clinical Data Risk Analyst assessing clinical-trial data risks for ICON, a global healthcare intelligence and clinical research organization. Ensuring data integrity, compliance, and risk mitigation across Mexico and Colombia.
Senior Risk Analyst
Senior Risk Analyst overseeing merchant collections, ACH funding returns, and fraud investigations. Supporting CSG, a provider of customer-connection and payment technologies.
Senior Manager, Risk Adjustment Market Performance
Senior Manager delivering risk adjustment initiatives for Navvis healthcare markets. Improving risk capture, analytics, provider workflows, compliance, and measurable performance outcomes.
Risk Claims Manager
Risk Claims Manager managing auto liability, property damage, and workers’ compensation claims for a freight transportation company. Investigating losses, coordinating insurers and counsel, and reducing claim exposure.
Senior SAP Master Data Governance, MDG Consultant
Senior SAP MDG consultant designing and governing S/4HANA master data solutions for C5MI’s federal modernization programs. Leading architecture, replication, compliance, and client delivery.
Local Political Expert – Elections Forecasting, Political Risk
Local Iowa political expert producing point-in-time election forecasts and political-risk analysis. Mercor uses expert data to train and improve frontier AI models.
Local Political Expert – Elections Forecasting, Political Risk
Iowa political expert authoring election forecasts and political-risk reports for Mercor. Producing point-in-time judgments to train and evaluate frontier AI models.
Senior Security Risk Analyst, GRC
Senior Security Risk Analyst managing security risk, controls, and GRC reporting for DoorDash’s technology and logistics marketplace. Automating risk workflows and shaping proactive risk management.
Operational Risk Manager – Technology, Payments Operations
Operational Risk Manager building zerohash’s operational risk framework for crypto and stablecoin infrastructure. Leading RCSA, FAIR scenario analysis, loss events, and technology incident oversight.
Fraud Risk Analyst II
Fraud Risk Analyst II overseeing fintech partner fraud reviews for Coastal’s Banking-as-a-Service platform. Monitoring events, compliance risks, and automation outputs.
Quality Control Manager – Risk, Anti-Fraud
Quality Control Manager auditing risk and anti-fraud cases for RISK, an international iGaming company. Monitoring KPIs, identifying systemic errors, and improving operational quality frameworks.
Data Integration and Governance Analyst
Data integration analyst improving automated pipelines and migrating legacy systems for WBL, a provider of short-term commercial loans. Ensuring data quality, reliability, and continuity across business systems.
Senior Corporate Sales Manager – High Risk
Senior Corporate Sales Manager building DNA Payments’ high-risk merchant acquiring business. Winning regulated merchants and partner channels across UK/EU sectors including gaming, healthcare and CBD.
Governance Coordinator
Governance Coordinator supporting BD’s medical technology governance, documentation, and archival processes. Coordinating stakeholders and audits for Swiss HQ operating models in an international environment.