Ludovic Omombo

■ Designed and deployed a complete Data Lake on GCP (Python → API → BigQuery → dbt → Looker Studio) to monitor 35 client brands — 136 URLs

• · 272 lines/day

◦ · Cloud Run orchestration + Scheduler ■ Modeled analytical datasets in dbt (staging → marts layers) with integrated quality controls (not_null, accepted_values, custom tests) — guaranteed reusability for business teams ■ Contributed to data governance: GDPR compliance, data lineage documentation, source data flow validation (GA4, GTM, Matomo, Tealium), Consent Mode v2 implementation (Didomi) ■ Produced steering dashboards (Looker Studio, Power BI) used daily by business teams for their strategic decisions ■ Performed ad-hoc analyses and exploratory studies (segmentation, pathways, RFM, ContentSquare) — operational recommendations and participation in POCs

SQL

• · dbt

• · BigQuery

• · GCP (Cloud Run, Scheduler)

◦ · Python

◦ · Looker Studio

◦ · Power BI

◦ · Data Quality

◦ · Data Governance

◦ · GDPR

■ Developed advanced SQL queries (CTEs, window functions, complex joins) on BigQuery for performance analysis on real data ■ Modeled end-to-end datasets (staging → marts in dbt) with a business approach — analytics engineering fundamentals: data modeling, transformation, testing, documentation ■ Built business use-case oriented Power BI / Looker Studio visualizations

SQL

• · dbt

◦ · BigQuery

◦ · Python

◦ · Power BI

◦ · Looker Studio

◦ · Data Modeling