Description

You will design and optimize curated data assets on Google BigQuery to support the Enterprise Data Platform initiative.

Responsibilities

• Design logical, conceptual, and physical data models for the curated layer using Kimball dimensional modeling.
• Optimize data models for performance and scalability through partitioning, clustering, and materialized views in BigQuery.
• Define data definitions, relationships, and business rules to ensure integrity and governance across datasets.
• Collaborate with data engineers, architects, and business analysts to translate requirements into scalable data structures.
• Ensure curated models are optimized for downstream consumption by BI tools, APIs, and AI/ML models.

Required Skills

• 5+ years of experience in data modeling and architecture within cloud data platforms.
• Expertise in BigQuery, including performance tuning, partitioning, and clustering.
• Advanced SQL skills for complex data transformation and optimization.
• Deep understanding of dimensional modeling (Kimball), Data Vault, and normalization/denormalization.
• Experience implementing models within ETL/ELT pipelines.
• Familiarity with data governance, metadata management, and data cataloging.
• Ability to support downstream analytics via Looker, Tableau, Power BI, APIs, and AI/ML models.
• Experience working within the GCP ecosystem.

Preferred Skills

• Prior experience in retail or e-commerce data environments.
• Exposure to modern data lakehouse or event-driven architectures.

Key Skills

Education

Any Gradute