Round 1 – SQL (Shared Doc Format)
Given schema:
- fact_impressions(event_date, account, media_type, impressions, revenue)
- dim_account_mappings(account, client, region, industry, sales_team)
- dim_dates(event_date, fiscal_quarter, fiscal_year)
Questions:
1. Number of clients supported by multiple sales teams
2. For each client, the percentage of revenue from display advertising
3. For each fiscal quarter, total revenue by industry and percent contribution per industry
4. For each client, the sales team that generated the most revenue
Rounds 2–4 – Behavioral
Focused on stakeholder management:
- TMAY
- Relevant experience
- Handling conflicting priorities
- Communicating with non-technical teams
- What to do if a stakeholder disagrees with your solution
