Job Summary
We are seeking an experienced GCP Data Architect to design and govern a scalable Data & BI platform on Google Cloud Platform (GCP). This role is responsible for defining end‑to‑end data architecture covering data ingestion, transformation, modeling, and analytics, ensuring alignment with business KPIs, data governance standards, and performance requirements.
Key Responsibilities
Data Analysis & Requirements
- Analyze data volumes, processing needs, and performance requirements across Marketing enterprise systems such as Google Analytics platform, Email, CRM and Survey etc
- Collaborate with business SMEs to understand business processes and define master data attributes
- Define enterprise KPIs, data quality rules, and reporting metrics
- Translate business and reporting requirements into scalable GCP data architecture designs
- Understand survey structures (fixed vs. custom fields) and finalize metadata/tags for attributes
Data Ingestion Architecture
- Design ingestion frameworks for multiple source systems including CRM, Google Analytics, email platforms and load survey files to GCP Cloud Storage
- Establish raw data lake architecture and ingestion standards
- Define data validation, reconciliation, and error-handling standards
- Ensure metadata discovery, lineage, and auditability for compliance requirements
- Support up to 6-7 predefined layouts using configuration‑based parsing
Data Transformation & Curation
- Define transformation architecture and standards for implementing business logic
- Govern data quality checks and dataset certification processes
- Oversee transformation of raw data into unified, curated, and consumable datasets
- Establish data quality metrics and SLAs
Data Modeling
- Design and maintain enterprise-level unified and dimensional data models
- Define standards for EAV and medallion architectures
- Ensure consistency across facts, dimensions, and reusable analytical models
Analytics & Performance
- Define data warehouse and analytics architecture on BigQuery
- Ensure optimized query performance for large-scale datasets
- Review and guide complex SQL and curated reporting dataset design
Required Skills & Qualifications
- Bachelor's or Master's degree in Computer Science, Engineering, or related field
- 10+ years of experience in data engineering and architecture roles
- 4+ years of hands-on experience designing solutions on Google Cloud Platform (GCS,BiqQuery,Data Flow,Data Fusion,Cloud Composer etc)
- Strong expertise in BigQuery, dimensional modeling, data warehousing ,SQL, Python and ETL/ELT data pipelines
- Experience with data governance, lineage, and compliance frameworks
- Excellent stakeholder communication and leadership skills
- Experience with BI tools (Looker, Tableau, Power BI)
- Experience working in large-scale enterprise data environments and optimizing complex SQL queries.
