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

Associate Data Science & Engineering - Data & Analytics Advisory

PwC

  • Kolkata, West Bengal
  • 6-8 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

PricewaterhouseCoopers (PwC) is one of the world’s leading professional services networks, offering audit, tax, consulting and advisory services to Fortune‑500 companies, governments and NGOs. In India, PwC has a strong presence across major metros, fostering a culture of trust, collaboration and continuous learning. The firm invests heavily in technology and innovation, helping clients navigate digital transformation, regulatory changes and complex business challenges.

As a fresher‑friendly employer, PwC provides structured onboarding, mentorship programmes and clear career ladders that enable young talent to grow into senior advisory roles.

The role of Associate – Data Science & Engineering in the Data & Analytics Advisory practice is designed for recent engineering graduates who are passionate about turning raw data into actionable insights. You will work alongside seasoned data scientists, consultants and industry experts to design, develop and operationalise analytical solutions for clients across sectors such as banking, retail, manufacturing and public services. The position offers exposure to end‑to‑end data pipelines, cloud platforms and cutting‑edge generative AI models, making it an ideal launchpad for a career in data‑driven consulting.

Key Responsibilities

  • Design and implement machine‑learning and deep‑learning algorithms using Python, R and related libraries.
  • Build scalable data pipelines and ETL workflows on AWS services (S3, Glue, Lambda, Redshift, etc.).
  • Develop and deploy generative AI applications (e.g., using OpenAI or Google Gemini) within client solutions.
  • Conduct statistical analysis, hypothesis testing and model validation to ensure robustness.
  • Collaborate with business analysts to translate client requirements into technical specifications.
  • Prepare data visualisations and dashboards that communicate insights to non‑technical stakeholders.
  • Maintain data quality, governance and documentation throughout the project lifecycle.
  • Stay updated with emerging AI/ML techniques and recommend innovative approaches to improve client outcomes.
  • Participate in code reviews, peer learning sessions and knowledge‑sharing forums.
  • Support the delivery team in client presentations and solution demos.

Tech Stack: Python, R, SQL, AWS (S3, EC2, Lambda, SageMaker), Spark/Flink, Docker, Git, Tableau/PowerBI, OpenAI API, Google Gemini, statistical packages (statsmodels, scikit‑learn).

Growth Path: Starting as an Associate, you can progress to Senior Associate, Manager, Senior Manager and eventually to Director/Partner within the Advisory line. PwC encourages continuous upskilling through internal certifications, external courses and on‑the‑job learning.

Why Join PwC? You will be part of a purpose‑driven firm that values diversity, inclusion and ethical leadership. The role offers hands‑on experience with real‑world data challenges, mentorship from industry veterans and a supportive environment that balances professional growth with personal wellbeing.

Competitive compensation, performance‑linked bonuses and a robust benefits package further enhance the employee experience.

Eligibility & process

Who can apply

Graduates with BE, B.Tech or M.Tech in Computer Science, Information Technology, Electronics, Electrical, Mechanical or related engineering streams. Minimum aggregate of 60% (or CGPA 6.0/10) in the final year. No active backlogs at the time of joining. Candidates from the 2023, 2024, 2025 or 2026 batches are eligible. Freshers and candidates with up to 2 years of relevant experience can apply.

Skills & stack

Python AWS Data Engineering SQL Machine Learning Deep Learning Generative AI Statistical Modeling

Selection process

  1. Round 1: Online assessment (aptitude and logical reasoning)
  2. Round 2: Technical interview (coding, ML concepts, AWS fundamentals)
  3. Round 3: HR interview (fitment, communication, 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 (Python, AWS, Data Engineering, SQL, Machine Learning, Deep Learning, Generative AI, Statistical Modeling) & 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 Data Science & Engineering - Data & Analytics Advisory?
Highlight PwC's market reputation, recent tech innovations, and how your skills in Python 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 6-8 LPA
Recruiter Resume Apply
Chat Chat with Kashii