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 Elasticsearch or other search / serving layers. * Support architecture for AI enrichment, embeddings, semantic search, and media metadata where required. * Prepare technical documentation, architecture diagrams, implementation roadmap, and handover materials. * Work closely with client engineering, data, DevO...