Position Details

Type Internship

Experience intern

Exp. Years 0-2 years

Education Bachelor's or Master's degree in related field

Category Human Resources & Recruiting

About this role

Compensation Intern supports compensation programs by maintaining pay bands and salary ranges, benchmarks market data, and analyzes compensation data in Excel to ensure alignment with ranges and trends.

Key Responsibilities

Support maintenance of pay bands, salary ranges, and job leveling documentation
Collect and organize compensation market data for benchmarking
Analyze compensation data in Excel to validate alignment to ranges and identify trends
Assist with the annual compensation refresh
Document compensation processes, templates, and workflows

Technical Overview

Hands-on Excel data work including Pivot tables, VLOOKUP, XLOOKUP; gathering and documenting compensation processes; cross-functional collaboration for annual compensation refresh.

Ideal Candidate

The ideal candidate is a student pursuing a bachelor’s or master’s in HR or related field, with strong Excel data skills (Pivot, VLOOKUP, XLOOKUP), high attention to detail, and a curiosity for how compensation decisions are made.

Must-Have Skills

Currently pursuing a Bachelor's or Master's degree in HROrganization DevelopmentStatisticsBusinessEconomicsFinanceor related fieldExperience with data in Excel including Pivot tablesVLOOKUPand XLOOKUPStrong attention to detailAbility to clearly explain data or findings

Nice-to-Have Skills

Coursework in compensationHR analyticsfinanceor data analysisExperience with large datasetsreportingor data validationFamiliarity with HR systemssurveysor benchmarking toolsExperience balancing multiple tasks or deadlines

Tools & Platforms

Excel

Required Skills

pivotsvlookupxlookupexceldata analysiscompensationpay bandssalary rangesjob levelinghr analyticsbenchmarkingattention to detail

Hard Skills

ExcelPivot tablesVLOOKUPXLOOKUPdata analysisbenchmarking

Soft Skills

attention to detailcommunicationorganizationproblem solving

Industry & Role

Industry SaaS

Job Function Assist with compensation data analysis and documentation to support equitable pay decisions during the internship.

Role Subtype HR Intern

Keywords for Your Resume

compensation internsupplyhouse.comremote internshipexcel pivot tablesvlookupxlookupdata analysisbenchmarkingsalary rangespay bandsjob levelinghr analyticsinternusa work authorization106? noton-site julyinternshipexcelpivot tables

Deal Breakers

Not pursuing a degree in a related field, Lack of Excel data skills, No US work authorization

Apply for this Position →

Get matched to jobs like this

Luna finds roles that fit your skills and career goals — no endless scrolling required.

Create a Free Profile

Compensation Analyst Intern

Get matched to jobs like this