Business Analyst
PwC
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
Selection process
- Online Assessment / Technical Interview Rounds / HR Review
Prep kit
20 resourcesStudy material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Behavioural & HR questions 3
Highlight PwC's market reputation, recent tech innovations, and how your skills in Power BI directly solve their team's objectives.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.