Freelancer profile translated to English.
Back to original languageAbout Guillaume
Data engineering expert with solid experience in the Retail and Telecom sectors. Specialized in process automation and industrialization of complex pipelines on GCP (BigQuery, SQL). Strong expertise in data visualization (Looker Studio, Power BI), I design robust business intelligence solutions with high business impact.
French
Native or bilingual
English
Conversational
Can work on-site
Drancy (up to 30km)
Experience
- CarrefourData analystRETAIL (LARGE RETAILERS)December 2023 - April 2026 (2 years and 4 months)Massy, France• Design and deployment of automated workflows on GCP• Creation of Looker Studio Dashboards with business documentation• Exploiting links between BigQuery, Gsheet, Gdoc, Looker environments• Extraction, preparation, and industrialization of BigQuery dataTechnical Environment: GCP, BigQuery, Looker Studio, Google Cloud, Workflows, PowerQuery, VBA, Excel, Python, Draw.io, Gsheet
- Dassault AviationData AnalystAVIATION AND AEROSPACEMay 2023 - August 2023 (4 months)Saint-Cloud, FranceAero Structure Technical Directorate, Testing Department• Collection of user needs and star schema design• Loading and transformation of data on Power Query• Creation of DAX measures and realization of the Dashboard on Power BI• Use of Synoptic Panel from okViz in Power BI
- LincolnData EngineerTELECOMMUNICATIONSJanuary 2019 - September 2022 (3 years and 9 months)Paris, FranceSFR Decision Support IT Mission, Data TeamProject Manager Data and Data Referent:• Study and scoping with business units• Flow and table structure modeling• Study on sensitive data access and retention periodFlow Developer:• Data integration (Loading / Transformation / Propagation). Creation of tables and views (Hive / Teradata), data transformation in SQL / HQL• Flow scheduling (Crontab / Airflow)Technical Support:• Data catch-up• Table balancing and optimization (Teradata)• Analysis and correction of QOD / QOS anomalies• Improvement and normalization of the industrial ETL process
Recommendations
Be the first to recommend Guillaume
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
- Master MIAGE - Business IntelligenceUniversité Paris Dauphine2018Data visualisation (Power BI) Base de donnée (SQL) Système d'information (Gestion de projet informatique) Datawarehouse (Entrepôt de donnée + ETL avec Talend) Big Data (Hadoop / Hive / Spark)