KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
N #3060
Applications open Full-Time Job

Data Analyst-Associate

PwC

  • Bengaluru, India
  • Competitive Package (Best in Industry)
  • 3-5 Yrs
  • Posted Today
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

Minimum Degree Required (BQ) *: Bachelors Degree Degree Preferred: Bachelors Degree Required Field(s) of Study (BQ): Computer Science, Information Technology, Data Analytics, Data Engineering Preferred Field(s) of Study: Cloud Computing, Software Engineering Minimum Year(s) of Experience (BQ) *: 4+ years of experience Certification(s) Preferred: Databricks Certified Data Analyst Associate Databricks Certified Data Engineer Associate AWS Certified Cloud Practitioner Microsoft Power BI Data Analyst c ertification (PL-300). Certifications are preferred, not required; hands-on experience carries more weight. Required Knowledge/Skills (BQ): Strong SQL: joins, subqueries, CTEs, window functions, aggregations, and query optimization, on SQL Server or another relational database.

Ability to build and maintain database objects such as tables, views, indexes, and stored procedures. Hands-on Databricks experience: notebooks, Spark SQL, Delta tables, and building datasets in Bronze, Silver, and Gold layers; working knowledge of PySpark. Python (pandas, PySpark) for data transformation, validation, and automation.

Working knowledge of AWS for data: Amazon S3 for storage and IAM basics, with exposure to Athena, Glue, or Redshift. Experience extracting and transforming large datasets using SQL-based processing and ETL/ELT techniques, including incremental loads. Experience developing operational reports and dashboards in Power BI or Tableau; advanced Excel including pivot tables and formulas.

Experience performing data validation, reconciliation, and troubleshooting data discrepancies. Strong understanding of data modeling and analytics dataset design (fact and dimension tables, star schemas). Ability to analyze large datasets and identify trends, patterns, and operational insights.

Awareness of HIPAA and PHI handling, and strong analytical thinking and problem-solving skills. Preferred Knowledge/Skills *: Databricks Workflows, Unity Catalog, Auto Loader, and Databricks SQL dashboards. AWS Glue (jobs and Data Catalog), Athena, Lambda, and CloudWatch.

Azure Data Factory and ADLS Gen2, since some engagements run on Azure. Experience building or supporting ETL/ELT pipelines, and migrating SQL Server logic to a lakehouse. Exposure to Alteryx, Informatica, or similar ETL tools.

Git and basic CI/CD for data code. Microsoft Power Platform (Power Apps, Power Automate) for workflow automation. Experience with healthcare datasets or Revenue Cycle Management (RCM) environments, including EDI X12 835/837.

Healthcare experience is not mandatory. QUALIFICATIONS: Education /

Experience

BE/BTECH, ME/MTECH, MBA, BCA/MCA, or a related field, or an equivalent amount of relevant professional experience. 4+ years of experience in data analytics, data engineering, or reporting roles. Hands-on experience with SQL databases and with Databricks (Spark SQL, Delta tables). Working experience with Python and with AWS data storage such as Amazon S3.

Experience building dashboards, analytics datasets, and operational reports in Power BI or Tableau. Experience with ETL pipelines or data transformation workflows. Experience working with large operational datasets, including validation and reconciliation.

Experience working in healthcare, insurance, or regulated industries is preferred. Additional Information: Shift timings: Flexible to work in night shifts (US Time zone) Experience Level: 3โ€“5 years Mode of working: Work from office Line of Service: Advisory Designation: Associate Role: Data Analyst (Databricks, SQL & AWS)

Location

Bangalore Primary Technology Stack: SQL Server, Databricks (Spark SQL, PySpark, Delta Lake), Python, AWS (S3, IAM), Power BI, Excel Preferred Technologies: Databricks Workflows / Unity Catalog / Auto Loader, AWS Glue / Athena / Lambda, Azure Data Factory, Tableau, Alteryx / Informatica, Git, Power Automate

Eligibility & process

Who can apply

Experience: 3-5 Yrs. Open to matching qualifications.

Skills & stack

Power BI Power Query Query Data Bricks Bricks SQL Data Python

Selection process

  1. Online Assessment / Technical Interview Rounds / HR Review

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 (Power BI, Power Query, Query, Data Bricks, Bricks, SQL, Data, Python) & 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 Power BI 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 Competitive Package (Best in Industry)
Recruiter Resume Apply
Chat Chat with Kashii