Andalib Ansari
DATA PLATFORM & AI ENGINEERING
Andalib Ansari

End-to-end data platforms, wired for AI agents.

I build the full path from raw events to a trusted warehouse - orchestration, quality gates, modeling - then wire agentic AI on top of it

Also teaches data engineering to 29,283 students on Udemy — see the course ↓

Platform design
Airflow setup
Data quality server
Warehouse modeling
n8n + LangChain AI apps
// data_to_decision.svg
OLTP transactional DB Events stream data S3 batch data Airflow orchestration DQ server custom checks Warehouse modeled schema BI & dashboards reports & KPIs AI Engineering agentic workflows Human validation Decision shipped
// core expertise

What I build, end to end

Not a generalist list — this is the specific stack I've shipped in production, repeatedly.

End-to-End Data Platform Design

Architecting the full path from raw ingestion to governed, trusted data - data lake, warehouse, catalog, and lineage as one coherent platform, not disconnected tools.

AWS S3Data LakeData CatalogData Lineage

Airflow Platform Setup

Standing up production-grade Airflow - custom operators and plugins, DAG authoring standards, code-review conventions, and on-call runbooks that scale as teams grow.

Apache AirflowCustom OperatorsDAG StandardsPagerDuty SOPs

Custom Data Quality Server

Building in-house data quality services from scratch — automated checks that catch schema drift, null violations, and SLA breaches before they hit downstream consumers.

Flask APIReact UI1500+ checks/daySLA/SLOObservability

Data Warehouse Modeling

Designing dimensional models and star schemas built for fast, trustworthy BI — the layer between raw pipelines and the dashboards people actually make decisions from.

RedshiftSnowflakeDatabricksBigQueryData ModelingSQL

AI Apps on Warehouse & Event Data

Building agentic AI applications with n8n and LangChain directly on top of warehouse and event-stream data — RAG assistants, natural-language query agents, and automation workflows.

n8nLangChainRAGEvent DataData Warehouse

Data Warehouse Migration

Moving traditional, on-prem data warehouses to modern cloud platforms — replatforming schemas, pipelines, and workloads with minimal downtime and validated parity.

RedshiftSnowflakeDatabricksBigQuery

1:1 / Group Data & AI Engineering Coaching

Mentoring engineers and small teams on data platform fundamentals and applied AI — architecture reviews, career guidance, and hands-on pairing, one-on-one or in groups.

MentoringArchitecture ReviewsCareer GuidanceTeam Training

Digital Presence Audit

Turning raw review, social, and GBP data into a monthly scored report that tells health SMEs exactly what their digital presence is costing them - competitor-benchmarked, AI-written commentary, delivered as a PDF report

NLP Sentiment AnalysisCompetitor BenchmarkingAI CommentaryGoogle ReviewsSocial AnalyticsPDF Automation
// engagement

How an engagement runs

01 / Discover

Scope the work

A short call to understand your data platform, pipelines, or digital presence — and agree what a successful engagement looks like.

02 / Deliver

Build or report

Hands-on delivery — platform architecture, Airflow setup, a data quality server, warehouse migration, an AI agent, or your first Digital Presence Audit report.

03 / Handover

Support & next steps

Documentation and runbooks for technical builds, or a walkthrough of your action plan for audit clients — plus a short support window either way.

// engagement models

Ways to work with me

Data & AI Consulting

Architecture reviews and hands-on build support across any of my core areas of expertise — scoped as a fixed project or ongoing advisory.

Discuss a project →

Data Engineering Build

End-to-end delivery: pipelines, Airflow platform, data quality server, or warehouse migration — scoped and shipped.

Scope a build →

Digital Presence Audit

A monthly report that finds the fixable gaps in your Google listing, reviews, and social media - ranked by what they're costing you in lost patients, with a clear action list to close them.

Request an audit →
// teaching

Also on Udemy

I teach data engineering to a global student base alongside consulting work.

12+
years in data & AI engineering
60%
infrastructure cost reduction delivered
1500+
automated data-quality checks / day
45%
query cost savings delivered
// proof

Selected work

Employer and client names withheld where engagements are proprietary — full context available on request.

Global gaming platform

Enterprise data lake consolidation

Unified BI, AI, and operational workloads onto a single governed AWS data lake, cutting infrastructure costs 60%.

Global gaming platform

In-house data quality server

Built a Flask-based data quality platform running 1500+ automated checks a day across ingestion and transformation layers.

Global gaming platform

Agentic BI assistant

Built a production RAG assistant that lets analysts ask the warehouse questions in plain English - orchestrated with n8n, reasoning handled by LangChain, semantic search backed by a vector database.

Ride-hailing super-app

Centralised warehouse & Airflow platform

Built the data warehouse powering executive dashboards, plus an Airflow DAG generator framework to automate pipeline creation.

// background

Experience

JUL 2023 — PRESENT · PERTH
Senior Data Architect, Data & AI Engineering
Microgaming Asia
Architected an enterprise AWS data lake and led a production RAG-based BI Assistant. Manages a team of 5 data engineers.
DEC 2019 — JUN 2023 · SINGAPORE
Data Architect, Data & AI Engineering
Microgaming Asia
Re-engineered the on-prem Financial Data Warehouse onto Redshift; scaled the Airflow platform and trained 15+ engineers.
AUG 2017 — NOV 2019 · SINGAPORE
Data Engineer
Grab
Built the centralised Data Warehouse powering C-suite dashboards across ride-hailing, payments, food, and delivery.
JAN 2015 — JUL 2017 · MUMBAI
Data Engineer
WebEngage
Built the company's Data Warehouse from scratch on Redshift, maintaining 99.9% uptime across ETL, warehouse, and BI layers.
JAN 2014 — DEC 2014 · MUMBAI
Data Analyst
Freestone Infotech
Designed ETL pipelines generating credit scoring metrics from raw telco datasets on an EMR/Hadoop/Hive stack.
// let's talk

Start a conversation

Tell me a bit about what you're working on and I'll follow up within a couple of days.