Freelancer profile translated to English.

Description

Freelance Data Engineer with 9 years of experience

Specializing in the design and optimization of data solutions, I master tools such as Google Cloud Platform (GCP), BigQuery, Cloud Run, Cloud Build, Dataflow, Workflow, Firestore, Teradata, Terraform, DBT, Apache Airflow, Docker, GitHub, Power BI, and Looker.

Key Skills

Analysis of business needs and definition of adapted data architectures
Design and maintenance of robust data pipelines integrating DevOps practices
Modeling and optimization of databases for efficient data processing
Technical documentation and project management using Agile methodology
Creation of dynamic reports and dashboards with Power BI and Looker Studio

Key Achievement

At L'Oréal, as a GCP Data Engineer, I:

Designed high-performance data models for product teams
Developed and integrated new data to enrich analyses
Implemented BigQuery APIs and pipelines to ensure smooth data access
Modeled complex data for clear reporting via Power BI and Looker Studio

Industry field of expertise

Languages

French
Native or bilingual
English
Fluent
Spanish
Basic

Workplace preferences

Can work on-site

Paris (up to 50km)

L'Oréal
GCP Data Engineer
LUXURY GOODS
December 2021 - October 2024 (2 years and 11 months)
Paris, France
Designed efficient data storage and analysis patterns for large amounts of data in BigQuery
Implemented complex data acquisition and transformation workflows
Developed optimized data models to support product teams and enhance decision-making
Contributed to the development of new datasets to meet evolving business needs
Gathered and processed raw, structured, semi-structured, and unstructured data using both batch and real-time data processing frameworks
Built and maintained APIs for seamless data integration.
Worked with structured and unstructured data in various formats (JSON, AVRO, CSV, etc.).
Designed, developed, and launched new data pipelines to ensure reliable data flow
Modeled data for efficient Power BI and Looker reporting
Communicated technical solutions and design decisions clearly to both technical and non-technical stakeholders
Documented work thoroughly, including code comments and user manuals, utilizing tools like Confluence, GitHub, and Jira
Presented technical solutions in a simple and comprehensible way for business teams
Translated complex and ambiguous business requirements into clear user stories, covering functional, non-functional, security, and acceptance criteria
Applied excellent SQL skills for large-scale data transformations and analysis
Managed multiple priorities and conflicting requests effectively, ensuring timely delivery
Utilized Terraform for infrastructure management and automation
Created dashboards with Looker Studio to monitor and report on data quality
Built transformation models using DBT to aggregate data for individual respondents
Working closely with report owners and data product owners to unlock the full analytics potential of the data structure
Built data pipelines using existing integration processes, adhering to best practices such as CI/CD, code quality
Expertise in configuring and managing IAM roles and policies to ensure secure access control
airflow dbt BigQuery Terraform SQL Python looker studio workflow API dataflow REST APIs Python Flask Pandas Microsoft Power BI cloud build Identity and Access Management (IAM) GitHub Dockerfile
Orange
Data Engineer
TELECOMMUNICATIONS
June 2019 - November 2021 (2 years and 5 months)
Bd Périphérique, Paris, France
Contributed to the successful migration from Teradata to GCP, ensuring smooth transition and optimized performance
Designed and implemented the necessary infrastructure to extract, transform, and load large volumes of data from various sources
Created and optimized complex SQL queries for efficient data processing on BigQuery, improving query performance and reducing costs
Specialized in designing, building, and optimizing scalable data pipelines using GCP services such as Dataflow, Dataproc, and BigQuery
Ensured secure data processing by applying GCP security best practices, including IAM roles, encryption standards, and compliance with GDPR and other relevant data regulations
Managed and processed large datasets using GCP tools like BigQuery, Dataflow, and Pub/Sub to enable real-time and batch processing
Used Terraform to automate the deployment and management of data infrastructure on GCP, ensuring scalability and efficiency
Implemented continuous integration and deployment (CI/CD) pipelines for data engineering projects using Cloud Build, streamlining development workflows
Led data quality management efforts on GCP, ensuring data integrity, accuracy, and reliability across all data processes
Developed strategies for cost-efficient data processing and storage on GCP, optimizing resource usage and minimizing unnecessary expenditures
Led a team of data engineers, providing technical guidance, mentoring junior engineers, and promoting the adoption of data engineering best practices on GCP
Regularly communicated with business team, providing updates on project progress and aligning technical solutions with business goals
Worked closely with business teams to understand data requirements, translating them into technical solutions and ensuring alignment with business objectives
Expertise in configuring and managing IAM roles and policies to ensure secure access control and protect sensitive data across GCP resources
Teradata SQL Shell Python Google cloud Google Cloud Platform Dataflow Jenkins GitHub Docker PubSub Big Query
Enedis
Data consultant
ENERGY AND UTILITIES
June 2016 - May 2019 (2 years and 11 months)
Île-de-France, France
As a Teradata consultant
Integration of data flows using the enedis framework
Development of loading scripts via Teradata utilities : bteq, tpt
Date management (temporal data)
Impact analysis
Implementation of unit tests, performance tests and non regression tests
Provision of data to different users
Source code management : GitLab, Jenkins
Development of SQL scripts in order to check data integrity
Development of stored procedures in order to generate annual consumption reports for each electricity supplier
Analysis and correction of bugs detected by functional users
Taking into consideration the users’ feedback
Optimizing teradata queries
Using Jira and confluence
Creation of automated tests on fitness (dbfit)
Teradata AngularJS SQL Python Bash Shell Scrum Power Shell Cucumber

Check out Ilham's experience

Youen Meyer and 3 other people have recommended Ilham

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

Baptiste Duhen

Fullstack developer

4.6

(4)

Amed Hamou

Senior Lead Developer

(2)

Audrey Champion

Web developer

4.3

(3)

Signup to reveal

Master's degree, Project and Program Management
SKEMA Business School
2016
Master's degree, Management de projets et programmes
Computer Engineering, Business Intelligence
Ecole Nationale Supérieure d'Informatique et d'Analyse des Systèmes - ENSIAS
2014
Ingénieur en Informatique, Business Intelligence