Role Specific Job Understanding Questions
Covers familiarity with specific job families and titles and the typical responsibilities and challenges associated with them. Examples include customer success, project management, account management, business intelligence, operations, sales operations, and executive roles such as vice president positions. Candidates should show domain knowledge about daily tasks, common tools, stakeholder interactions, and specific outcomes expected in those named roles, and ask role specific questions about scope and priorities.
HardTechnical
0 practiced
Given an event table where payload is JSON (events(event_id, user_id, occurred_at timestamp, payload jsonb)), write a PostgreSQL query that extracts a nested property (payload->>'page') and computes session-level metrics per user: session_id (30-minute inactivity), session_start, session_end, events_per_session. Assume event ordering by occurred_at.
EasyTechnical
0 practiced
Write an ANSI SQL query to return the top 5 customers by revenue for the last calendar month, excluding refunded orders. Given table schema:orders(order_id PK, customer_id, amount numeric, currency varchar, order_timestamp timestamp, status varchar)Assume status='refunded' marks refunded orders. Include currency handling note if multi-currency conversion is required.
MediumTechnical
0 practiced
You're evaluating a two-week pilot feature. Define primary and secondary KPIs to measure success, describe how to establish baseline metrics, outline sample-size and power considerations, identify early warning signs that should trigger rollback, and recommend clear go/no-go success criteria.
MediumTechnical
0 practiced
Design an end-to-end weekly automated ETL pipeline that ingests daily CSV sales files from regional teams into a central data warehouse for reporting. Describe ingestion mechanism, schema design, incremental load strategy, error handling, monitoring and alerting, testing approach, and cost considerations.
HardSystem Design
0 practiced
Design an analytics operating model for a 500-employee company with 10 product teams. Propose a structure (centralized, federated, or hybrid), define key analytics roles and responsibilities, describe request workflows and SLAs, outline metric governance, and propose success metrics to measure the analytics team's impact.
Unlock Full Question Bank
Get access to hundreds of Role Specific Job Understanding interview questions and detailed answers.
Sign in to ContinueJoin thousands of developers preparing for their dream job.