Senior Analyst · Mercer · New Delhi

Turning Compensation
Data into
Strategic Decisions

Data Analyst specializing in Compensation & Benefits, helping organizations optimize pay structures, improve benchmarking accuracy, and drive data-backed workforce decisions.

2+Years at Mercer
APACMarket Coverage
SQL · PySparkCore Stack

At the intersection of
data engineering
and business impact.

Download CV

I am a Data Analyst with hands-on experience in compensation analytics, salary benchmarking, and large-scale data validation.

Currently working at Mercer, I handle complex compensation datasets across APAC, transforming raw data into structured insights that support pay decisions, job alignment, and workforce strategy.

My work sits at the intersection of data engineering and business impact — building pipelines, improving data quality, and delivering analytics that leaders can trust.

2+Years
Experience
2Completed
Projects
APACMarket
Focus
Compensation Analytics PySpark & Databricks APAC Markets ETL Pipelines

Capabilities & Stack

Compensation Analytics

  • Salary Benchmarking
  • Job Matching & Level Alignment
  • Pay Structure Analysis

Data & Engineering

  • SQL
  • Python
  • Apache Spark (PySpark)
  • Databricks
  • ETL Pipelines

Visualization

  • Power BI
  • Excel
  • Statistical Analysis

AI & Emerging Tech

  • Generative AI
  • Prompt Engineering
  • LLM Applications

Proficiency Levels

SQL88%
Python78%
PySpark / Spark72%
Power BI82%
Databricks70%
Excel90%

Where I've Worked

May 2024 – PresentFull-Time

Senior Analyst

Mercer · Noida, India

  • Analyzed large-scale compensation datasets to support salary benchmarking and pay structure decisions
  • Processed APAC compensation data and transformed raw datasets into analysis-ready formats
  • Improved data validation workflows, reducing inconsistencies and improving reporting accuracy
  • Enabled better job alignment and compensation insights through structured data processing
Jul 2022 – Aug 2022Internship

Trainee

Tata Motors Ltd.

  • Performed data analysis on manufacturing datasets to support operational decision-making
  • Developed reports and presented insights to management teams

Selected Work

01

Apache Spark Data Pipeline

Designed and implemented a scalable ETL pipeline using Apache Spark and Delta Lake (Bronze–Silver–Gold architecture) to process multi-source datasets. Improved data accessibility and enabled structured reporting by cleaning, standardizing, and aggregating raw data into analytics-ready formats.

SparkPySparkDelta LakeETL
02

Compensation Data Validation Tool

Developed a data validation and analytics solution combining Power BI and Python. Built dashboards for salary benchmarking and compa-ratio analysis, while implementing automated validation checks to detect anomalies, missing values, and pay inconsistencies. Enabled faster issue identification and improved reliability of compensation insights.

Power BIPythonPandasTkinter

Academic Background

2025 – Present

MBA — Data Science

Amity University Online

2019 – 2023

B.Tech — Computer Science Engineering

Graphic Era Hill University

Senior Analyst

Mercer · Noida
May 2024 – Present

Trainee

Tata Motors Ltd.
Jul – Aug 2022

Volunteer

RobinHood Army
2022 – Present

Let's work
together.

Open to opportunities in Data Analytics, Compensation Analytics, and Data Engineering.