Macy's Data Analyst Interview Questions

The questions to prepare for a Macy's Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

Window Ranking in Ticket Queues

Medium

Explain SQL window functions and when to use ROW_NUMBER() versus DENSE_RANK() for ranked ticket analysis.

Window FunctionsRankingrow_number

Macy's

Troubleshooting Missing Rows with Joins

Easy

Explain how INNER JOIN and LEFT JOIN affect missing records and when to use each while debugging data mismatches.

SubqueriesJoinsData Wrangling

Macy's

More SQL & Data Manipulation questions with a free account

Diagnose Conversion Drop Post Launch

Medium

Diagnose why conversion fell from 4.8% to 3.1% after a launch by breaking the metric across funnel steps, cohorts, and segments.

Funnel AnalysisConversion RateDiagnosis

Macy's

Define KPIs for E-Commerce

Easy

Tests KPI selection and ability to connect metrics to funnel and revenue drivers.

Funnel AnalysisKPIsConversion Rate

Macy's

More Metrics questions with a free account

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

Tailor Analysis by Stakeholder Segments

Medium

Tests segmentation thinking and stakeholder-specific framing of analysis.

User SegmentsUser NeedsValue Proposition

Macy's

Data vs Stakeholder Judgment

Medium

Tests prioritization and judgment in choosing when to rely on data versus expert input.

User NeedsValue PropositionUse Cases

Macy's

Open any question for its full solution and discussion.