Actively Hiring
PW
Business Analyst
PwC
Bengaluru
Skills:
Python
SQL
Power BI
Tableau
Job Description
Job Title: Business Analyst
Company: PwC
Job Category: Data Science
Roles & Responsibilities:
* 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.
* 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.
* 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.
* Shift timings: Flexible to work in night shifts (US Time zone)
* Experience Level: 1-3 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
Work Location: Bengaluru, India
Availability: Full time
Requirements
Minimum Degree Required (BQ) \: Bachelors Degree
Degree Preferred: Bachelors Degree
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.
QUALIFICATIONS: Education / Experience:
Key Skills: Python, SQL, Power BI, Tableau
Salary: Not disclosed