Employee Benefits Reporting Compensation Analyst

Jobtailor; New York (NY); On-site; USD 85,000 - 110,000; Full time

Job summary

Jobtailor in New York, NY, is seeking a Compensation Analyst to support Employee Benefits incentive programs, perform bonus calculations, and generate compensation statements that provide insights into sales performance and business results.

You will collaborate with Sales leadership and stakeholders to optimize compensation arrangements, resolve data issues with Commissions and vendors, and ensure data integrity in a regulated, data-driven environment.

Qualifications

• 3+ years of experience using SQL, data analysis, and QA to support compensation or financial payments.
• Proven ability to build relationships with stakeholders while delivering service and resolving complex issues.
• Excel proficiency with Pivot Tables and VLOOKUPs.
• Proactive, solutions-oriented mindset focused on process improvement.
• Strong organizational skills to manage multiple priorities.
• Attention to detail and data integrity.
• Bachelor's Degree preferred.
• Knowledge of Employee/Group Benefits including compensation practices (preferred).
• Analytical and communication skills.
• Experience in regulated or data-driven compensation/finance ops (preferred).

Responsibilities

• Support the design, review, and administration of Employee Benefits incentive compensation programs.
• Perform monthly, quarterly, and annual bonus calculations.
• Generate compensation statements and provide insights supporting sales performance and business results.
• Partner with Sales leadership to establish and optimize compensation arrangements.
• Collaborate with Commissions, vendors, and cross-functional teams to resolve data issues.
• Perform quality assurance reviews of commission transactions, invoices, and processes.
• Analyze and validate commission data, identify trends, research discrepancies, and recommend solutions.
• Conduct appointment reconciliations between internal systems and state regulatory records.
• Support setup and maintenance of broker and General Agency commission structures, hierarchies, payment scales, and in-force business management.
• Evaluate complex compensation and commission scenarios and recommend operational improvements.

Skills

SQL

Data Analysis

Quality Assurance

Compensation Calculations

Commission Structures

Data Validation

Trend Analysis

Operational Improvement

Appointment Reconciliation

Financial Payment Processes

Education

Associate's Degree

Bachelor's Degree (Preferred)

Tools

Microsoft Excel

Pivot Tables

VLOOKUP

Job description

• Support the design, review, and administration of Employee Benefits incentive compensation programs
• Perform monthly, quarterly, and annual bonus calculations
• Generate compensation statements and provide insights supporting sales performance and business results
• Partner with Sales leadership and business stakeholders to establish, maintain, and optimize compensation arrangements
• Collaborate with Commissions, vendors, and cross-functional teams to investigate and resolve data, file transmission, and downstream system issues
• Perform quality assurance reviews of commission transactions, invoices, and processes
• Analyze and validate commission data, identify trends, research discrepancies, and recommend solutions
• Conduct appointment reconciliations between internal systems and state regulatory records
• Support setup and maintenance of broker and General Agency commission structures, hierarchies, payment scales, and in-force business management
• Evaluate complex compensation and commission scenarios and recommend operational improvements

Requirements

• Associate's Degree
• 3+ years of experience leveraging SQL, data analysis, and quality assurance methodologies to support compensation, commission, or financial payment processes
• Ability to build relationships with internal and external stakeholders while delivering customer service, resolving complex issues, and managing administrative transactions accurately and efficiently
• Microsoft Excel proficiency, including Pivot Tables, VLOOKUPs, and other data analysis tools
• Proactive, solutions-oriented mindset focused on process improvement, controls, and operational effectiveness
• Organizational skills and ability to manage multiple priorities in a dynamic, fast-paced, collaborative environment
• High attention to detail and commitment to data integrity, accuracy, and quality results
• Bachelor's Degree (preferred)
• Knowledge of Employee Benefits and Group Benefits products, including compensation and commission practices (preferred)
• Analytical, problem-solving, written, and verbal communication skills
• Experience supporting compensation, commission, or financial operations processes within a highly regulated or data-driven environment (preferred)

Demonstrates expertise in SQL, data analysis, and quality assurance methodologies to support compensation and commission processes, while maintaining high attention to detail and data integrity. Proven ability to collaborate with stakeholders and optimize compensation arrangements in a fast-paced, regulated environment.

Highest-signal resume keywords

• SQL Data Analysis
• Compensation Program Administration
• Microsoft Excel Proficiency
• Quality Assurance Methodologies
• Employee Benefits Knowledge

ATS Optimization Keywords

Hard Skills

• SQL
• Data Analysis
• Quality Assurance
• Compensation Calculations
• Commission Structures
• Data Validation
• Trend Analysis
• Operational Improvement
• Appointment Reconciliation
• Financial Payment Processes

Soft Skills

• Relationship Building
• Customer Service
• Problem-Solving
• Organizational Skills
• Attention to Detail

Certifications & Qualifications

• Associate's Degree
• Bachelor's Degree (Preferred)

Industry Keywords

• Employee Benefits
• Group Benefits
• Compensation Practices
• Commission Practices
• Regulated Environment

Tools & Technologies

• Microsoft Excel
• Pivot Tables
• VLOOKUP