Skip to content
BackNov 7
Md A.

Md A.

Analytics Engineer | dbt, BigQuery, Looker & Power BI | E-commerce

I build e-commerce data stacks that pay for themselves. One model I built caught a $35K 3PL overcharge; another saved $10K a month by flagging incorrect carrier fees. dbt, BigQuery, Looker and Power BI. For two years I was the analytics engineer at Maven Lane, a US e-commerce brand, with full ownership of the data stack. Nothing existed when I started. I built it end to end: Daton pulling 20+ sources into BigQuery, dbt for modeling, Looker for reporting. Later I moved the company off Power BI and onto one governed Looker layer. What I can do for you: • Build or clean up your warehouse. BigQuery + dbt with tests, source freshness checks, docs and CI, instead of scheduled queries nobody understands. • Cut your BigQuery bill. I reduced warehouse compute costs by 35% with partitioning, clustering and incremental models. • Define metrics people trust. I owned the 30+ KPI layer behind the weekly business review for the C-suite and shareholders: revenue, margin, ad efficiency, conversion and inventory health. • Check what your 3PL and carriers bill you. Shipping, storage and pick & pack cost models, used by Finance for month-end close. • Get ahead of inventory problems. Weeks of supply by SKU tier, lost sales from stockouts, landed cost. I improved Q4 forecast accuracy by 8% and cut stockouts by 22%. • Dashboards in Looker (LookML) or Power BI that people actually open on Monday morning. Tools: dbt (Cloud & Core), SQL, Jinja, BigQuery / GCP, Looker & LookML, Power BI, DAX, Power Query, Excel, Daton, Fivetran, Git, CI for dbt. Data from Shopify, GA4, ad platforms, 3PL and carrier invoices. How I work: the dashboard is rarely the hard part. Agreeing on what a number means, and making it reconcile with Finance, is. That is where I start. You get a documented model and clear metric definitions your team can maintain without me. Available 30+ hrs/week, with overlap for US or EU hours. If something looks wrong in the reports you already have, send me a screenshot or a sample query. I will tell you what I think is going on before you hire anyone.

🇮🇳Bhopal, India$22/hr100% JSS4.99 (4)Since May 2024

Earnings and projects

MRR
$414

Last 6 months ÷ 6

World#85,469 / 412k
🇮🇳Country#9,065 / 45.9k
Revenue, last 30 days
$640

Last 6 months: $2.5k

World#56,353 / 412k
🇮🇳Country#5,928 / 45.9k
Total earnings
$13k

Billed in all: $14k

World#173,175 / 412k
🇮🇳Country#22,465 / 45.9k
Per project
$2.2k

$1.2k in the last 6 months

World#71,436 / 412k
🇮🇳Country#8,609 / 45.9k
Projects, last 6 months
2
100% fixed0% hourly
World#88,918 / 412k
🇮🇳Country#10,198 / 45.9k
Projects in all
6

Across 7 contracts

71% fixed29% hourly
World#250,290 / 412k
🇮🇳Country#31,808 / 45.9k

Earnings, last 30 days

$14k+$640 earned in the last 30 daysBilled in all, before Upwork's fee · drag across the chart to see what was earned in any stretch
$13.0k$13.5k$14.0k$14.5kOct 8Oct 23Nov 7

Skill rankings: Top 18% in SQL

Ranked by MRR among everyone on Upwork with the skill.

  1. #11Fivetran39 freelancers · 🇮🇳 #3Top 28%
  2. #12LookML34 freelancers · 🇮🇳 #2Top 35%
  3. #78Looker297 freelancers · 🇮🇳 #9Top 26%
  4. #103dbt375 freelancers · 🇮🇳 #9Top 27%
  5. #117Data Warehousing494 freelancers · 🇮🇳 #17Top 24%
  6. #244Data Modeling1,203 freelancers · 🇮🇳 #31Top 20%
  7. #265BigQuery908 freelancers · 🇮🇳 #36Top 29%
  8. #372ETL Pipeline1,396 freelancers · 🇮🇳 #48Top 27%