Intern - Analytics

Overview

Chi Networks, a Chicago-headquartered IT company with a strong presence in India, is 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.

Requirements

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**.**

Location & Additional Details

• Work Days & Timings: Monday to Friday 10AM-7PM
• Job Type: Full-time, On-site
• Location: New Delhi, India
• Mandatory: Candidates must be based in or willing to relocate to New Delhi for this position.
• Internship Certificate provided
• May convert to full-time based on performance