Design metrics resilient to data quality
OtherData Scientist · Technical ScreenLast updated
This question evaluates the ability to design robust data-quality metrics and apply SQL window-function techniques for deduplication and time-windowed completeness calculations, focusing on quantifying how ingestion delays, duplicates, and negative amounts can bias payment metrics.
Overview: This question evaluates the ability to design robust data-quality metrics and apply SQL window-function techniques for deduplication and time-windowed completeness calculations, focusing on quantifying how ingestion delays, duplicates, and negative amounts can bias payment metrics. Read the full Data Scientist interview experience this question came from
Solution walkthrough is for members
Get the full walkthrough with reference code and complexity analysis, plus Kitty Coach at 300 messages a day. Hints, the code runner and community answers stay free.