Sales Compensation Data Architect

Confidential; United States; On-site; USD 180,000 - 240,000; Full time

Job summary

Confidential, based in New York, seeks a Sales Compensation Data Architect to lead design, governance, and ongoing management of a centralized, SOX-compliant data platform for commission calculations and sales performance reporting. You will own schema design, tool selection, and build-out of the database, drive data integrity, automate reconciliations, and develop standardized adjustment protocols.

You will lead a team of data and compensation analysts and collaborate with BI and Systems

Qualifications

• Extensive experience in sales compensation, data architecture, data governance or financial systems, including leadership of analytical teams.
• Proficiency in large-scale database design, ETL pipeline management, advanced SQL querying and automation tools.
• Proven track record in establishing SOX-compliant data governance frameworks.
• Strong communication skills for presenting real-time analytics and data-quality metrics to senior leadership.

Responsibilities

• Own schema design, tool selection, database build-out and maintenance for a centralized data platform.
• Lead and develop a team of data and compensation analysts; set goals and allocate resources.
• Collaborate with BI and Systems Analytics teams to shape Data Warehouse architecture and ETL workflows.
• Develop automated reconciliation processes and standardized adjustment protocols to ensure data integrity and audit readiness.
• Act as primary data liaison for sales leadership and translate contracts into structured data for workflows.

Skills

Data architecture

Sales compensation

SOX governance

SQL querying

ETL pipelines

Automation tools

Leadership

Communication skills

Data governance

Job description

The client is seeking a Sales Compensation Data Architect based in New York to lead the design, governance, and ongoing management of a centralized, SOX-compliant data platform for commission calculations and sales performance reporting. This role is responsible for owning schema design, tool selection, database build-out, and maintenance, ensuring the platform serves as the single source of truth for all related data. The position requires proactive detection and resolution of data anomalies, implementation of automated reconciliation processes, and the development of standardized adjustment protocols to maintain data integrity and audit readiness.

The successful candidate will serve as the primary point of contact for sales leadership on data-related matters, translating complex commercial contracts into structured, reusable data frameworks that integrate seamlessly into operational workflows. The role involves leading and developing a team of data and compensation analysts, setting goals, allocating resources, and fostering a culture of technical excellence and continuous improvement. Collaboration with Business Intelligence and Systems Analytics teams is expected to shape Data Warehouse architecture and ETL workflows, ensuring downstream analytics are based on validated, trusted inputs.

Applicants should have extensive experience in sales compensation, data architecture, data governance, or financial systems, including leadership of analytical teams. Proficiency in large-scale database design, ETL pipeline management, advanced SQL querying, and automation tools is required, along with a proven track record in establishing SOX-compliant data governance frameworks. Strong communication skills are essential for presenting real-time analytics and data-quality metrics to senior leadership and for translating complex data architecture into accessible language for stakeholders. A competitive compensation package is offered for this role.