Skip to content
System ReadyData & Automation Engineer

Data & Automation Engineer building systems that don't break at 2am.

I'm Hammad Tariq, a Data & Automation Engineer with 5+ years on AWS, building production data platforms and the automation around them: ETL pipelines, cloud warehouses, backend APIs and AI features that cut cost and scale cleanly.

HT

Hammad Tariq

Data & Automation Engineer

Faisalabad, Punjab, Pakistan
AWS Glue
Redshift
Dagster
PySpark
Featured guide

RabbitMQ Data Pipelines: Scale ETL without adding compute

How to scale a data pipeline with RabbitMQ: work queues, a worker pool, durability and backpressure. The pattern that took one pipeline past 2M records a day.

Data Engineering12 min read

Tools of the trade

Trusted by teams at

CertifiedAWS Solutions ArchitectAWS Cloud EssentialsIBM Data EngineeringIBM Python for Data ScienceHackerRank SQLTraining Project - DEBig DataAzureCloud ETLView all
Core Philosophy

Systems that are resilient by default.

Whether it's orchestrating ETL or modelling a cloud data warehouse, the focus is always scalability, observability and clean execution.

What I do

AWS data engineering, end to end.

I build the AWS data layer a business runs on: ETL/ELT pipelines, cloud warehouses on Redshift and Snowflake, and migrations off creaking on-prem systems. My focus is the unglamorous part: whether the platform still holds up when real data gets messy at 2am. Recent work cut operating costs by up to 99% and turned hours of manual effort into seconds. The AWS-cost lessons from that work are in my guide to cutting an AWS Glue bill.

Pipeline Orchestration

Orchestrated ETL/ELT with Dagster, dbt and Airflow, from raw ingestion to analytics-ready warehouses.

Cloud Warehouses

Data marts and warehouses on Snowflake, Redshift and BigQuery: modelled, governed and query-fast.

Cloud Native

Dockerised, CI/CD-driven deployments on AWS with cost optimisation and observability baked in.

Production-Grade

Idempotent pipelines, isolated failure domains and graceful degradation, built to survive real data.

Selected Work

Case studies, not screenshots.

Real systems with measured outcomes: the problem, the architecture, and the numbers that moved.

All Projects
Data EngineeringDelivered

Enterprise Data Warehouse Migration — Sybase to Amazon Redshift

Re-platforming a tier-1 banking EDW onto a cloud-native AWS warehouse

Led the migration of a major retail bank’s on-premises Enterprise Data Warehouse from Sybase to Amazon Redshift on AWS, re-engineering 800+ stored pro…

+40%Redshift compute
PythonSQLPL-SQLAmazon Redshift
View Case Study
Data EngineeringDelivered

Cloud-Native ETL for Environmental Analytics

A 3-tier AWS Glue pipeline for assessment, measurement & analysis data

Built a 3-tier data architecture on AWS for an environmental-solutions provider, using AWS Glue, S3, Redshift, Lambda and PySpark to lift data-process…

+30%AWS Glue
PythonAWS GlueAWS S3Amazon Redshift
View Case Study
Data EngineeringDelivered

Cloud Data Warehouse Migration on AWS

Re-architecting on-prem ETL into AWS for 80% better resource utilisation

Led a data-warehouse migration to AWS for a pan-African financial-services group, moving 20–30 ETL scripts and stored procedures onto Glue, Redshift a…

+80%job re-architecting
AWSAWS GluePySparkSQL
View Case Study
AI EngineeringProduction Core

Anchor

AI Cost Attribution & Real-Time Outage Monitoring from Shared Provider Spend

Restores per-application cost visibility from a single shared AI invoice. A near-zero-touch SDK captures durable usage “receipts”, and invoice-anchore…

Reconciles to the centPer-application cost vs. real invoice
PythonSQLite (WAL)PostgreSQLOpenAI
View Case Study
AI EngineeringProduction

Intelligent Document Processing Platform

AI-Powered Multilingual OCR & Document Intelligence

Converts scanned PDFs and photographed forms into clean, structured Markdown across 10+ languages, including hard scripts like Urdu, Arabic and Amhari…

AutomatedManual keying eliminated
FastAPICeleryRedisDocling
View Case Study
Data EngineeringDelivered

Automated Distributor ETL for Unilever

Hands-off SFTP-to-analytics for daily sales & stock data

An automated ELT pipeline that detects distributor files landing on SFTP, validates and homologates them, and lands analytics-ready data in S3 for rea…

ZeroManual intervention
DagsterdbtPostgreSQLAWS S3
View Case Study
From the Blog

Latest writing

Practical deep dives on data engineering, ETL and analytics: the decisions and the numbers behind real work.

All Articles
Security

How to Mask PII on Ingest Into an S3 Data Lake

Mask PII in an S3 data lake at the ingest boundary: deterministic hashing that keeps joins working, Glue detection, Lake Formation filters, KMS and erasure.

PII MaskingData GovernanceAWS Lake FormationAWS Glue
AI Engineering

Why LLM Features Fail in Production: The Demo Data Was Clean

Why LLM features fail in production when the demo worked: messy real inputs, queues that starve each other, and failures that never raise an alarm.

LLMAI EngineeringProductionFastAPI
Data Engineering

AWS Cost Optimisation: In-House, a Tool, or a Consultant?

Fix your AWS bill in-house, buy an automated cost tool, or hire someone? A straight comparison of what each option reaches, and when each is wasted money.

AWSCost OptimizationFinOpsHiring
Free Tools

Free tools for data teams

Small, browser-based utilities I built. No signup, and nothing leaves your browser.

All Tools
In Their Words

What clients say

A few words from people I've delivered for.

Skilled, flexible, and fast. Would hire Hammad again.
Rafael NasserInteractive Brokers
Excellent communication and amazing work with great execution.
Frank CohenAirplane & helicopter parts supplier
How I Can Help

Work with me

Three ways to engage, from a focused consultation to full end-to-end delivery.

Taking on new projects · Outside IR35

Have a data pipeline or warehouse problem worth solving?

From messy source data to analytics-ready warehouses that cut cost. Let's scope it. I reply within one business day.