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 up-to-date 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.

📌 Data Modeler GCP Big Query (Bengaluru)
🏢 Elabs Infotech
📍 Bengaluru