
Sofiane Kihal
Data Platform Engineeer GCP
Salary / Daily rate
Paris, France
Freelance
Can come onsite
Skills
Languages
About me
Intro
GCP Data Platform Engineeer with proven expertise in cloud architecture, data engineering, and security. Built scalable data pipelines and implemented robust governance frameworks for B&B HOTELS France and Fortune 500 clients. Specializing in GCP services (BigQuery, Dataproc, Dataflow), infrastructure as code, and cost optimization while mentoring teams in cloud best practices.
Work experience
Data Architect GCP
B&B HOTELS FranceFreelance
Oct 2022 - Present
4 years 1 month
Paris, France
• GCP Foundations Architecture • GCP Foundations design and deployment (IAM, Network, Security, CI/CD, Monitoring) • CI/CD design and implementation (GitHub, Gitlab, Cloud Build, Docker, Terraform) • IAC design and implementation (Gitlab, Terraform) • Monitoring dashboards design • Data Governance strategy design and implementation • GCP Data Architecture (Medallion Architecture implemented) • Requirement gathering from business team, design and implementation of Data Products • Dataform ELT and deployment design (CLI with CI/CD) • Cloud Composer architecture design and deployment • Dataproc Hub - JupyterLab design and deployment for Data Scientists • Datastream with private connectivity design and deployment • Data loading solution with Cloud Run Functions (Python), Pub/Sub, Cloud Storage • Python development framework design and implementation • PySpark code design and optimization • SQL development for business needs • Multi-Cloud network connection to Shared VPC network design and deployment • Private Google Access set up on each network peering design and deployment • VPC Service Control implementation • Confluence documentation structure design • Technical documentation (DAT) • Customer Encryption key management • Workload Identity Federation • Technical documentation (DAT)
Accenture
Sep 2019 - Oct 2022
3 years 2 months
Paris, France
Data Engineer - Team Lead Consultant
Dec 2021 - Oct 2022
11 months
Paris, France
• GCP Architecture design and optimization of a data pipeline factory. • GCP Architecture support and consulting of a lift & shift migration (Cloudera to GCP) • Migration from Data Lake (Cloudera) to GCP • Design, sizing and optimization of Dataproc clusters. • Implementation, migration and optimization of on-premise solutions to adapted GCP services (Dataproc, Dataflow, BigQuery, Composer). • Design of a Data Governance through Data Catalog • Python package design for custom pipelines process through GCP API • Python package for custom logging process through the Google Cloud Logging API • Cost and performance optimization of BigQuery process • Knowledge sharing on GCP services and many other technologies like Spark MapReduce. • Design and implementation of a soft CI/CD pipeline on Gitlab
Data Engineer - Senior Analyst
Nov 2020 - Dec 2021
1 year 2 months
Paris, France
• Migration from Data Lake (Horton Works) to GCP. • Design of Dataproc clusters and optimization of sizing according to needs. • Migration and optimization of on-premise solutions to adapted GCP services (Dataflow, BigQuery, Composer). • Cost and performance optimization of BigQuery queries. • ETL orchestration and design via Cloud Composer. • Knowledge sharing on the Spark MapReduce framework and the optimization of associated parameters. • Design of an ELT and a script for sending files to external servers via Cloud Function, Bigquery. • Use of a CI / CD chain via Cloud Repository and Cloud Build. • Flow monitoring.
Data Engineer - Analyst
Sep 2019 - Dec 2020
1 year 4 months
Paris, France
As a GCP developer, i've mainly experienced following services : BigQuery, DataFlow, Dataproc, Cloud SQL, Cloud Composer, Cloud Pub/Sub, Cloud Dataprep. • Data mining, modeling, analysis, processing and visualization. • Data solution GCP architecture. • Design and implementation of a migration datasets using Python script, monitoring, Compute Engine, BigQuery and Cloud Storage. • Design and implementation of batch pipelines to extract, transform and load data from external databases sources (public data, SQL server, etc...) to BigQuery. • Design of a MySQL continuous replication on Google Cloud SQL. • Analysis of data usage in BigQuery Data Warehouse in order to make recommendations on actions to be taken. • KPI design, using Natural Language Processing, automated BigQuery SQL transformations, ML. • Dashboards design using BigQuery and Google Data Studio. • Personalized data access management system design.
Stagiaire Data Scientist
Groupe Renault
Jan 2019 - Jul 2019
7 months
92350 Le Plessis-Robinson, France
Within the Marketing & After-Sales Performance Europe Department, linked to the team responsible for developing Data Intelligence in the management of Renault workshops' business in Europe. • Development, testing, and deployment of algorithms for predicting vehicle workshop visits. • Application of Machine Learning algorithms (Random Forests, GBT, Multiple Linear Regressions, etc.) to model workshop visits based on vehicle history and technical information. • Use of tools such as Hive, Spark, Jupyter, Zeppelin to process billions of lines of available data. • Communication with Marketing managers from each European subsidiary (20 different countries) to understand their needs and explain the results.
Intern Data Miner
QuantCube Technology
Jun 2018 - Aug 2018
3 months
Région de Paris, France
• Specification, design and development of modules for the systematic extraction of massive data (macro and financial data, satellite images, open data ...) • Implementation and deployment of Big Data data storage structures • Design and development of the internal API for querying massive data • Implementation of tests and monitoring indicators • Writing technical documentation
Challenger
IMT Starter
Mar 2018 - Mar 2018
1 month
Évry, Île-de-France, France
Finalist winner of the Entreprendre Projects Challenge (2nd place) The Entreprendre® Projects Challenge is the largest entrepreneurial projects competition in France. It was created in 2000 by Télécom SudParis and Télécom Ecole de Management.
Entrepreneur
Social Farmer
Jun 2017 - Aug 2017
3 months
IMT Starter (Incubateur)
Member of the Insta Farmer team as part of an entrepreneurship project with IMT Starter. Development of tools to improve audience efficiency on Instagram.
Education
EF Language Abroad
Langue anglaise et littérature
2019 - 2019
1 month
ENSIIE
Diplôme d'ingénieur
2016 - 2019
3 years 1 month
Lycée Jules Ferry
CPGE
2014 - 2016
2 years 1 month
Licenses & certifications
Professional Data Engineer
Issued: May 2022
Professional Cloud Architect
Issued: Jun 2020
Google Cloud Professional Data Engineer
Issued: Jan 2020