Role Overview: We are seeking a motivated and detail-oriented Junior Compensation & Benefits Analyst to join our team. In this role, you will assist with the administration of employee compensation and benefits programs, with a strong focus on data analysis, reporting, and Excel-based modeling. You will play a key role in ensuring the accuracy and efficiency of compensation and benefits processes, supporting decision-making with data-driven insights.

Reporting directly to Senior Compensation and Benefits Specialist, you will be responsible for:

• Assist in the analysis and maintenance of compensation structures, including salary surveys, market benchmarking, and pay equity analysis.
• Support the annual salary review process by gathering and preparing relevant data.
• Prepare and maintain compensation and benefits-related reports and dashboards using Excel.
• Assist in analyzing compensation data to identify trends, disparities, and opportunities for improvement.
• Support the team in managing data integrity and accuracy for compensation and benefits databases.
• Assist in the administration of employee benefits programs (health, wellness, retirement, etc.), ensuring that employee enrollments, changes, and terminations are processed accurately.
• Help communicate benefits offerings to employees and assist with benefits inquiries.
• Assist in the research and analysis of industry trends and external compensation data to ensure competitive compensation and benefits packages.
• Build and maintain spreadsheets and models to calculate compensation and benefits figures, including bonus structures, salary increases, and cost-of-living adjustments.
• Use advanced Excel functions (e.g., VLOOKUP, pivot tables, formulas) to generate insights and assist in decision-making.
• Contribute to the continuous improvement of compensation and benefits processes, helping to streamline tasks and enhance data accuracy.

The ideal candidate should possess the following background

• Bachelor's degree in Human Resources, Business Administration, Finance, or a related field. (Relevant coursework or certifications in compensation/benefits will be a plus.)
• 1-2 years of experience in compensation and benefits, HR analytics, or a data-driven administrative role.
• Experience with compensation surveys and benefits administration is a plus but not required.
• Proficient in Microsoft Excel, including advanced functions such as VLOOKUP, pivot tables, formulas, and data analysis tools.
• Familiarity with HRIS (Human Resource Information Systems) or compensation/benefits software is a plus.
• Strong data analysis and problem-solving skills, with the ability to manage large sets of data.
• Excellent verbal and written communication skills, with the ability to explain complex data to non-technical stakeholders.
• Ability to work collaboratively across departments and interact with employees at all levels.
• Strong organizational skills with high attention to detail and accuracy, especially when working with numerical data.