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