> Markdown version of [/jobs/ext/2152386-google-cloud-data-modeler-data-architect](https://www.wearedevelopers.com/jobs/ext/2152386-google-cloud-data-modeler-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Google Cloud Data Modeler / Data Architect - **Company:** Codeforce 360 - **Location:** Lisle, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Airflow, Business Analytics Applications, Data Analysis, Application Integration Architecture, Business Logic, Business Intelligence Development, BigQuery, Cloud Computing, Cloud Engineering, Cloud Storage, Cyber Security, Data as a Services, Data Architecture, Data Dictionary, Data Governance, Data Integration, Extract Transform Load (ETL), Data Warehousing, Database Queries, Database Theory, Software Design Patterns, Data Flow Control, Identity and Access Management, Information Systems Security Architecture Professional, Logical Data Models, Metadata, Meta-Data Management, Reference Data, Lucidchart, Cloudera, SQL Databases, Technical Data Management Systems, Transaction Data, Enterprise Data Management, Data Processing, Google Cloud, Data Ingestion, Cloud Monitoring, Data Lakes, Data Lineage, Star Schema, Google Bigquery, Data Management, Physical Data Models, Terraform - **Published:** August 20, 2026 - **Apply:** https://www.dice.com/job-detail/bd4dc903-3d35-4a87-a7da-1b9cfa86f8ff ## About the Role About the Job- We are looking for an experienced Google Cloud Data Modeler / Data Architect to join one of our enterprise client engagements. The ideal candidate should have strong expertise in, BigQuery, SQL, Sparx Enterprise Architect, Dataflow, Google Cloud Platform along with experience working in fast-paced enterprise environments., * 8+ years of experience in data architecture, data modeling, data warehousing, or related areas. * Strong hands-on experience with Google Cloud Platform. * Strong BigQuery experience. * Strong SQL skills. * Experience with enterprise data modeling. * Experience with ETL/ELT architecture. * Experience with data governance and data quality. * Understanding of master data and reference data management. * Experience with metadata and data lineage. * Strong understanding of relational and analytical database concepts. * Experience developing: Preferred Google Cloud Platform Skills: * BigQuery * Cloud Storage * Dataflow * Dataproc * Pub/Sub * Cloud Composer * Dataplex / Knowledge Catalog * Cloud SQL * IAM * Cloud Monitoring * Terraform / Infrastructure as Code ## Description * We are seeking an experienced Google Cloud Data Modeler / Data Architect to design, develop, and govern scalable enterprise data architectures on Google Cloud Platform (Google Cloud Platform). * The role will be responsible for translating business requirements into robust conceptual, logical, and physical data models and implementing scalable data solutions using Big Query and other Google Cloud Platform data services. * The ideal candidate will have strong experience in enterprise data modeling, data warehousing, data integration, data governance, data quality, and cloud architecture, with the ability to work closely with business stakeholders, data engineers, analysts, and application teams., Data Architecture: * Design end-to-end data architecture solutions on Google Cloud. * Define scalable and secure architectures for data ingestion, transformation, storage, analytics, and reporting. * Design data lake, data warehouse, and modern Lakehouse architectures. * Define Google Cloud Platform project, dataset, schema, and data-layer strategies. * Establish architecture standards, design patterns, and best practices. * Evaluate existing data platforms and recommend modernization opportunities. Data Modeling: * Develop Conceptual, Logical, and Physical Data Models. * Design enterprise data models covering master data, transactional data, reference data, and analytical data. * Develop dimensional models including Fact and Dimension tables. * Design Star and Snowflake schemas where appropriate. * Define entities, attributes, relationships, keys, constraints, and business rules. * Develop canonical and semantic data models for enterprise reporting and analytics. * Maintain data dictionaries, business glossaries, metadata, and lineage. Google Cloud Platform / BigQuery: * Design and optimize data models in Google BigQuery. * Define BigQuery datasets, tables, views, materialized views, and schemas. * Apply partitioning and clustering strategies for performance and cost optimization. Design scalable data processing solutions using services such as: * + BigQuery + Cloud Storage + Dataflow + Dataproc + Pub/Sub + Cloud Composer + Dataplex / Knowledge Catalog + Cloud SQL Data Governance & Quality: * Establish data governance standards and architecture principles. * Define data ownership, stewardship, classification, and access patterns. * Implement data quality rules and validation frameworks. * Define standards for master and reference data. * Support data lineage, metadata management, and data cataloging. * Ensure compliance with security, privacy, and regulatory requirements. * Define appropriate IAM and data-access models. * Google Cloud's BigQuery ecosystem includes governance, metadata, lineage, and access-control capabilities that support these responsibilities. Data Integration & Transformation: * Define source-to-target mappings. * Design data ingestion and transformation patterns. * Develop transformation rules and business logic. * Define data reconciliation and validation processes. * Design integration between source systems, Google Cloud Platform, and downstream analytics platforms. * Work with engineering teams to ensure physical implementations conform to approved architecture and data models. Business & Stakeholder Collaboration: * Partner with business stakeholders to understand business processes and data requirements. * Translate business requirements into technical data architecture. * Work with data engineers, BI developers, data scientists, and application teams. * Facilitate architecture and data-model review sessions. * Communicate complex technical concepts to both technical and non-technical stakeholders., * ER/Studio * ERwin * Lucidchart * Draw.io * Sparx Enterprise Architect * SQL Developer Data Modeler * dbt * BigQuery Data Modeling tools Architecture & Design Skills: The candidate should be able to create and maintain: Source Systems * Raw/Landing Layer * Curated Layer * Business/Consumption Layer * BI / Analytics and define: * Source-to-target mappings * Data flow diagrams * Logical data models * Physical data models * Data lineage * Data dictionaries * Business rules * Data quality rules * Integration architecture * Security architecture * Data governance framework Preferred certifications: * Google Cloud Professional Cloud Architect * Google Cloud Professional Data Engineer * Other relevant Google Cloud Platform certifications. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [AI Model Management Life Circles: ML Ops For Generative AI Models From Research to Deployment](https://www.wearedevelopers.com/videos/1152-ai-model-management-life-circles-ml-ops-for-generative-ai-models-from-research-to-deployment) - [Crafting Custom Frameworks with Rust: A Deep Dive into Procedural Macros](https://www.wearedevelopers.com/videos/849-crafting-custom-frameworks-with-rust-a-deep-dive-into-procedural-macros) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Got AI ideas but no money? Here are 10 free ways to level up your AI skills with Google Cloud](https://www.wearedevelopers.com/magazine/600-got-ai-ideas-but-no-money-here-are-10-free-ways-to-level-up-your-ai-skills-with-google-cloud) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [7 Cloud Computing Trends Coming in 2025 for Developers](https://www.wearedevelopers.com/magazine/412-7-cloud-computing-trends-coming-in-2025-for-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)