Top 18
Prep plan
Updated weekly · Last refresh Oct 17

The City Of Providence Data Analyst Interview Questions

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

18questions
~2htotal time
Track your progressSign up free to work through all 18 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 3 drills · ~78 min
Moderate to High SQL QueriesHard

Evaluates advanced SQL problem-solving and reasoning under query complexity.

queriessqlThe City Of Providence
Schema Design for Multi-Department ProjectsHard

Tests your data modeling skills for complex, cross-department tracking use cases.

schema designdimensionsData ModelingThe City Of Providence
Advanced SQL With Window FunctionsMedium

Tests your ability to write advanced SQL for complex analytical requirements.

Window FunctionsCTEscomplex queriesThe City Of Providence
Clustered vs Non-Clustered IndexesMedium

Tests your SQL performance knowledge and indexing decision-making.

Performance Tuningindexesquery optimizationThe City Of Providence
Find Duplicate Municipal TransactionsMedium
Practice
Practice drill

Use window functions to identify duplicate municipal transaction records and show each duplicate's count and sequence.

Window Functionsdeduplicationdata cleaningThe City Of Providence
SQL for Top Performing RetailersHard
Practice
Practice drill

Rank retailers by seasonally adjusted quarterly sales and return the top 10 percent using PostgreSQL CTEs and window functions.

Window FunctionsDate FunctionsRankingThe City Of Providence
Second Highest Without AggregatesHard
Practice
Practice drill

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsCredit GenieDevoteamCisco Restaurant + Bar
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership9 questions · ~72 min
Tech Stack FitMedium

Assesses how your technical experience translates into analytics delivery at The City Of Providence.

experienceThe City Of Providence
More Behavioral & Leadership questions with a free account
3
More topics3 questions · ~24 min
Financial Reporting for PlanningMedium

Assesses your experience building financial reports and using them to support business planning decisions at Providence India.

financial datareportingThe City Of Providence
Automated Reporting and Data QualityMedium

Tests your pipeline design, automation practices, and data quality controls.

Data QualitySchedulingAutomationThe City Of Providence
Choosing KPIs for DashboardsMedium

Tests your KPI selection, stakeholder thinking, and dashboard design for different audiences.

Stakeholder ManagementMetricsUser NeedsThe City Of Providence

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 18 questions plus 3 hands-on drills to finish this plan.