Coinbase Analytics Engineer Interview Questions
The questions to prepare for a Coinbase Analytics Engineer interview. Questions from real interview reports rank first. Updated weekly.
Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.
CoinbaseExplain how FULL OUTER JOIN and LEFT JOIN differ when reconciling customer records across systems.
CoinbaseExplain how to diagnose and optimize a slow PostgreSQL query on large Apidel Technologies datasets.
CoinbaseCompare star and snowflake schemas for warehouse design, including trade-offs in normalization, query simplicity, and analytics performance.
CoinbaseAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreCompute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.
Gain Digital
TCS
Zest AITests prioritization under pressure across stakeholders, with emphasis on trade-off judgment, influence, and clear communication.
CoinbaseTests whether you can translate complex trends or data quality issues into clear business language and drive stakeholder alignment.
CoinbaseA structured approach to debugging production data pipelines, with focus on orchestration, data quality, idempotency, and safe backfills.
CoinbaseApproach for handling missing data in an ML data pipeline, including validation, imputation, and safe downstream consumption.
CoinbaseSign up to see every question
Create a free account to unlock this list and practice real interview questions.