Top 30
Prep plan
Updated weekly · Last refresh Oct 17

Providence Data Analyst Interview Questions

The questions to prepare for a Providence Data Analyst interview. Questions from real interview reports rank first. Updated daily.

30questions
~5htotal time
Track your progressSign up free to work through all 30 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 9 questions · ~83 min
Running Total Sales by DateMedium
Practice

Aggregate posted Arcesium portfolio sales by date, then calculate each active portfolio's cumulative sales with a window function.

Window FunctionsRunning TotalsProvidence
Second Highest Trader SalaryEasy
Practice

Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.

SubqueriesRankingSortingProvidence
More SQL & Data Manipulation questions with a free account
2
A/B Testing & Experimentation3 questions · ~28 min
Choosing Randomization Unit for UI TestMedium

Choose the right randomization unit for a customer-facing experiment and explain how that choice affects metrics, power, and validity.

ExperimentationGuardrail MetricsA/B TestingProvidence
Diagnose Sample Ratio MismatchHard

Investigate sample ratio mismatch and decide whether an experiment readout is trustworthy enough to ship.

Guardrail MetricsSample Ratio MismatchA/B TestingProvidence
More A/B Testing & Experimentation questions with a free account
3
Pipelines4 questions · ~37 min
Backfilling Missing Pipeline DataMedium

Approach for safely backfilling missing data while preserving correctness, idempotency, and data quality.

ETLQualityProvidence
Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityProvidence
More Pipelines questions with a free account
4
Metrics4 questions · ~37 min
Hospital KPI Dashboard DesignMedium

Tests your ability to define KPIs, design dashboards, and support operational decision-making.

North Star MetricKPIsDiagnosisProvidence
More Metrics questions with a free account
5
Behavioral & Leadership9 questions · ~83 min
More Behavioral & Leadership questions with a free account
6
More topics1 question · ~9 min
The finish line: interview-readyComplete all 30 questions to finish this plan.