Compensation Specialist

Total Rewards Business PartnerThis 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.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 offerConduct 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.CapabilitiesAdvanced 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 environmentStrong written and verbal communication skills.Behaviors / Ways of WorkingBehaves inclusively and equitably so that everyone can contribute and participate.Deals comfortably with ambiguity and changing course when needed.Work collaboratively with other team membersKeeps an enterprise and one team mindset with common goals and strategiesQualifications: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 administrationRequires strong written communication skills, with the ability to produce clear, professional, and grammatically sound corporate-level English content for audiences at all levels, including stakeholders. The benefits that you are eligible for with Collins Consulting, Inc:401(k)Medical, Dental and Vision InsuranceTerm Life InsuranceAccidental Death and DismembermentLong Term Disability