About Guillaume
French
Native or bilingual
English
Native or bilingual
Experience
- WakamSenior Data Analytics EngineerBANKING AND INSURANCEFebruary 2024 - July 2025 (1 year and 5 months)• Mentored a team of 5 Analytics Engineers on best practices and projects delivery• Built dbt Core, Snowflake & SQL guidelines for the data office (~30 people)• Set up end-to-end CI/CD pipeline for testing and deploying a Python project• Automated data documentation with Python, reducing manual effort and enhancing data governance• Contributed to architecture a CORE data model based on insurance products and policies• Led the development of a data quality testing system, reducing data quality issues by 50%• Defined and built KPIs & data products with business teams, enhancing performance insights• Designed ELT data pipelines with Prefect, enhancing data accuracy by 25%• Implemented observability to monitor Snowflake performances and costs (reduced costs by 20%)• Developed an internal CLI tool to streamline data platform operations and boost team efficiency• Led data platform projects that enabled faster business decisions (+30% of reporting efficiency)Skills: Azure · dbt Core · Snowflake · Databricks · Prefect · Metabase · Azure DevOps · Azure Pipelines · SQL · Python · Bash · Data Modeling · CI/CD · Docker · Terraform · Notion
- SumUpAnalytics EngineerTECHOctober 2023 - February 2024 (4 months)• Collaborated with different tribes and gathered requirements to build KPI trees• Contributed to dbt & SQL conventions in a data mesh architecture• Created incremental & transactional models for data analysts & Finance reporting (+10M daily rows)• Built and managed ELT data pipelines with Airflow & dbt• Built dbt macros to store product & business logics for dbt projects• Built CI pipeline to lint & test modified dbt models changes on pull requests for a squad of 20 peopleSkills: AWS · dbt Core · Snowflake · Airflow · Tableau · GitHub · GitHub Actions · SQL · Python · Bash · Data Modeling · CI/CD · Docker · Terraform · Jira
- QontoSenior Data Analyst / BI EngineerSeptember 2022 - September 2023 (1 year)• Reviewed current data modeling solutions and practices• Cleaned & enhanced current data model to get one source of truth• Built data lineage & dbt models from raw to datamart layer• Contributed to best practices, standards & code style guide• Automated Tableau workbooks refreshes with Airflow (+100 automated extract refreshes)• Contributed to build data models for ~15 Company OKRs and ~80 Finance KPIs with C-levels stakeholdersSkills: AWS · dbt Core · Snowflake · Airflow · Tableau · Metabase · GitLab · SQL · Python · Bash · Data Modeling · Docker · Terraform · Notion
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's degree •INSEEC Grande Ecole2017Master's degree •
- Bachelor's degreeCY Cergy Paris Université2014Bachelor's degree