Data CloudArchitect (Hardest)multi-currencyharmonizationglobal
Architect multi-currency harmonization for global unified profiles
Real World Scenario
Retail group ingests orders in 14 currencies; segments on spend thresholds produce wrong cohorts when amounts not normalized.
Expected Answer
• Standardize to corporate reporting currency in harmonized layer with FX rate source documented
• Store original currency and amount for audit
• FX rate refresh cadence aligned to finance not ad hoc
• Calculated insights use normalized amounts only
• Regional segments may use local currency with explicit rule documentation
• Handle null FX rate dates with holdout not guess
• Test segment boundaries after FX methodology change
Follow-Up Questions & Answers
Click to expand — each follow-up includes a direct, interview-ready answer
Main difference: use case and scale. Standardize to corporate reporting currency in harmonized layer with FX rate source documented. Store original currency and amount for audit. Pick based on your integration pattern and team capability. Currency harmonization is finance architecture — involve FP&A before marketing segments on dollar thresholds. Document the decision in an ADR and align with enterprise standards.
Architect Perspective
Currency harmonization is finance architecture — involve FP&A before marketing segments on dollar thresholds.