Data Analyst Intern

ALLEN Career Institute Pvt. Ltd.; India; On-site; INR 400,000 - 600,000; Full time

Job summary

A leading educational institute in India is seeking a data analyst to manage data consolidation and reporting. The ideal candidate should have strong analytical skills and be proficient in Excel and Google Sheets. Responsibilities include compiling data into a master database, ensuring data accuracy, and generating insights through dashboards and reports. A basic knowledge of Power BI or Tableau is preferred. This is a great opportunity for individuals passionate about data-driven decision-making.

Qualifications

• Strong analytical and logical thinking skills.
• Proficiency in Excel / Google Sheets is mandatory.
• Basic knowledge of Power BI / Tableau is a plus.

Responsibilities

• Compile raw data into a structured master database.
• Identify discrepancies and ensure high data accuracy.
• Create dashboards and reports for business insights.

Skills

Analytical skills

Proficiency in Excel / Google Sheets

Attention to detail

Data interpretation

Tools

Excel

Google Sheets

Power BI

Tableau

Job description

Key Responsibilities

• Data Consolidation: Compile raw data from multiple assessment sheets into a structured master database.
• Data Cleaning & Validation: Identify discrepancies, remove duplicates, and ensure high data accuracy.
• Report & Insights Generation: Create dashboards and reports (zone-wise, city-wise, performance-wise) and generate insights to support business decision-making.

Ideal Candidate

• Strong analytical and logical thinking skills
• Proficiency in Excel / Google Sheets (mandatory)
• Basic knowledge of Power BI / Tableau is a plus
• Strong attention to detail
• Ability to interpret and present data clearly