Sales Compensation Data Architect Lead

SMP GLOBAL PTE. LTD.; Singapore; On-site; SGD 120,000 - 180,000; Full time

Benefits offered by this job

Health & Wellness

Flexible Downtime

Continuous Learning

Retirement planning

Family perks

Job summary

S&P Global Market Intelligence seeks a seasoned TheFinance Associate Director, Sales Compensation to lead the data architecture and strategy for commissions and reporting. You will own the data platform, drive governance, and partner with BI and analytics teams to ensure clean, trusted data for leadership.

This role demands deep SQL, warehousing, and executive reporting expertise in a finance-sales context.

Qualifications

• 10+ years in sales compensation, data architecture, data governance, financial systems, sales operations, or a related field, including experience leading and developing high-performing analytical teams.
• Deep hands-on experience in database building, schema design, database maintenance, data warehousing, ETL processes, and advanced SQL querying across very large and complex data environments.
• Proven ability to identify, evaluate, and implement tools that consolidate disparate data sources into a unified single source of truth for commissions, sales performance analytics, and reporting.
• Practical experience with script-based reconciliation or automation tools such as VBA, Python/Pandas, SQL, Alteryx, or equivalent methods to rapidly reconcile large dataset pipelines and identify data integrity issues.
• Proven track record establishing and enforcing data governance policies, automated reconciliation frameworks, standardized adjustment protocols, territory hierarchies, validation models, and SOX-compliant audit trails.
• Ability to interpret complex commercial deal structures and translate them into clean, structured, repeatable data frameworks for system processing.
• Experience developing reporting, dashboards, and data health metrics in Power BI, with ability to present insights, risks, and trends to senior leadership.
• Experience partnering with BI, Systems Analytics, Commissions, and Sales Operations to troubleshoot data pipelines and support scalable infrastructure.
• Demonstrated ability to transform ambiguous or legacy workflows into documented SOPs, clear SLAs, and repeatable processes.

Responsibilities

• Manage, mentor, and develop a high-performing team of data and compensation analysts by defining goals, allocating resources, and fostering technical excellence and continuous improvement.
• Own the full data platform lifecycle for extremely large, complex datasets: lead database build-out, schema design, tool selection, and ongoing maintenance to support commission calculations and sales reporting.
• Design and implement automated reconciliation and standardized adjustment processes to ensure data integrity, accuracy, and audit-ready change management.
• Partner with Business Intelligence and Systems Analytics teams to shape Data Warehouse architecture, ETL workflows, and scalable infrastructure that supports reliable downstream analytics.
• Translate complex commercial contracts into structured, reusable data constructs that integrate cleanly into operational systems and reporting workflows.
• Establish, document, and enforce enterprise data governance—covering data health, traceability, and operational consistency—across the organization.
• Govern audit trails and automated validation models so every data change is fully traceable and SOX-compliant, and so calculations run on validated inputs.
• Produce and communicate sales performance analytics and data-quality metrics for senior leadership, highlighting trends, risks, and root causes.
• Communicate complex data and architecture in clear plain English for sales reps and leaders, resolving data-related questions and driving adoption of correct processes.
• Serve as the first point of contact for sales leadership; proactively detect and resolve data anomalies (e.g., double-counted revenue, incorrect territory mapping) before they impact calculations.
• Lead end-to-end pipeline and calculation troubleshooting with Commissions and Systems Analytics to ensure clean, validated data foundations.
• Lead process design and standardization by converting ambiguous legacy workflows into documented SOPs and clear SLAs.

Skills

Data architecture

SQL querying

Data governance

SOX compliance

Automation

Executive reporting

Stakeholder communication

Tools

Power BI

ETL tools

Python/Pandas

Alteryx

Job description

S&P Global Market Intelligence seeks a seasoned TheFinance Associate Director, Sales Compensation to lead the data architecture and strategy for commissions and reporting. You will own the data platform, drive governance, and partner with BI and analytics teams to ensure clean, trusted data for leadership.

This role demands deep SQL, warehousing, and executive reporting expertise in a finance-sales context.