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 daily.
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 PhiladelphiaRank Philadelphia departments by quarterly spending and return the top three for each fiscal quarter.
City of PhiladelphiaPivot product sales into monthly reporting columns with quarterly totals.
World Wide Technology
Nestlé USAMeasure dashboard adoption by Johns Hopkins user segment using joins, aggregation, and reporting-period filters.
The Johns Hopkins UniversityDiscuss 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.