HM Revenue and Customs Data Analyst Interview Questions

The questions to prepare for a HM Revenue and Customs Data Analyst interview. Questions from real interview reports rank first. Updated daily.

2questions

~1htotal time

Track your progressSign up free to work through all 2 questions and resume where you left off.

Start practicing free →

SQL & Data ManipulationStart here. 1 question + 3 drills · ~38 min

Discuss Data Analysis Tooling ChoicesEasy

Explain how SQL fits with data analysis and visualization tools, and when to use each in an analytics workflow.

JoinsData WranglingAggregationsHHM Revenue and Customs

Optimize a Slow SQL QueryHard

Practice

Practice drill

Rewrite a slow PostgreSQL loan payment query to reduce scanned rows while preserving the required aggregated results.

database optimizationJoinsData Wrangling

AmeripriseEEltro Cyberchrome Private

EnergyHub

Top Customers by Net SalesMedium

Practice

Practice drill

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData Wrangling

Gain Digital

TCS

Zest AI

Optimize Database QueriesMedium

Practice

Practice drill

Optimize a PostgreSQL aggregation query by filtering efficiently, reducing intermediate rows, and returning qualifying customer totals.

database optimizationJoinsData WranglingSSonata SoftwareCCentelonAAarohiinfo FI Management

Behavioral & Leadership1 question · ~8 min

Influencing a Resistant Senior StakeholderMedium

Tests influence without authority when a senior stakeholder disagrees with your project strategy, including communication, conflict handling, and outcome ownership.

Influence Without AuthorityStakeholder ManagementCommunicationHHM Revenue and Customs

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 2 questions plus 3 hands-on drills to finish this plan.