Data Modeler GCP Big Query

Job Details

• Role: Data Modeler GCP BigQuery
• Experience: 812 Years
• Location: Kolkata (Preferred)
• Notice Period: Immediate to ASAP
• Interview Process: L1 & L2 Technical (No Client Interview)

Key Responsibilities

• Design and maintain enterprise-wide conceptual, logical, and physical data models.
• Develop dimensional data models using Star Schema and Snowflake Schema for analytics and reporting.
• Build canonical and semantic data models supporting enterprise data products.
• Design scalable data structures for Google BigQuery-based analytical platforms.
• Model data across Bronze, Silver, and Gold layers of the Lakehouse architecture.
• Collaborate with architects, data engineers, and business stakeholders to deliver scalable data solutions.
• Define and maintain metadata, business glossaries, data lineage, and governance standards.
• Establish data quality frameworks and source-to-target mappings.
• Support AI/ML-ready data foundations and self-service analytics initiatives.
• Optimize data models for reporting, BI, and enterprise analytics.

Required Skills

• Strong expertise in Conceptual, Logical, and Physical Data Modeling
• Dimensional Modeling
• Star Schema & Snowflake Schema Design
• Advanced SQL
• Data Warehousing Concepts
• Google Cloud Platform (GCP)
• BigQuery
• Google Cloud Storage (GCS)
• Dataplex
• Data Governance
• Metadata Management
• Data Lineage
• Data Quality Frameworks
• Source-to-Target Mapping
• Performance Optimization & Query Tuning

Preferred Skills

• Data Vault Modeling
• LookML / Semantic Layer Design
• Cloud Composer
• Dataflow
• Dataproc
• Google Professional Data Engineer Certification
• Experience in Snowflake or AWS to GCP migration projects
• Domain experience in Manufacturing, Supply Chain, ERP, CRM, Product Data, or Finance

What We're Looking For

• 812 years of experience in Enterprise Data Modeling.
• Hands-on experience with BigQuery and modern cloud data platforms.
• Strong understanding of data governance, metadata, and enterprise architecture.
• Excellent SQL and analytical skills.
• Ability to collaborate with cross-functional teams in Agile environments.