I locate the root cause of your broken North-Star metrics. Fast.
I build the Snowflake + AI analytics infrastructure B2C scale-ups need to survive. No open-ended contracts. Strict determinism. Fixed outcomes.
Zero Data Exfiltration
I do not host your data. All algorithms run directly inside your Snowflake VPC. Legal and InfoSec approve in 48h.
Local LLM Execution
NLP and AI insights are generated using Snowflake Cortex locally. No API calls to external providers. Full compliance.
Strict Determinism
Anomalies are engineering failures, not mysteries. I use variance decomposition to prove the cause mathematically.
See MetricPilot in action
Root-Cause & WBR Generation Engine
Engagement Models
Start with certainty. Scale with autonomy.
01 AUDIT
Metric Root-Cause Audit
Your North-Star metric moved. I connect to your warehouse and isolate the root cause deterministically — variance decomposition tree + executive WBR brief in days.
- Variance decomposition tree
- Executive WBR brief
- 30-day Snowflake alert template
€15–25K
1–2 weeks · Fixed scope
02 DEPLOYMENT
Cortex AI Infrastructure
Snowflake Cortex deployed inside your VPC. Non-technical teams query data in natural language, governed locally. Zero data ever leaves your warehouse.
- Cortex agents + governed SQL chains
- Internal natural-language Q&A interface
- InfoSec & legal pack (48h approval)
€650–950
per day · 4–8 weeks
03 SPRINT
Analytics Team Rescue
Your data team is stuck on the hard part — complex modeling, perf bottlenecks, experimentation, ML. I parachute in, unblock the pipeline, leave a playbook.
- Technical unblock & code shipment
- Architectural playbook
- Senior knowledge transfer
€15–30K
2–4 weeks · Custom
About & Journey
14 years turning data into decisions
I am an independent Tech Strategist specializing in Snowflake architecture and mathematical variance decomposition. I operate strictly at the intersection of data engineering and executive finance.
My methodology was forged in top-tier enterprise B2C environments, handling terabytes of behavioral telemetry and millions of daily active users. In these environments, an unexplained 2% drop in conversion rates costs millions. Guessing is not an option.
I do not build generic dashboards. I do not bill by the hour to explore your data. I build deterministic systems that locate revenue leaks instantly, and I deploy local AI infrastructure that makes your BI team radically faster.
simonsangla.com 2026 – present
Independent Analytics Engineer
Help B2C scale-ups fix broken North-Star metrics with Snowflake + variance analysis. Creator of MetricPilot, a Snowflake-native revenue root-cause engine.
Tripadvisor Jan 2021 – Dec 2025
Senior Lead Analyst
Built the Insight Bot (text-to-SQL on Snowflake Cortex, 500+ natural-language queries/month) and shipped Cortex AI to production — anomaly detection, forecasting, LLM functions. Led the Eppo experimentation rollout and the Mixpanel→Snowflake pipeline; created a dbt dashboard template adopted across 5 teams. Cut KPI root-cause cycles from days to hours.
Technical Skills
Snowflake · Cortex AI · dbt · SQL · Python · Mixpanel · Eppo · Tableau
Education
MSc Statistics (TIDE) & Econometrics · Université Paris 1 Panthéon-Sorbonne
Stop guessing. Start fixing.
If your North-Star metric is bleeding and your current team cannot pinpoint the exact technical or behavioral root cause, we need to talk.
Response time: < 24h. NDA-ready.