Md. Ahnaf Tanvir

Hi, I'm

Md. Ahnaf Tanvir

Data & Analytics Engineer · Snowflake · dbt

Data and analytics engineer with 3 years of experience developing scalable data infrastructure leveraging Snowflake, BigQuery, dbt, Terraform (IaC), and full-stack data tools.

About Me

I’m a data and analytics engineer based in Dhaka, Bangladesh. I build the pipelines, data models, and cloud infrastructure that quietly keep a business running, and most of what I know I picked up by actually shipping things and learning from what broke along the way.

I studied biomedical engineering at Bangladesh University of Engineering & Technology (BUET), working on medical imaging and a thesis on lung nodule detection with deep learning. Somewhere along the way I realized I cared more about the systems that move and shape data than the specific domain it belonged to. That curiosity eventually led me into data engineering.

I spent two and a half years at G-Star working on a production data platform on GCP: retail and e-commerce models in a 700+ model BigQuery/Dataform warehouse, streaming pipelines with Pub/Sub and Dataflow, and infrastructure across multiple environments with Terraform. Since August 2026 I’ve been at Gildan in the Data Warehouse Architecture team, building Snowflake data marts for manufacturing and leading the team’s move to dbt, pull-request review and CI/CD. I approach problems with a builder’s mindset, focusing on production-grade solutions that minimize manual effort.

Data Warehousing & Modeling

  • Snowflake
  • BigQuery
  • dbt / Dataform
  • Dimensional Modeling

Streaming & Pipelines

  • Pub/Sub
  • Dataflow
  • Apache Beam
  • Cloud Functions

Platform Engineering

  • Terraform
  • Multi-env GCP IaC
  • Docker
  • IAM

Engineering Practice

  • Git & PR Review
  • CI/CD
  • SQLFluff
  • Data Lineage

Professional Experience

Developer, Data Warehouse Architecture

Full-time

Gildan · Dhaka, Bangladesh

Aug 2026 – Present
  • Data Warehouse Architecture: Architected and built Snowflake data marts for manufacturing with 20+ tables and views using dimensional modeling, feeding semantic views for AI agents; reviewed 100+ legacy objects to plan the warehouse redesign and retirement.
  • SOX Access Review Automation: Replaced an Excel-based SOX user access review covering 300+ managers and 1,000+ users with a Snowflake data model, stored procedures and two Streamlit in Snowflake apps: one for managers to certify their reports’ roles, one for admins to track progress.
  • dbt, Git & CI/CD Adoption: Leading the team’s adoption of dbt, pull-request review and CI/CD, from the phased roadmap and Snowflake–GitHub integration to onboarding the team on dbt.
  • Snowflake
  • Dimensional Modeling
  • Semantic Views
  • Stored Procedures
  • Streamlit in Snowflake
  • dbt
  • Git
  • GitHub Actions

Data Engineer

Full-time

G-Star · Dhaka, Bangladesh

Jan 2025 – Aug 2026
  • Data Warehouse Engineering: Owned and improved retail pipelines in a 700+ model BigQuery/Dataform warehouse spanning 12 business domains and 6+ source systems (SAP, Sterling OMS, EVA, Hybris, EDI); contributed to a major e-commerce data model refactor.
  • Performance & Cost Tuning: Refactored legacy full-refresh models into incremental models, cutting query runtime by up to 80% and cloud spend by up to $200 per day.
  • Omnichannel & Loyalty Reporting: Built the omnichannel reporting pipeline from the ground up, integrating a new Order Management System across 8+ event types, and delivered the Japan Loyalty Program dashboard as a greenfield project.
  • Team Enablement: Rolled out SQLFluff, VS Code and AI coding tools for the analytics team, wrote the SQL style guide, and added SQLFluff checks to CI with GitHub Actions, speeding up daily development and PR reviews.
  • Data Lineage: Built a nightly Python/GraphQL pipeline extracting Tableau Cloud lineage, mapping 300+ downstream dashboard dependencies for impact checks before releases.
  • BigQuery
  • Dataform
  • Pub/Sub
  • Dataflow
  • Apache Beam
  • Cloud Functions
  • Terraform
  • FastAPI
  • Cloud IAP
  • Python
  • GraphQL
  • GitHub Actions
  • SQLFluff

Junior Data Engineer

Full-time

G-Star · Dhaka, Bangladesh

Feb 2024 – Dec 2024
  • Partner Commission Reporting: Worked with the finance team to define commission business logic, then automated the monthly calculation with Dataform, BigQuery and Google Workflows. The output dataset is used in financial reporting.
  • PLM & Salesforce Pipelines: Built Product Lifecycle Management pipelines (Python, GCS, BigQuery) with fact/dimension models for product lifecycle and supplier performance analysis; maintained Salesforce ingestion via Airbyte.
  • Dataform
  • Google Workflows
  • Python
  • GCS
  • BigQuery
  • Airbyte

Technical Skills

Languages & Libraries

  • SQL
  • Python
  • FastAPI
  • Pandas
  • PyArrow
  • GraphQL

Warehouse & Modeling

  • Snowflake
  • BigQuery
  • dbt
  • Dataform
  • Dimensional Modeling
  • Incremental Models
  • Data Marts

GCP

  • BigQuery
  • Pub/Sub
  • Dataflow
  • GCS
  • Cloud Functions
  • Cloud IAP
  • Cloud Load Balancing
  • Secret Manager

Pipelines & Orchestration

  • Apache Beam
  • Airflow
  • Google Workflows
  • Airbyte
  • Apache Kafka
  • DuckDB
  • MinIO

IaC & DevOps

  • Terraform
  • Git
  • GitHub Actions
  • CI/CD
  • SQLFluff
  • Docker

BI & Data Apps

  • Streamlit in Snowflake
  • Tableau
  • Apache Superset

Featured Projects

GCP Streaming Ingestion Pipeline

Production

End-to-end event ingestion: Pub/Sub topics and Cloud Functions → Apache Beam / Dataflow → Hive-partitioned GCS → BigQuery sink. Terraform-provisioned across 4 environments.

  • Pub/Sub
  • Cloud Functions
  • Apache Beam
  • Dataflow
  • GCS
  • BigQuery
  • Terraform
[+] details

Designed and delivered an event-driven ingestion pipeline from scratch as part of a new order-management platform integration.

  • Provisioned Pub/Sub topics, Cloud Functions and BigQuery sink tables entirely via Terraform across 4 environments.
  • Built an Apache Beam / Dataflow streaming job that handles XML → JSON transformation, validates events, and routes failures to a dead-letter topic.
  • Wrote raw payloads to Hive-partitioned GCS paths for cheap replay alongside the BigQuery sink, with WRITE_APPEND and clustering on high-cardinality keys.

FastAPI Self-Service Ingestion Portal

Production

Schema-validated CSV / Excel / JSON uploads via FastAPI, routed to date-partitioned GCS paths backing BigQuery external tables. Deployed behind Cloud IAP with managed SSL inside a custom VPC.

  • FastAPI
  • Pandas
  • YAML
  • GCS
  • BigQuery
  • Cloud IAP
  • Terraform
[+] details

A browser-based upload tool that lets business users land data into the warehouse without pipeline disruption or public exposure.

  • Schema-as-config. Each ingestion target is defined once in YAML (columns, dtypes, nullability, enums, primary keys). Pandas validates every upload before anything hits the warehouse, returning line-numbered failure reports.
  • Secured perimeter. Cloud IAP fronts the service so access lives in IAM, not app code. Managed SSL handles certs; a custom VPC keeps payloads off the public internet.
  • Warehouse-ready output. Validated files land in date-partitioned GCS paths compatible with BigQuery external tables — analysts can query loaded data within minutes.
  • Fully Terraform-provisioned alongside the rest of the GCP environment.

Tableau Metadata Pipeline

Production

Nightly Python / GraphQL job that extracts Tableau Cloud metadata (dashboards, sheets, full lineage) and lands it in GCS. Surfaces 300+ downstream dashboard dependencies for impact analysis.

  • Python
  • GraphQL
  • Tableau Metadata API
  • GCS
  • GCP Secret Manager
[+] details

Before this pipeline, “what breaks if we drop this table?” was a manual half-day question.

  • Pages through the Tableau Metadata API over GraphQL nightly, collecting every workbook, dashboard, sheet, and upstream datasource.
  • Flattens the graph into a wide GCS / BigQuery dataset (one row per downstream_dashboard ↔ upstream_object pair) alongside a snapshot timestamp for change tracking.
  • Reduced manual lineage tracing for the data analytics team and surfaced 300+ downstream Tableau dependencies in a single queryable view.
  • Tableau credentials retrieved at runtime from GCP Secret Manager — rotation is a one-line change.

Self-Hosted Real-Time Data Platform

Personal Project

End-to-end medallion lakehouse on a single laptop — Kafka in KRaft mode at 50 RPS, MinIO for object storage, DuckDB for query, Airflow for orchestration, Superset for BI. Zero cloud dependency.

  • Apache Kafka
  • MinIO
  • DuckDB
  • Airflow
  • Superset
  • Docker
  • Python
  • PyArrow
[+] details

A production-grade, end-to-end streaming data platform on self-hosted open-source infrastructure, processing synthetic e-commerce events through a Medallion architecture with zero cloud dependency.

  • Designed a full Medallion data lakehouse (Bronze → Silver → Gold) stored on MinIO (S3-compatible object storage), processing e-commerce events end-to-end with no cloud dependency.
  • Built a 3-broker Apache Kafka cluster (KRaft mode, RF=3, 50 RPS) with a Python producer and buffered consumer, both instrumented with Prometheus metrics for observability.
  • Implemented schema validation, type casting, and a dead-letter path in the Silver transformation layer using Pandas + PyArrow; rejected records are preserved for auditing.
  • Orchestrated the full daily batch pipeline with Apache Airflow 2.8 (Silver → Gold → DQ checks → DuckDB view refresh) using partition-aware execution.
  • Containerized 10+ services with Docker Compose profiles (infra vs. jobs), health-check-gated initialization order, and a one-command Makefile startup.

Education

Bachelor of Science in Biomedical Engineering

Bangladesh University of Engineering and Technology (BUET) · Dhaka, Bangladesh

  • Dean’s List Award for Excellent Scholarly Achievement (2023)
  • University Stipend Scholarship (2022)
2023 GPA — 3.73 / 4.00

Higher Secondary Certificate

Ananda Mohan College · Mymensingh, Bangladesh

2017 GPA — 5.00 / 5.00

Secondary School Certificate

Mymensingh Zilla School · Mymensingh, Bangladesh

2015 GPA — 5.00 / 5.00

Research

Research Experience

Lung Nodule Detection from CT Scan Images

mHealth Lab , Department of Biomedical Engineering, BUET

  • Undergraduate thesis under Dr. Taufiq Hasan, Professor, Department of Biomedical Engineering, BUET.
  • Developed a lung-nodule detection system on volumetric CT scans using deep learning for image segmentation and classification, collaborating with graduate and undergraduate researchers.
Jun 2022 – May 2023

Get In Touch