This is a remote position.
Key Responsibilities
* Assess the existing data pipeline, GCP architecture, data sources, and current limitations.
* Design a BigQuery-based medallion architecture: Bronze, Silver, Gold, and Serving layers.
* Design and/or implement data ingestion pipelines from Cloud Storage and Cloud SQL / MySQL into BigQuery.
* Define BigQuery datasets, tables, partitioning, clustering, and cost-control strategies.
* Support batch, incremental, and on-demand processing patterns.
* Design curated and BI-ready datasets for analytics and reporting.
* Support data quality checks, validation, logging, monitoring, and reprocessing patterns.
* Define integration patterns for El...