Project information
Automated platform promoting faster and better-informed decisions.
- Data engineering
- The Creative Club
- March 13, 2024
- Paris, France
The Creative Club – Marketing & ERP Data Integration
The Creative Club was facing a dispersion of its data across several marketing platforms and an internal ERP, complicating analysis and slowing down decision-making. The project aimed to create a unified, secure and scalable data platform, facilitating the collection, transformation and exploitation of strategic data.
This solution enabled the company to streamline its processes, obtain reliable insights and improve decision-making speed.
Project challenges
Ensure the consistency and performance of integrated data.
- Manage the heterogeneity of data sources.
- Ensure the reliability and scalability of pipelines.
- Automate deployments for smooth monitoring.
- Optimise analytical performance in the cloud.
Solutions implemented
Unified cloud architecture for integration and analysis.
- Multi-source data ingestion (S3, Salesforce, SharePoint, Facebook Ads, ERP).
- ELT pipelines built on Redshift, then migrated to Snowflake.
- Orchestration with Dagster and ingestion via Airbyte.
- Automated deployment on EKS with GitHub Actions (CI/CD).
Français