Gilbert Lelon

Fabric Analytics Engineer with hands-on expertise across the full Microsoft Fabric stack — from OneLake storage design and medallion lakehouse architecture to governed semantic models and self-service Power BI reports. Certified DP-600 (Fabric Analytics Engineer Associate) and PL-300 (Power BI Data Analyst), with DP-700 actively in progress. Proven ability to own complex data solutions end-to-end: batch and streaming ingestion, Spark-based medallion transformation, Direct Lake semantic models with advanced DAX, KQL real-time analytics, row-level security, and deployment pipeline governance.

Additionally fluent in BigQuery, Python/pandas, and AI-augmented reporting pipelines. Finance background (BCom Banking & Finance, CIFA, MSc Finance) enables sharper business framing of data problems. Open to full-time Fabric specialist roles and BI modernization engagements with remote-first global teams.

Microsoft Fabric Consultant - BluePeak Analytics (Independent) - Nairobi, Kenya · Remote

(2025-01)

Design and implement end-to-end Microsoft Fabric solutions for clients migrating from legacy Power BI Premium, Azure Synapse, and on-premises data warehouses — covering workspace planning, OneLake architecture, medallion layering, and capacity governance.

• Build ingestion pipelines using Data Factory (watermark-based incremental loads), Dataflow Gen2, and Spark notebooks; deliver Bronze→Silver→Gold medallion transformations with Delta/Parquet table design.
• Engineer Direct Lake semantic models with advanced DAX measures (time intelligence, RANKX, semi-additive), row-level security roles, deployment pipelines, and XMLA endpoint integration.
• Developed Real-Time Retail Intelligence Hub — dual-track Fabric solution combining incremental SQL Server migration (121,317 rows, watermark pipeline) with live IoT event streaming (574,320+ events, KQL Eventhouse) and a governed Power BI report with RLS.
• Layer Claude API narrative generation on structured analytics outputs to deliver automated daily intelligence reports — replacing manual spreadsheet workflows for eCommerce clients.

Shopify Analytics Consultant - Freelance / Self-Employed - Nairobi, Kenya · Remote

(2024-01 - 2025-12)

Built BigQuery data warehouses, SQL analysis pipelines, and Power BI dashboards surfacing profitability insights, customer behaviour, and automated daily reporting for Shopify merchants.

• BluePeak Commerce Profit Leakage Analysis: BigQuery warehouse + Power BI dashboard on $94.2K revenue dataset; identified 40.9% gross margin with 5 high-refund products, underperforming discount codes (SUMMER20 at 25.8% margin vs BUNDLE15 at 38.3%), and affiliate channel underperformance vs email/Google.
• Northstar Trail Supply Analytics: Full cleaning pipeline across 9 raw CSV tables; identified SKU concentration risk (top 2 products = 36%+ of revenue) and confirmed Q4 seasonality pattern across $286K gross revenue.
• Productized live Shopify analytics pipeline: raw Shopify data → BigQuery → Power BI → automated daily inbox report with zero manual intervention.

Master of Science - Finance - Kabarak University (2023-09 - 2025-12)

Bachelor of Commerce - Banking & Finance - Egerton University (2017 - 2020)

CIFA - Chartered Investment & Financial Analyst - KASNEB (2017 - 2020)