HR Specialist / Compensation Analyst / Excel / PowerBI-BA

Would you be avail / interested in this AbbVie position coming tomorrow? If not avail would you know anyone else? It is a hybrid role in North Chicago. 3 days onsite 2 remote. Thank you, Denise denisep@kyyba.com HR Specialist / compensation / benefits / Excel / PowerBI 31712 36.00 an hour + 5 PTO days Location : 1 N Waukegan Road, Building : AP34; North Chicago, Illinois, United States of America 60064-1802 - 40 hours a week typically 8am – 5pm M-F with flexibility to accommodate global team Hybrid onsite days expected to be Tuesday through Thursday to accommodate AbbVie's policy starting in January 2026. Contract : 1 year - based on performance and business needs Top 3 – 5 Skills Needed for each role 1. Advanced competency in Excel required; experience with PowerBI a plus. 2. Bachelor’s degree, preferably in HR Management, Business Administration, or related field. 2-3 years of relevant work experience in either Human Resources, Compensation and Benefits or Finance 3. Demonstrated ability to lead projects and drive initiatives from concept to execution 4. Strong analytical skills with the ability to interpret complex data sets and identify trends, exceptional detail orientation, ability to creatively develop offers within established guidelines and manage stakeholders 5. Demonstrated ability to work independently within interpretive guidelines, take initiative, and perform effectively in a fast-paced constantly changing environment Total Rewards Business Partner (Contract) Location : Lake County, IL – Hybrid Role 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.

• Serve as an advisor for routine inquiries from Business Human Resources (BHR) and Talent Acquisition (TA).
• Conduct 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. Lead global job evaluation projects related to functional roles across multiple geographies.
• Develop market-competitive and internally aligned compensation offer recommendations for external hires and internal moves, in accordance with company practices, including recommendations on base salary, incentive programs, sign-on bonuses, or other cash-based programs.
• Conduct audits to ensure data accuracy across various HRIS systems leveraged by TR to ensure accurate employee compensation data.
• Support the execution of various compensation programs for the assigned client group(s) and project(s) this includes operational support to the annual rewards cycle, leading the compensation recommendations for function specific promotion cycle, survey submissions and establishing the salary structure.
• Lead and participate in market and internal benchmarking studies, gathering and synthesizing data from published sources to evaluate competitive market positioning. Analyze compensation data to identify trends, ensure internal equity, and provide actionable recommendations or solutions for specific compensation-related questions and issues.
• Maintain and keep the various TRBP tools accurate and up to date by running and updating necessary reports.
• Assist in other ad hoc Compensation projects and tasks as directed by Functional TRBP Team Lead Capabilities
• Advanced competency in Excel including experience with pivot tables and troubleshooting advanced formulas
• Understanding of Compensation concepts and administration.
• Ability to use previous reward experience to complete new tasks.
• Excellent analytical and communication skills including written and verbal.
• Strong analytical skills with the ability to interpret complex data sets and identify trends. 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