This is a hybrid position: Monday and Friday Remote; Tuesday, Wednesday, Thursday in Lake County Office Pre-Test Required for Candidates for Pivot Tables; read/write complex formulas, VLOOKUP's, index match and aggregate (sumifs/averageifs). Ideally, would be an Excel SME at an advanced level. Advanced competency in Excel required; experience with HRIS systems such as Workday or HRSoft, and Data Analytics software such as PowerBI is a plus. Bachelor's degree, preferably in HR Management, Business Administration, Finance, Analytics or related field. 2-4 years of relevant work experience supporting compensation programs demonstrable understanding of broad-based concepts and administration. Analytical skills with the ability to interpret complex data sets and identify trends to surface issues and opportunities. Translate findings into actionable insights and recommendations within established guidelines. Strong attention to detail and commitment to data accuracy, validation, and process consistency. Strong written and verbal communication skills. Demonstrated ability to work independently within interpretive guidelines, take initiative, and perform effectively in a fast-paced constantly changing environment As part of the Total Rewards Excellence team the Total Rewards Business Partner (TRBP) is responsible for routine advisory on Total Rewards topics to ensure consistent application of competitive pay practices. The Total Rewards Business Partner will analyze data related to compensation and other reward programs to ensure internal equity and market competitiveness.
Responsibilities:
Develop compensation offer recommendations for external hires and internal moves in accordance with company practices including recommendations on base salary, incentive programs, sign-on or other cash-based programs to provide a market competitive and internally aligned offer
Conduct audits to ensure data accuracy across various HRIS systems leveraged by TR to ensure accurate employee compensation data.
Maintain and keep the various TRBP tools accurate and up to date by running and updating necessary reports.
Serve as an advisor for routine inquiries from Business Human Resources (BHR) and Talent Acquisition (TA) within established guidelines.
Support job evaluations and benchmarking studies to make grade and job code recommendation aligned with company practices maintaining key documentation within the HRIS, benchmarking and case management systems.
Support the execution of various compensation activities including operational support to the annual rewards cycle, compensation recommendations for function specific promotion cycle, survey submissions and establishing the salary structure.
Support market and internal benchmarking studies, gathering and synthesizing data from published sources to evaluate competitive market positioning.
Assist in other ad hoc Compensation projects and tasks as directed.
Capabilities:
Advanced competency in Excel including experience with pivot tables and troubleshooting advanced formulas.
Analytical skills with the ability to interpret complex data sets and identify trends to surface issues and opportunities. Translate findings into actionable insights and recommendations within established guidelines.
Strong attention to detail and commitment to data accuracy, validation, and process consistency.
Demonstrated ability to work independently within interpretive guidelines, take initiative, and perform effectively in a fast-paced constantly changing environment
Strong written and verbal communication skills.
Behaviors / Ways of Working:
Behaves inclusively and equitably so that everyone can contribute and participate.
Deals comfortably with ambiguity and changing course when needed.
Work collaboratively with other team members
Keeps an enterprise and one team mindset with common goals and strategies
Qualifications:
Bachelor's degree, preferably in HR Management, Business Administration, Finance, Analytics or related field.
2-4 years of relevant work experience supporting compensation programs demonstrable understanding of broad-based concepts and administration
Numbers & Facts
Location
Mettawa, Illinois
Job Type
Full-time
Industry
Staffing/Employment Agencies
Salary
$32–$37 Per Hour
Company Size
10 to 19 employees
Website
http://www.colcon.com
About Company
Collins Consulting brings over two decades of total talent solutions experience to meet your on-demand consulting needs. We have an established history of serving clients nationwide in both the public and private industries. These clients range from Fortune 100 companies within the commercial arena to supporting contracts within federal agencies.
Collins Consulting is a certified Service-Disabled Veteran Owned Small Business and a SBA Small Business. We believe in servicing our country's veterans by supporting and nurturing opportunities to join their skillsets with clients who have the same principles. These certifications coupled with Top Secret facility clearance allow us to meet category and diversity goals.
Collins Consulting is agile, innovative, and an award winning advocate in providing total talent solutions to serve your business needs. Whether you are a professional who is looking for a new career or an organization in need of experienced talent, we have the resources to help you.
Skills
Analysis Skillsunmatched
Analysis Softwareunmatched
Auditingunmatched
Benchmarkingunmatched
Business Administrationunmatched
Case Managementunmatched
Channel Strategiesunmatched
Communication Skillsunmatched
Compensation Analysisunmatched
Compensation and Benefitsunmatched
Data Analysisunmatched
Data Collectionunmatched
Data Qualityunmatched
Data Setsunmatched
Detail Orientedunmatched
Documentationunmatched
Equity Securitiesunmatched
Financial Analysisunmatched
HRIS/HRMSunmatched
Human Resourcesunmatched
Human Resources Managementunmatched
Identify Issuesunmatched
Incentive Programsunmatched
Market Analysisunmatched
Operational Supportunmatched
Pivot Tablesunmatched
Power BIunmatched
Presentation/Verbal Skillsunmatched
Product Positioningunmatched
Team Playerunmatched
Trend Analysisunmatched
Vlookupsunmatched
Writing Skillsunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.