City of Philadelphia Data Analyst Interview Questions
The questions to prepare for a City of Philadelphia Data Analyst interview. Questions from real interview reports rank first. Updated weekly.
Tests dashboard tooling choices, usability, and ability to present insights to executive audiences.
City of PhiladelphiaTests depth of SQL for complex querying and performance-minded data extraction.
City of PhiladelphiaCompute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.
Gain Digital
TCS
Zest AIMerge CRM orders with GA events via an identity map to build a customer-level view using joins, window functions, and monthly rollups.
ArtefactUse ROW_NUMBER() to keep the earliest created_at 'Repl created' per entity and return out-of-order duplicates to delete.
Replit
QuantcastDiscuss automating a manual reporting workflow with code, focusing on batch ETL, orchestration, and data quality.
City of PhiladelphiaTests product sense and integrity in metric definitions while managing stakeholder expectations.
City of PhiladelphiaTests judgment on when to apply statistical tooling and methods for city reporting needs.
City of PhiladelphiaTests dashboard design choices, metric selection, and communication for non-technical city stakeholders.
City of PhiladelphiaTests product sense and stakeholder discovery to align metrics with real operational needs.
City of PhiladelphiaTests ability to communicate statistics and uncertainty clearly to non-technical stakeholders.
City of PhiladelphiaSign up to see every question
Create a free account to unlock this list and practice real interview questions.