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

Business Analyst

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: Microsoft Power BI Data Analyst certification (PL-300) Databricks Certified Data Analyst Associate AWS Certified Cloud Practitioner. Certifications are preferred, not required; hands-on experience carries more weight. Required Knowledge/Skills (BQ): Hands-on experience with Power BI, including Power Query, DAX, and dashboard development.

Strong understanding of Power BI data modeling, including star schema design and relationship management. Experience optimizing reports using query folding, DAX performance tuning, and efficient dataset design. Experience publishing and managing dashboards in Power BI Service, including workspace management, scheduled refresh, and row-level security (RLS).

Strong SQL experience on SQL Server or MySQL (joins, CTEs, subqueries, window functions, aggregations), and ability to query Databricks SQL. Advanced Microsoft Excel, including pivot tables and analytical modeling. Requirements gathering and business analysis: KPI and metric definition, functional specifications, business rules, and user acceptance testing.

Ability to validate data and reports against source systems and flag discrepancies to data teams. Experience with root cause analysis and operational performance analysis. Ability to interpret results, tell a clear story, and present recommendations to operations and client stakeholders.

Awareness of HIPAA and PHI handling, and strong analytical thinking and problem-solving skills. Preferred Knowledge/Skills *: Familiarity with Databricks: reading Delta tables, Databricks SQL, notebooks, and the Bronze, Silver, and Gold layers. Exposure to AWS data services such as S3, Athena, or Redshift as sources for reporting.

Basic Python or SQL scripting for analysis and automation. Power Platform tools such as Power Apps and Power Automate. Experience working with healthcare datasets or Revenue Cycle Management (RCM): claims, denials, payments, and A/R.

Healthcare experience is not mandatory. Process mapping and documentation, and Agile ways of working with tools such as Jira. Exposure to Tableau.

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 business analytics, reporting, or business intelligence roles. Hands-on experience developing Power BI dashboards and reports. Experience using SQL tools such as SQL Server Management Studio or MySQL Workbench for data analysis, with the ability to work in Databricks SQL.

Experience working with Power Query and DAX. Experience gathering requirements, defining metrics, and presenting insights to business stakeholders. Experience analyzing operational datasets and developing reporting insights.

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: Business Analyst (Power BI, SQL & Databricks) |

Location

Bangalore & Hyderabad Primary Technology Stack: Power BI (Power Query, DAX), SQL Server / MySQL, Databricks SQL, Excel Preferred Technologies: Databricks notebooks, AWS (S3, Athena, Redshift), Python, Power Automate / Power Apps, Jira

Eligibility & process

Who can apply

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

Skills & stack

Power BI Business Analysis KPI Dax Data Bricks Bricks SQL Data

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, Business Analysis, KPI, Dax, Data Bricks, Bricks, SQL, Data) & 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 Business Analyst?
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