Data Modeler/Data Architect on GCP - Remote

Overview

An experienced Data Modeler is needed to support the Enterprise Data Platform initiative, focusing on building and optimizing curated data assets on Google BigQuery.

In Short

• Design logical, conceptual, and physical data models for EDP’s curated layer in BigQuery.
• Develop fact and dimension tables, ensuring adherence to dimensional modeling best practices (Kimball methodology).
• Optimize data models for performance, scalability, and query efficiency.
• Collaborate with data engineers to translate models into efficient BigQuery implementations.
• Define and maintain data definitions, relationships, and business rules for curated assets.
• Ensure data integrity, consistency, and governance across datasets.
• Engage with business analysts and product teams to understand data needs.
• Support BI & analytics teams by ensuring curated models are optimized for downstream consumption.

Requirements

• Experience in data modeling and architecture in cloud data platforms (BigQuery preferred).
• Expertise in dimensional modeling (Kimball), data vault, and normalization techniques.
• Strong SQL skills with hands-on experience in BigQuery performance tuning.
• Understanding of retail data models (sales, inventory, pricing).
• Experience working with data engineering teams on ETL/ELT pipelines.
• Familiarity with data governance and metadata management.
• Excellent communication skills to translate business needs into data models.

Benefits

• 100% remote position.