Portrait of Samiullah Arshad

Data Engineer

Samiullah Arshad

View Real-World Projects Linkedin

Introduction

Data Engineer with hands-on experience building scalable ETL pipelines and cloud data platforms on AWS and Azure. I specialize in Apache Airflow, Airbyte, and modern data infrastructure—from data warehouses to lakehouse architectures and BI solutions. I focus on delivering reliable, business-driven data solutions through close collaboration with stakeholders.

Experience

Data Engineer — Orcion Systems

Feb 2026 – Present | Lahore, Pakistan

  • Architecting scalable AWS-based ETL/ELT pipelines for a multi-tenant platform.
  • Operating Medallion architecture workflows for ingestion, validation, and transformation.
  • Enabling validated datasets for QuickSight reporting and data quality assurance.

Data Engineer — Expertflow

Nov 2024 – Jan 2026 | Pakistan

  • Built scalable ETL pipelines on in-house data platform using Airflow, DBT, and Alembic.
  • Added platform features to onboard multiple internal product teams.

Associate Data Engineer — DOT LABS

Nov 2023 – Nov 2024 | Lahore, Pakistan

  • Delivered cloud-based ETL and BI solutions on AWS and Azure.
  • Led project delivery, stakeholder communication, and team mentorship.

Research Associate — LUMS Energy Institute

Feb 2022 – Jan 2023 | Lahore, Pakistan

  • Contributed to energy monitoring and control applications using R and R Shiny for applied research workflows.
  • Supported research delivery with code review, debugging, and data-driven reporting in a respected academic environment.

Featured Real-World Projects

Use filters to explore platform engineering, cloud ETL, BI, and automation work.

Data Platform (On-Prem)

Apache Airflow, Docker, Kubernetes, Python, SQL, DBT, Alembic

Designed and scaled a medallion-architecture platform integrating structured and semi-structured sources with reliable batch orchestration.

Impact

  • Unified MySQL, MSSQL, PostgreSQL, MongoDB, and API data pipelines.
  • Managed schema evolution through version-controlled migrations.
  • Containerized workflows and deployed on Kubernetes for enterprise reliability.

Architecture Diagram

Architecture diagram for Data Platform On-Prem using Airflow and Kubernetes
Data Platform (On-Prem) Architecture

DataExtend (DEX) — Multi-Tenant AWS Data Platform

AWS Batch, AWS Glue, Apache Spark, QuickSight, Python, SQL

Built a multi-tenant AWS data platform for secure ingestion, large-scale processing, and reliable client-specific data snapshots.

Impact

  • Ingested data from multiple sources through AWS Batch and processed large-scale datasets with AWS Glue and Spark.
  • Delivered dependable data snapshots to dedicated client environments with continuous monitoring.
  • Used Amazon QuickSight dashboards to track data quality and workflow health for rapid troubleshooting.

Architecture Diagram

Architecture diagram for DataExtend (DEX) multi-tenant AWS data platform
DataExtend (DEX) Architecture

CRM ETL & Warehouse Solution

Flask, Airbyte OSS, AWS EC2, S3, Glue, Athena

Built a multi-user HubSpot-to-AWS ETL system with OAuth-based extraction, user-isolated data lake storage, and query-ready warehousing.

Impact

  • Used OAuth 2.0 to connect multiple HubSpot tenants.
  • Automated connector setup in Airbyte per user credentials and scopes.
  • Transformed S3 parquet datasets with Glue and queried in Athena.

Architecture Diagram

Architecture diagram for CRM ETL and warehouse solution using HubSpot, Airbyte and AWS
CRM ETL & Warehouse Architecture

Real Estate ETL & BI

DynamoDB, Kinesis, Lambda, S3, Glue, Athena, QuickSight

Implemented a near real-time and batch ETL/BI pipeline to support data-driven insights for a housing platform in the Netherlands.

Impact

  • Captured historical JSON and streaming data into S3.
  • Performed daily cleaning and consolidation using Python + Glue jobs.
  • Published curated views for QuickSight dashboards with timeseries and map visualizations.

Architecture Diagram

Architecture diagram for Hospi Housing ETL and BI pipeline on AWS
Real Estate ETL/BI Architecture

Meal Project ETL & BI

Azure Blob, Function App, Azure SQL, Power BI

Created a cloud ETL workflow that processes CSV uploads, loads transformed results into SQL Server, and powers decision-focused Power BI reporting.

Impact

  • Triggered serverless ingestion and transformation on schedule.
  • Archived processed files and maintained ingestion trace.
  • Exposed analytics-ready relational tables for BI dashboards.

Architecture Diagram

Architecture diagram for Meal Project ETL solution on Azure
Meal Project ETL Architecture

Top Skills

Cloud Platforms

AWS (EC2, S3, Lambda, Kinesis, Glue, Athena, QuickSight), Azure

Data Engineering

ETL/ELT, Apache Airflow, Airbyte, DBT, Alembic, Medallion Design

Databases

PostgreSQL, MySQL, MSSQL, MongoDB, DynamoDB, Azure SQL

DevOps

Docker, Kubernetes, CI/CD, Terraform

Version Control

GitLab, GitHub, Bitbucket

BI & Analytics

QuickSight, Power BI, Superset, Looker Studio, Python, SQL

Contact

Based in Lahore, Pakistan