Data Analyst

Job Summary

We are seeking a detail-oriented Data Analyst with strong expertise in Advanced Excel to analyze, interpret, and present data insights. The ideal candidate will use Excel-based tools and techniques to support business decisions, streamline reporting, and improve operational efficiency.

Key Responsibilities

Collect, organize, and analyze data using Advanced Excel

Create dynamic dashboards and reports using Excel

Perform data cleaning, validation, and transformation

Use formulas and functions to automate calculations and reporting

Analyze trends, patterns, and anomalies in datasets

Generate actionable insights for business stakeholders

Maintain and update Excel-based reporting systems

Collaborate with teams to understand data requirements

Required Skills & Qualifications

Bachelor’s degree in any quantitative field (e.g., Commerce, Statistics, Economics, Mathematics)

Strong expertise in Advanced Excel

Proficiency in:

Pivot Tables & Pivot Charts

VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH

Conditional Formatting

Data Validation

Advanced formulas (IF, nested IF, SUMIFS, COUNTIFS, etc.)

Experience with:

Excel Dashboards & Reporting

Data Cleaning and Data Analysis techniques

Strong analytical and problem-solving skills

High attention to detail and accuracy

Good communication and presentation skills

Preferred Skills

Basic knowledge of data concepts and reporting

Familiarity with business metrics and KPIs

Exposure to automation using Excel Macros/VBA (optional but a plus)

Key Tools

Microsoft Excel (Advanced level)

Key Deliverables

Interactive Excel dashboards

Periodic reports (daily/weekly/monthly)

Clean and structured datasets

Data-driven insights and summaries

KPIs

Accuracy of reports

Efficiency in report generation

Dashboard usability and clarity