Total Rewards Analyst

Better Being

. Build and maintain Power BI and Excel dashboards, reports, and visualizations for compensation, benefits, and workforce trends .

Posted 9/23/2026full-timeSalt Lake City • Utah • United StatesJuniorMid-LevelWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Proficient in building and maintaining Power BI and Excel dashboards for compensation and benefits analysis, with strong analytical skills in trend and variance analysis. Demonstrates expertise in HR metrics, compliance, and data governance while maintaining confidentiality and accuracy in data handling.

Highest-signal resume keywords

Power BI Dashboard DevelopmentExcel Proficiency (Pivot Tables, INDEX/MATCH, XLOOKUP)SQL Querying SkillsCompensation Analysis and ReportingWorldatWork Certification (CCP)

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalysisTrend AnalysisVariance AnalysisPay Equity AnalysisForecastingHR MetricsData GovernanceAutomation TechnologiesBenefits AdministrationReporting

Soft Skills

Excellent Communication SkillsDetail-OrientedAbility to Work IndependentlyCollaborative TeamworkConfidentiality Management

Tools & Technologies

Power BIExcelSQLHCM SystemsWorkday

Certifications & Qualifications

WorldatWork Certification (CCP)

Industry Keywords

CompensationBenefitsWorkforce TrendsData AnalysisHR Compliance

Tech Stack

Tools & technologies

SQL

About the role

Key responsibilities & impact

Build and maintain Power BI and Excel dashboards, reports, and visualizations for compensation, benefits, and workforce trends
Support compensation analysis, market pricing, pay equity reviews, and rewards program effectiveness
Analyze turnover, retention, hiring, promotions, and organizational effectiveness trends
Partner with the Total Rewards team on benefits utilization, enrollment trends, plan performance, and employee participation metrics
Deliver customized analyses supporting business leaders and People Team initiatives
Identify opportunities to automate reporting and improve processes through technology and AI-enabled tools
Assist with annual benefits planning, forecasting, and budget management
Support 401(k) plan administration and annual audit activities, including data collection, reconciliation, testing support, vendor coordination, and documentation
Develop and maintain reporting for healthcare costs, retirement plans, wellness initiatives, leave programs, and other benefits
Maintain accurate HR and benefits records for audit, compliance, and reporting
Support data governance, confidentiality, and security protocols
Participate in company, department, and safety policies, procedures, programs, and activities
Perform other duties as assigned

Requirements

What you’ll need

Bachelor's degree in Business, Analytics, Economics, Statistics, Information Systems, Human Resources, or a related field
2+ years of experience in a role combining HR, compensation, or benefits data with hands-on analysis and reporting
Hands-on proficiency in Excel, including pivot tables, INDEX/MATCH or XLOOKUP, and Power Query
Experience building dashboards and reports in Power BI or a comparable BI tool
Basic to intermediate SQL skills for querying HRIS or reporting databases, or strong willingness/aptitude to learn
Experience applying trend analysis, variance analysis, pay equity analysis, or basic forecasting to workforce or compensation data
Knowledge of HR metrics, practices, and compliance requirements
Excellent written and verbal communication skills
Detail-oriented with a high degree of accuracy in data analysis
Ability to maintain confidentiality and handle sensitive HR and compensation data appropriately
Ability to work independently and collaboratively in a fast-paced environment
Familiarity with AI tools and automation technologies
Familiarity with HCM systems and databases; proficiency in Workday is a plus
WorldatWork certification (CCP) or coursework in compensation analytics is preferred

Benefits

Comp & perks

Access to Employee Health Clinic
Medical, Dental, and Vision Insurance coverage
Family First Program emphasizing work-life balance
401(K) plan with generous employer match
Educational Reimbursement opportunities
Wellness Incentives
Substantial product discounts
Generous Paid Time Off
Paid Holidays