Compensation & Benchmarking Analyst

Omam Consultants; New Delhi; On-site; INR 600,000 - 900,000; Full time

Job summary

Omam Consultants is seeking a data analytics professional to collect, validate, and analyze compensation data for benchmarking, surveys, and client reports. You will support market pricing and customize client deliverables with clear visuals.

The role requires strong data skills, experience with Excel, and familiarity with BI tools like Power BI or Tableau. You will generate dashboards and reports while ensuring confidentiality and accuracy.

Qualifications

• Bachelor's or master's degree in Statistics, Economics, Mathematics, Business Analytics, HR, or a related field.
• Strong Advanced Excel skills.
• Good understanding of statistics and data analysis.
• Strong attention to detail and data-quality mindset.
• Ability to work with large datasets.
• Good report-writing and presentation skills.

Responsibilities

• Collect, validate, and manage large compensation datasets with accuracy and consistency.
• Perform data cleaning, validation, standardization, and reconciliation.

Skills

Advanced Excel

Data analysis

Report writing

Attention to detail

Big data handling

Education

Bachelor's/Master's in Statistics or related field

Tools

Power BI

Tableau

SQL

Python/R

Job description

Role Purpose:

To collect, validate, analyze, and interpret compensation and employee data to support salary benchmarking, compensation surveys, market pricing, and customized client reports.

Key Responsibilities

1. Data Collection & Management
   • Maintain large datasets and ensure data accuracy, completeness, and consistency.
   • Perform data cleaning, validation, standardization, and reconciliation.
2. Compensation & Salary Benchmarking
   • Calculate statistics such as minimum, maximum, average, median, quartiles, and percentiles (P25/P50/P75/P90).
   • Support job matching and job-level alignment for compensation benchmarking.
3. Salary Survey Report Generation
   • Prepare periodic salary survey and compensation benchmarking reports.
   • Generate customized reports for clients based on their requirements.
   • Create salary tables, charts, dashboards, and market comparison analyses.
   • Ensure reports are accurate, visually clear, and delivered within agreed timelines.
4. Excel / BI / Statistical Analysis
   • Use advanced Excel for data processing, formulas, PivotTables, Power Query, and reporting.
   • Develop dashboards and visualizations using Power BI/Tableau, where applicable.
   • Use SQL/Python/R, if required, for large-scale data extraction and analysis.
   • Automate repetitive data-processing and reporting activities.
5. Quality & Confidentiality
   • Conduct multiple levels of data quality checks before publishing survey results.
   • Maintain strict confidentiality of client and employee compensation information.
   • Follow data privacy, security, and internal quality-control procedures.

Skills/Qualifications

Essential:

• Bachelor's/Master's degree in Statistics, Economics, Mathematics, Business Analytics, HR, or a related field.
• Strong Advanced Excel skills.
• Good understanding of statistics and data analysis.
• Strong attention to detail and data-quality mindset.
• Ability to work with large datasets.
• Good report-writing and presentation skills.

Good to have:

• Power BI/Tableau
• SQL
• Python/R
• Knowledge of compensation & benefits / HR analytics

Experience with salary surveys or compensation benchmarking