⛷️ Global Ski Resorts Data Pipeline

This project demonstrates a production-style, end-to-end data engineering pipeline built to ingest, transform, and model global ski resort and snow coverage data for analytics and decision-making using Snowflake and dbt.

📌 Project Scope

Ingest global ski resort and snow coverage datasets
Apply Bronze → Silver → Gold transformations
Perform spatial joins between resorts and snow grids
Classify resorts by beginner and expert difficulty
Expose analytics-ready models with dbt documentation

📘 Documentation

View dbt Documentation View Data Architecture View GitHub Repository

🧱 Technology Stack

AWS S3 (object storage)
AWS IAM (authentication)
Snowflake (cloud data warehouse)
dbt (data transformations & testing)
Git & Github (version control and documentation)

🎯 Why This Project

This project is designed to showcase real-world data engineering practices: dimensional modeling, data quality enforcement, spatial analytics, and analytics-friendly gold models aligned with business questions.