Amsterdam, Netherlands

Senior Data Analyst
& Analytics Architect

14 years building data infrastructure, KPI frameworks, and insight systems. BigQuery · dbt · GA4 · Adobe Analytics · Looker Studio.

About

I build the analytics layer that lets organisations stop guessing. That means data models, tracking instrumentation, KPI frameworks, dashboards, and the experimentation culture to make them useful.

Most recently at Telus Digital as an Analytics Architect across enterprise clients — consumer electronics, B2B SaaS, e-commerce, travel. Before that, five years at Stanley Steemer building marketing analytics from scratch across 280 franchise locations: no prior capability, full BigQuery-backed BI layer on the way out.

Currently based in Amsterdam. EU work authorisation. Available immediately.

Location
Amsterdam, Netherlands
Core stack
BigQuery · SQL · dbt · GA4 · Adobe Analytics · Looker Studio
Languages
English (native) · French (B1) · Dutch (A2)
Authorization
EU Work Authorization

Projects

Public work evidencing the technical skills that don't fit on a CV.

dbt · BigQuery · SQL In progress

Analytics Engineering with NYC TLC Data

Staging → intermediate → mart dbt models on public taxi trip data. Tests, documentation, and lineage on every model. The question it answers: which pickup zones are underserved relative to demand, and how does that shift by time of day?

GitHub — coming soon
Python · Attribution Planned

Multi-Touch Attribution Modelling

Last-click, first-click, linear, time-decay, and data-driven attribution compared on the same dataset. Built around the question: what changes when you stop crediting the last touchpoint?

GitHub — coming soon
Python · BigQuery · Cohort Analysis Planned

Retention Cohort Analysis

Cohort retention curves, churn modelling, and LTV estimation on a public SaaS or e-commerce dataset. Visualised in Python with a business-facing write-up.

GitHub — coming soon
GA4 · Tracking Architecture Planned

GA4 Measurement Plan Template

A reusable SDR and tracking plan for GA4 implementations: event taxonomy, naming conventions, parameter structure, and QA checklist. The methodology before the code.

GitHub — coming soon

"Frederic's abilities with analytics are so good, they seem like dark magic. The insights he extracts from data are fantastic, the testing and business strategies he devises are best-in-class, and he could present complex findings to a 3-year-old. Having one Frederic at your company is like having 2 regular analysts."

Karim Merchant Principal Product Designer · Dell

"He helps me with data issues I didn't even know I had. He is especially quick to link marketing with IT and all of the data in between."

Elizabeth Schilling Data & Digital Strategy · Geben Communications (colleague, Stanley Steemer)

Skills

Analytics Platforms

  • Google Analytics 4
  • Adobe Analytics
  • Amplitude
  • GTM (client-side & server-side)
  • Adobe Launch / AEP Tags

Data Engineering

  • BigQuery / GCP
  • SQL (advanced)
  • dbt
  • Python (pandas, numpy, matplotlib)
  • Databricks · Snowflake

BI & Dashboarding

  • Looker Studio
  • SSRS
  • Power BI
  • Tableau

Methods

  • A/B testing & experimentation
  • Multi-touch attribution
  • Cohort & retention modelling
  • Funnel analysis
  • Audience segmentation

Tracking & Instrumentation

  • Solution Design Reference (SDR)
  • Data layer architecture
  • Custom JavaScript tracking
  • Tag QA (ObservePoint, Omnibug)

MarTech & Privacy

  • Bloomreach CDP
  • Oracle Responsys
  • OneTrust (GDPR/CCPA)
  • Consent management

Certifications

Analytics & Data Engineering

  • dbt Fundamentalsdbt Labs · Apr 2026
  • Databricks FundamentalsDatabricks · Feb 2026
  • Adobe Analytics Business PractitionerAdobe · Nov 2024
  • Google Analytics CertificationGoogle · Oct 2015, renewed
  • Conversion OptimizationGoogle · Aug 2025

Amplitude

  • Expert — Data ManagementAmplitude
  • Specialist — Marketing AnalyticsAmplitude
  • Specialist — ExperimentAmplitude
  • Specialist — Data CleanupAmplitude
  • Practitioner — RetentionAmplitude
  • Practitioner — AcquisitionAmplitude
  • Practitioner — MonetizationAmplitude
  • Foundations — AnalyticsAmplitude
  • Foundations — ExperimentAmplitude
  • Foundations — Data ManagementAmplitude

AI & Cloud

  • Prompt Design in Vertex AIGoogle Cloud · Feb 2026
  • Data Mesh ArchitectureLinkedIn · Mar 2026

MarTech & CDP

  • Bloomreach EngagementFoundations · SMS · Jinja · Crash Course

Education

  • MSc, Data AnalyticsWestern Governors University · 2023
  • Data Science CertificateUC Irvine · 2018
  • BA, Strategic CommunicationsThe Ohio State University · 2011

Contact

Open to senior data analyst, analytics architect, and analytics engineering roles in Amsterdam.