Top 50
Company roadmap
Updated weekly · Last refresh Aug 30

City of Philadelphia Interview Questions

The questions to prepare for City of Philadelphia interviews, across all roles. Questions from real interview reports rank first. Updated weekly.

50questions
~8htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 7 questions · ~71 min
2
Pipelines7 questions · ~71 min
Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityCity of Philadelphia
More Pipelines questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Execution6 questions · ~60 min
Recover a Slipping ProjectMedium

Explain how you would diagnose and recover a project that is falling behind schedule without losing stakeholder trust.

Success CriteriaRoadmappingRisk AssessmentCity of Philadelphia
More Execution questions with a free account
4
SQL & Data Manipulation6 questions + 3 drills · ~90 min
5
Strategy6 questions · ~60 min
Staying Current on ThreatsEasy

Tests your threat intelligence habits and ability to incorporate new information into practice.

EstimationCompetitive AnalysisGrowth StrategyCity of Philadelphia
More Strategy questions with a free account
6
Metrics5 questions · ~50 min
Diagnosing Budget VariancesMedium

Tests your variance diagnosis skills to support City of Philadelphia budget accountability.

KPIsVarianceDiagnosisCity of Philadelphia
More Metrics questions with a free account
7
More topics13 questions · ~131 min
Data Visualization TechniquesEasy

Tests your practical visualization choices and ability to make analysis understandable.

RegressionCorrelationData WranglingCity of Philadelphia
Research for Underserved CommunitiesMedium

Tests your approach to equitable, community-centered research design and execution.

User SegmentsUser ResearchUser NeedsCity of Philadelphia
More questions with a free account
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.