Business Analyst - Associate

Overview

Support client engagements within PwC's Advisory practice by analyzing business processes, gathering information, and helping identify opportunities to improve efficiency, productivity, and service delivery, with a focus on healthcare revenue cycle operations.

What you'll do

• Gather requirements from operations and client stakeholders, and define KPIs and metrics.
• Analyze operational datasets using SQL (SQL Server, MySQL) and Databricks SQL to extract and interpret data.
• Develop interactive dashboards and reports using Power BI.
• Create and modify Power BI data models, Power Query transformations, and DAX calculations.
• Translate analytical insights into actionable business recommendations and operational improvements.
• Specify datasets and business rules for data analysts and engineers, and validate the results.
• Support user acceptance testing and report validation during the move of reporting data to Databricks.
• Identify opportunities to automate reporting workflows using Power BI and Power Platform tools.
• Communicate analytical insights through dashboards, reports, and presentations.
• Ensure compliance with data governance standards and healthcare data privacy regulations including HIPAA.
• Analyze client operational processes to identify inefficiencies, process gaps, and improvement opportunities.
• Gather and organize process data from multiple sources to support workflow evaluation and issue tracking.
• Support the development of process maps, operational documentation, and service delivery materials.
• Assist in the design of streamlined procedures that improve productivity, quality, and cycle time.
• Apply business process improvement methods and lean concepts to day-to-day operations work.
• Contribute to technology implementation and automation efforts that simplify manual tasks and improve service delivery.
• Monitor operational metrics and prepare summaries that highlight trends, risks, and performance drivers.
• Participate in client discussions, take notes, and translate requirements into clear follow-up tasks.
• Coordinate with team members to complete project activities, meet deadlines, and maintain organized work products.
• Build knowledge of revenue cycle operations, managed services delivery, and healthcare client needs.

What you'll need

• At least 3-5 years of experience.
• Oral and written proficiency in English.
• Strong 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.
• 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.
• Strong SQL experience on SQL Server or MySQL (joins, CTEs, subqueries, window functions, aggregations), and ability to query Databricks SQL.
• 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.

Nice to have

• Preferred qualification: BE/BTECH, ME/MTECH, MBA, BCA/MCA.
• Certification(s) preferred: Microsoft Power BI Data Analyst certification (PL-300), Databricks Certified Data Analyst Associate, AWS Certified Cloud Practitioner.
• Learning mindset and ownership of personal development.
• Active listening, asking questions, and clearly expressing ideas.
• Gathering information from multiple sources and discerning patterns.
• Building commercial awareness across business operations and client needs.
• Adapting to varied clients and team members in fast-paced settings.
• Accepting feedback, reflecting, and applying it to daily work.

Details

• Location: Bangalore.
• Shift timings: flexible to work in night shifts (US time zone).