Head of Data

Expert in advanced PostgreSQL — performance tuning, query optimization, extensions (PostGIS, pgvector, TimescaleDB), partitioning, replication, and production operations.

Expert in Python-based data analysis — Pandas, NumPy, exploratory data analysis, statistical profiling, data cleaning, and visualization for business insights.

Expert analytics engineering skill for dbt Core/Cloud — guides you through SQL-based data modeling with staging/intermediate/mart layers, dimensional modeling (Kimball methodology), incremental models, SCD Type 2 snapshots, comprehensive testing strategies, Jinja macros, dbt packages, and warehouse-specific optimization for Snowflake, BigQuery, and Redshift.

Designs robust ETL and ELT data pipelines with focus on idempotency, incremental loading, data lineage, and orchestration. Guides implementation with Apache Airflow, dbt, and modern data stack tools.

Expert in Google BigQuery — SQL analytics at scale, partitioning and clustering strategies, BigQuery ML, materialized views, Dataform pipelines, cost optimization, and data governance.

Design and implement cohort analyses for retention measurement, behavioral segmentation, and product analytics. Provides SQL implementations, visualization recommendations, and statistical interpretation guidance.

Expert regression analysis guidance covering model selection, diagnostics, regularization, and causal inference across OLS, GLM, and ML techniques.

Designs and implements Monte Carlo simulations for quantitative analysis, covering probability distributions, variance reduction techniques, financial modeling (VaR, options pricing), convergence analysis, sensitivity analysis, and production-quality Python/R implementation patterns.

Guides you through designing effective, insight-driven dashboards with proper KPI selection, visual encoding, and data storytelling — applying Tufte and Few principles to avoid common anti-patterns.

Transform data into compelling visual narratives using chart type selection, Tufte principles, color theory, annotation strategies, and audience-adapted presentation-ready outputs.