Guillaume ABDOULHOUSSEN

• 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 · PowerBI · Azure DevOps · Azure Pipelines · SQL · Python · Bash · Data Modeling · CI/CD · Docker · Terraform · Notion

• 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 people Skills: AWS · dbt Core · Snowflake · Airflow · Tableau · GitHub · GitHub Actions · SQL · Python · Bash · Data Modeling · CI/CD · Docker · Terraform · Jira

• 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) • Automated the monthly financial closing of the Finance team with dedicated data products (from a 2 days process to only 30 minutes) • Contributed to build data models for ~15 Company OKRs and ~80 Finance KPIs with C-levels stakeholders Skills: AWS · dbt Core · Snowflake · Airflow · Tableau · Metabase · GitLab · SQL · Python · Bash · Data Modeling · Docker · Terraform · Notion

• Collaborated with data people & collected needs on tables & KPIs for the final users • Delivered BI database tables with the Data Engineers - starting with dimension tables • Redesigned global data model & documented it with data & business analysts • Enhanced existing Tableau Embedded dashboards used for data exposition in the product • Gathered needs of the product squads for future embedded analytics dashboards in the product Skills: AWS · AWS S3 · Amazon Athena · PostgreSQL · Airflow · Tableau · GitHub · SQL · Python · Bash · Data Modeling · Jira

Missions within major Banking, Finance and Retail accounts (LCL, Louis Vuitton Malletier, REXEL) • Created, scheduled and monitored data pipelines for several organisations • Reported on data integration, business applications freshness and platforms observability • Managed team operations on different ELT reporting and data warehousing projects • Led data modeling and design for several data warehouse conceptions • Improved SQL queries time with code reviews & execution plans • Developed data visualisations apps for Finance, Pricing and Supply Chain business teams • Built automations to refresh Power BI dashboards with Bash scripting and Azure / Power BI APIs Skills: PostgreSQL · MariaDB (MySQL) · Oracle · Teradata · SQL Server · SSIS · Datastage · Dollar Universe · Control-M · QlikSense · Power BI · Azure · SQL · Bash · Data Warehousing · Data Modeling · Data Orchestration · Jira

Missions of data liability and functional testing of banking applications (BEOBANK NV/SA) • Analysed the functionalities of banking applications • Prepared test cases with business analysts • QA and functional testing in order to detect bugs • Managed a team of 8 temporary employees for 3 months • Created dashboards to monitor the performance of the project Skills: Microsoft Excel · Project Management · QA