Consultant, Process Management (Compensation Administration)
Core
Consultant supporting complex Standard Variable and Base Compensation plans, including NWAG Profit Share, Base Commissions, and OCP/EGP, ensuring accurate calculations, data validation, and operational resilience.
Role type
Senior IC compensation process consultant
Builds
Accurate compensation payments and reports for Property and Casualty business lines
Domain
Insurance / Compensation Administration
Required skills
Advanced Excel (formulas, validation, reconciliation), complex calculation analysis, data reconciliation, root cause analysis, process documentation, UAT participation, stakeholder coordination, peak-period capacity management, continuous improvement
Preferred skills
SAP workflows, SQL, Power BI, Power Automate, macro development, variable compensation administration, process transition experience
Technologies
Excel, SAP, SQL, Power BI, Power Automate
Responsibilities
Serve as Plan Owner for NWAG Profit Share transition; co-own complex compensation plans; perform complex calculations and data validation; analyze plan results and identify discrepancies; participate in UAT and defect resolution; coordinate with Finance, IT, and Business Insights; document processes and establish backup coverage; support peak-period processing; recommend automation and process improvements.
Seniority
Senior, hands-on IC