Batch employee metadata lookup

Fetch all employee metadata in single query instead of per-employee queries for reports.