Twitter (X) Data Analyst Interview Guide

From what candidates report after interviewing at X, the product sense round is where most people stall. Not SQL. They walk in with generic metric frameworks that could describe any social app, and the interviewer loses interest fast. X's leaner post-acquisition org expects analysts to think like product owners who happen to write queries, and the interview reflects that expectation.

Twitter (X) Data Analyst Role

Whether it's the For You algorithm's reply ranking, X Premium subscriber churn by cohort, or a brand-safety score that determines ad spend, you're the one telling product and engineering teams if it's working. Success after year one means PMs come to you before writing a spec, not after. You've shipped an experiment readout that changed a launch decision and built dashboards stable enough that leadership trusts the numbers without a Monday morning sanity check.

A Typical Week

The surprise isn't what fills your calendar; it's what doesn't. You'd expect a data analyst role to be mostly heads-down querying, but the real time sink is translating messy findings into narratives that PMs and engineers can act on before the next priority shift lands. Infrastructure firefighting (chasing undocumented schema changes on the ads impressions extract, filing instrumentation tickets with client teams) also eats into your week because pipeline ownership is thin and upstream tables break without warning.

Projects & Impact Areas

X Premium retention cohorts, creator monetization dashboards, and the For You algorithm's engagement signals all compete for your attention in any given sprint. The monetization work is where you'll build metric frameworks closest to scratch, since some of these product surfaces are still half-built and nobody has defined "success" yet. Content safety analytics runs parallel to all of it, quietly shaping whether advertisers stay by measuring how policy changes affect reply quality and brand-safety scores.

Skills & What's Expected

The ability to propose a metric framework cold, for a feature you learned about ten minutes ago, is what separates hires from rejections. SQL depth (window functions over billions of rows in BigQuery, self-joins on event-log tables) is a baseline expectation at every level from L3 through L6, not a differentiator. Stats knowledge (power analysis, confidence intervals, causal inference basics) outweighs any ML skill here, and your Tableau dashboards need to be clear enough for a product director to present without edits.

Levels & Career Growth

The bottleneck most candidates describe is L4 to L5. Shipping more dashboards won't get you there. You need a concrete example of an experiment or metric framework you owned that visibly changed a product decision, plus evidence of cross-team influence. At L6, the role looks less like "analyst" and more like "measurement strategist," and depending on org structure, you may report to a Product or Engineering Director rather than a data science manager.

Work Culture

X enforces return-to-office at San Francisco HQ (with Austin and NYC satellites), though most teams operate on an in-office-three-days-per-week cadence with some remote exceptions for tenured ICs. The pace is intense: short planning cycles, priorities that can shift overnight based on leadership direction, and weeks that spike past 50 hours when a major launch lands. You'll get more autonomy and scope faster than at a comparable Big Tech company, but fewer mentors and a thinner safety net when you're wrong.

Twitter (X) Data Analyst Compensation

Equity is the hardest part of an X offer to evaluate, and most candidates don't push hard enough for the details that make it possible. Because X is private, grants may come as stock options rather than RSUs, with vesting schedules that often follow a 4-year cadence and a 1-year cliff. Liquidity depends on tender offers, secondary sales, or a future public listing, so before you sign, get the strike price, latest 409A valuation, option expiration terms, and any existing buyback program in writing. Those specifics vary by offer and change over time, which is exactly why you need them pinned down for yours.

Your strongest negotiation lever is a competing offer that includes liquid equity, because it forces X's recruiting team to close the gap with cash they can guarantee today. That means pushing on base salary and sign-on bonus rather than requesting additional options whose real value you can't yet know. One move candidates overlook: negotiate leveling before you negotiate dollars. If your experience maps to a higher level's scope, locking that in first resets the entire comp band in your favor, and it's a conversation that's easier to win early in the process than after numbers are already on paper.

Twitter (X) Data Analyst Interview Process

The loop runs about four weeks from first recruiter call to offer. SQL correctness gaps top the list of rejection reasons, and for good reason: X's event tables for posts, impressions, and retweet chains demand fluency with window functions, deduplication, and fan-out joins at a scale where small mistakes compound fast. But don't over-index on SQL prep alone. Weak metric definitions and shallow experimentation knowledge knock out nearly as many candidates.

The behavioral round deserves more prep than most people give it. X's interviewers probe specifically for stories about shipping analyses with incomplete data, navigating priority shifts, and pushing back on stakeholders, all reflective of the post-acquisition operating tempo where planning cycles are short and ambiguity is constant. Show up with a quantified example of changing a product or policy decision through data, not just a portfolio of dashboards you maintained.

Twitter (X) Data Analyst Interview Questions

SQL & Data Manipulation

Expect questions that force you to translate messy payments/product prompts into correct SQL under time pressure. You’ll be evaluated on joins, window functions, cohorting, and debugging logic to produce decision-ready tables.

For each listing, compute the trailing 28-day booking revenue, excluding the current day, and return the top 50 listings by that metric for yesterday. Bookings can be refunded, so use net revenue per booking.

AirbnbMediumWindow Functions and Time Windows

Sample Answer

Compute daily net revenue per listing, then sum it over the prior 28 days using a date-based window that excludes the current day. You avoid double counting by aggregating to listing-day before windowing, then filtering to yesterday at the end. Use $[d-28, d-1]$ as the window, not 28 rows, because missing days exist. Net revenue should incorporate refunds at the booking level before the listing-day rollup.

SQLCopy

1WITH booking_net AS (
2  SELECT
3    b.booking_id,
4    b.listing_id,
5    DATE(b.booking_ts) AS booking_day,
6    COALESCE(b.gross_amount_usd, 0) - COALESCE(b.refund_amount_usd, 0) AS net_amount_usd
7  FROM bookings b
8  WHERE b.status IN ('confirmed', 'completed', 'refunded')
9),
10listing_day AS (
11  SELECT
12    listing_id,
13    booking_day,
14    SUM(net_amount_usd) AS net_revenue_usd
15  FROM booking_net
16  GROUP BY 1, 2
17),
18scored AS (
19  SELECT
20    listing_id,
21    booking_day,
22    SUM(net_revenue_usd) OVER (
23      PARTITION BY listing_id
24      ORDER BY booking_day
25      RANGE BETWEEN INTERVAL '28' DAY PRECEDING AND INTERVAL '1' DAY PRECEDING
26    ) AS trailing_28d_net_revenue_excl_today_usd
27  FROM listing_day
28)
29SELECT
30  listing_id,
31  trailing_28d_net_revenue_excl_today_usd
32FROM scored
33WHERE booking_day = CURRENT_DATE - INTERVAL '1' DAY
34ORDER BY trailing_28d_net_revenue_excl_today_usd DESC NULLS LAST
35LIMIT 50;

You need host-level cancellation rate for the last 90 days, where the numerator is guest-initiated cancellations and the denominator is all bookings that reached confirmed status. Hosts can have multiple listings, and booking status changes are tracked in an events table with one row per status transition.

AirbnbHardEvent Log Deduping and Conditional Aggregation

Sample Answer

Unlock the full solution

View detailed answers and practice in our question bank

View Solution

Practice more SQL & Data Manipulation questions

Product Sense & Metrics

The bar here isn’t whether you know a metric name—it’s whether you can structure an analysis plan that maps to decisions. You’ll need to define success, identify leading vs lagging indicators, and anticipate confounders and data limitations.

How would you define and choose a North Star metric for a product?

EasyFundamentals

Sample Answer

A North Star metric is the single metric that best captures the core value your product delivers to users. For Spotify it might be minutes listened per user per week; for an e-commerce site it might be purchase frequency. To choose one: (1) identify what "success" means for users, not just the business, (2) make sure it's measurable and movable by the team, (3) confirm it correlates with long-term business outcomes like retention and revenue. Common mistakes: picking revenue directly (it's a lagging indicator), picking something too narrow (e.g., page views instead of engagement), or choosing a metric the team can't influence.

Outbound delivery speed for the company Logistics improved from 2.3 to 2.1 days, but CS contacts per 1,000 orders increased by 12% in the same period. You have order, shipment scan, and contact reason data, propose a metric framework to diagnose whether the speed win is causing the contact increase.

AmazonMediumMetric Decomposition and Customer Contacts

Sample Answer

You could do cohort decomposition by promised speed buckets or you could do contact rate standardization holding mix constant. Cohort decomposition wins here because it exposes which promise and ship-method segments changed behavior, and whether contacts spike specifically where speed improved. Standardization is faster but can hide operational failure modes like more partial shipments or missed promised windows. You want both eventually, but the cohort view answers causality-adjacent questions with fewer assumptions.

A company reduces the guest service fee by 1 percentage point in 5 countries, and Finance wants a metric tree that separates demand lift from margin impact and host behavior changes. Propose the primary success metric, the decomposition you would show (with formulas), and 2 guardrails that prevent gaming or long-run supply damage.

AirbnbHardMetric Tree and Unit Economics

Sample Answer

Unlock the full solution

View detailed answers and practice in our question bank

View Solution

Practice more Product Sense & Metrics questions

A/B Testing & Experiment Design

What is an A/B test and when would you use one?

EasyFundamentals

Sample Answer

An A/B test is a randomized controlled experiment where you split users into two groups: a control group that sees the current experience and a treatment group that sees a change. You use it when you want to measure the causal impact of a specific change on a metric (e.g., does a new checkout button increase conversion?). The key requirements are: a clear hypothesis, a measurable success metric, enough traffic for statistical power, and the ability to randomly assign users. A/B tests are the gold standard for product decisions because they isolate the effect of your change from other factors.

You run an experiment on the guest cancellation flow and randomize by user_id, but a guest can book multiple trips and see both variants across devices. How do you detect and quantify interference, and what changes to the design or analysis would you make?

AirbnbMediumSUTVA violations and unit of randomization

Sample Answer

Reason through it step by step as if thinking out loud. Start by checking exposure logs, does the same guest_id have multiple variant assignments across sessions or devices, and what share of traffic is affected. Next, quantify bias risk by comparing outcome rates for cross-exposed users versus clean users, and by re-estimating the lift on the clean subset to see how sensitive the result is. Then pick a fix: enforce sticky assignment at the guest_id level with consistent identity stitching, or move randomization to a higher level like booking_id if the treatment is per booking. If you cannot fix assignment, analyze with cluster-robust standard errors at the guest_id level, or switch to a design like switchback only if the interference is time-based rather than user-based.

A company runs 8 simultaneous experiments on the host pricing page, and your experiment shows $p = 0.03$ on booking conversion and $p = 0.20$ on contribution margin. How do you decide whether this is a real win, and what correction or validation would you apply?

AirbnbHardMultiple testing and ambiguous readouts

Sample Answer

Unlock the full solution

View detailed answers and practice in our question bank

View Solution

Practice more A/B Testing & Experiment Design questions

Statistics

Most candidates underestimate how much applied stats shows up in fraud analytics, from thresholding to false-positive tradeoffs. You’ll need to reason clearly about distributions, sampling bias, and how to validate signals with limited labels.

What is a confidence interval and how do you interpret one?

EasyFundamentals

Sample Answer

A 95% confidence interval is a range of values that, if you repeated the experiment many times, would contain the true population parameter 95% of the time. For example, if a survey gives a mean satisfaction score of 7.2 with a 95% CI of [6.8, 7.6], it means you're reasonably confident the true mean lies between 6.8 and 7.6. A common mistake is saying "there's a 95% probability the true value is in this interval" — the true value is fixed, it's the interval that varies across samples. Wider intervals indicate more uncertainty (small sample, high variance); narrower intervals indicate more precision.

A company Logistics changed a routing rule and late deliveries dropped from $2.4\%$ to $2.1\%$ over 14 days, but shipment volume also increased and the mix shifted toward longer-distance lanes. How do you estimate whether the routing change reduced late deliveries, and which statistical model or adjustment would you use?

AmazonMediumConfounding and Adjusted Comparisons

Sample Answer

Walk through the logic step by step as if thinking out loud. Start by defining the outcome as a binary label per shipment (late or not) and list the main confounders, lane distance, carrier, promised speed, weather, day-of-week, and volume. Then fit a logistic regression with a treatment indicator for the routing rule change plus those covariates (and ideally lane fixed effects) so you compare like with like. Validate by checking pre-change trends by lane, then report an adjusted lift with a CI, not just the raw $2.4\%$ to $2.1\%$ delta.

An AWS Console UI experiment shows a $+1.2\%$ lift in weekly active users, but the metric has heavy-tailed session counts and the variance doubled during the test. How do you decide whether to ship, and what statistical technique would you use to make the result decision-ready?

AmazonHardVariance, Heavy Tails, and Robust Inference

Sample Answer

Unlock the full solution

View detailed answers and practice in our question bank

View Solution

Practice more Statistics questions

Data Modeling

When you design tables for analytics, you’re being tested on grain, keys, and how modeling choices impact BI performance and correctness. Expect star schema reasoning, fact/dimension tradeoffs, and how you’d model common product/usage datasets.

An ETL job builds fct_support_interactions from Zendesk tickets, chat transcripts, and on-chain deposit events, and you notice a sudden 12% drop in interactions after a schema change in chat. What data quality checks and pipeline safeguards do you add so this does not silently ship to dashboards again?

CoinbaseMediumETL Monitoring, Data Quality

Sample Answer

Get this wrong in production and your CX dashboards underreport demand, staffing and SLA decisions get made on fake stability. The right call is to add volume and freshness checks (row count deltas by source, max event timestamp lag), completeness checks on required keys (ticket_id, interaction_id, user_id), and distribution checks on critical dimensions (channel, product surface). Gate the publish step with alerting and fail-closed thresholds, plus backfill logic and schema versioning so a renamed field cannot null out a join unnoticed.

A company wants a single "gross bookings" metric used by Finance and Product, but your model has cancellations, modifications, partial refunds, and multiple payment captures per reservation. How do you model facts and keys so that gross bookings, net bookings, and revenue can be computed without double counting across these flows?

AirbnbHardFact Modeling, Double Counting, Payments and Reservations

Sample Answer

Unlock the full solution

View detailed answers and practice in our question bank

View Solution

Practice more Data Modeling questions

Visualization

When dashboards become the source of truth, small choices in charting and narrative can change decisions. You’ll be tested on picking the right visual, communicating insights to non-technical stakeholders, and proposing actionable next steps.

A Tableau dashboard for the company Retail shows conversion rate by store, but the VP wants stores ranked and "actionable" by tomorrow. What is your default chart and sorting approach, and what adjustment do you make to avoid overreacting to small-sample stores?

AppleMediumRanking, Variability, and Visualization Choice

Sample Answer

The standard move is a ranked bar chart of conversion with a reference line for the fleet median, plus a small table for traffic and transactions. But here, sample size matters because $n$ varies wildly by store, so the ranking is mostly noise for low-traffic locations. You either filter to a minimum volume threshold or plot a funnel chart (conversion versus sessions) with confidence bands, then call out only statistically stable outliers for action.

You ship an exec dashboard for iOS crash rate by build, but a new build rollout causes an apparent crash-rate jump. How do you redesign the dashboard so leadership can tell whether the build is worse versus the user mix changing due to staged rollout?

AppleHardCohorting, Segmentation, and Narrative Design

Sample Answer

Unlock the full solution

View detailed answers and practice in our question bank

View Solution

Practice more Visualization questions

Data Pipelines & Engineering

In practice, you’ll be asked how you keep reporting accurate when pipelines break or definitions drift. Strong answers cover validation checks, anomaly detection, backfills, idempotency, and communicating data incidents to stakeholders.

What is the difference between a batch pipeline and a streaming pipeline, and when would you choose each?

EasyFundamentals

Sample Answer

Batch pipelines process data in scheduled chunks (e.g., hourly, daily ETL jobs). Streaming pipelines process data continuously as it arrives (e.g., Kafka + Flink). Choose batch when: latency tolerance is hours or days (daily reports, model retraining), data volumes are large but infrequent, and simplicity matters. Choose streaming when you need real-time or near-real-time results (fraud detection, live dashboards, recommendation updates). Most companies use both: streaming for time-sensitive operations and batch for heavy analytical workloads, model training, and historical backfills.

You need a trustworthy daily metric for App Store subscriptions that powers Finance reporting and product dashboards, and events can arrive up to 72 hours late. How do you design the warehouse tables and the incremental rebuild logic so the metric is both stable and correct?

AppleMediumLate Arriving Data and Incremental Loads

Sample Answer

Start with what the interviewer is really testing: "This question is checking whether you can keep a metric stable for stakeholders while still correcting for late data." You typically separate an immutable raw events layer from a curated fact layer keyed by a stable business grain (for example, subscription, day, storefront), and define a rolling recompute window of the last $N$ days where $N \ge 3$ to absorb late arrivals. You also need a clear definition of when the metric is final (for example, a watermark), plus audit columns like load_timestamp and source_max_event_time so you can explain changes and meet SLAs.

An Airflow DAG builds a daily fact table for payouts to hosts, partitioned by payout_date, and finance reports missing payouts for a two week window after a backfill. How do you design the backfill and data quality safeguards so you avoid double counting, preserve idempotency, and keep downstream Superset dashboards stable?

AirbnbHardBackfills, Idempotency, and Data Quality Gates

Sample Answer

Unlock the full solution

View detailed answers and practice in our question bank

View Solution

Practice more Data Pipelines & Engineering questions

Causal Inference

What is the difference between correlation and causation, and how do you establish causation?

EasyFundamentals

Sample Answer

Correlation means two variables move together; causation means one actually causes the other. Ice cream sales and drowning rates are correlated (both rise in summer) but one doesn't cause the other — temperature is the confounder. To establish causation: (1) run a randomized experiment (A/B test) which eliminates confounders by design, (2) when experiments aren't possible, use quasi-experimental methods like difference-in-differences, regression discontinuity, or instrumental variables, each of which relies on specific assumptions to approximate random assignment. The key question is always: what else could explain this relationship besides a direct causal effect?

Hulu ad load was reduced for a subset of DMAs, but advertisers also shifted budgets toward those same DMAs mid-flight due to a sports schedule. You need the causal effect of ad load reduction on ad revenue per hour, do you use a geo-based diff-in-diff or an instrumental variables approach, and why?

DisneyMediumGeo Experiments and Instrumental Variables

Sample Answer

You could do geo diff-in-diff or instrumental variables (IV). Geo diff-in-diff is simpler, but it loses credibility here because budget reallocation creates time-varying confounding correlated with treatment assignment. IV wins if you have a plausibly exogenous instrument for ad load, for example a policy or capacity constraint that shifts ad load but does not directly shift demand, then you estimate $\text{AdLoad}\rightarrow\text{RevenuePerHour}$ via 2SLS and defend exclusion and relevance.

A company runs a retargeting campaign for the company+ lapsed subscribers, but exposure is highly selective because it targets users with high predicted return probability. How do you design a quasi-experiment to estimate incremental resubscription lift, and what diagnostics convince you the estimate is not driven by selection bias?

DisneyHardSelection Bias and Quasi-Experimental Design

Sample Answer

Unlock the full solution

View detailed answers and practice in our question bank

View Solution

Practice more Causal Inference questions

Product sense and experimentation questions feed off each other in ways that punish siloed prep. Defining success metrics for something like X Spaces is already tricky, but the real compounding difficulty hits when you then have to design an experiment around those metrics while accounting for network effects and spillover across the timeline. Most candidates over-invest in SQL drills (comfortable, measurable progress) while neglecting the product metrics work that carries more weight and can't be crammed from a syntax cheat sheet.

Sharpen your product metrics thinking with questions modeled on real X features (timeline ranking, Communities, creator monetization) at datainterview.com/questions.

How to Prepare for Twitter (X) Data Analyst Interviews

X is chasing the "everything app" vision, bolting payments, video, and Grok AI onto a social graph that still generates roughly $2.5 billion in annual revenue (down about 14% year-over-year). For data analysts, that tension between a maturing ad business and brand-new product surfaces is the job. You'll spend mornings debugging why ad engagement dipped on the algorithmic timeline and afternoons trying to define what "success" even means for a payments feature with two months of data.

The "why X?" answer that works isn't about the mission statement. Candidates who reference the real-time event-log infrastructure and explain which measurement problem on, say, X Spaces or creator monetization they'd want to tackle stand out. Contrast that with vague enthusiasm about "the public square," which tells the interviewer nothing about how you think analytically.

Try a Real Interview Question

1WITH base AS (
2  SELECT
3    a.market,
4    a.variant,
5    s.session_id,
6    CAST(s.did_book AS DOUBLE) AS did_book
7  FROM experiment_assignments a
8  JOIN sessions s
9    ON s.user_id = a.user_id
10   AND s.session_start >= a.assigned_at
11   AND s.session_start < a.assigned_at + INTERVAL '7' DAY
12  WHERE a.experiment_name = 'search_ranker_v2'
13), agg AS (
14  SELECT
15    market,
16    variant,
17    AVG(did_book) AS conversion_rate
18  FROM base
19  GROUP BY 1, 2
20)
21SELECT
22  market,
23  MAX(CASE WHEN variant = 'control' THEN conversion_rate END) AS conv_control,
24  MAX(CASE WHEN variant = 'treatment' THEN conversion_rate END) AS conv_treatment,
25  (MAX(CASE WHEN variant = 'treatment' THEN conversion_rate END)
26   - MAX(CASE WHEN variant = 'control' THEN conversion_rate END)) AS lift
27FROM agg
28GROUP BY 1
29ORDER BY 1;

From what candidates report, X's SQL rounds lean heavily on event-log tables where you model entities like tweets, quote tweets, and impressions, then query your own schema under time pressure. Sessionization and funnel-style problems with null handling and retweet deduplication show up often enough to be worth drilling. Practice similar multi-step problems at datainterview.com/coding.

Test Your Readiness

Run through X-specific product metrics and experimentation scenarios (think: measuring algorithmic timeline changes, or designing an A/B test with network spillover) at datainterview.com/questions.