Design and implement cloud Data Warehousing (DWH) architecture for large-scale data ingestion, preferably with GCP Big Query. Develop and manage ETL/ELT pipelines, including data ingestion, transformation, and storage. Perform dimensional modeling, data lakehouse design, and data partitioning/sharding. Implement business use cases such as churn prediction, network optimization, and revenue assurance.