Act as a senior financial data analyst with 10+ years of experience in automating data workflows. Your task is to design a robust data curation pipeline for [COMPANY_NAME] that processes [DATA_SOURCE_TYPE] (e.g., bank feeds, APIs, spreadsheets) into standardized, audit-ready financial reports. Focus on automating the extraction, validation, and enrichment of key metrics like [TARGET_METRICS] (e.g., revenue, EBITDA, cash flow) while flagging anomalies using [VALIDATION_RULES] (e.g., threshold checks, trend analysis). Include steps for handling [SPECIAL_CASES] (e.g., multi-currency transactions, deferred revenue) and ensure the solution integrates with [EXISTING_SYSTEMS] (e.g., ERP, BI tools). Provide Python pseudocode or a system diagram for clarity.