Core Capabilities

Practical analytics engineering skills demonstrated through hands-on projects.

Layered Data Modeling (dbt)

Designing staging → foundation → marts transformations using dbt with clear layer responsibilities and analytical data modeling principles.

Dimensional Modeling

Implementing Kimball-style star schema models, including Slowly Changing Dimension (SCD Type 2), to create reliable analytical datasets.

Reproducible ELT Pipelines

Building deterministic batch pipelines that transform raw data into analytics-ready warehouse tables.

Pipeline Orchestration

Scheduling and managing data pipeline workflows using Apache Airflow with retry handling and monitored DAG runs.

Data Quality Validation

Applying structured validation checks and dbt tests to detect inconsistencies and protect analytical data contracts.

Warehouse-Based Transformations

Structuring SQL transformations in modern analytical databases such as Snowflake and PostgreSQL.

Tech Stack

My go-to stack for data engineering pipelines

Languages

Python
SQL

Data Infrastructure & Tools

Cloudflare R2
Dbt-icon SVG Icon
dbt
Snowflake-icon SVG Icon
Snowflake
Airflow
Docker
PostgreSQL
Featured Projects
SaaS Subscription Analytics Pipeline - Layered Data Architecture with Deterministic ETL featured image

SaaS Subscription Analytics Pipeline - Layered Data Architecture with Deterministic ETL

An end-to-end analytics engineering simulation for a SaaS subscription business, implementing layered transformations, dimensional modeling, and resilient data ingestion across …

avatar
Karhomatul Faqih Al Amin
E-commerce Data Pipeline - Analytical Data Modeling with Reproducible ETL featured image

E-commerce Data Pipeline - Analytical Data Modeling with Reproducible ETL

A reproducible analytical ETL pipeline with explicit data contracts, star schema modeling, and enforced data quality gates.

avatar
Karhomatul Faqih Al Amin
Current Focus

Current Focus

Phase 4: Cloud Infrastructure & Automation

  • Infrastructure as Code: Provisioning scalable cloud environments and networking using Terraform.
  • Containerized Workloads: Ensuring pipeline portability and production-ready environments with Docker.
  • CI/CD & DevOps: Automating deployment lifecycles via GitHub Actions for seamless delivery to AWS/GCP.
See full roadmap
Recent Posts
Phase 3 - Moving from Local Data Pipelines to Cloud Analytics Engineering featured image

Phase 3 - Moving from Local Data Pipelines to Cloud Analytics Engineering

Phase 3 of my data engineering journey focused on moving beyond local experimentation and into a cloud-based analytics pipeline, while learning how to work within real-world …

avatar
Karhomatul Faqih Al Amin
Closing Phase 2 - Why My First End-to-End Pipeline Broke Until I Learned Data Modeling featured image

Closing Phase 2 - Why My First End-to-End Pipeline Broke Until I Learned Data Modeling

Phase 2 of my data engineering journey was all about putting theory into practice by building an end-to-end data pipeline project while learning why architectural decisions matter …

avatar
Karhomatul Faqih Al Amin

Get In Touch

Let’s build something amazing together

Connect

I'm always interested in hearing about new projects and opportunities. Whether you're looking to hire, collaborate, or just want to say hi, feel free to reach out!

✓ Copied to clipboard!
Send a message

Find me on

Open to Opportunities

I’m currently looking for Analytics Engineer or Data Engineer roles.

Let’s connect and discuss how I can help your team.