Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

PwC

NewBe an early applicant

Business Analyst

Posted Updated

Description

Job Summary

To truly excel and drive innovation in an ever-evolving technological landscape, every member of PwC is expected to be a purpose-driven and value-led leader at every level. Our PwC Professional framework serves as a cornerstone for professional growth, offering a clear set of expectations across all functions, geographies, and career paths.

As an Associate Business Analyst (Power BI, SQL & Databricks), you will support healthcare revenue cycle operations by delivering data-driven insights, building dashboards, and translating analytical findings into business recommendations.

This role works at the business end of the data team. You will gather requirements from operations and client stakeholders, define metrics, build Power BI reports on SQL Server and Databricks data, analyze performance and root causes, and work with data analysts and engineers so the datasets behind the reports are correct. As RCMS moves reporting data from SQL Server to Databricks, you will help confirm that reports and numbers carry over accurately.

Core Responsibilities at This Level Include:

  • Gathering requirements from operations and client stakeholders, and defining KPIs and metrics.
  • Analyzing operational datasets using SQL (SQL Server, MySQL) and Databricks SQL to extract and interpret data.
  • Developing interactive dashboards and reports using Power BI.
  • Creating and modifying Power BI data models, Power Query transformations, and DAX calculations.
  • Translating analytical insights into actionable business recommendations and operational improvements.
  • Specifying datasets and business rules for data analysts and engineers, and validating the results.
  • Supporting user acceptance testing and report validation during the move of reporting data to Databricks.
  • Identifying opportunities to automate reporting workflows using Power BI and Power Platform tools.
  • Communicating analytical insights through dashboards, reports, and presentations.
  • Ensuring compliance with data governance standards and healthcare data privacy regulations including HIPAA.
  • Adhering to PwC’s Code of Ethics & Business Conduct while handling sensitive client data.

By joining PwC, you will become part of a technology-driven and people-focused culture that fosters growth, learning, and innovation. If you thrive on solving complex problems and have a passion for software development, this is the place for you!

Minimum Degree Required (BQ) *: Bachelor’s Degree

Degree Preferred: Bachelor’s 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.

Purpose Statement:

The primary purpose of this position is to support healthcare revenue cycle operations by defining the metrics, analyzing operational data, building dashboards, and delivering business insights that improve operational performance and decision-making.

The Associate – Business Analyst will use SQL, Databricks SQL, and Power BI to build dashboards, interpret data trends, and give actionable insights to operational teams and client stakeholders, and will work with data analysts and engineers to keep the underlying data accurate.

ESSENTIAL FUNCTIONS:

Requirements and business analysis

  • Gather requirements from operations and client stakeholders, define metrics and KPIs, and document business rules and report specifications.
  • Analyze operational data to identify performance trends and improvement opportunities.
  • Perform root cause analysis for operational and financial performance issues.
  • Interpret findings and turn them into business insights and recommendations.
  • Support operational teams with ad hoc reporting and analytical requests.

Reporting and dashboards

  • Develop dashboards and reports using Power BI, with Power Query transformations and DAX measures.
  • Publish and manage reports in Power BI Service, including scheduled refresh and row-level security.
  • Extract and analyze data using SQL on SQL Server and MySQL, and Databricks SQL on Delta tables.
  • Identify opportunities to improve reporting efficiency and automate reporting processes.

Working with the data team

  • Specify datasets, business rules, and acceptance criteria for data analysts and engineers building reporting datasets.
  • Validate datasets and report outputs against source systems, and log and follow up on discrepancies.
  • Support user acceptance testing and report validation as reporting data moves from SQL Server to Databricks.

Governance and communication

  • Ensure secure handling of Protected Health Information (PHI) and compliance with HIPAA regulations.
  • Maintain documentation for reporting workflows, definitions, and analytics processes.
  • Communicate insights through dashboards, reports, and presentations, and attend team and client meetings as required.
  • Stay up-to-date with analytics and reporting practices, and perform other duties as assigned.

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

Skills

Apply

See also

Business Analysis jobs by country — openings, pay and top skills →