21 practice questions for HubSpot Data Analyst interviews
HubSpot data analyst interviews focus on SQL, data visualisation, business metrics, statistical analysis, and translating data insights into actionable recommendations.
Question Your task is to implement a simple in-memory cloud storage system that maps objects (files) to their metadata (name, size, etc.). You...
Input: Graph (nodes and edges) Output: Array
codingHardVerified Question#2
2. OA[CodeSignal] Design Banking System
Category: Graph coding problem
Question Design a banking system that supports account management, transactions, and various financial operations.
Input: Graph (nodes and edges) Output: Computed result
codingHardVerified Question#3
3. OA[CodeSignal] In-Memory Database
Category: Graph coding problem
Description Implement a simplified in-memory database that supports record manipulation with various operations. The system should handle basic...
Input: Graph (nodes and edges) Output: Array
codingMediumVerified Question#4
4. Service Log Aggregator
Category: Trie-based coding problemA distributed system emits log entries from multiple services and worker threads. Each log entry is a colon-separated string in the format...Input: Array Output: Computed result
codingEasyVerified Question#5
5. Top Recurring Substring
Category: Graph coding problemA search analytics service needs to find which fixed-length pattern occurs most often in a block of text. Given a lowercase string s and a positive...Input: Graph (nodes and edges) Output: Computed result
codingMediumVerified Question#6
6. Arithmetic Expression Tree
Category: Binary tree coding problemYou are given a mathematical expression encoded as a binary tree in JSON format. Evaluate the expression and return its integer result. Each node in...Input: Binary tree Output: Computed result
codingHardVerified Question#7
7. Event Participant Role Validator
Category: Trie-based coding problem
Question A conference platform manages associations between events, attendees, and their roles. Each association is represented by three strings:...
Input: List Output: Array
codingMediumVerified Question#8
8. Team Standup Scheduler
Category: Algorithm coding problem
Question A remote-work platform needs to schedule weekly standups for distributed teams. Each team member provides a list of dates (formatted as...
Input: List Output: Array
codingHardVerified Question#9
9. Peak Stream Viewer Tracker
Category: String coding problem
Question A streaming analytics platform needs to track peak viewership for each user on each day. You are given a list of Session records. Each...
Input: List Output: Computed result
codingEasyVerified Question#10
10. Top Frequency Substring
Category: Graph coding problemGiven a string text containing only lowercase English letters and a positive integer k, find the substring of length k that appears most...Input: Graph (nodes and edges) Output: Computed result
codingMediumVerified Question#11
11. [CodeSignal] Contact Role Capacity Validator
Category: String coding problemA platform tracks permission assignments between departments, employees, and their access levels. Each assignment is represented by three strings:...Input: List Output: Array
codingMediumVerified Question#12
12. [CodeSignal] Country Meeting Date Finder
Category: Algorithm coding problemA global organization is scheduling regional check-ins for its distributed teams. Each team member belongs to a region and provides a list of...Input: List Output: Array
codingMediumVerified Question#13
13. [CodeSignal] Customer Peak Call Tracker
Category: String coding problemA billing platform tracks user sessions for resource usage metering. Each session record contains: - userId: an integer identifying the user. -...Input: List Output: Computed result
codingMediumVerified Question#14
14. Expression Tree Calculator
Category: Tree coding problemGiven a mathematical formula represented as a JSON object, compute its result. The formula is encoded as a recursive expression tree with two node...Input: Integer(s) Output: Computed result