Sanofi Commercial Enterprise Data Lake

Sanofi needed to replace an Excel-based market data workflow with a modern, enterprise-grade data platform to support commercial decision-making. The new foundation had to: Centralize and standardize market and commercial data Provide reliable, easy access to data for senior leadership Enforce strict data governance, monitoring, and quality controls Guarantee timely and complete data delivery for financial and commercial use cases The existing spreadsheet-driven approach could not scale and lacked reliability and governance

OrbitaLab designed and supported the implementation of a commercial enterprise data lake using the organization’s approved technology stack: Cloud-native data lake architecture on AWS with Snowflake as the analytical layer ETL pipelines implemented using Informatica and Python Infrastructure provisioned and managed with Terraform Custom Python-based framework to configure pipelines, data validations, and delivery guarantees using Excel-based configurations Orchestration of data workflows with Airflow Data consumption enabled via Power BI for leadership and business users