Compensation Analyst Data Entry

JENNIFER LEIGH WEILER, CCP

Plano, TX, ***** 214-***-****

linkedin.com/in/jennifer-leigh-weiler-a27153187/ ********.*****.******@*****.***

Compensation / Financial Analyst

Serve as a consultant to client groups on compensation issues, ensuring compensation decisions are in alignment with the organization's compensation and total rewards philosophy and the business strategy

Propel success for clients while effectively analyzing and diagnosing problems, providing clear advice and recommendations, and guiding clients in making sound business decisions

Key point of contact in the research, analysis, and assessment of data within the compensation and total rewards programs

Instrumental in executing and evaluating compensation programs, including salary, short- and long-term incentives, reward and recognition programs, benchmarking, and survey analysis

Work in tandem with key stakeholders to solve challenging real-time compensation problems

Partner with members of the Compensation team to perform pay equity reviews for individuals and groups

Recognized for streamlining cost tracking, census and billing reconciliations, forecasting various financials, statistical analyses, compensation programs, and market surveys, through appropriate modeling and analytics with compensation policies and programs

Considered subject matter expert in all facets of compensation, including base salary and salary structures, merit design, incentive/sales compensation, and equity-based programs

Data Mining

Critical Thinking

Data Analysis

Project Management

Cross-functional Collaborator

Financial Reports

Problem Resolution

Accounts Receivable/Payable Billing

Comp/Sales Comp Analysis

Microsoft Office Suite

Motivational Team Lead

Excel Expertise

PROFESSIONAL EXPERIENCE

Johnstone Supply, Plano, TX (Remote)

Compensation Specialist

November 2022 - Present

Partnered with HR team members to provide compensation and consulting services to reinforce the company's overall compensation philosophy with all recommendations made, including salary structures and incentive compensation commissions for corporate and six distribution centers’ employees.

Improved existing processes with documentation, automation, and innovative ideas regarding the structures for the DCs as well as the incentive plans

Used analytical skills to perform detailed analysis, interpret results, and then recommend and implement measures to meet business needs

Used problem-solving skills which included listening to, interpreting, and meeting the needs of distribution center managers as well as corporate employees

Defined problems, collected data, established facts, and drew valid conclusions, diagnosing and rectifying problems

TopGolf International, Inc., Dallas, TX

Compensation Analyst

March 2021 - November 2021

Collaborated with team members to resolve and complete compensation related functions within the company which affected corporate and venue related compensation

Participated in managing the monthly and quarterly incentive calculation processes for the Topgolf sales and venue operations teams -- understanding and applying the commission and bonus plans consistently, ensuring commission calculations were accurate, complying with the plan and completing them according to established due dates.

Calculated sales commissions and bonuses primarily using advanced Excel techniques. Helped in improvement processes for more efficiency in building calculation models to administer complex incentive plans

Improved existing processes with documentation, automation, and innovative ideas

Performed compensation benchmarking and salary surveys for sales, operational and corporate business units

Worley Parsons, Dallas, TX

Contracted Compensation Analyst

March 2019 - August 2019

Collaborated with team members to resolve and complete recent merger/acquisition tasks which included organizational chart compiling, data entry, and Excel related documents

Korn Ferry / Hay Group, Dallas, TX

Compensation Consultant / Sr. Compensation Analyst / Compensation Analyst / HR Consulting

April 1998 - March 2019

Spearheaded success for projects over $25,000 resulting in the optimization of the client experience. Directed a plethora of free massive surveys from inception through completion for over 75 retailers leading to substantial revenue generation as well as new client acquisition and existing client retention. Worked in partnership with top leaders to conduct multiple analyses on cleaning the retail data that other consultants nationwide would use for projects throughout the year

Drove market price success (title match and regression-based data) for executive and general reward positions resolving any data integrity issues

Streamlined efficiency, using Excel for importing and exporting large amounts of data and analyze the information using vlookups, pivot tables, macros, subtotals, concatenation, creating advanced filters, and using complex formulas

Analyzed and interpreted complex problems with discrepancies in market data and offer solutions in a resourceful and logical manner

Launched proxy and survey peer groups based on revenues, industry, business type, etc.

Instrumental in conducting top executive proxy analyses, including Form 4 research and STI/LTI design practices and trends

Examined Board of Director compensation and made recommendations based on market trends for the specific industry and group of peers

Evaluated trends in annual and long-term incentive design analyses drawing data from a variety of sources

Slotted jobs into compensation structures using Hay Group’s proprietary Job Evaluation Methodology and recommended appropriate salary grades according to compensation guidelines

Crafted client reports that included methodology discussions, observations, recommendations, and various graphical views of findings (including charts, graphs, and tables) in a concise and easy to read format

Conducted Korn Ferry Retail Annual and Long-term Incentive surveys, as well as merit increase, turnover, and other hot topic surveys over last ten years

Developed survey submission tools, solicitation of companies to participate, compilation of data, analyzing the data year-over-year to discover any new up and coming trends, creation of reports/exhibits for participants, and was a resource for participants for any follow-up questions and research

Facilitated the Korn Ferry Retail Industry Executive Survey, review of data submission kits for participants, survey submission reviews, title match reviews, analyzing of compensation elements, and analyzing trends in data year-over-year for quality control

EDUCATION & CREDENTIALS

Associate degree Collin County Community College, Dallas, TX

Certificates & Licenses

Certified Compensation Professional (CCP)

Professional & Community Involvement

Member, World-at-Work Total Rewards Association

Contact this candidate