Senior GCP Data Architect

Cynet Systems•Issaquah, WA

About The Position

The Senior GCP Data Architect designs and maintains scalable, high-quality conceptual, logical, and physical data models for enterprise and cloud-based applications, APIs, analytics platforms, and integrations. The role translates complex business requirements into reusable data structures and develops models for solutions hosted on Google Cloud Platform, including BigQuery and Cloud SQL. The architect partners with Data Architects, Application Architects, Developers, Business Analysts, Product Owners, Data Engineers, and governance teams. The role supports data integration, migration, cloud modernization, application data contracts, governance, security, privacy, and retention requirements, and provides guidance on data modeling best practices.

Requirements

  • 8+ years of experience in data modeling, database design, data architecture, or related data engineering roles.
  • Strong experience creating conceptual, logical, and physical data models.
  • Strong understanding of relational, dimensional, and analytical data modeling.
  • Hands-on experience with Google Cloud Platform data technologies.
  • Strong knowledge of BigQuery and Cloud SQL.
  • Advanced knowledge of SQL and relational database concepts.
  • Experience designing models for APIs, microservices, cloud-native applications, and enterprise integrations.
  • Strong understanding of normalization, denormalization, referential integrity, indexing, keys, and database design principles.
  • Experience with star schemas, snowflake schemas, facts, dimensions, and dimensional modeling.
  • Experience with source-to-target mapping, data lineage, and metadata management.
  • Experience with enterprise data modeling tools such as erwin Data Modeler, ER/Studio, SAP PowerDesigner, or similar tools.
  • Experience working with Data Architects, Data Engineers, Application Architects, and business stakeholders.
  • Strong analytical, problem-solving, documentation, and communication skills.
  • Understanding of GCP data pipelines and integration patterns.
  • Understanding of cloud-native and microservices architectures.
  • Experience designing data models optimized for cloud scalability and performance.

Responsibilities

  • Design and maintain conceptual, logical, and physical data models for enterprise and cloud-based applications.
  • Translate complex business requirements into scalable, reusable data structures.
  • Develop models supporting transactional applications, APIs, microservices, analytics, and reporting.
  • Design data models for GCP-hosted solutions and optimize structures for BigQuery, Cloud SQL, and other applicable GCP data services.
  • Define entities, attributes, relationships, keys, reference data, and business rules.
  • Apply normalization and dimensional modeling techniques to meet transactional and analytical requirements.
  • Develop star schemas, snowflake schemas, facts, dimensions, and semantic data structures for analytical workloads.
  • Maintain enterprise data dictionaries, metadata, naming standards, and modeling conventions.
  • Perform source-to-target data mapping and support data transformation requirements.
  • Collaborate with Data Engineers on ingestion, transformation, migration, and data integration solutions.
  • Partner with API and application teams to align application data contracts with enterprise data models.
  • Review existing models and recommend improvements to scalability, performance, maintainability, and data quality.
  • Assess legacy database structures and develop target-state models for cloud modernization and migration initiatives.
  • Participate in data architecture and design reviews.
  • Support impact analysis for data model and schema changes across dependent applications and interfaces.
  • Work with governance teams to ensure adherence to data governance, security, privacy, and retention requirements.
  • Provide technical guidance and mentoring to development and data engineering teams on data modeling best practices.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service