• Internship
  • Delhi

Website Indian Army

Data Analyst Intern – Indian Army

Opportunity Overview

Attribute Details
Organization Indian Army
Role Title Data Analyst Intern
Duration 75 Days
Eligible Disciplines B.Tech / B.E. (Computer Science / CSE / Equivalent), B.Sc, M.Sc, M.Tech, MBA
Employment Type Internship
Core Domain Defense Data Analytics, Business Intelligence & Automation

Role Scope & Defence Analytics Lifecycle

The Data Analyst Intern works with military datasets to build business intelligence solutions, reporting pipelines, and interactive operational dashboards:

[Data Ingestion & Cleaning] ➔ [Advanced Excel / SQL Validation] ➔ [Power BI / Tableau Dashboards] ➔ [Report Automation & Insights]

Core Responsibilities

  • Military Dataset Management: Collect, clean, validate, and structure real-world defence data while maintaining security and documentation standards.

  • Advanced Spreadsheet Analytics: Process and analyse complex datasets using Advanced Excel features, including Pivot Tables, Power Query, XLOOKUP, INDEX-MATCH, and Dynamic Arrays.

  • BI Dashboard Development: Build interactive operational dashboards and executive reports using Power BI and Tableau.

  • Automation & Trend Analysis: Identify trends, automate recurring reporting workflows, and generate actionable insights for cross-functional teams.

Candidate Qualifications & Technical Matrix

Minimum Requirements

  • Education: Enrolled in or graduated from B.Tech/B.E. (CS/CSE/Equivalent), B.Sc, M.Sc, M.Tech, MBA, or related quantitative disciplines.

  • Core Excel Skills: Advanced proficiency in Power Query, Pivot Tables, lookup functions, and dynamic array formulas.

  • BI Platform Depth: Hands-on experience developing dashboards in Power BI (and preferably Tableau).

  • Availability: Available for the full 75-day internship duration.

Technical & Analytical Competency Matrix

Category Technical Skills & Frameworks
Core Spreadsheet & BI

• Advanced Excel (Power Query, Dynamic Arrays, XLOOKUP, INDEX-MATCH)


• Power BI (DAX, Power Query Editor), Tableau (Advanced Visualizations)
Scripting & Databases (Bonus)

• SQL (Data extraction/filtering), Python (Pandas/NumPy), VBA (Excel Macros)


• Looker Studio
Professional Competencies • Data hygiene, documentation, visual storytelling, and technical presentation

Selection Workflow & Evaluation Pipeline

[Application & Academic Screening] ➔ [Excel & Data Processing Test] ➔ [BI Dashboard & Analytics Interview] ➔ [Final Selection & Onboarding]

  1. Resume & Eligibility Screening: Verification of CS/CSE or analytical background, academic record, and 75-day availability commitment.

  2. Technical Data Assessment: Hands-on test covering Advanced Excel formulas, Power Query data cleaning, or a short SQL/data manipulation task.

  3. Analytics & BI Interview: Review of portfolio projects, Power BI/Tableau dashboard design logic, DAX calculations, and data visualization best practices.

  4. Final Selection Loop: Final panel review evaluating problem-solving rigor, data integrity awareness, and communication skills.

To apply for this job please visit remotejobhiring.com.