Freelancer profile translated to English.
Back to original languageAbout Matthieu
🎯Senior Data Analyst&Analytics Engineerfreelance, with over 14 years of experience in data analysis, SQL modeling, data pipeline automation (ELT/ETL), and business intelligence. My goal: to transform your data into clear decision-making indicators aligned with your business challenges.
🛠️ Mastered Stack:
- Languages: SQL, Python, VBA
- Orchestration & Transformation: DBT, Airflow, Git
- Cloud & Warehouses: Snowflake, BigQuery, Databricks, GCP, Azure
- BI & Dataviz: Power BI, Tableau, Looker (Google Data Studio), Excel
- Methodologies: ELT, ETL, DataOps, CI/CD, automated tests, DBT documentation, versioning, data governance
📊 Areas of Expertise:
- Financial reporting, KPI modeling, dashboard automation
- CRM analytics, customer scoring, RFM segmentation
- Fraud detection, alerting, behavioral data enrichment
- Advanced dataviz, dashboards, self-service BI
- Pipeline industrialization, multi-source integration, performance optimization
- Data transformation for Marketing Mix Modeling (MMM)
🏢 Sectors Covered:
- Banking, market finance, insurance, fintech, compliance, audit, digital marketing, retail, FMCG, industry, e-commerce, agri-food, luxury, public sector
💼 Recent Client References:
- Pernod Ricard: MMM & marketing dashboards via Snowflake + Databricks + Azure + DBT + Power BI
- Qonto: automated reporting via Snowflake + DBT + Tableau
- Nickel (BNP Paribas): CRM scoring, fraud detection via BigQuery + DBT + Looker
🚀 My deliverables are robust, scalable, documented, tested, maintainable, and business-oriented. My work combines technical rigor, business acumen, and innovation. Passionate about data-driven technologies, I am ready to take on your data analytics and business intelligence challenges. Expert in SQL and DBT, I provide data-centric solutions to maximize your analytical potential.
French
Native or bilingual
English
Fluent
Can work on-site
Paris (up to 50km), Bordeaux (up to 50km)
Experience
- Pernod RicardSenior Data Analyst - Marketing & Trade Investment Optimization EMEAAGRICULTURESeptember 2023 - Today (2 years and 9 months)🎯 Context:As aSenior Data Analyst**, I contributed to a strategic project aimed at maximizing the effectiveness of **marketing investmentsby analyzing their impact on sales.🛠 Actions Taken:
- Supervised thepreparationandpre-modeling verificationof data
- Collaborated closely withlocalandinternationalteams for the interpretation ofBayesian modelresults
- Integrated data via aDBT pipelineand stored it inSnowflake(Modern Data Stack)
- UsedDatabricksandPythonfor data cleaning
- ManagedPower BI dashboardsfor a holistic view ofmarketing spend
- Served as the primary point of contact forData Engineeringteams
- Contributed to the development of theMATRIXtool to integrate data-driven decision-making
📈 Results Achieved:- Successful illustration of the influence of marketing decisions onfinancial results
- Strategic recommendations delivered tomanagementandmarketingteams
- Significant improvement in the efficiency of analytical processes, enabling a reduction inproduction timeand betterresponsiveness
🛠 Stack Used:DBT, Snowflake, Power BI, Git, SQL, Python, Azure - QontoSenior Data Analyst / BI Engineer - Finance / StrategyBANKING AND INSURANCEJanuary 2023 - September 2023 (8 months)🎯 Context:As aSenior Data Analyst / BI Engineer**, I managed stakeholder requests in **financeand **strategy**, contributing to pipeline development and dashboard projects.🛠 Actions Taken:
- DevelopedDBT pipelinesto automate data preparation (**Airflow** being the tool used for workflows)
- CreateddashboardsonTableauto visualizeKPIsand key metrics
- Conducted in-depth analyses to establishfinancialandstrategic indicators
- Implemented tracking tools for **deposit remuneration**, facilitating decision-making
- Immersed in aLEANenvironment to improve efficiency and work methods
📈 Results Achieved:*Increased team responsivenessthrough clear and actionable visualization tools*Improved operational efficiencythrough the adoption of LEAN practices, reducing request processing time*Strengthened strategic decision-makingby providing reliable and relevant data- **Optimized financial processes**, enabling better resource and cost management
🛠 Stack Used:DBT, Snowflake, Tableau, Git, SQL, Python, Metabase - NickelSenior Data Analyst - Sales departmentBANKING AND INSURANCEApril 2022 - December 2022 (7 months)Charenton-le-Pont, France🎯 Context:As a **Senior Data Analyst**, I managed the data needs for the sales department at **Nickel**, covering 5 countries and serving about twenty teams.🛠Actions Taken:
- Maintained and developed theCRMdata feed viaDBT/BigQueryand theSalesforceAPI
- Improved point-of-sale scoring and fraud detection algorithms
- Provided support for data analysis and ad-hoc requests
- Built and maintained a scope of one hundred tableson DBT
📈 Results Achieved:- Improveddata qualityandreliabilityof analyses for the sales department
- Strengthened **fraud detection capabilities**, contributing to better risk management
- Optimized **reporting processes**, enabling faster and more informed decision-making
🛠 Stack Used:DBT, BigQuery, Looker (Google Data Studios), Git, SQL, GCP
Recommendations
AO
AC
+1
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
- DUT Statistics and Decision InformaticsUniversity of Caen Basse Normandie2011
- Bachelor's Degree in Financial Markets Operations ManagementUniversity Lumière (Lyon 2)2012
Certifications
- Financial Engineering and Risk Management Part ICoursera - Columbia University2016
- Financial Engineering and Risk Management Part IICoursera - Columbia University2016