Monthly obligation fulfillment pipeline

You are the system analyst in the Contract Operations team of a SaaS contract-management platform serving midsize enterprises. The product owner asked for a daily pipeline that builds the "Obligations Due Next 30 Days" report, refreshed at 02:00 UTC and must capture any contract signed after midnight so the obligations count for the prior day. She said, "The report must be ready by 09:00 for the compliance dashboard."

📎 Late-data window: 2 hours after midnight; if a signature arrives after 01:00, recompute the previous day's snapshot.

Your task
1. Create a source-to-target mapping table for the report columns.
2. Define refresh schedule, late-data handling and recompute rules.
3. List data-quality checks to run before publishing the report.

LegalTech / contract management · Reporting / data pipeline spec
#sa #junior #reporting #etl #legal_tech