Salary
💰 $67,200 - $80,000 per year
About the role
- Assist with reporting for self-funded pharmacy plan reporting and our total reward program, including data gathering, validating, and utilization analysis.
- Perform regular data audits of HRIS and supporting HR systems, ensuring accuracy and integrity of organizational data across systems.
- Gather and prepare data from multiple sources for compliance filing.
- Create and generate standard and ad-hoc reports to provide insights into workforce trends and metrics for management review.
- Collaborate with HR teams and operational leaders to identify data gaps.
- Provide solutions and generate reports to ensure leaders have data needed to make informed business decisions.
- Manage, create, and maintain HR dashboards and develop presentations for leadership briefings as needed.
- Generate turnover reports and conduct trend analysis, including review of exit interview data for common themes.
- Orient report users to reports, gather feedback, and edit/enhance reports as needed.
- Provides data summaries or statistical analysis for use in strategic planning or decision-making.
- Support employee engagement data analytics as needed.
- Identify opportunities for system enhancements and lead initiatives to implement improvements.
- Process requisitions and promotions for existing positions.
- Assist with annual market analysis and pay equity analyses.
- Manage job description library, ensuring all job descriptions received are in the proper template and format.
- Review new/updated job descriptions to ensure best practices are followed.
- Ensure accuracy of market pricing and merit system data.
- Assist with annual merit and bonus cycle processes including system set up, statement revisions, and general questions.
- Input bonus targets for off-cycle bonuses and perform job evaluations as needed.
- Act as backup to Compensation leader.
- All other duties as assigned
Requirements
- Bachelor’s degree in Business Administration, HR, Finance, Data Science or related field
- 2-4 years of experience creating and generating HRIS reports, and/or managing file feeds, preferably in ADP and/or Cornerstone
- Intermediate to Advanced Excel skills including XLOOKUP, INDEX, MATCH, Pivot tables, keyboard shortcuts, and chart creation
- Proven ability to implement process improvements
- Ability to use logic and critical thinking to identify roadblocks and resolve issues
- Ability to use strong collaboration skills to see projects through completion
- Excellent verbal and written communication skills
- Ability to perform root cause analysis
- Desire to continuously seek performance and process improvements
- Preferred Skills/Experience:
- Experience with compensation administration
- Excel Macro recording and VBA editor
- SHRM-CP, PHR, or similar certification