Associate Director, Finance - Sales Compensation

Page Executive; New York (NY); On-site; USD 170,000 - 210,000; Full time

Job summary

Page Executive is seeking a seasoned Data Architect to own the data foundation for sales compensation across the division. You will design governance, ETL, and a trusted source of truth, partnering with Sales leadership and BI to deliver validated inputs and real-time insights.

You will lead a team of data and compensation analysts, translate complex contracts into reusable data models, and ensure audit-ready data across systems. This role requires strong SQL, scripting, and communication skills.

Qualifications

• 10+ years in sales compensation, data architecture, data governance, or financial systems, including 2+ years in a people leadership role managing analytical teams.
• Hands-on experience in large-scale database design, schema development, ETL pipeline management, advanced SQL querying, database automation, and query performance optimization across complex, high-volume datasets.
• Proficiency in scripting or automation tools - Python/Pandas, VBA, or Alteryx - to design and automate large-scale reconciliation pipelines and standardized adjustment workflows.
• Proven experience establishing SOX-compliant data governance frameworks, including automated audit trails, validation models, and standardized adjustment protocols.
• Experience building and configuring real-time Power BI reports and dashboards, and presenting data-quality metrics to Director-level and above stakeholders.

Responsibilities

• Architect and govern a centralized, SOX-compliant data platform serving as the single source of truth for all commission calculations and sales performance reporting.
• Serve as the first point of contact for sales leadership on data-related matters, proactively detecting and resolving anomalies before they impact calculations, while designing automated reconciliation and standardized adjustment processes.
• Lead and develop a team of data and compensation analysts; set goals, allocate resources, and build a culture of technical excellence and continuous improvement.
• Translate complex commercial contracts into structured, reusable data frameworks that integrate into operational and reporting workflows.
• Partner with Business Intelligence and Systems Analytics to shape Data Warehouse architecture and ETL workflows for validated inputs.
• Communicate and present real-time sales performance analytics and data-quality metrics to senior leadership, translating data architecture for non-technical stakeholders.

Skills

Data architecture

Sales compensation

Data governance

Advanced SQL

Leadership

Python/Pandas

Tools

Power BI

Alteryx

Python

VBA

Job description

This role sits at the intersection of Finance, Sales Operations, and Technology - and it's central to how our client ensures every sales commission is calculated on a clean, trusted, and fully governed data foundation. As the primary data architect and strategic partner for Sales leadership, you will shape the infrastructure that powers commercial decisions across the division.

Our client has a high-accountability, globally connected Sales Compensation team that values disciplined execution, a strong sense of urgency, and end-to-end ownership.

Description

• Architect and govern a centralized, SOX-compliant data platform - owning schema design, tool selection, database build-out, and ongoing maintenance - that serves as the single source of truth for all commission calculations and sales performance reporting.
• Serve as the first point of contact for sales leadership on all data-related matters - proactively detecting and resolving anomalies (e.g., double-counted revenue, incorrect territory mapping) before they impact calculations, while designing and implementing automated reconciliation and standardized adjustment processes that ensure data integrity and audit-readiness at scale.
• Lead and develop a team of data and compensation analysts: set goals, allocate resources, and build a culture of technical excellence and continuous improvement.
• Translate complex commercial contracts - including joint/split deals and strategic accounts - into structured, reusable data frameworks that integrate cleanly into operational and reporting workflows.
• Partner with Business Intelligence and Systems Analytics to shape Data Warehouse architecture and ETL workflows, ensuring downstream analytics always run on validated, trusted inputs.
• Communicate and present real-time sales performance analytics and data-quality metrics to senior leadership, while translating complex data architecture into plain English for sales reps and leaders - resolving data-related questions and driving adoption of correct processes across the organization.

Profile

Basic Required Qualifications

• Experience: 10+ years in sales compensation, data architecture, data governance, or financial systems, including 2+ years in a people leadership role managing analytical teams.
• Database, Automation and Optimization: Hands-on experience in large-scale database design, schema development, ETL pipeline management, advanced SQL querying, database automation, and query performance optimization across complex, high-volume datasets.
• Reconciliation and Adjustments: Demonstrated proficiency in at least one scripting or automation tool - Python/Pandas, VBA, or Alteryx - to design and automate large-scale reconciliation pipelines and standardized adjustment workflows, ensuring data integrity and calculation accuracy at scale.
• Governance and Compliance: Proven experience establishing SOX-compliant data governance frameworks, including automated audit trails, validation models, and standardized adjustment protocols.
• Real-Time Reporting: Experience building and configuring real-time Power BI reports and dashboards, and presenting data-quality metrics and insights to Director-level and above stakeholders.

Additional Preferred Qualifications

• Prior experience in a sales compensation platform environment (e.g., Xactly, Anaplan, SAP Commissions, or equivalent).
• Experience interpreting and translating complex commercial deal structures - including joint/split deals, multi-party credits, and territory hierarchies - into clean, system-ready data constructs.
• Background contributing to Data Warehouse architecture or scalable BI infrastructure within a cross-functional Finance or Sales Operations environment.
• Track record converting ambiguous legacy workflows into documented SOPs and measurable SLAs.
• Ability to proactively identify and resolve revenue anomalies (e.g., double-counted revenue, incorrect territory mapping) before they impact commission execution.
• Strong verbal and written communication skills - able to explain database logic and commission calculations clearly to non-technical stakeholders including Sales Directors and senior commercial leadership.