Compensation Analyst I

CRG; Charlotte (NC); On-site; USD 48,000 - 52,000; Full time

Benefits offered by this job

Wellness programs

Annual bonus

Merit increases

Free refreshments onsite

Job summary

CRG is seeking a Compensation Analyst in Charlotte, NC to conduct market-based salary analysis, audit compensation programs, and support annual compensation cycles. The role requires strong Excel skills (VLOOKUP/XLOOKUP, pivots) and experience with market pricing resources such as Mercer.

On-site position with a competitive benefits package. The ideal candidate will analyze base and incentive compensation data, maintain data integrity, and produce actionable insights for leadership.

Qualifications

• 3–5 years of relevant experience in Compensation, HR Data Analytics, HRIS, Total Rewards, or a related analytical HR function preferred.
• Demonstrated experience performing data analysis, auditing, reconciliation, and/or compensation-related analysis.
• Bachelor’s degree in Accounting, Statistics, Business Administration, Economics, Finance, Human Resources, or related experience preferred.

Responsibilities

• Conduct analysis and create high-level summaries to support leadership presentations and decision-making.
• Research and analyze market data trends to align external benchmarks with internal positions and evaluate equity and competitiveness.
• Provide analytical support to identify gaps and inefficiencies in compensation programs and processes.

Skills

Compensation analysis

HR data analytics

Data auditing

Data reconciliation

Excel advanced

Education

Bachelor's degree

Tools

Mercer data

Job description

Our Consumer Packaged Goods client that boasts a brand that resonates worldwide, has a history that spans over a century. Headquartered in Charlotte, NC with over 17,000 employees, the organization values diversity, inclusion, and collaboration, where individuals can grow, contribute, and make a difference. Over the past 9 years, CRG has helped hire over 100 employees at this company, which offers competitive employee benefits and perks, ranging from wellness programs and annual bonus and merit increase potential to free access to popular refreshments onsite!

Location: Charlotte, NC

Payrate: $35-$38/hour

Responsibilities

• Conduct analysis and create high-level summaries to support leadership presentations and decision-making.
• Research and analyze market data trends that align external benchmarks with internal positions, evaluate internal equity, external competitiveness, business conditions, legal requirements, and economic impact to make sound recommendations and resolve compensation concerns.
• Provide analytical support to identify gaps and inefficiencies in programs and processes for base and/or incentive compensation initiatives.
• Conduct individual and group salary analysis using market-based evaluation methods and prepare recommendations to maintain a competitive position within labor markets.
• Audit compensation processes and programs and provide recommendations to ensure compliance with internal guidelines and government regulations.
• Support job-building and job-maintenance activities, including reviewing and updating job descriptions and ensuring jobs are appropriately classified and aligned.
• Perform job matching and benchmarking activities using compensation survey and market data, including Mercer and other market-pricing resources as applicable.
• Review and validate compensation-related data, including pay grades, bonus structures, job classifications, geographic/geo codes, and other position or employee information.
• Perform ongoing compensation data audits, reconciliations, and cleanup activities to identify inaccurate, outdated, incomplete, or misaligned information.
• Investigate and resolve data discrepancies resulting from organizational restructuring, employee movement, job changes, or other business changes.
• Support data-integrity activities associated with HR system implementations, transformations, and other projects by validating information before it moves through downstream processes or systems.
• Support annual compensation-cycle activities, including data review, validation, analysis, and potentially associated employee or leadership communications.
• Utilize advanced Excel functionality to sort, manipulate, reconcile, audit, and analyze large datasets. Experience with VLOOKUP/XLOOKUP, pivot tables, formulas, and macros is strongly preferred.
• Proactively identify discrepancies, potential downstream issues, and items requiring follow-up rather than relying solely on established processing procedures.
• Manage multiple priorities and ad hoc data requests while maintaining accuracy during high-volume periods and tight deadlines.
• Handle confidential employee, compensation, and potentially compliance-related information with appropriate discretion.

Qualifications

• 3–5 years of relevant experience in Compensation, HR Data Analytics, HRIS, Total Rewards, or a related analytical HR function preferred.
• Demonstrated experience performing data analysis, auditing, reconciliation, and/or compensation-related analysis.
• Bachelor’s degree in Accounting, Statistics, Business Administration, Economics, Finance, Human Resources, or related experience preferred.
• Compensation experience is strongly preferred, particularly experience with job classification, job matching/benchmarking, pay grades, bonus structures, and annual compensation cycles.