Analytics Specialist · Fribourg, Switzerland
David Guillaume
Data without causality is just pattern-matching. My background in econometrics taught me to ask not only what happened, but why — and whether an intervention actually made a difference.
I've spent my Master's and my time at Swisscom applying causal inference methods — DiD, SCM, ITS, IPW, MMM — to move beyond dashboards toward decisions grounded in evidence. It's the part of analytics I find most useful, and where I want to keep building my expertise.
Experience
- —Web & app analytics data collection — Google Analytics, Google Tag Manager, BigQuery, Adobe Experience Platform, Adobe Target
- —Analysis and dashboard creation — SQL, Python ETL, Quarto, Looker Studio, Customer Journey Analytics
- —Causal analysis — Difference-in-Differences (DiD), Synthetic Control Method (SCM), Interrupted Time Series (ITS), Inverse Probability Weighting (IPW)
- —Managed the Open Government Data platform (opendata.fr.ch), ensuring public data accessibility for stakeholders
- —Designed and implemented ETL pipelines to automate data processing and improve data accessibility
- —Developed data visualisations with Power BI and web tools, delivering insights to diverse audiences
- —Collaborated with cross-functional teams across services to align data initiatives with public transparency goals
Education
5.68 / 6 — Summa cum Laude
transcript ↗Thesis: "Measuring CSV initiative of la Mobilière: Causal analysis using Synthetic Control Method" (6/6)
5.5 / 6 — 2 ECTS (CAS Public Sector Transformation)
transcript ↗Fundamentals of data management, legal frameworks, OGD strategies, catalog data, data usage measurement — group project with practical federal and cantonal examples
Thesis: "Mise en place d'un service mutualisé à l'aide de FileMaker" (5.5/6)
Licences & Certifications
Bayesian Machine Learning in Python: A/B Testing
Udemy
Fundamentals of Marketing Mix Modeling: Learn by Doing
certificate ↗Udemy — MASS Analytics
Data Analytics in Python — Softskill (6/6)
certificate ↗University of Fribourg · DigitalSkills@Fribourg
Microeconomics of Competitiveness: Firms, Clusters and Economic Development
Harvard Business School (with Prof. Michael E. Porter)
Udacity
Udacity
Python Online Course — Softskill (6/6)
certificate ↗University of Fribourg · DigitalSkills@Fribourg
Winter School in Data Analytics and Machine Learning
certificate ↗University of Fribourg — Dept. of Applied Econometrics
Skills
Languages
French
Native
German
C1 — Goethe-Zertifikat
English
Professional