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
