Compensation Analyst: Data-Driven Pay & Analytics

Focus Partners; United States; On-site; USD 80,000 - 90,000; Full time

Benefits offered by this job

Annual bonus

Medical, dental, vision

Life insurance

401(k)

Job summary

Focus Partners is seeking a Compensation Analyst to support the development, administration, and continuous improvement of compensation programs across FPW. This role will centralize compensation processes, strengthen governance and audit controls, and enhance reporting and analytics capabilities.

The analyst will collaborate with Finance, HR, Payroll, Sales Operations, and business leaders to ensure accurate compensation administration while identifying opportunities to streamline processes,

Qualifications

• Bachelor's degree in Finance, Business, Accounting, Analytics, or related field.
• 1-3 years of experience in compensation, finance, payroll, sales operations, data analysis, or related analytical role.
• Advanced Microsoft Excel skills including XLOOKUP/VLOOKUP, Pivot Tables, SUMIFS, IF statements.
• Experience working with CRM and large datasets to analyze data.
• Strong analytical and problem-solving abilities.
• Exceptional attention to detail and commitment to data accuracy.
• Strong written and verbal communication skills.
• Ability to manage multiple priorities and meet deadlines.
• Experience supporting sales compensation, incentive compensation, or variable pay programs is preferred.
• Experience with Power BI or other reporting/visualization tools is preferred.

Responsibilities

• Support the administration and execution of compensation programs across multiple FPW divisions.
• Assist with centralization and standardization of compensation processes, policies, and procedures.
• Ensure timely and accurate processing of compensation-related transactions.
• Maintain and monitor compensation data within CRM, Orion and HCM.
• Perform regular audits and reconciliations to ensure data accuracy.
• Develop and maintain documentation for compensation processes, calculations, and system workflows.
• Establish and maintain audit trails for compensation transactions and approvals.
• Ensure compensation processes comply with company policies.
• Provide actionable insights to leadership through data-driven reporting and analysis.
• Identify opportunities to reduce manual processes through automation and system enhancements.
• Support quarter‑end and year‑end compensation processes.

Skills

Excel (Advanced to XLOOKUP/VLOOKUP)

CRM data analysis

Data analytics

Attention to detail

Communication skills

Time management

Sales compensation

Power BI

Education

Bachelor's degree in Finance/Business/Accounting/Analytics

Tools

CRM

Orion

HCM

Power BI

Job description

Focus Partners is seeking a Compensation Analyst to support the development, administration, and continuous improvement of compensation programs across FPW. This role will centralize compensation processes, strengthen governance and audit controls, and enhance reporting and analytics capabilities.

The analyst will collaborate with Finance, HR, Payroll, Sales Operations, and business leaders to ensure accurate compensation administration while identifying opportunities to streamline processes,