Compensation Analytics Specialist

Focus Partners Wealth; United States; Remote; USD 80,000 - 90,000; Full time

Benefits offered by this job

Annual cash bonus

Comprehensive benefits: medical,Dental

401(k)

Job summary

Focus Partners Wealth is seeking a Compensation Analyst to support development and administration of compensation programs across FPW. The role emphasizes governance, data integrity, and reporting analytics, collaborating with Finance, HR, Payroll, Sales Operations, and leaders to streamline processes and increase transparency.

The ideal candidate will have 1–3 years of experience, strong Excel and CRM skills, and familiarity with compensation data.

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, Pivot Tables, SUMIFS, IF statements.
• Experience working within CRM and large dataset to analyze.
• Strong analytical and problem-solving abilities.

Responsibilities

• Support administration and execution of compensation programs across FPW divisions.
• Assist 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

Advanced Excel

Power BI

CRM data analysis

Data governance

Analytical thinking

Education

Bachelor's degree in Finance/Accounting/Analytics

Tools

Excel

Power BI

CRM

Orion HCM

Job description

Focus Partners Wealth is seeking a Compensation Analyst to support development and administration of compensation programs across FPW. The role emphasizes governance, data integrity, and reporting analytics, collaborating with Finance, HR, Payroll, Sales Operations, and leaders to streamline processes and increase transparency.

The ideal candidate will have 1–3 years of experience, strong Excel and CRM skills, and familiarity with compensation data.