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 daily.
Define the checkout metrics to watch and use funnel diagnosis to find where conversion is leaking.
Macy'sDiagnose why conversion fell from 4.8% to 3.1% after a launch by breaking the metric across funnel steps, cohorts, and segments.
Macy'sTests KPI selection and ability to connect metrics to funnel and revenue drivers.
Macy'sExplain SQL window functions and when to use ROW_NUMBER() versus DENSE_RANK() for ranked ticket analysis.
Macy'sExplain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.
Macy'sAssesses your hands-on SQL experience and ability to work with data in practice.
Macy'sFind duplicate American Institutes for Research assessment submissions using a CTE, GROUP BY, HAVING, and joins.
American Institutes for Research
Publix Super MarketsMacy'sCompute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.
Gain Digital
TCS
Zest AIMerge CRM orders with GA events via an identity map to build a customer-level view using joins, window functions, and monthly rollups.
ArtefactSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests prioritization and judgment in choosing when to rely on data versus expert input.
Macy'sTests segmentation thinking and stakeholder-specific framing of analysis.
Macy's