Description

You will design and maintain logical, conceptual, and physical data models for curated data layers. You will own the end-to-end modeling lifecycle, from translating business requirements into technical structures to optimizing for downstream analytics and AI/ML use cases.

Responsibilities

• Design fact and dimension tables using dimensional modeling best practices (Kimball) and data vault techniques.
• Optimize data models for performance, scalability, and query efficiency on cloud data platforms.
• Define and maintain data definitions, relationships, and business rules to ensure integrity and governance.
• Collaborate with data engineers to implement models via ETL/ELT pipelines and cloud infrastructure.
• Align models with enterprise metadata standards and support BI teams in consuming data for reporting.

Required Skills

• 10+ years of experience in data modeling and data architecture.
• Expertise in dimensional modeling, data vault, and normalization techniques.
• Strong SQL skills with proven experience in query optimization and performance tuning.
• Hands-on experience with cloud data platforms, specifically BigQuery.
• Understanding of retail data models including sales, inventory, pricing, and customer analytics.
• Familiarity with data governance, metadata management, and data cataloging.
• Ability to translate business requirements into technical data structures.

Preferred Skills

• Experience in retail or e-commerce environments.
• Familiarity with modern architectures such as data lakehouse or event-driven systems.
• Experience with cloud ecosystem tools including Dataflow, Pub/Sub, and Cloud Storage.

Key Skills

Education

Bachelor's degree