Data Analyst - Advanced Excel (1 to 2 yrs)

Data Analyst - Advanced Excel (WFH) Experience: 1–2 Years Location: Remote (WFH) Mode of Engagement: Full-time No of Positions: 5 Educational Qualifications: Bachelor's degree in computer science, Statistics, Mathematics, Business Industry: IT / Software Services / Data Analytics Notice Period: Immediate Joiners Preferred What We Are Looking For: • Strong expertise in Advanced Excel functions: Pivot Tables, VLOOKUP, HLOOKUP, INDEX-MATCH, Nested IF, SUMIFS, COUNTIFS, Text Functions, and Advanced Charting. • Proficiency in data cleaning, transformation, and validation techniques for large datasets. • Ability to prepare reports, MIS dashboards, and data summaries with high accuracy. • Familiarity with tools like SQL, Power BI, or Tableau will be a good to have. Responsibilities: • Perform data cleaning, preprocessing, and validation to ensure accuracy and consistency. • Apply Advanced Excel techniques (Lookups, Conditional Formatting, Data Consolidation, Dynamic Named Ranges, Array Formulas). • Conduct descriptive data analysis to identify patterns, anomalies, and insights. • Collaborate with teams to support business decision-making through data-driven insights. • Ensure data quality standards and documentation for reporting processes. Qualifications: • 1–2 years of experience as a Data Analyst / MIS Analyst / Reporting Analyst. • Strong knowledge of Advanced Excel: Pivot Tables, Power Query, INDEX-MATCH, Nested IFs, SUMIFS/COUNTIFS, Text-to-Columns, Data Validation, Advanced Charting. • Hands-on experience with data cleaning, deduplication, and transformation. • Excellent analytical mindset, attention to detail, and problem-solving skills. Pay: ₹15,412.41 - ₹25,000.27 per month Benefits: • Health insurance • Work from home Application Question(s): • Years of experience in data cleaning, preprocessing, and transformation (handling duplicates, missing values, text-to-columns)? • Years of experience working with Advanced Excel (Pivot Tables, VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS)? • Years of experience in building reports and dashboards using Advanced Excel (Pivot Charts, Conditional Formatting, Data Consolidation)? • Notice Period (days) • Current CTC (Monthly) Work Location: Remote