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