# Vansh Agrawal

Vansh Agrawal is a remote worker on Himalayas, Data Specialist at Mercer, based in India.

Source: https://himalayas.app/@vanshagrawal2

```text
Data Specialist at Mercer analyzing compensation surveys and salary benchmarks with SQL and AI-assisted workflows.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 1539k+ INR |
| Job categories | Data Analyst, Data Engineer, Business Intelligence Analyst |
| Skills | Data Analysis, Business Intelligence, Financial Reporting, Compensation Analysis, Salary Benchmarking, SQL, Python, Power BI, ETL ELT, Data Pipelines, data transformation, Data Integration, Data Quality, Data Modeling, Data Warehouse |
| LinkedIn | https://linkedin.com/in/vansh-agrawal-9a7577322 |

## About

```text
At Mercer, I analyze compensation survey files to identify salary trends and market-pay benchmarks. I consolidate and validate data from multiple reports, and use AI-assisted workflows to streamline report preparation and summarize findings.

Previously, I developed financial and business performance dashboards at WEchartered Management Consultancy Pvt Ltd, automating recurring reporting and reducing monthly reporting time by 30%. I also built an Azure end-to-end data engineering pipeline using Azure Data Factory, ADLS Gen2, SQL, and dbt, with Power BI dashboards for sales performance and business KPIs.
```

## Experience

### Data Specialist (current)

[Mercer](https://himalayas.app/companies/mercer). Mar 2026 - Present

```text
Analyzed compensation survey files using SQL to identify salary trends and market-pay benchmarks. Performed data cleaning, validation, and reconciliation to prepare reliable datasets for compensation analysis.
```

Skills: SQL, Data-Analysis, Data-Cleaning, Data-Validation, Compensation-Analysis, AI-Assisted-Analytics, Report-Preparation

### Data Analyst

WEchartered Management Consultancy Pvt Ltd. Sep 2024 - Feb 2026

```text
Developed 15+ Power BI dashboards for financial and business performance analysis. Built ETL workflows using Power Query and SQL, and automated recurring financial reporting, reducing monthly reporting time by 30%.
```

Skills: Power-BI, DAX, Power-Query, SQL, ETL, Data-Modeling, Financial-Reporting, Data-Validation, Variance-Analysis

### Sales & Data Analyst

Mentorkart. Apr 2023 - Aug 2024

```text
Analyzed sales datasets to identify revenue trends and business KPIs. Developed sales performance reports and KPI trackers to monitor target achievement and lead conversion.
```

Skills: Data-Analysis, SQL, Excel, KPI-Reporting, Trend-Analysis, Variance-Analysis, Data-Cleaning

## Education

### Accenture North America

Data Analytics and Visualization Job Simulation, Data Analytics. 2024 - 2024

```text
Completed a Data Analytics and Visualization job simulation in 2024.
```

### Zakir Hussain Delhi College, Delhi University

Bachelor of Commerce, Commerce. 2020 - 2023

```text
Pursued a Bachelor of Commerce degree from Zakir Hussain Delhi College, Delhi University, from 2020 to 2023.
```

### Microsoft

Introduction to Cloud Computing & Microsoft Azure Fundamentals, Cloud Computing

```text
Completed the Introduction to Cloud Computing and Microsoft Azure Fundamentals certification.
```

### Microsoft

DP-203 – Data Engineering on Microsoft Azure, Data Engineering

```text
Completed the DP-203 Data Engineering on Microsoft Azure certification.
```

## Tech stack

- Microsoft Azure
- NumPy
- Pandas
- dbt
- Python
- Microsoft Excel
- Azure SQL Database
- SQL
- Azure Blob Storage
- Delta Lake
- Power BI
- Power Query

To contact Vansh, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Gangi Yaamini](https://himalayas.app/@gangiyaamini): Associate Data Analyst, Entri Software Pvt. Ltd.
- [Atul Chakwa](https://himalayas.app/@atulchakwa): Data Analyst, Deloitte
- [Samarth Tandon](https://himalayas.app/@samarthtandon): Data Analyst, Wipro Ltd
- [Rishob Ghosh](https://himalayas.app/@rishobghosh): Software Development Engineer, Wissen Technology Pvt Ltd
- [priya sariyal](https://himalayas.app/@priyasariyal): Analytics Consultant, Wells Fargo
- [Mithil Gundeti](https://himalayas.app/@mithilgundeti): Customer Data Quality Validation, Personal Project
- [venkatesh Koppala](https://himalayas.app/@venkateshkoppala): Data Analyst, Mott MacDonald Pvt. Ltd.
- [Aravindkumar dyavathi](https://himalayas.app/@aravindkumardyavathi): Data Analyst, Self Employed
- [Abdul Pasha](https://himalayas.app/@abdulpasha): Lead Data Analyst, Thomson Reuters
- [Abhi M](https://himalayas.app/@abhim1): Data Analyst Intern, Rows and Columns
