Data Analyst-Associate
PwC
About the role
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: Databricks Certified Data Analyst Associate Databricks Certified Data Engineer Associate AWS Certified Cloud Practitioner Microsoft Power BI Data Analyst c ertification (PL-300). Certifications are preferred, not required; hands-on experience carries more weight. Required Knowledge/Skills (BQ): Strong SQL: joins, subqueries, CTEs, window functions, aggregations, and query optimization, on SQL Server or another relational database.
Ability to build and maintain database objects such as tables, views, indexes, and stored procedures. Hands-on Databricks experience: notebooks, Spark SQL, Delta tables, and building datasets in Bronze, Silver, and Gold layers; working knowledge of PySpark. Python (pandas, PySpark) for data transformation, validation, and automation.
Working knowledge of AWS for data: Amazon S3 for storage and IAM basics, with exposure to Athena, Glue, or Redshift. Experience extracting and transforming large datasets using SQL-based processing and ETL/ELT techniques, including incremental loads. Experience developing operational reports and dashboards in Power BI or Tableau; advanced Excel including pivot tables and formulas.
Experience performing data validation, reconciliation, and troubleshooting data discrepancies. Strong understanding of data modeling and analytics dataset design (fact and dimension tables, star schemas). Ability to analyze large datasets and identify trends, patterns, and operational insights.
Awareness of HIPAA and PHI handling, and strong analytical thinking and problem-solving skills. Preferred Knowledge/Skills *: Databricks Workflows, Unity Catalog, Auto Loader, and Databricks SQL dashboards. AWS Glue (jobs and Data Catalog), Athena, Lambda, and CloudWatch.
Azure Data Factory and ADLS Gen2, since some engagements run on Azure. Experience building or supporting ETL/ELT pipelines, and migrating SQL Server logic to a lakehouse. Exposure to Alteryx, Informatica, or similar ETL tools.
Git and basic CI/CD for data code. Microsoft Power Platform (Power Apps, Power Automate) for workflow automation. Experience with healthcare datasets or Revenue Cycle Management (RCM) environments, including EDI X12 835/837.
Healthcare experience is not mandatory. 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 data analytics, data engineering, or reporting roles. Hands-on experience with SQL databases and with Databricks (Spark SQL, Delta tables). Working experience with Python and with AWS data storage such as Amazon S3.
Experience building dashboards, analytics datasets, and operational reports in Power BI or Tableau. Experience with ETL pipelines or data transformation workflows. Experience working with large operational datasets, including validation and reconciliation.
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: Data Analyst (Databricks, SQL & AWS)
Location
Bangalore Primary Technology Stack: SQL Server, Databricks (Spark SQL, PySpark, Delta Lake), Python, AWS (S3, IAM), Power BI, Excel Preferred Technologies: Databricks Workflows / Unity Catalog / Auto Loader, AWS Glue / Athena / Lambda, Azure Data Factory, Tableau, Alteryx / Informatica, Git, Power Automate
Eligibility & process
Who can apply
Experience: 3-5 Yrs. Open to matching qualifications.
Skills & stack
Selection process
- Online Assessment / Technical Interview Rounds / HR Review
Prep kit
20 resourcesStudy material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Behavioural & HR questions 3
Highlight PwC's market reputation, recent tech innovations, and how your skills in Power BI directly solve their team's objectives.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.