Total Rewards Analyst

nutraceutical; Salt Lake City (UT); Hybrid; USD 70,000 - 90,000; Full time

Job summary

Better Being Co. seeks a Total Rewards Analyst to turn HRIS data into actionable insights. You’ll build dashboards in Power BI and Excel, analyze pay and benefits, and partner with the Director of Total Rewards to inform leadership decisions.

This hands-on role focuses on data analysis and reporting within existing tools, not on data engineering. If you’re curious, enjoy solving problems with data, and want to grow in People Analytics and Total Rewards, we’d love to meet you.

Qualifications

• Strong Excel skills with pivot tables and advanced formulas.
• Experience building dashboards in Power BI.
• Basic SQL or willingness to learn.
• Experience with HRIS data and compensation/benefits analytics.

Responsibilities

• Build and maintain dashboards in Power BI and Excel for compensation and benefits insights.
• Support compensation analysis, market pricing, pay equity reviews, and rewards program effectiveness.
• Analyze workforce trends and translate findings into recommendations for leaders.
• Partner with Total Rewards to analyze benefits utilization, enrollment trends, and plan performance.
• Deliver customized analyses to support People Team initiatives.
• Identify opportunities to automate reporting using technology and AI-enabled tools.

Skills

Pivot tables

Excel formulas

Power BI

Power Query

XLOOKUP

SQL basics

HRIS data

Data analysis

Communication skills

Forecasting

Pay equity

Variance analysis

Data governance

Education

Bachelor's degree

Tools

Workday

Job description

This hybrid role offers the flexibility to work from either our Ogden or Salt Lake City office. Employees are expected to work onsite at their designated office location at least four days per week.

About Us

At Better Being Co. we empower and inspire individuals to feel better and live healthier lives by providing the most trustworthy, pure, and innovative natural wellness solutions. If you thrive in a challenging work environment, surrounded by incredible team members who will help you grow and do your best work, Better Being is the right place for you. Come build with us and be part of an award-winning company that's helping create meaningful and lasting change in the healthcare industry.

Job Summary

At Better Being, we believe our people are our greatest competitive advantage. We're looking for a Total Rewards Analyst who is hands‑on with data. Someone comfortable building pivot tables, writing Excel formulas, and putting together Power BI dashboards from HRIS data - to partner closely with the Director of Total Rewards and turn workforce and compensation data into clear, actionable recommendations. This highly visible role influences decisions across the organization by transforming data on pay, benefits, and workforce trends into insights leaders can act on.This role focuses on analysis and reporting within our existing tools and platforms (Excel, Power BI, Workday). It is not a data engineering role, and it does not involve building data pipelines, warehouses, or custom software. If you're naturally curious, enjoy solving problems through data, and want to build your expertise in People Analytics and Total Rewards, we'd love to meet you.

Essential Functions

• Build and maintain dashboards, reports, and visualizations in Power BI and Excel that give leadership visibility into compensation effectiveness, benefits program performance, and workforce trends.
• Support compensation analysis, market pricing, pay equity reviews, and rewards program effectiveness using tools such as pivot tables, INDEX/MATCH or XLOOKUP, Power Query, and Power BI data modeling.
• Analyze workforce trends including turnover, retention, hiring, promotions, and organizational effectiveness, and translate findings into recommendations for business leaders.
• Partner with the Total Rewards team to analyze benefits utilization, enrollment trends, plan performance, and employee participation metrics.
• Deliver timely, customized analyses that support 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 by providing data analysis and reporting.
• Support 401(k) plan administration and annual audit activities, including data collection, reconciliation, testing support, vendor coordination, and documentation.
• Develop and maintain reporting related to healthcare costs, retirement plans, wellness initiatives, leave programs, and other benefit offerings.
• Assist in creating and maintaining accurate HR and benefits records for audit, compliance, and reporting purposes.
• Support data governance, confidentiality, and security protocols related to employee, compensation, and benefits information.
• Support and participate in company, department, and safety policies, procedures, programs, and activities.
• Perform other duties as assigned.

Job Qualifications

• Bachelor's degree in Business, Analytics, Economics, Statistics, Information Systems, Human Resources, or a related field.
• 2+ years of experience in a role that combined HR, compensation, or benefits data with hands‑on analysis and reporting - for example, as a compensation analyst, HR/people analytics analyst, benefits analyst, or a quantitative/business analyst role with direct exposure to workforce data.
• Demonstrated, hands‑on proficiency in Excel, including pivot tables, INDEX/MATCH or XLOOKUP, and Power Query.
• Experience building (not just viewing) 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 analytical methods such as 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, with the ability to translate data into a clear narrative for non‑technical audiences.
• 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.

Preferred Qualifications

• 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