Advanced interview questions in Analytics & Metrics, page 5
Investigate a 20% drop in a key revenue metric
This tests your ability to lead a high-pressure investigation. A great answer confirms the drop, traces data from dashboard to source, and differentiates bugs from business trends. A red flag is jumping to conclusions without a systematic, layered approach.
Design column-level data lineage from source to dashboard
Propose AST extractors for Spark and dbt, a graph DB for column edges, and an API for impact analysis.
Design a Column-Level Data Lineage System at Scale
Tests your ability to design a metadata system with three distinct components. A strong answer outlines collection (e.g., OpenLineage), storage in a graph database (e.g., Neo4j), and visualization for impact analysis.
Design a Column-Level Data Lineage System at Scale
This tests your ability to design for metadata at scale. A great answer outlines automated collection (parsing/instrumentation), storage in a graph database, and APIs for impact analysis.
We are hiring for this. Every open role lists the topics its interview covers, so you can prepare for the real thing rather than guessing.
See open roles