Recruitment Analytics Service

Backend service exposing a paginated REST endpoint that aggregates referral data from the referrals table. Executes a single JOIN query (referrals + users) grouped by referrer_user_id and filtered by the requesting coordinator's organization membership to enforce tenant isolation. Returns recruiter summaries sorted by total redemptions descending.

Feature: Recruitment Tracking

recruitment-analytics-service

• Aggregate referrals by referrer with sent and redeemed counts per peer mentor
• Enforce organization scoping by joining referrals to organization_memberships of the requesting user
• Support parameterized date-range filtering via query parameters
• Return paginated recruiter summaries with display names to avoid N+1 queries
• Expose near-real-time data by reading committed rows without caching delays