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 productive 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 straightforward, 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
📌 Data Analyst (Sahibzada Ajit Singh Nagar)
🏢 Important Company of the Sector
📍 Sahibzada Ajit Singh Nagar
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.