I've spent the past 9+ years turning messy data into something teams can actually rely on — from ETL/ELT pipelines and data warehouses to streaming systems and cloud platforms. These days I'm also exploring how AI/LLMs fit into that world, building data-driven solutions on top of it.
|
Pipelines Batch & streaming ETL/ELT, CDC with Debezium and Kafka, orchestration in Airflow, Dagster, Prefect and NiFi. |
Modeling Data Vault 2.0 and Kimball warehouses, medallion lakehouses on Iceberg and Delta, transformations in dbt and SQLMesh. |
Platforms & BI GCP, AWS, Azure, Alibaba Cloud · Databricks, Fabric, Snowflake · Power BI, Tableau, Superset, Metabase. |
| Project | Focus | Flow |
|---|---|---|
| kafka-cdc-flink | Streaming CDC | Postgres → Debezium → Kafka → Flink → ClickHouse |
| kafka-cdc-jdbc-sink | Streaming CDC | Postgres → Debezium → Kafka Connect → ClickHouse (Avro + Schema Registry) |
| kafka-spark-metabase | Streaming | Kafka → Spark Structured Streaming → Postgres → Metabase |
| dagster-iceberg-panel | Lakehouse | REST API → S3 → Iceberg → Trino → Panel, orchestrated by Dagster |
| databricks-spark-medallion | Lakehouse | Medallion layers with Spark SQL, Delta Lake and Unity Catalog |
| prefect-seaweedfs-duckdb | Lakehouse | Open-Meteo → Prefect → SeaweedFS → DuckDB → Streamlit |
| datavault-dbt | Warehouse | Data Vault 2.0 in three layers with dbt-core on Postgres |
| ksei-holding-pipeline | Warehouse | Monthly KSEI ownership ETL: Airflow → ClickHouse → dbt → Superset |
| trino-mongodb-metabase | Analytics | CSV → MongoDB → Trino → Metabase |
| airflow-duckdb-dash | Analytics | Crypto market data: Airflow → DuckDB → Plotly Dash |
Learning & mentoring — dbt-postgres-story · sql-story-postgresql · kafka-hands-on-basic · docker-hands-on-basic
Full stack by layer
| Layer | Tech Stack |
|---|---|
| Orchestration | Apache Airflow, Dagster, Prefect, Apache NiFi |
| Language | Python, SQL |
| Processing | Apache Spark, Apache Flink |
| Streaming | Apache Kafka |
| Ingestion | Airbyte, Debezium, Talend, Pentaho, IBM DataStage, SSIS |
| Cloud Computing | AWS, GCP, Azure, Alibaba Cloud |
| Lakehouse | Apache Iceberg, Amazon S3, Google Cloud Storage, SeaweedFS |
| Data Platform | Databricks, Microsoft Fabric, Snowflake |
| Transformation | dbt, SQLMesh |
| Warehouse and Query | BigQuery, Redshift, ClickHouse, DuckDB, PostgreSQL, SQL Server, Oracle, Trino |
| Search and Enrichment | OpenSearch, MongoDB |
| Monitoring | Grafana, Prometheus |
| BI and Visualization | Power BI, Tableau, IBM Cognos, Metabase, Plotly Dash, Superset |
| DevOps and Containerization | Docker, Podman |
| Collaboration | Jira, Confluence |
| AI/LLM Data Processing | LLM-driven data workflows |
Happy to talk data platforms, pipelines and analytics — LinkedIn · j.chaesar94@gmail.com