Programming
PythonSQLSpark SQL
Data Engineering Portfolio
Owais Ahmad
Data Engineer
Python | SQL | PySpark | Databricks | Delta Lake
I build scalable ETL pipelines, reliable data validation workflows, and modern Lakehouse solutions that turn raw data into trusted analytics-ready assets.
Bronze
Silver
Gold
ETLBatch pipelines
SparkPySpark and SQL
DeltaMERGE workflows
BIAnalytics models
About
Data Engineer Focused On Reliable Analytics
I am a Data Engineer and BS Computer Science student specializing in Data Science at the University of Engineering & Technology, Mardan. My work centers on building clean, validated, and analytics-ready datasets with Python, SQL, PySpark, Databricks, and Delta Lake.
I design ETL and ELT workflows that move data from raw ingestion into Bronze, Silver, and Gold layers, applying cleaning, transformation, validation, and quality checks so downstream teams can trust the results.
I enjoy connecting engineering discipline with business impact: data pipelines, Lakehouse architecture, data warehousing, and dashboards that help teams answer questions faster.
Education
BS Computer Science (Data Science)
University of Engineering & Technology, Mardan
2022 - 2026
Capabilities
Skills & Technologies
Data Engineering
ETLELTData PipelinesData CleaningData TransformationData ValidationData Quality
Big Data
Apache SparkPySparkDatabricksDelta Lake
Databases
PostgreSQLMySQLSQL Server
Backend
FastAPIREST APIsStreamlit
Analytics
Power BIPandasNumPyExcel
Development Tools
GitGitHubDockerVS Code
Experience
Professional Experience
Data Engineer Intern
YBIX | Full-Time
- Developed ETL pipelines using Python, SQL, PySpark, and Databricks.
- Performed data cleaning, validation, and transformation to improve data quality.
- Built a modern Lakehouse architecture using Bronze, Silver, and Gold layers.
- Implemented Delta Lake MERGE operations for incremental data processing.
- Created dashboards and reports to support business intelligence.
- Collaborated with engineering teams to build scalable and reliable data workflows.
PythonSQLPySparkSpark SQLDatabricksDelta Lake
Selected Work
Data Engineering Projects
Automated ETL Pipeline
Production-style batch pipeline that ingests raw files, validates schemas, transforms records, and produces analytics-ready tables.
PythonSQLPySparkETL
- Schema validation and quality checks
- Reusable extract, transform, load modules
- Audit logs for pipeline monitoring
Databricks Lakehouse Architecture
Bronze, Silver, and Gold layer architecture designed for incremental processing with Delta Lake and Spark SQL.
DatabricksDelta LakePySparkSpark SQL
- Delta MERGE incremental loads
- Medallion architecture design
- Curated tables for reporting
Online Retail Analytics
Retail analytics workflow for sales, customer, and product performance reporting with clean dimensional models.
SQLPower BIPandasData Warehouse
- Customer and product marts
- Revenue and retention KPIs
- Executive dashboard metrics
AI Personal Assistant
Assistant prototype that combines API workflows, natural language prompts, and user task automation.
PythonFastAPIREST APIsAI
- API-first architecture
- Conversation workflow design
- Task automation modules
Customer Lifetime Value Prediction
Predictive modeling workflow to estimate customer value and support telecom retention strategy.
PythonPandasScikit-learnAnalytics
- Feature engineering pipeline
- Regression and classification models
- Business-friendly scoring output
Showing 5 projects
Credentials
Certifications
Databricks Data Engineering Fundamentals
Databricks
CompletedVerify CredentialDatabricks SQL Analytics
Databricks
CompletedVerify CredentialIBM Data Engineering
IBM
CompletedVerify CredentialKPITB AI & Machine Learning
KPITB
CompletedVerify CredentialResume
Recruiter Snapshot
Owais Ahmad
Junior Data Engineer | Python, SQL, PySpark, Databricks, Delta Lake
Core Strengths
ETL pipelines, data cleaning, validation, transformation, Lakehouse architecture, Delta MERGE, dashboards, and analytics engineering.
Experience
Data Engineer Intern, YBIX | Full-Time | May 2026 - July 2026
Open Source
GitHub Profile
Contact