Data Analyst

Role Overview

We are looking for a Data Analyst with strong expertise in Microsoft Excel who can efficiently work with large datasets, formulas, and analytical models.

The ideal candidate should be able to **transform raw data into meaningful insights **, build efficient spreadsheets, and support business decisions through structured analysis and reporting.

This role requires someone who is highly detail-oriented, analytical, and extremely efficient in Excel-based data handling.

Key Responsibilities

Data Analysis & Reporting

• Analyze large datasets to identify trends, patterns, and actionable insights

• Prepare structured reports and dashboards for internal stakeholders

• Convert complex data into simple, actionable business insights

Excel-Based Data Management

• Work extensively with **advanced Excel formulas and functions **• Build ** dynamic spreadsheets, dashboards, and automated reports **• Clean, organize, and structure large datasets for analysis

Data Accuracy & Validation

• Ensure accuracy and consistency across datasets

• Identify discrepancies and resolve data-related issues

• Maintain structured documentation of data processes

Business Support

• Collaborate with internal teams to understand reporting requirements

• Provide analytical support for operational and strategic decisions

• Generate periodic performance and business reports

Required Skills

Advanced Excel Expertise

Strong hands-on experience with:

• Pivot Tables

• VLOOKUP / HLOOKUP

• XLOOKUP

• INDEX + MATCH

• Advanced formulas

• Conditional formatting

• Data validation

• Data cleaning and transformation

• Power Query (preferred)

Analytical Skills

• Strong numerical and logical thinking

• Ability to identify trends and patterns in data

• High attention to detail

Other Skills

• Strong problem-solving ability

• Ability to handle large datasets efficiently

• Good communication and reporting skills

Qualifications

• Bachelor’s degree in **Business, Statistics, Mathematics, Economics, Engineering, or a related field • ** 2–4 years of experience in a Data Analyst, MIS Analyst, or Reporting role

• Strong proficiency in Microsoft Excel

Work Mode : office 5 days

Shift : 6:30 am to 3:30 pm

Location : Mohali Phase 8-B