Overview
Job Summary:
We are looking for a detail-oriented Data Analyst with strong proficiency in Advanced Excel to collect, analyze, and interpret large datasets. The candidate will be responsible for generating reports, identifying trends, and providing actionable insights to support business decisions.
Key Responsibilities:
Collect, clean, and analyze large datasets to generate meaningful business insights.
Develop and maintain dashboards, reports, and data visualizations using Advanced Excel (Pivot Tables, Power Query, VBA, Macros).
Perform statistical analysis and forecasting based on historical data.
Identify patterns, trends, and outliers to support business decision-making.
Collaborate with different departments to understand data needs and provide analytical solutions.
Ensure data accuracy, integrity, and consistency across multiple sources.
Automate repetitive data processes using Excel Macros and VBA.
Generate reports for management, including KPI tracking and performance analysis.
Assist in database management, data validation, and data reconciliation.
Support ad-hoc analysis requests from various teams.
Required Skills & Qualifications:
Educational Qualification: Bachelor's degree in Statistics, Mathematics, Economics, Computer Science, Business Analytics, or a related field.
Technical Skills:
Advanced Excel (Pivot Tables, VLOOKUP, HLOOKUP, Index-Match, Power Query, VBA, Macros)
Data visualization using Excel charts and Power BI (Preferred)
Strong numerical and analytical skills
Soft Skills:
Strong problem-solving and critical-thinking skills
Excellent attention to detail and accuracy
Good communication and presentation skills
Ability to work in a fast-paced environment and meet deadlines
Preferred Qualifications:
Experience in handling large datasets.
Knowledge of Google Sheets, Power BI, Python, or SQL is an added advantage.
Experience in business intelligence or financial data analysis is preferred.
Job Type: Full-time
Pay: ₹300,000.00 - ₹480,000.00 per year
Schedule:
- Day shift
Work Location: In person