Compensation & People Analytics Analyst

Summary

Quantum Health is a healthcare navigation organization focused on simplifying the cost and complexity of healthcare for its members. The Compensation & People Analytics Analyst supports compensation administration, incentive calculations, Power BI reporting, workforce analytics, and process automation to improve compensation decision-making and operational effectiveness.

Responsibilities

• Support the administration of annual merit, bonus, and incentive compensation programs
• Calculate commissions, quarterly incentives, and bonus payouts while ensuring accuracy and compliance with plan documents
• Audit compensation data and resolve discrepancies prior to payroll processing
• Partner with Payroll to validate compensation-related payments
• Support market pricing activities and compensation analysis
• Maintain compensation documentation, templates, and reporting resources
• Design, build, and maintain Power BI dashboards for compensation, workforce, and HR metrics
• Develop automated reporting solutions that improve visibility into workforce trends and compensation programs
• Analyze workforce, compensation, and incentive data to identify trends and deliver actionable insights
• Create recurring executive-level reports for HR and business leadership
• Ensure data integrity across HRIS, payroll, and reporting systems
• Administer monthly, quarterly, and annual commission and bonus calculations
• Validate performance data supporting incentive payments
• Partner with Finance and business leaders to reconcile payout calculations
• Maintain incentive tracking files and reporting
• Support annual incentive plan updates, testing, and implementation
• Identify opportunities to automate manual compensation and reporting processes
• Improve reporting accuracy through Power BI and HRIS enhancements
• Document compensation administration procedures and reporting processes
• Partner with HRIS teams to improve workflows and reporting capabilities
• Support continuous improvement initiatives across the Total Rewards function
• Perform other duties as assigned by leadership or business needs dictate

Skills

• • Bachelor's degree in Human Resources, Business, Finance, Analytics, Data Science, or a related field
• • 3 to 5 years of experience in compensation, HR analytics, finance, payroll, or business analytics
• • Strong Microsoft Excel skills, including:
• + Pivot Tables
• + XLOOKUP
• + Power Query
• + Complex formulas
• • Advanced Power BI experience, including dashboard development and data visualization
• • Experience administering commissions, incentive plans, or bonus programs
• • Strong analytical and problem-solving abilities
• • Exceptional attention to detail with a high degree of accuracy
• • Ability to handle confidential compensation and employee data
• • Excellent communication, collaboration, and stakeholder management skills
• • Location: This position may work remotely anywhere in the United States of America or may work hybrid from our Dublin, Ohio location
• • Applicants must be legally authorized to work in the United States on a permanent and ongoing future basis without requiring sponsorship
• • Experience with UKG Pro or a similar HRIS platform
• • Experience using compensation survey tools such as Mercer, Radford, Salary.com, or similar platforms
• • Knowledge of Power Automate and/or Power Query
• • Basic SQL experience
• • Experience supporting annual compensation planning and review cycles

Qualifications

Must Haves

• • Bachelor's degree in Human Resources, Business, Finance, Analytics, Data Science, or a related field
• • 3 to 5 years of experience in compensation, HR analytics, finance, payroll, or business analytics
• • Strong Microsoft Excel skills, including:
• + Pivot Tables
• + XLOOKUP
• + Power Query
• + Complex formulas
• • Advanced Power BI experience, including dashboard development and data visualization
• • Experience administering commissions, incentive plans, or bonus programs
• • Strong analytical and problem-solving abilities
• • Exceptional attention to detail with a high degree of accuracy
• • Ability to handle confidential compensation and employee data
• • Excellent communication, collaboration, and stakeholder management skills
• • Location: This position may work remotely anywhere in the United States of America or may work hybrid from our Dublin, Ohio location
• • Applicants must be legally authorized to work in the United States on a permanent and ongoing future basis without requiring sponsorship

Nice to Haves

• • Experience with UKG Pro or a similar HRIS platform
• • Experience using compensation survey tools such as Mercer, Radford, Salary.com, or similar platforms
• • Knowledge of Power Automate and/or Power Query
• • Basic SQL experience
• • Experience supporting annual compensation planning and review cycles

Benefits

• Competitive incentive compensation
• Health, vision and dental featuring our best-in-class healthcare navigation services
• Life insurance
• Legal and identity protection
• Adoption assistance
• EAP
• Teladoc services
• 401(k) plan with up to 4% employer match and full vesting on day one
• Paid Time Off (PTO)
• 7 paid holidays
• Parental leave
• Volunteer days
• Paid sabbaticals
• Tuition reimbursement up to $5,250 annually
• Certification/continuing education reimbursement
• Discounted higher education partnerships
• Paid trainings
• Leadership development
• Recognition as a Best Place to Work for 15+ years
• Dedication to diversity, philanthropy and sustainability, and people-first values that drive every decision
• A modern workplace with a casual dress code
• Open floor plans
• Full-service dining
• Free snacks and drinks
• Complimentary 24/7 fitness center with group classes
• Outdoor walking paths
• Game room
• Notary and dry-cleaning services
• This position may work remotely anywhere in the United States of America or may work hybrid from our Dublin, Ohio location