KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
JD #3626
Applications open Internship

Data Analyst

Adani Enterprises Limited

  • Ahmedabad, Gujarat, India
  • 4 LPA
  • 1 Year
  • Posted Today
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

Adani Group, one of India’s largest diversified conglomerates, operates across sectors such as energy, logistics, agribusiness, and infrastructure. With a strong focus on sustainable growth, the group has consistently invested in cutting‑edge technology to drive operational efficiency and data‑centric decision making. The company’s data culture emphasizes real‑time analytics, predictive modeling, and robust data governance, making it an attractive destination for fresh talent eager to contribute to high‑impact projects.

As a Data Analyst at Adani’s Ahmedabad office, you will be part of a dynamic analytics team that supports business units ranging from renewable energy to port operations. The role is designed for recent graduates with a solid foundation in statistics, programming, and data visualization. You will work closely with product managers, engineers, and senior analysts to translate raw data into actionable insights that influence strategic initiatives.

Key responsibilities include

  • Apply advanced analytical techniques to uncover trends, patterns, and correlations in large, heterogeneous data sets.
  • Build, test, and maintain predictive models and statistical algorithms using Python or R.
  • Write efficient SQL queries for data extraction, transformation, and loading (ETL) processes.
  • Design interactive dashboards and visual reports with Tableau, Power BI, or Qlik to communicate findings to stakeholders.
  • Perform rigorous data validation, cleansing, and quality checks to ensure reliability.
  • Collaborate with cross‑functional teams to gather requirements and deliver data‑driven recommendations.
  • Document data pipelines, methodologies, and best practices for future reference.
  • Stay updated on emerging tools, industry trends, and best practices in data analytics.
  • Ensure compliance with data privacy, security standards, and internal governance policies.
  • Participate in continuous learning programs and knowledge‑sharing sessions within the analytics community.

The tech stack revolves around SQL, Python/R, Tableau/Power BI, and cloud platforms such as AWS or Azure for data storage. Successful analysts can progress to senior analyst, analytics lead, or data science roles, with opportunities to work on large‑scale projects across the Adani ecosystem. Joining Adani means exposure to a fast‑growing environment, mentorship from industry veterans, and the chance to make a tangible impact on India’s infrastructure and sustainability goals.

Eligibility & process

Who can apply

Bachelor’s degree in Information Technology, Computer Science, Mathematics, Statistics or related fields; minimum 60% aggregate (or CGPA 6.0/10); final year students of 2023‑2026 batches eligible; no active backlogs at the time of joining; internship experience of 0.6‑1 year in data management or analytics is a plus.

Skills & stack

SQL Python Tableau Power BI Data Modeling Statistical Analysis Data Cleaning Data Visualization

Selection process

  1. Round 1: Online aptitude & technical test
  2. Round 2: Technical interview (SQL/Python/analytics case study)
  3. Round 3: HR interview (fit & cultural alignment)

Prep kit

20 resources
Study material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
Round 1: Online Assessment (OA) Aptitude, Quantitative Logic & 2 Coding Problems Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1 Core Tech Stack (SQL, Python, Tableau, Power BI, Data Modeling, Statistical Analysis, Data Cleaning, Data Visualization) & Live Code Tracing Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving Database Schemas, APIs & Architecture Basics Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion Adani Enterprises Limited Core Values, Learning Agility & Offer Terms Demonstrate passion, strong communication, and readiness for full-time collaboration.
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Model answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
Model answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
Model answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
Model answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Model answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Behavioural & HR questions 3
Why do you want to join Adani Enterprises Limited as a Data Analyst?
Highlight Adani Enterprises Limited's market reputation, recent tech innovations, and how your skills in SQL directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
Adani Enterprises Limited 4 LPA
Recruiter Resume Apply
Chat Chat with Kashii