Overview
Support healthcare revenue cycle operations through data analytics, building reliable analytics datasets and dashboards that enable data-driven decision-making within PwC's Operations Consulting practice.
What you'll do
- Analyze large healthcare operational datasets to identify trends, performance metrics, and financial insights.
- Build analytics datasets and data models in Databricks (Delta tables, Silver and Gold layers) using SQL, PySpark, and Python.
- Extract and transform data using SQL on SQL Server and Databricks SQL.
- Rebuild existing SQL-based logic as Databricks datasets and validate results against current outputs.
- Support data pipelines and ETL/ELT processes that feed analytics and reporting, including data on Amazon S3.
- Develop dashboards and reports using Power BI, Tableau, and Excel.
- Automate data and reporting workflows with Databricks jobs, Python, and Power Automate.
- Ensure data accuracy through validation, reconciliation, and monitoring across analytics datasets.
- Analyze revenue cycle data to identify trends, variances, and process improvement opportunities.
- Support client service teams by gathering operational data and preparing clear reporting materials.
- Map billing, coding, collections, and cash application processes to identify breakdowns and delays.
- Track key performance metrics for revenue cycle activities and flag issues that affect productivity.
- Assist in the execution of process improvement initiatives across revenue cycle workflows.
- Use automation tools, digital platforms, and data preparation methods to streamline repetitive tasks.
- Document operational findings and organize information for client presentations and internal reviews.
- Apply technical knowledge of revenue cycle operations to support service delivery and issue resolution.
What you'll need
- BE/BTech, ME/MTech, MBA, or BCA/MCA (preferred educational qualification).
- At least 3-5 years of experience.
- Oral and written proficiency in English.
- Strong experience in data analytics, data engineering, or reporting roles.
- Hands-on experience with SQL databases and with Databricks (Spark SQL, Delta tables, Databricks Workflows, Unity Catalog, Auto Loader, and Databricks SQL dashboards).
- Working experience with Python and with AWS data storage such as Amazon S3.
- Strong SQL: joins, subqueries, CTEs, window functions, aggregations, and query optimization, on SQL Server or another relational database.
- Hands-on Databricks experience: notebooks, Spark SQL, Delta tables, and building datasets in Bronze, Silver, and Gold layers; working knowledge of PySpark.
Nice to have
- Databricks Certified Data Analyst Associate, Databricks Certified Data Engineer Associate, AWS Certified Cloud Practitioner, or Microsoft Power BI Data Analyst certification (PL-300).
Details
- Location: Bangalore.
- Shift timings: flexible to work in night shifts (US time zone).
Read the full description and apply on the company’s own careers page.