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

Data Analyst - Associate

PwC

  • Bangalore, India
  • ₹6 LPA - ₹9 LPA
  • 5 Years
  • Posted Today
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

PwC (PricewaterhouseCoopers) is one of the world’s leading professional services networks, offering audit, tax, consulting and advisory services to a diverse client base across industries. In India, PwC operates through its Acceleration Centers, which combine cutting‑edge technology, data science, and industry expertise to help clients transform their operations. The firm is known for its collaborative culture, continuous learning opportunities, and a strong emphasis on ethical standards and social responsibility.

Working at PwC means exposure to global best practices, mentorship from seasoned professionals, and the chance to contribute to high‑impact projects for Fortune‑500 companies and emerging businesses alike.

The Data Analyst – Associate role sits within the Operations Consulting practice of PwC’s Acceleration Center in Bangalore. The associate will partner with healthcare clients to turn raw operational data into actionable insights that drive revenue‑cycle efficiency. The position blends data engineering, analytics, and domain knowledge, allowing the candidate to build robust data pipelines, develop visual dashboards, and support process‑improvement initiatives.

This is an ideal role for candidates who enjoy solving complex problems, automating repetitive tasks, and delivering clear, data‑driven recommendations to senior stakeholders.

Key Responsibilities

  • Analyse large healthcare operational datasets to uncover trends, performance metrics, and financial insights.
  • Build analytics datasets and multi‑layered Delta tables (Bronze, Silver, Gold) in Databricks using SQL, PySpark, and Python.
  • Re‑engineer existing SQL‑based logic into Databricks datasets and validate outputs against legacy reports.
  • Design, develop, and maintain ETL/ELT pipelines that ingest data from Amazon S3 and SQL Server into Databricks.
  • Create interactive dashboards and reports using Power BI, Tableau, and Excel for client‑facing deliverables.
  • Automate data and reporting workflows with Databricks Jobs, Python scripts, and Power Automate.
  • Perform data validation, reconciliation, and monitoring to ensure accuracy across analytics datasets.
  • Map and analyse revenue‑cycle processes (billing, coding, collections, cash application) to identify bottlenecks and improvement opportunities.
  • Support client service teams by gathering operational data, preparing concise reporting material, and presenting findings.
  • Document analytical methods, process flows, and insights for internal knowledge bases and client presentations.

Tech Stack: Databricks (Spark SQL, Delta Lake, Unity Catalog, Workflows), SQL Server, AWS S3, Python, PySpark, Power BI, Tableau, Excel, Power Automate.

Growth Path: Starting as an Associate, high performers can progress to Senior Associate, Manager, and eventually to Leadership roles within the Data & Analytics practice, with opportunities to specialize in healthcare, finance, or technology domains.

Why Join PwC: The firm offers a structured learning environment, access to world‑class tools, and a global network of experts. Employees benefit from flexible shift options, exposure to US‑timezone projects, and a culture that rewards curiosity, ownership, and continuous improvement.

Eligibility & process

Who can apply

Graduates with BE/BTech, ME/MTech, MBA, BCA or MCA degrees; minimum 3‑5 years of relevant experience in data analytics, data engineering or reporting; strong command of English (both written and spoken); academic performance of at least 60% CGPA/percentage; no active backlogs at the time of joining.

Skills & stack

SQL Databricks Spark Sql Delta Lake Python Pyspark AWS S3 Power BI

Selection process

  1. Round 1: Online assessment (aptitude & logical reasoning)
  2. Round 2: Technical interview (SQL, Databricks, Python, case study)
  3. Round 3: HR interview (fit, 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 (SQL, Databricks, Spark Sql, Delta Lake, Python, Pyspark, AWS S3, Power BI) & 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 Data Analyst - Associate?
Highlight PwC'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.
PwC ₹6 LPA - ₹9 LPA
Recruiter Resume Apply
Chat Chat with Kashii