Associate Analyst

Round 1: Online Aptitude & Logical Reasoning Test → Round 2: Technical Interview (Python, SQL, Data Engineering concepts) → Round 3: HR Interview (behavioural fit, motivations)

EY is known for its collaborative and inclusive work environment, offering continuous learning through EYU and a strong emphasis on work‑life balance. Employees benefit from global mobility options, mentorship programmes and a clear performance‑driven career ladder.

EY's interview process typically starts with a timed online aptitude test covering quantitative, logical and verbal reasoning. Successful candidates move to a technical interview focused on Python, SQL and data‑engineering concepts, followed by an HR round that assesses cultural fit, communication skills and career aspirations. The overall difficulty is moderate; thorough preparation of core programming and consulting fundamentals helps candidates stand out.

Bachelor of Technology (B.Tech) in Computer Science or equivalent. Minimum 60% aggregate in graduation (or CGPA 6.5/10). No active backlogs at the time of joining. Fresher – no prior work experience required.

Ernst & Young (EY) is one of the world’s leading professional services firms, offering assurance, tax, transaction and advisory services to a diverse portfolio of clients across industries. With a presence in more than 150 countries, EY combines deep industry knowledge with cutting‑edge technology to help organisations navigate complex challenges and create sustainable value. The firm’s culture is built around its purpose – "building a better working world" – and it invests heavily in learning, mentorship and career development for its people. The Business Consulting Risk practice at EY focuses on helping clients identify, assess and mitigate a wide spectrum of risks, ranging from enterprise‑wide strategic risks to technology‑driven vulnerabilities. Within this practice, the National team works across sectors, giving consultants exposure to varied business environments and the opportunity to develop a holistic risk‑management skill set. As an Associate Consultant, you will be part of a collaborative team that delivers data‑driven insights and robust risk frameworks to Fortune‑500 companies and emerging businesses alike. **Key Responsibilities** 1. Design, develop and maintain end‑to‑end data pipelines using Python, SQL and Databricks to support risk‑analytics engagements. 2. Extract, transform and load (ETL) structured and semi‑structured data from multiple sources, ensuring data quality and consistency. 3. Write optimized SQL queries and scripts for ad‑hoc analysis and reporting. 4. Assist senior consultants in building risk‑assessment models, dashboards and visualisations for client presentations. 5. Participate in client workshops to understand business requirements and translate them into technical specifications. 6. Conduct data validation, testing and documentation to ensure production‑ready deliverables. 7. Stay updated with Azure‑based data platforms and recommend cloud‑enabled solutions where appropriate. 8. Contribute to knowledge‑sharing sessions within the team and help build reusable assets. 9. Support compliance and internal‑control reviews by providing accurate data extracts and analytical support. 10. Collaborate with cross‑functional teams, including technology and people advisory services, to deliver integrated risk solutions. **Tech Stack**: Python, SQL, Databricks, Azure Data Lake/SQL, Power BI/Tableau for visualisation, Git for version control. **Growth Path**: Starting as an Associate Consultant, you can progress to Senior Consultant, Manager, Senior Manager and eventually Director or Partner, with regular performance reviews, formal training programmes and opportunities for international assignments. **Why Join EY**: EY offers a globally recognised brand, exposure to high‑impact projects, a structured learning ecosystem (EYU – EY University), and a culture that values diversity, inclusion and wellbeing. Fresh graduates get hands‑on experience with cutting‑edge technologies, mentorship from industry leaders and a clear roadmap for career advancement.