About Othmane
French
Native or bilingual
English
Fluent
Spanish
Fluent
Experience
- EDFData Engineer and ManagerNovember 2025 - Today (9 months)• - Gathering business needs through workshops and stakeholder discussions• - Writing detailed technical and functional specifications• - Data modeling (star and snowflake schemas) for optimizing analytical uses• - Defining and implementing data lakehouse architectures (Bronze / Silver / Gold)• - Designing Gold data models adapted to BI and reporting needs• - Participating in architecture and data technology choices based on use cases• - Implementing best practices for data management: historization, versioning, S3 storage, backup strategyDeveloping and maintaining data pipelines:• - Ingestion to S3• - Transformation via Python / Spark / SQL• - Workflow orchestration with Airflow• - Data exploitation and processing via Spark, Trino, and Jupyter notebooks• - Integration of data from heterogeneous systems (PostgreSQL, Oracle, APIs)IoT & API Data• - Defining and implementing IoT data recovery plans• - Integration of data from EDF sensors via API (Cumulocity)• - Managing large-volume and real-time data streamsData Visualization & Reporting• - Creating reports and dashboards with Power BI• - Structuring data for BI exploitation (PostgreSQL / Oracle)• - Translating business rules into technical logic (and vice versa)Tech: GIT, AIRFLOW, SPARK, PYTHON, SQL, ORACLE, POSTREG, TRINO, ICEBERG
- NATIXISData EngineerMay 2023 - October 2025 (2 years and 5 months)Project: LCLF Team – Fraud Detection (European context, SAFE Agile)• Active participation in several projects within an agile team (SAFe) in an international context (English communications).• Cross-border payments project for the European Commission in preparation for the 2024 Olympics:• Implementation of a new end-to-end pipeline on BigQuery to aggregate data from various existing GCP tables within the BPCE group. - Transformation and quality control of data (SQL, Python).• Generation of normalized XML and CSV files for transmission to authorities.• Orchestration and monitoring of pipelines with Airflow (automatic reprocessing in case of failure).• Data security & governance: implementation of automated GCP permission management with Terraform, management of roles and sensitive access.• Optimization of ingestion pipelines: reduction of processing times by 30% through BigQuery partitioning, clustering, and SQL refactoring.• Implementation of operational reporting: exposure of data on Power BI to enable business teams to analyze fraud indicators.• Continuous improvement: contribution to the standardization of Terraform templates, improvement of CI/CD best practices (GitLab/Jenkins).• Support and maintenance: monitoring of production projects, bug fixing, and integration of new data sources.• Transverse context: regular interaction with other data teams within the group (Finance, Risk, Compliance) to align pipelines and avoid duplication.Tech: GCP (BigQuery, Pub/Sub, Dataproc, Airflow), Jenkins, Python, SQL, Terraform, Git, Power BIMethodology: Agile SAFE (PI Planning, daily stand-up, sprint reviews)
- L'OREALData EngineerJune 2022 - May 2023 (11 months)Active participation in several projects within an agile team in an international context (coordination with EMEA and Global teams) Luxury:• - Design and implementation of automated ELT pipelines with dbt, feeding BigQuery from the L'Oréal Data Lake (Global and EMEA zones).◦ - Data modeling (tables, views, datasets) in BigQuery with optimization via partitioning and clustering.◦ - Optimization of processing performance and reduction of loading times.◦ - Implementation of technical and business documentation via dbt (docs + lineage).◦ - Construction of analytical models for market share comparison (L'Oréal vs Amazon, Sephora…).◦ - Automation of transformations via dbt, reducing analysis time from several days to a few hours.◦ - Optimization of SQL queries and BigQuery costs.◦ - Implementation of data quality tests (dbt tests) and monitoring of pipeline reliability.◦ - Implementation and improvement of ingestion pipelines (batch) with transformation via dbt and storage on BigQuery.• - Optimization of robustness, error management, and cost reduction on GCP.• - Design and realization of ELT pipelines on BigQuery, integrating advanced transformations: partitioning, clustering, materialized views, incremental tables (dbt incremental models).• - Industrialization of pipelines: CI/CD, deployment, monitoring, incident management, and continuous improvement.Tech DBT, GCP (BigQuery, Build), Python, SQL, Terraform, Git, Power BI
Recommendations
Be the first to recommend Othmane
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
- Master2019Master
- Engineering degree in Computer Science and NetworksMoroccan School of Engineers (EMSI)2023Diplôme ingénieur en informatique et réseaux