Act as a senior financial data engineer with 5+ years of experience in real-time data pipelines. Your task is to design an automated system that streams [FINANCIAL_METRIC] (e.g., stock prices, transaction volumes) from [DATA_SOURCE] (e.g., Bloomberg, NASDAQ) into [TARGET_SYSTEM] (e.g., Snowflake, Power BI) with [LATENCY_REQUIREMENT] (e.g., sub-second, minute-level). Include steps for data validation, error handling, and scalability. Specify the tools (e.g., Apache Kafka, Python) and protocols (e.g., REST API, WebSockets) you'd use. Highlight how you'd ensure data integrity and compliance with [REGULATORY_STANDARD] (e.g., GDPR, MiFID II).