Freelancer profile translated to English.
Back to original languageAbout Florian
I am passionate about using data and technical challenges. I have been working as a freelance consultant since 2018 on all types of data-related missions:
-> **Collection**: API connections, Web Scraping, Databases, webhooks, Airbyte, Funnel, or via OpenData
->Processing**: Setting up Cloud data architectures, ETL **processingpipelines (Airflow, DBT, SQL), and creating API backends (Flask, Node.js, serverless).
->Storage**: In **data warehouses(PostgreSQL, BigQuery, Snowflake),data lakes(S3, GoogleCloudStorage, Redshift), document-oriented (MongoDB), graph (Neo4j), or TimeSeries (InfluxDB).
-> **Visualization**: Dashboards (Looker Studio, Dash) or Web
-> On a large number of **Clouds**: Microsoft Azure, Amazon Web Services, GoogleCloudPlatform, OVH, or Oracle.
I have had the opportunity to work on multi-month assignments with **dozens of clients**, from large corporations to startups and SMEs.
Client examples: Doctolib, Accor, Suez, CNRS, Onepoint...
I would be delighted to discuss your projects!
To see my references in detail, visit my website:florianblanchet.fr
French
Native or bilingual
English
Fluent
Can work on-site
Montpellier (up to 50km), Paris (up to 40km), Lyon (up to 10km), Marseille (up to 10km), Toulouse (up to 10km)
Experience
- STUDILead Analytics EngineerEDUCATION AND E-LEARNINGJanuary 2026 - Today (5 months)Montpellier, FranceLeader in online training.Managed the organizational and technical transformation of a Data department of 10 people, aiming to convert a fragmented legacy environment into a modern, industrialized, and collaborative infrastructure.
Team Structuring and Change Management
- Team Coordination: Transverse management of10 employees (6 Data Analysts, 4 Data Engineers)to align technical and business objectives.
- **Team Life Facilitation**: Establishment of agile rituals (Daily, Weekly) and organization of skill-sharing sessions to foster collective skill development.
- Activity Management: Deployment of Jira for **ticketing management**, providing increased visibility into the department's velocity and priorities.
- **Technical Acculturation**: Widespread onboarding on **dbt**, unifying work methods and disseminating SQL best practices throughout the team.
Architecture Redesign and Technical Migration
- Transition to **Medallion Architecture**: Design of a technical roadmap to implement a layered structure (Bronze, Silver, Gold), ensuring the provision of a certified "Gold" layer.
- Migration of SQL Server views, "scheduled queries," and stored procedures that fed Power BI dashboards and Machine Learning models.
- **Transform Consolidation**: Centralization of business logic in dbt, facilitating the maintenance and reuse of data models across the organization.
- **Orchestration Modernization**: Definition of a Data Engineering roadmap to migrate isolated Python/Cron scripts to a centralized **Airflow**, thus ensuring the reliability of all extractions.
- Scale-up et Grand ComptesMarketing Data Audit and Strategic PlanningCONSULTING AND AUDITSAugust 2025 - December 2025 (4 months)Paris, France**Mission Objective**: Conduct a 360° diagnosis of marketing data maturity and deliver a roadmap to transition from volume-based (Leads) to value-based (ROI/LTV) management.**Methodology & Deliverables**:
- **Technical Diagnosis & Tracking**: Analysis of the existing setup (GTM, Tagging Plans, CMP). Identification of collection flaws (signal loss, third-party cookies) and compliance risks (GDPR). Recommendation to transition to Server-Side Tracking and CAPI to ensure data reliability.
- **Data Architecture Audit**: Mapping of data flows and identification of silos (Marketing vs. Sales vs. Tech). Highlighting data fragmentation (manual Excel, redundant tools).
- Target Architecture Definition: Design and recommendation of a centralized"Modern Data Stack"(Extraction + Data Warehouse + DBT) to reconcile sources (CRM, Ads, ERP) and create a single source of truth.
- **Management & Attribution Strategy**: Modeling of new financial KPIs for marketing (CAC, LTV, MRR). Recommendation of multi-touch attribution models to move beyond "Last-Click" and value the impact of Brand/Nurturing.
- **Roadmap & Governance**: Development of a prioritized 12-month action plan (Build -> Run -> Scale) including recruitment needs (Marketing Data Analyst) and dashboard structuring (Strategic vs. Operational).
**Audited References**: Doctolib, Cegid, Santevet, Hexadone, JDC, Alterna Énergie, Assuropoil.. - MOBSUCCESSMigration of SQL Queries to DBTPRESS AND MEDIASeptember 2024 - June 2025 (10 months)Paris, FranceAudit ofDBTandAirflowusage and recommendations for improvement.Long-term support for migrating advertising campaign dataSQLqueries toDBT(connected toAWS Athena**) with integration into the existing data model. Refactoring of transformation layers ( **medallion architectureand snowflake).Improvement of the DBTCI/CDpipeline on Github.Data transfers withGlue(AWS) /SparkandIceberg/parquetstorage.Setup of Aurora databases (PostgreSQL) to make data available faster to the backend and reporting.Remote / 4 days per week
Reviews
Recommendations
FU
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
- Specialized engineer in Data ScienceTélécom Bretagne (Institut Mines Télécom)2018Diplôme d'ingénieur avec spécialisation en data science. Télécom Bretagne s'appelle aujourd'hui IMT Atlantique suite à la fusion avec les Mines de Nantes.
- Dual degree in managementGrenoble Ecole de Management2019Spécialisation en management et marketing.
Certifications
- Semantic Web and Web of DataINRIA2020
- Principles of Data NetworksIMT2015