SQL Quest › SQL Interview Prep › Bloomberg
Bloomberg's data-role SQL format is thinly reported, and this page says so. What is reported: a final round with a data exercise on a messy financial dataset, and SQL shaped around prices, trades and sessions by time period.
16 practice challenges · 4 Easy / 7 Medium / 5 Hard · 11 play free · runs in the browser
Bloomberg does not publish the format. Each row is what candidates and prep guides have described publicly, with its source; where sources disagree, the row says so. Formats change — treat every specific as reported, not official.
| Data analyst stages | An application, an online assessment (logic, English, Excel), a recruiter call, then a final round of three or four interviews that includes a 30–60 minute data exercise on a messy corporate-filings dataset.[1] |
|---|---|
| SQL screen for data roles | Not reliably reported. The assessment platform reported for Bloomberg is for software-engineering phone screens, not data roles, so this page names none. (no reliable source) |
| What the analyst round weighs | Reported as basic SQL and Excel alongside data-quality judgement — finding errors and proposing checks.[1] |
Sources: OphyAI — Bloomberg interview guide (updated 3 Jun 2026); DataLemur — Bloomberg SQL interview questions (17 Apr 2025); DataLemur — stock min/max question (Bloomberg-tagged) (undated). Accessed 13 Sep 2026.
Reported most often, in order
Difficulty: Easy-to-medium. The data is daily prices, trades and volume, terminal sessions, exchange data subscriptions, and financial filings.
Our Bloomberg practice set, by skill
The 16 SQL Quest challenges tagged Bloomberg, resolved onto the nine Skillmap skills. A challenge exercises several skills, so shares do not sum to 100%. This is the composition of the practice set on this page, not a measurement of Bloomberg’s interview.
Shapes candidates and guides report (paraphrased)
Practise now — SQL Quest challenges matched to those patterns
Our challenges, chosen because their SQL matches the shapes above; not questions Bloomberg has asked. Each card opens the challenge in the browser — no signup.
Skillmap
Ten questions, no signup. You get a readiness score weighted to the SQL this page covers, your Skillmap across joins, window functions, aggregation and the rest, and the weakest skill to practise first.
Drill the skills the Bloomberg set leans on, one at a time: Window function practice · GROUP BY exercises · CTE practice · JOIN practice · CASE WHEN practice — or browse every SQL practice question.
Every question in the Bloomberg set, one page each with the schema and a hint: National Total Deposits · Monthly Spend Per Account · Spend by Day of Week · The Ledger's First Week, Day by Day · RANK vs DENSE_RANK Side-by-Side · Second-Highest Earner Per Department (ROW_NUMBER) · Average Tier 1 Ratio Per State · Ticket-Size Mix by Category · Month-over-Month Spend Growth by Category · Busiest Merchants, and What a Tie Does to the Rank · Running Total of Daily Card Spend · Second Highest Salary per Department · Top 3 Banks Per State by Assets · QoQ Asset Growth — Top Banks · Peak Rolling 30-Day Spend Per Account · How Concentrated Is the Spend?.
No signup, no card. Start with the free challenges in the set; the Skillmap shows what to fix before the interview.
Start the Bloomberg set — free