Intern - Analytics

Chi Networks; New Delhi; On-site; INR 167,400 - 279,000; Full time

Job summary

Chi Networks is seeking a dynamic MIS/Data Reporting Intern to join our team in New Delhi. This position is ideal for students or recent graduates proficient in Advanced Excel/Google Sheets, SQL, and Power BI/Tableau. The intern will prepare MIS reports, build dashboards, and analyze performance metrics. We're looking for candidates with strong analytical skills and excellent English communication, ready to work with large data sets. Join us in a supportive environment to grow your data analytics capabilities.

Qualifications

• Certifications in SQL / BI tools preferred but not mandatory.
• Strong understanding of SQL (queries, joins, aggregations).
• Basic knowledge of data cleansing and visualization.

Responsibilities

• Prepare daily/weekly MIS reports for Operations and Management.
• Build dashboards and visual analytics in Google Sheets, Power BI or Tableau.
• Write and optimize SQL queries to extract and transform data.
• Create automated reports using formulas, pivot tables, and scripts.
• Analyze performance metrics and highlight trends and insights.

Skills

Advanced Excel/Google Sheets

SQL

Power BI/Tableau

Data Analytics

Analytical skills

Communication skills

Education

BCA / BBA / B.Tech / B.Sc (IT/Maths/Stats) / MBA / PGDM / Data Analytics course

Tools

Power BI

Tableau

Google Sheets

Job description

Seeking a dynamic and results-driven enthusiastic and skilled MIS / Data Reporting Intern to join our growing team in New Delhi. This role is ideal for students or recent graduates who are strong in Advanced Excel/Google Sheets, SQL, Power BI/Tableau, and data analytics. You will work closely with Operations, Sales, NOC/SOC, and Management teams to create dashboards, automate reports, and analyze performance trends.

Key Responsibilities

• Prepare daily/weekly MIS reports for Operations and Management
• Build dashboards and visual analytics in Google Sheets, Power BI or Tableau
• Write and optimize SQL queries to extract and transform data
• Create automated reports using formulas, pivot tables, and scripts
• Maintain data accuracy, formatting, and integrity across reporting systems
• Analyze performance metrics and highlight trends, exceptions, and insights
• Create Google Sheets dashboards with advanced formulas, lookups, filters, and pivot tables
• Support ad-hoc data requests from management and internal teams

Qualifications

• BCA / BBA / B.Tech / B.Sc (IT/Maths/Stats) / MBA / PGDM / Data Analytics course
• Certifications in SQL / BI tools (preferred but not mandatory)
• Advanced Excel/Google Sheets (VLOOKUP, INDEX/MATCH, Pivot Tables, Array formulas, Query function, Filters, Conditional formulas, Charts, etc.)
• Strong understanding of SQL (queries, joins, aggregations, grouping, views)
• Experience with Power BI or Tableau (dashboard creation, data modeling preferred)
• Basic knowledge of data cleansing and data visualization
• Good analytical and problem-solving skills
• Ability to work with large data sets accurately
• Communication: Excellent English verbal and written communication skills
• Ability to work both independently and as part of a team