Freelancer profile translated to English.
Back to original languageAbout Florian
I am passionate about using data and technical challenges. I have been working as anindependent contractor since 2018on 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 processing(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 missions with **dozens of clients**, from large corporations to startups and SMEs.
Examples of clients: 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 (7 months)Montpellier, FranceLeading online training provider.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 Management**: Instituted agile rituals (Daily, Weekly) and organized skill-sharing sessions to foster collective skill development.
- Activity Management: Deployed Jira for **ticketing management**, providing increased visibility on the department's velocity and priorities.
- **Technical Aculturation**: Company-wide onboarding on **dbt**, unifying work methods and disseminating SQL best practices throughout the team.
Architecture Overhaul and Technical Migration
- Transition to **Medallion Architecture**: Designed a technical roadmap to implement a layered structure (Bronze, Silver, Gold), ensuring the availability of a certified "Gold" layer.
- Creation of aSemantic Layerwith DBTMetricFlowand opened to anMCPfor querying data via Claude.
- Migration of SQL Server views, scheduled queries, and stored procedures that fed Power BI dashboards and Machine Learning models.
- **Orchestration Modernization**: Defined a Data Engineering roadmap to migrate isolated Python/Cron scripts to a centralized **Airflow**, thereby improving 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 gaps (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 structure (Strategic vs. Operational).
**Audited References**: Doctolib, Cegid, Santevet, Hexadone, JDC, Alterna Énergie, Assuropoil.. - MOBSUCCESSSQL Query Migration 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 (PostgreSQL) databases to provide faster data access 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 Data WebINRIA2020
- Principles of Data NetworksIMT2015