Total Rewards Analyst

Better Being; Ogden (UT); Hybrid; USD 70,000 - 95,000; Full time

Benefits offered by this job

Health Clinic access

Medical, Dental & Vision insurance

Family First Program

401(k) employer match

Educational reimbursement

Wellness incentives

Product discounts

Paid time off & holidays

Job summary

Better Being is seeking a Total Rewards Analyst who is hands-on with data to partner with the Director of Total Rewards. Build pivot tables, Excel formulas, and Power BI dashboards from HRIS data to turn pay, benefits, and workforce trends into actionable insights.

This role focuses on analysis within existing tools (Excel, Power BI, Workday), not data engineering. Hybrid onsite in Ogden, UT with occasional Salt Lake City travel.

Qualifications

• 2+ years in HR/compensation analytics with hands-on data reporting.
• Proficient in Excel (Pivot, INDEX/MATCH or XLOOKUP).
• Experience building dashboards in Power BI.
• Basic SQL or eagerness to learn SQL.
• Knowledge of HR metrics and compliance.

Responsibilities

• Build and maintain Power BI and Excel dashboards for leadership.
• Support compensation analysis, market pricing, pay equity.
• Analyze turnover, retention, hiring, promotions and org effectiveness.
• Analyze benefits utilization and enrollment trends.
• Deliver customized analyses to support People Team initiatives.
• Identify opportunities to automate reporting with AI tools.
• Assist with benefits planning, budgeting and audits.

Skills

Excel pivot tables

Power BI dashboards

Data analysis

Attention to detail

Communication

Education

Bachelor's degree in Business, Analytics, Economics, Statistics, Information Systems, Human Resources, or related field

Tools

Workday

SQL

Power Query

Job description

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.

Ability to work onsite at Better Being's Ogden, UT office a minimum of four (4) days per week, with one (1) day per week eligible for remote work, and the ability to travel occasionally to our Salt Lake City office as business needs require.

Regular, reliable, in‑person attendance at the Ogden office is an essential function of this role.

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 analytics.

Physical Requirements

While performing the duties of this job, the employee is occasionally required to stand, walk, sit, reach with hands and arms, and talk or hear. Employee must exert up to 30 lbs. of force occasionally, and/or up to 10 lbs. of force frequently, and/or a negligible amount of force constantly to move objects. Specific vision abilities required by this job include near acuity, far acuity, depth perception, accommodation, color vision, and field of vision.

Our Benefits

Join our team and enjoy a comprehensive package of competitive benefits and perks designed to support your well‑being and professional growth.

• Access to our Employee Health Clinic for your medical needs.
• Comprehensive Medical, Dental, and Vision Insurance coverage.
• Participation in our Family First Program, emphasizing work‑life balance.
• 401(K) plan with generous employer match to help you plan for the future.
• Educational Reimbursement opportunities to support your continued learning and development.
• Wellness Incentives to promote a healthy lifestyle.
• Substantial product discounts, because we value our team members as customers too.
• Generous Paid Time Off and Paid Holidays, ensuring you have time to rest and recharge.

For more information, check out our website Better Being Careers and join us in experiencing a workplace where your well‑being and success are our top priorities.

This description is not intended to be an exhaustive list of responsibilities and qualifications. The position, duties, and qualifications are subject to change at any time.

We provide equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

At Better Being 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.