LinkedIn Analytics Engineer interview questions

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