Expense Aggregate Nightly Scheduler

Scheduled background job that runs nightly to materialize expense aggregate metrics and statistical baseline values into the expense_summary_snapshots table. Reduces dashboard query latency by replacing ad-hoc aggregation over large claim datasets with simple snapshot reads supplemented by a same-day real-time delta.

Feature: Reimbursement Overview

expense-aggregate-scheduler

• Run nightly SQL aggregation over expense_claims and expense_items grouped by organization_id and time period
• Upsert computed aggregate rows into the expense_summary_snapshots materialized table
• Compute and persist rolling average and standard deviation baselines per organization for the anomaly detection layer
• Log execution status and surface failures via existing monitoring infrastructure