Meta's People Analytics team supports compensation planning across Engineering, Product, Sales, and G&A. After the latest annual compensation cycle, HR leadership noticed that total compensation per employee rose faster than headcount and wants a reporting framework that explains the movement and flags emerging risks.
In the last 12 months, global headcount increased from 72,000 to 78,000 (+8.3%), while total annualized compensation expense increased from $15.1B to $17.4B (+15.2%). Average annualized compensation per employee rose from $209.7K to $223.1K (+6.4%). The CFO is asking whether the increase is driven primarily by merit increases, promotions, hiring mix, geography mix, stock refreshers, or retention actions. The VP of People also wants recurring reporting that can identify unusual compensation trends by org before the next planning cycle.
employee_snapshot_monthly: employee_id, month, org, job_family, level, manager_flag, country, office, hire_date, termination_date, employment_typecompensation_history: employee_id, effective_date, base_salary, annual_bonus_target, equity_grant_value, sign_on_bonus, retention_bonus, currencypromotion_events: employee_id, event_date, old_level, new_level, orgoffer_acceptance: candidate_id, accepted_date, org, level, country, offered_base, offered_equity, offered_bonusperformance_ratings: employee_id, review_cycle, rating, org, levelbudget_plan: org, quarter, planned_headcount, planned_comp_expense