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

Associate Analyst

PwC

  • Gurugram, India
  • 7 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

PwC India is a global professional services network that offers audit, tax, advisory, and consulting services to a diverse range of clients across industries. With a strong presence in Gurugram, the firm is part of the Acceleration Center India, a hub that brings together cross‑functional teams to deliver innovative solutions to clients worldwide. PwC’s culture emphasizes collaboration, continuous learning, and a commitment to sustainability, making it an ideal environment for professionals who want to shape the future of business.

The Sustainability Associate 2 role is a full‑time position that focuses on sustainability assurance and reporting. As an associate, you will support engagements that evaluate the quality, reliability, and completeness of sustainability data against global frameworks such as GRI, SASB, and TCFD. You will work closely with senior team members to gather evidence, test data integrity, and document findings that help clients improve their ESG disclosures.

Key responsibilities include

  • Gathering and testing evidence for sustainability metrics across selected performance indicators.
  • Comparing reported information with framework requirements and identifying disclosure gaps.
  • Assisting in materiality analysis by reviewing source data and tracking assumptions.
  • Evaluating control activities related to data collection, transformation, and reporting.
  • Analyzing trends and patterns in sustainability data using spreadsheets and visualization tools.
  • Conducting research on climate, environmental, and social topics to support client projects.
  • Communicating progress and findings clearly to senior team members.
  • Adhering to professional standards, independence requirements, and internal guidelines.
  • Collaborating with cross‑functional teams across Advisory, Assurance, Tax, and Business Services.
  • Continuously improving processes and learning new sustainability frameworks.

The role requires proficiency in Excel, data visualization tools (e.g., Power BI or Tableau), and a solid understanding of ESG reporting standards. You will also need strong analytical, communication, and problem‑solving skills.

Growth path: Starting as an associate, you can progress to Senior Associate, Manager, Senior Manager, and eventually to Director or Partner, with opportunities to specialize in sustainability, ESG strategy, or audit. PwC offers structured learning programs, mentorship, and exposure to global projects.

Why join PwC? The firm offers competitive compensation, a supportive work culture that values diversity and inclusion, and a platform to work on high‑impact sustainability projects that influence global business practices. You will gain exposure to cutting‑edge tools, continuous professional development, and the chance to build a rewarding career in a leading professional services firm.

Eligibility & process

Who can apply

Bachelor’s degree in any discipline with a minimum of 60% marks or 6.5 CGPA. At least 1 year of relevant experience. No backlogs. Proficiency in English (oral and written).

Skills & stack

Sustainability Reporting Esg Frameworks Data Analysis Advanced Excel Data Visualization Audit Principles Power BI Tableau

Selection process

  1. Round 1: Technical assessment and case study
  2. Round 2: Managerial interview with senior associate
  3. Round 3: HR interview

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 (Sustainability Reporting, Esg Frameworks, Data Analysis, Advanced Excel, Data Visualization, Audit Principles, Power BI, Tableau) & 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 PwC 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 PwC as a Associate Analyst?
Highlight PwC's market reputation, recent tech innovations, and how your skills in Sustainability Reporting 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.
PwC 7 LPA
Recruiter Resume Apply
Chat Chat with Kashii