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 in BigQuery using Kimball methodology.
• Develop fact and dimension tables optimized for performance, scalability, and query efficiency.
• Collaborate with data engineers to implement models using partitioning, clustering, and materialized views.
• Define and maintain data definitions, business rules, and relationships to ensure data integrity and governance.
• Partner with business analysts and BI teams to ensure models are optimized for Looker, Tableau, Power BI, AI/ML models, and APIs.

Required Skills

• 5+ years of experience in data modeling and architecture within cloud data platforms.
• Expertise in dimensional modeling (Kimball), Data Vault, and normalization/denormalization techniques.
• Advanced SQL skills with hands-on experience in BigQuery performance tuning.
• Deep understanding of retail data models including sales, inventory, pricing, supply chain, and customer analytics.
• Experience implementing models within ETL/ELT pipelines alongside data engineering teams.
• Knowledge of data governance, metadata management, and data cataloging.
• Proficiency with BigQuery, GCP, Dataflow, Pub/Sub, and Cloud Storage.
• Experience supporting downstream consumption via Looker, Tableau, Power BI, AI/ML models, and APIs.

Preferred Skills

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

Key Skills

Education

Any Gradute