Data Science Intern

Houlihan Lokey, Inc.; Gurugram District; On-site; INR 223,000 - 446,000; Full time

Job summary

Houlihan Lokey, Inc. in Gurugram invites undergraduates or recent graduates for a data analytics internship. You will pull and transform financial data, manage it in Snowflake, and perform quantitative analysis using Excel, SQL, and Python.

You’ll build dashboards in Power BI or Tableau and create reproducible Excel workflows for the team. Strong academic results, Excel proficiency, and an interest in data science are essential; internship experience is preferred, with a fast-paced environment

Qualifications

• Currently completing final year or recently graduated.
• Excellent academic performance.
• Comfort with Excel and strong quantitative reasoning.
• Working knowledge of SQL and Python.
• Fluent in English, written and spoken.
• Interest in data science as a career path.
• Previous internship in data analysis or data science.
• Self-motivated and collaborative across teams.
• Thrives in a high-pace, growth-focused environment.

Responsibilities

• Pull financial information from databases and prepare it for analysis.
• Transform raw data into structured formats using Python and Dataiku.
• Load and manage data within Snowflake infrastructure.
• Perform quantitative analysis using Excel functions like PivotTables, VLOOKUP, INDEX/MATCH.
• Build interactive visual reports in Power BI or Tableau for stakeholders.
• Develop and share documentation on Excel workflows to create repeatable processes.

Skills

Excel

Quantitative reasoning

Team collaboration

Data analysis

Fluent English

Education

Bachelor of Engineering

Bachelor of Technology

BSc in Mathematics/Statistics/Data Science

Tools

SQL

Python

Dataiku

Snowflake

Power BI

Tableau

Job description

Batch: 2025/2026/2027

About the role:

• Pull financial information from databases Houlihan Lokey has access to and readying it for analysis
• Transform raw data into structured formats using Python and Dataiku for further processing
• Load and manage data within Snowflake infrastructure
• Perform quantitative analysis on datasets using spreadsheet functions including PivotTables, VLOOKUP, INDEX/MATCH and other advanced formulas
• Build interactive visual reports and dashboards in Power BI or Tableau that make data trends and business insights accessible to stakeholders
• Develop and share documentation on Excel workflows to establish repeatable processes across the team

What we're looking for:

• Currently completing your final year of an undergraduate degree or recently graduated
• Bachelor of Engineering, Bachelor of Technology, Bachelor of Science in Mathematics, Statistics or Data Science from a respected institution
• Demonstrated excellence in your academic performance
• Comfort with Excel and strong quantitative reasoning
• Working knowledge of SQL and Python
• Fluent in English, both written and spoken
• Clear genuine interest in data science as a career path
• Previous experience as an intern in data analysis or data science roles
• Self-motivated with the ability to collaborate effectively across teams and organizational levels
• Ready to thrive in a high-pace, demanding environment that offers genuine growth