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).
- Solid 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 explicit 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
📌 Business Analyst (Bengaluru)
🏢 PwC
📍 Bengaluru