Context
Group reporting needs a consistent model across local entities without ignoring country-level access boundaries or the currency conversions behind consolidated figures.
Delivery
The system combines PySpark, dbt, Delta Lake, Power BI, and Kyriba exchange rates. Transformations establish shared finance models, while country-level row security controls which data each audience can access.
Engineering decisions
- Centralize exchange-rate handling through controlled Kyriba inputs.
- Use shared transformation models for consistent group reporting.
- Apply row-level security at country level.
- Keep reporting semantics aligned with the governed data foundation.
Outcome
The resulting analytics foundation supports consistent reporting across 18 countries and 12 currencies while preserving country-level access controls.