Ludovic H.

Analytics Engineer:

⚙️ DBT Integration → industrialization of transformations (staging, marts, ...). Gains through clear data structuring.

🛠 Modeling in DBT → migration of our legacy and optimization of our models. Cost reduction and faster operation of our models in Snowflake.

🧹 Cleaning & normalization → improved reliability of KPIs and consistency of reporting.

📊 Data preparation & validation with Data Scientists → robust datasets for advanced analysis and predictive models.

📑 Data Governance → organization, with Data Engineers, of database partitioning in line with our DBT transformations.

Data Analyst:

📈 Looker Dashboards / Reporting → better understanding of business challenges and impacts for business units (Finance, HR, Sales, ...).

📊 Amazon QuickSight / Embedded reports → direct access to reporting resources on the web. Time and reactivity savings for users.

Data Product:

- Gather needs from the network of agencies (300+) to deploy version 2 of the margin report used by the entire network (600 users). Organization of scoping workshops, small group workshops by brand, and mockup creation.

- Monitor the adoption of version 2 report across the entire network and ensure a high level of reactivity for post-deployment support.

- Training of Data Champions to upskill on our Looker tool.

🔑 Keywords: Analytics Engineer, data analyst, data product, dbt models, dbt cloud, dbt core, Data warehouse, Data lake, Data pipeline, ETL, ELT, Data orchestration, SQL optimization, Query optimization, Business Intelligence, Data visualization, Data governance, Data quality, Cloud data stack, Modern data stack, KPI tracking, Metrics, Analytics.

- Monthly active users target analysis

- Improve user acquisition through business performance analysis

- Funnel analysis for sales performance with Tableau and Amplitude

- Python script to automate Tableau report mail sending

- Weekly and monthly analysis for sales report

- Improve user transformation on checkout page for Pumpkin Business ticketing

Stack: Tableau Software, PostgreSQL, Docker, Python and Amplitude.

Business Data Analyst within a payment fintech company with an annual turnover exceeding 500 million euros.

- Detection of at-risk behaviors (AML/CFT and KYC).

- Real-time revenue visualization using Tableau and Tableau Prep tools.

- Construction of a MongoDB data lake.

- Identification of trends through the cross-referencing of external data with GlobalData.

- RFM customer scoring with Tableau.

- Data Governance.

- Drafting of the semi-annual roadmap.

Stack: Tableau Desktop, Tableau Prep Builder, MongoDB, SQL.