Freelancer profile translated to English.
Back to original languageAbout Adam
Expert Data & Analytics with over ten years of experience (media, telecoms, retail, industry), I work on the decision-making layer: where KPIs are defined, modeled, and exposed to management. My job is to align indicators between Finance, Business, and IT, to clean up data models (Bronze / Silver / Gold layered architectures, star schemas, semantic layer), and to design C-Level dashboards that are readable, performant, and actually used.
I have managed analytical teams of up to 8 people and supported clients like Orange, Coty, Nexans, and Groupe M6 on KPI governance, Power BI performance, and BI industrialization topics. The challenge is always the same: reduce debates about numbers, clarify the reference metric, and secure scaling.
I primarily work with Power BI (DAX, Power Query, semantic models, RLS), BigQuery, SQL, dbt, AWS, and Python, with a handover-ready approach: stabilized pipelines, quality controls, documentation, and runbooks so that internal teams are autonomous. Certified Power BI Data Analyst and bilingual French/English, I undertake short, targeted missions, 100% remotely in Europe and internationally.
French
Native or bilingual
English
Native or bilingual
Can work on-site
Paris (up to 15km)
Experience
- Artefact FranceSenior Data and Analytics ConsultantCONSULTING AND AUDITSJuly 2024 - Today (1 year and 11 months)Paris, FranceAnalytics consulting for major clients - rebuilding reliable decision-making layers and industrializing KPI frameworks.Non-exhaustive list of projects:Orange (ProPME): Rebuilding the decision-making layer on BigQuery (layered architecture, star schema) to support budget forecasting including marketing hypotheses. Unification of KPI definitions between Finance and Business - discrepancies made explainable for the first time.Coty: Design and industrialization of a multi-source Advocacy Score (composite KPI from social, CRM, and retail data). Construction of automated pipelines, operational runbook, and handover documentation. Score adopted by brand managers as the primary performance indicator.Nexans: Construction of an executive sell-out cockpit for top management despite strong constraints on source data. Pragmatic approach to missing data with quality control layers. Reporting ready for management delivered on time.
- Groupe M6Lead Data Analyst then Head of AnalyticsFILM AND AVJanuary 2019 - December 2022 (3 years and 11 months)Neuilly-sur-Seine, FranceBuilding and managing the analytics entity of Groupe M6 - from team structuring to developing the technical stack powering over 8 business units.Managed a team of 8+ people (data analysts, engineers, data scientists) organized into 3 pillars: Analytics / R&D Lab / EngineeringPrimary analytics contact for senior management in Advertising, Content, Digital, and Operations.
- M6 publicitéData AnalystJune 2017 - July 2019 (2 years and 1 month)Neuilly-sur-Seine, FranceProgrammatic Team:- Consolidation of data from over 20 programmatic monetization and ad network sources. Development of data visualizations (using Tableau), an OLAP Cube for various business units, in partnership with the M6 group IT department, as well as reporting for management.- Improving reliability, developing, and automating audience tracking reports (Google Analytics) and digital advertising indicators (Impressions, eCPM, Revenue, CTR...).- Tracking performance of direct and programmatic campaigns.Smart6Tem Data Team:- Creation and automation of reports tracking revenue, eCPM, and Impressions for the different data segments offered to agencies and advertisers, clients of M6 Publicité, development of Visualizations.Golden Network Team:- Data mining and consolidation using Google Cloud Platform (BigQuery) and YouTube and AdManager (ex-DFP) APIs, using Python via Cloud Data Lab. Creation of Data Visualizations via Google Data Studio and Tableau.Machine Learning Project:- Brainstorming and development of a Machine Learning strategy applied to digital advertising...
Recommendations
Be the first to recommend Adam
Help this freelancer shine by sharing your experience working together.
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
- Master 2 Accounting, Control, and AuditIpag Business School2016Master 2 CCA, Comptabilité, Contrôle et Audit
- Baccalaureate, ES European MentionCondorcet2010Baccalauréat, ES Mention Européenne