Automates ETL pipelines using Apache Airflow. Ingests data to PostgreSQL hourly and loads daily data to BigQuery with incremental and partitioned processing. Implements core data engineering practices like timestamps, foreign keys, and scheduled workflows.