Description :

Overview :

We are looking for a Data Architect with strong hands-on experience in GCP (BigQuery) to design scalable data architecture for an AI-driven platform.

The role involves defining data models, building semantic layers for NL SQL use cases, designing real-time CDC pipelines, and leading migration from Redshift to BigQuery.

Must-Have Skills :

- Strong hands-on experience with BigQuery (data modeling, partitioning, clustering, performance tuning)

- Advanced SQL (complex queries, optimization)

- Strong understanding of Data Warehousing (OLAP, star/snowflake schema)

- Experience in real-time data pipelines / CDC (Kafka, Debezium, Dataflow)

- Proven experience in data migration (Redshift ? BigQuery or similar)

- Experience designing end-to-end data architecture on GCP

- Strong problem-solving and system design skills

Good-to-Have Skills :

- GCP services: Dataflow, Pub/Sub, GCS

- Data governance, IAM & access control

- Cost optimization strategies in BigQuery

- Exposure to AI/ML data preparation or NL?SQL systems

- Experience with streaming + batch hybrid architectures

- Client-facing or consulting experience

Tools & Technologies :

- BigQuery data modeling, query performance, optimization

- GCP GCS, Dataflow, Pub/Sub