Data Analyst
AI Summary
A Data Analyst who works with large datasets to build reports and dashboards, using advanced Excel to transform data into actionable business insights and support decision-making.
About this role
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
