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

Associate Analyst

Eyglobal

  • Pan India
  • 4-6 LPA
  • 2 Years
  • Posted Yesterday
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

Ernst & Young (EY) is one of the world’s leading professional services firms, offering assurance, tax, consulting and advisory services to a diverse set of clients across industries. With a presence in more than 150 countries, EY has built a reputation for delivering innovative solutions, fostering a culture of continuous learning, and driving sustainable impact for businesses and societies. In India, EY operates through a network of offices in major metros, serving Fortune 500 companies, start‑ups, and government agencies, and is known for its inclusive work environment and strong emphasis on employee development. The Associate Analyst role is an entry‑level position designed for fresh graduates as well as early‑career professionals who are eager to dive into business operations, data analysis, and client‑facing projects. As an Associate Analyst, you will be part of a dynamic team that supports senior consultants and managers in delivering insights, preparing reports, and executing project deliverables for EY’s global clientele. This role offers a solid foundation in consulting methodologies, exposure to industry‑specific challenges, and the chance to build a professional network within a globally recognized brand. Key Responsibilities: 1. Collect, clean, and analyze large data sets to identify trends and support decision‑making. 2. Prepare client‑ready presentations, dashboards, and reports using PowerPoint and Excel. 3. Assist in the development of business process models and improvement recommendations. 4. Conduct market research and competitive analysis to inform strategic recommendations. 5. Support senior team members in project planning, tracking, and documentation. 6. Participate in client meetings, take minutes, and follow up on action items. 7. Contribute to the creation of proposals, RFP responses, and internal knowledge assets. 8. Maintain compliance with EY’s quality standards and data security policies. 9. Continuously learn and apply new analytical tools and industry best practices. 10. Collaborate across cross‑functional teams, including tax, advisory, and technology groups. Tech Stack: Advanced Excel, PowerPoint, Power BI/Tableau, basic SQL, and familiarity with data visualization tools. Knowledge of ERP systems such as SAP or Oracle is a plus. Growth Path: Starting as an Associate Analyst, high performers can progress to Analyst, Senior Analyst, Consultant, and eventually Manager or Senior Manager within 3‑5 years, depending on performance and skill acquisition. EY invests heavily in training programs, certifications, and mentorship to accelerate career growth. Why Join EY? EY offers a global platform with exposure to world‑class clients, structured learning pathways, and a culture that values diversity, inclusion, and work‑life balance. Employees benefit from flexible work arrangements, robust mentorship, and opportunities to work on transformative projects that shape industries. The firm’s commitment to continuous upskilling ensures that you stay relevant in a rapidly evolving business landscape.

Eligibility & process

Who can apply

Any graduate or postgraduate degree from a recognized university. No specific branch restriction, though degrees in Business, Commerce, Economics, Engineering, Computer Science, or Statistics are preferred. Minimum aggregate of 60% (or CGPA 6.0/10) in the final year. No active backlogs at the time of application. Candidates graduating between 2022 and 2026 are eligible. Freshers and candidates with up to 2 years of relevant experience can apply.

Skills & stack

Data Analysis Advanced Excel Powerpoint Business Communication Basic Sql Data Visualization Team Collaboration

Selection process

  1. Round 1: Online aptitude and logical reasoning test
  2. Round 2: Technical interview focusing on data analysis, Excel, and case studies
  3. Round 3: HR interview assessing cultural fit, communication skills, and career aspirations

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 (Data Analysis, Advanced Excel, Powerpoint, Business Communication, Basic Sql, Data Visualization, Team Collaboration) & 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 Eyglobal 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 Eyglobal as a Associate Analyst?
Highlight Eyglobal's market reputation, recent tech innovations, and how your skills in Data Analysis 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.
Eyglobal 4-6 LPA
Recruiter Resume Apply
Chat Chat with Kashii