PwC Data Analyst Interview Questions
The questions to prepare for a PwC Data Analyst interview. Questions from real interview reports rank first. Updated weekly.
Approach for safely backfilling missing data while preserving correctness, idempotency, and data quality.
PwCApproach for cleaning and preparing raw data inside an ETL pipeline.
PwCA framework for connecting user needs to business goals, then making product decisions with clear trade-offs and measurable outcomes.
PwCSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Explain practical SQL methods for analyzing large datasets, including filtering, aggregation, sampling, and performance-aware query design.
PwCExplain how to identify, assess, and handle missing values in SQL using NULL checks, COALESCE, and validation logic.
PwCUse PostgreSQL window functions to calculate client running totals and trailing 30-day average transaction volumes.
PwCAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreUse joins, CTEs, and CASE logic to flag and fill missing financial fields for Qlik planning records.
QlikExplain when network interference threatens an A/B test, how it biases estimates, and how to redesign the experiment safely.
PwCDesign an end-to-end A/B test for a new product change, including metrics, MDE, power, randomization, and launch decision rules.
PwCTests exploratory analysis methods for detecting patterns and trends in data.
PwC