Description

You will support the Enterprise Data Platform initiative by building and optimizing curated data assets on Google BigQuery.

Responsibilities

• Design logical, conceptual, and physical data models for the curated layer in BigQuery, developing fact and dimension tables using Kimball methodology.
• Optimize data models for performance and scalability, collaborating with data engineers on BigQuery implementations like partitioning and clustering.
• Define and maintain data definitions, relationships, and business rules to ensure data integrity and governance across datasets.
• Engage with business analysts to translate data needs into structured models that meet business requirements.
• Support BI and analytics teams by optimizing curated models for downstream consumption by tools like Looker or Tableau.

Required Skills

• 5+ years of experience in data modeling and architecture within cloud data platforms, specifically BigQuery.
• Expertise in dimensional modeling (Kimball), data vault, and normalization/denormalization techniques.
• Strong SQL skills and hands-on experience tuning BigQuery performance (partitioning, clustering, query optimization).
• Understanding of retail data models (sales, inventory, pricing, supply chain, customer analytics).
• Experience working with data engineering teams to implement models in ETL/ELT pipelines.
• Familiarity with data governance, metadata management, and data cataloging principles.
• Proficiency with ETL processes.
• Familiarity with GCP ecosystem.

Key Skills

Education

Any Graduate