Remote Senior Compensation Analyst - Incentives & Data

Swoon; Chicago (IL); Remote; USD 89,000 - 123,000; Full time

Job summary

Swoon is seeking a Senior Analyst to support a major transformation of sales reporting and incentive compensation within a Wealth Management organization. The role focuses on financial data analysis, reconciliation, reporting, and validation as legacy processes move to Salesforce and Varicent.

The ideal candidate has advanced Excel skills, strong analytical abilities, and experience with complex datasets. Experience supporting incentive compensation, sales compensation, or financial reporting is

Responsibilities

• Analyze and reconcile large datasets to ensure accuracy across sales reporting and incentive compensation processes.
• Utilize advanced Microsoft Excel functions, including VLOOKUP, INDEX/MATCH, and data queries, to identify discrepancies and validate information.
• Support incentive compensation calculations, reporting, data validation, and reconciliation activities.
• Perform parallel testing and compare legacy reporting outputs against new system calculations.
• Investigate missing or inaccurate information, identify root causes, and resolve data inconsistencies.
• Communicate with sales representatives and business stakeholders to gather information, address discrepancies, and resolve compensation-related questions.
• Support the transition from manual reporting and validation processes to more automated solutions.
• Assist with financial reporting, control documentation, testing, and audit-related activities as needed.
• Identify opportunities to improve reporting accuracy, data integrity, and operational efficiency.
• Work independently to troubleshoot issues, manage competing priorities, and recommend solutions.

Job description

Swoon is seeking a Senior Analyst to support a major transformation of sales reporting and incentive compensation within a Wealth Management organization. The role focuses on financial data analysis, reconciliation, reporting, and validation as legacy processes move to Salesforce and Varicent.

The ideal candidate has advanced Excel skills, strong analytical abilities, and experience with complex datasets. Experience supporting incentive compensation, sales compensation, or financial reporting is