Freelancer profile translated to English.
Back to original languageAbout Marouane
Data Engineer with over 14 years of experience in developing and implementing advanced analytical solutions on cloud platforms. Specializing in transforming data into actionable insights, I help companies maximize the value of their data through scalable and high-performance solutions. Expertise in using DBT and Dataform for data transformation, as well as in leveraging Google Cloud Platform (GCP), SQL, and BigQuery to design robust and automated data pipelines.
French
Native or bilingual
English
Fluent
Can work on-site
Rabat (up to 50km)
Experience
- SERVIERAgile Analytics EngineerJanuary 2023 - Today (3 years and 5 months)Paris, FranceImproving data management and processing in pharmaceutical research, specifically in the in-vitro phase. Focused on optimizing data from Screener and various external partners to accelerate research.Technical ResponsibilitiesDesign and optimization of data pipelines to ensure smooth and efficient integration of data required by researchers. Evaluation and improvement of existing data infrastructures.AchievementsDeployment of ETL workflows on **Argo workflow**.Implementation of biomedical data analysis rules in **python, sql, and dbt**.Monitoring of data usage and consistency via **Looker**, with the creation of dynamic dashboards to ensure data integrity.Data exposure via **FastAPI**.Technical EnvironmentGoogle Cloud Platform (GCP), BigQuery, Dbt, Looker, FastAPI, Google Kubernetes Engine (GKE), Argo Workflows, Python, GitLab, Terraform, Docker
- FRED JewelryAgile Data EngineerLUXURY GOODSNovember 2021 - December 2022 (1 year and 1 month)Paris, FranceInvolved in the migration project of an on-premise database to the GCP cloud to ensure data quality and calculation speed. Also involved in setting up a Data Warehouse that meets business requirements and centralizes relevant data to feed datamarts.AchievementsImplementation of IaC using Terraform modulesCreation of data cleaning and loading tasks in **BigQuery**.Orchestration of data integration from GCS to BigQuery via IA Platform and Cloud FunctionImplementation of various scripts to populate the DWH and Datamart using **Dataform**.Management and monitoring of processes (alerts in case of errors)Technical EnvironmentGoogle Cloud Platform, BigQuery, Dataform, Python, GCS, Shell scripting, Cloud build, Docker, IA Platform, Cloud Function
- The Estée Lauder Companies Inc.Data Architect & Data EngineerLUXURY GOODSJune 2021 - December 2022 (1 year and 6 months)Paris, FranceLed an audit of the existing data platform, proposed recommendations and an improvement roadmap, and mentored data engineers in the use of the data platform.AchievementsEnsured the RUN Migration of the existing solution from Python 2 to Python 3. Implemented Cloud Scheduler and Cloud Workflows to facilitate pipeline execution. Migrated the solution from Python to Bigquery.Technical EnvironmentGCP, Workflows, Compute Engine, BigQuery, Data studio, GA360, Google Ads, Facebook Ads
Recommendations
Be the first to recommend Marouane
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Engineering Degree, specialization in Information Technology Methods Applied to Business ManagementEMSI2012
Certifications
- Dbt Analytics EngineeringDbt Labs2024
- Google Cloud Certified - Professional Data EngineerGoogle Cloud2021