Job description
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
This job post has been translated by AI and may contain minor differences or errors.
