Data Analytics Intern

CK Birla Healthcare; Gurugram District; On-site; INR 167,000 - 279,000; Full time

Job summary

CK Birla Healthcare seeks a detail-oriented Data Analytics Intern to support data collection, cleaning and validation from multiple sources. You will build dashboards using Excel, Power BI, or Tableau, and write SQL queries to extract and analyze data.

This internship provides hands-on exposure to MIS and business performance reporting, with mentoring and potential full-time opportunities based on performance.

Qualifications

• Proficiency in Microsoft Excel (Pivot Tables, VLOOKUP/XLOOKUP, Charts).
• Basic knowledge of SQL.
• Knowledge of Power BI or Tableau.
• Basic understanding of Python (Pandas, NumPy) is preferred.
• Strong analytical and problem-solving skills.
• Good communication and presentation skills.
• Ability to learn quickly and work in a team environment.

Responsibilities

• Collect, clean, and validate data from multiple sources.
• Analyze datasets to identify trends, patterns, and actionable insights.
• Develop reports and dashboards using Excel, Power BI, or Tableau.
• Write and optimize SQL queries for data extraction and analysis.
• Assist in preparing MIS reports and business performance reports.
• Support data visualization and dashboard creation for stakeholders.
• Work closely with cross-functional teams to understand business requirements.
• Maintain data accuracy, integrity, and documentation.
• Assist in automating recurring reports and improving reporting processes.

Skills

Data analysis

Analytical thinking

Communication skills

Team collaboration

Problem-solving

Excel basics

Tools

Power BI

Tableau

SQL

Python (Pandas)

Job description

Job Summary

We are looking for a detail-oriented and analytical Data Analytics Intern to join our team. The ideal candidate should have a strong interest in data analysis, business intelligence, and problem-solving. This internship offers an excellent opportunity to work with real business data, create insightful reports, and gain hands-on experience with industry-standard analytics tools.

Key Responsibilities

• Collect, clean, and validate data from multiple sources.
• Analyze datasets to identify trends, patterns, and actionable insights.
• Develop reports and dashboards using Excel, Power BI, or Tableau.
• Write and optimize SQL queries for data extraction and analysis.
• Assist in preparing MIS reports and business performance reports.
• Support data visualization and dashboard creation for stakeholders.
• Work closely with cross-functional teams to understand business requirements.
• Maintain data accuracy, integrity, and documentation.
• Assist in automating recurring reports and improving reporting processes.

Required Skills

• Proficiency in Microsoft Excel (Pivot Tables, VLOOKUP/XLOOKUP, Charts).
• Basic knowledge of SQL.
• Knowledge of Power BI or Tableau.
• Basic understanding of Python (Pandas, NumPy) is preferred.
• Strong analytical and problem-solving skills.
• Good communication and presentation skills.
• Ability to learn quickly and work in a team environment.

What You'll Gain

• Hands-on experience with real-world datasets.
• Exposure to business intelligence and analytics tools.
• Mentorship from experienced professionals.
• Opportunity to work on live projects.
• Potential full-time employment opportunity based on performance.